On Tue, Dec 16, 2003 at 09:19:01AM -0800, R. Joseph Newton wrote: >George Georgalis wrote: > >> After I wrote that, I made some good progress... notably: >> http://www.thedumbterminal.co.uk/software/webmysql.shtml >> >> This might be good too, haven't tried >> http://sourceforge.net/projects/mysqltool/ >> >> // George > >That sounds good. You didn't say what myphpadmin does, though, so I'm not >really sure what functionality you are looking for. The standard tool in Perl >for basic DB access is the DBI [database independent] interface, coulple >withDBD::<target_db> as the driver for specific engine <target_db>. You will >want to get familiar with these, though it sounds like yur immediate issue has >more to do with database administration. I'm not sure what DBI's capabilities >are for design tasks. It does have methods for querying metadata. My guess is >that it will also pass DDL statements as well as SQL.
Hi Joseph, the tool I had in mind was http://www.phpmyadmin.net/ it does a lot, with php. I'm looking for a perl based cgi program I can drop in to allow remote users to design a db and enter data. template/css based would be good. I'd expect it to use DBI::mysql and would hopefully be a good project for me to use to get better experience with perl. Presently I create mysql scripts for database generation and bash interfaces for input and queries. webmysql doesn't seem to support INSERT so... the idea is to get something simple in place quickly, for remote clients to admin/insert on databases (and web based not client), then work on developing a more specialized custom application. // George -- GEORGE GEORGALIS, System Admin/Architect cell: 646-331-2027 <IXOYE>< Security Services, Web, Mail, mailto:[EMAIL PROTECTED] Multimedia, DB, DNS and Metrics. http://www.galis.org/george -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
