mysql cgi admin and client

[George Georgalis]

Hi,

I thought there was something like myphpadmin (for mysql) in perl but
I'm not finding it.

I'm looking for a perl or mod_perl cgi, to create (as admin) mysql
database and tables, data entry interface and access client. Ideally
template / css based. Lots of companies sell this sort og thing for
under $40, but I suspect there is a GNU one out there?

// George


--
GEORGE GEORGALIS, System Admin/Architect cell: 646-331-2027 <IXOYE><
Security Services, Web, Mail, mailto:george@galis.org
Multimedia, DB, DNS and Metrics. [url]http://www.galis.org/george[/url]

[George Georgalis]

After I wrote that, I made some good progress... notably:
[url]http://www.thedumbterminal.co.uk/software/webmysql.shtml[/url]

This might be good too, haven't tried
[url]http://sourceforge.net/projects/mysqltool/[/url]

// George

On 12/15/03, George Georgalis wrote:

>Hi,
>
>I thought there was something like myphpadmin (for mysql) in perl but
>I'm not finding it.
>
>I'm looking for a perl or mod_perl cgi, to create (as admin) mysql
>database and tables, data entry interface and access client. Ideally
>template / css based. Lots of companies sell this sort og thing for
>under $40, but I suspect there is a GNU one out there?
>
>// George
>
>
>--
>GEORGE GEORGALIS, System Admin/Architect cell: 646-331-2027 <IXOYE><
>Security Services, Web, Mail, mailto:george@galis.org
>Multimedia, DB, DNS and Metrics. [url]http://www.galis.org/george[/url]
>

--
GEORGE GEORGALIS, System Admin/Architect cell: 646-331-2027 <IXOYE><
Security Services, Web, Mail, mailto:george@galis.org
Multimedia, DB, DNS and Metrics. [url]http://www.galis.org/george[/url]

[R. Joseph Newton]

George Georgalis wrote:

> After I wrote that, I made some good progress... notably:
> [url]http://www.thedumbterminal.co.uk/software/webmysql.shtml[/url]
>
> This might be good too, haven't tried
> [url]http://sourceforge.net/projects/mysqltool/[/url]
>
> // 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.

Joseph

[George Georgalis]

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:
>> [url]http://www.thedumbterminal.co.uk/software/webmysql.shtml[/url]
>>
>> This might be good too, haven't tried
>> [url]http://sourceforge.net/projects/mysqltool/[/url]
>>
>> // 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 [url]http://www.phpmyadmin.net/[/url]

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:george@galis.org
Multimedia, DB, DNS and Metrics. [url]http://www.galis.org/george[/url]

[George Georgalis]

yeah, that looks right. Thanks Jose.

// George


On Tue, Dec 16, 2003 at 03:30:10PM +0100, NYIMI Jose (BMB) wrote:

>Try
>[url]http://www.gossamer-threads.com/scripts/mysqlman/index.htm[/url]
>
>Jos?.
>
>-----Original Message-----
>From: George Georgalis [mailto:georgw@galis.org]
>Sent: Tuesday, December 16, 2003 6:14 AM
>To: [email]beginners@perl.org[/email]
>Subject: Re: mysql cgi admin and client
>
>
>After I wrote that, I made some good progress... notably: [url]http://www.thedumbterminal.co.uk/software/webmysql.shtml[/url]
>
>This might be good too, haven't tried [url]http://sourceforge.net/projects/mysqltool/[/url]
>
>// George
>
>On 12/15/03, George Georgalis wrote:

>>Hi,
>>
>>I thought there was something like myphpadmin (for mysql) in perl but
>>I'm not finding it.
>>
>>I'm looking for a perl or mod_perl cgi, to create (as admin) mysql
>>database and tables, data entry interface and access client. Ideally
>>template / css based. Lots of companies sell this sort og thing for
>>under $40, but I suspect there is a GNU one out there?
>>
>>// George
>>

--
GEORGE GEORGALIS, System Admin/Architect cell: 646-331-2027 <IXOYE><
Security Services, Web, Mail, mailto:george@galis.org
Multimedia, DB, DNS and Metrics. [url]http://www.galis.org/george[/url]