I'm looking for a Plone product that emulates PhpMyAdmin - essentially, 
a table and query editor for an underlying SQL database (aka a 
simplified MS Access in Plone).

I've found a few things, but nothing really close.


How to "access query results using 
ZSQL":http://zope.org/Members/teyc/howtoSQLVariables

"Defining Radio Buttons based on SQL query 
results":http://plone.org/documentation-old/howto/ExtractingDataFromMicrosoftSQLUsingZPT

"Keylime for Zope SQL methods":http://wiki.c3w.org/index.php?keylime
and 
at "freshmeat":http://freshmeat.net/projects/keylime/


Does anyone have any leads on this?

Thanks.

I'm not sure what you're trying to do but my experience with emulation
is that it's usually not as good as a native implementation.

If you're dealing with rows, columns, and relations it's best left to a
tool that's really good at that. MySQL rocks for 95%ish reads and 5%ish
writes and Postgres rocks for grown up database work.

What are you doing? 

Christoph Berendes muttered about this on Sun, Dec 12, 2004 at 08:18:09PM
-0500:
|I'm looking for a Plone product that emulates PhpMyAdmin - essentially, 
|a table and query editor for an underlying SQL database (aka a 
|simplified MS Access in Plone).
|
|I've found a few things, but nothing really close.
|
|
|How to "access query results using 
|ZSQL":http://zope.org/Members/teyc/howtoSQLVariables
|
|"Defining Radio Buttons based on SQL query 
|results":http://plone.org/documentation-old/howto/ExtractingDataFromMicrosoftSQLUsingZPT
|
|"Keylime for Zope SQL methods":http://wiki.c3w.org/index.php?keylime
and 
|at "freshmeat":http://freshmeat.net/projects/keylime/
|
|
|Does anyone have any leads on this?
|
|Thanks.
[...]

There are times when it's nice to be able to inspect and perhaps 
administer a SQL database directly via the web, without first having to 
write a frontend. I like phpMyAdmin for this a lot. It makes it easy to 
inspect tables, run whatever SQL query, define/redefine tables, tinker 
with data. I'm looking for a tool that would let me do this via Plone.

Since I posted, I found a couple more links:

Zope MySql admin: http://zope.org/Members/randhir/MysqlAdmin
Zope Sql Forms: http://www.zope.org/Members/Ioan/SQLForms/

but haven't played with them yet.



On 12/12/2004 8:42 PM, Jules wrote:
[...]

At the risk of sounding like overly pragmatic why not just use one of
the programs that has a lot more momentum for this task? phpMyAdmin is
a fine effort. phpPgAdmin is equally nifty -- just installed it on my
laptop this weekend after getting Zope working with Postgres on OS X
(slight struggle -- email for details while they're still fresh).

I suppose the point is I don't know anybody that runs Zope on port 80.
A lot of people use Apache or Squid as a front end for good reason. I'm
perfectly OK with the fact that Zope and/or Plone can't do everything.

If you're really paranoid grab a copy of apache from source
(www.apachetoolbox.com is a great way to go), compile in php, bind it to
127.0.0.1 on some high port behind the firewall and keep it locked down.

If you do find one of these admin tools rocks beyond belief do please
share both with the list and at a meeting.

Cheers,
Jules

Christoph Berendes muttered about this on Sun, Dec 12, 2004 at 09:22:41PM
-0500:
|There are times when it's nice to be able to inspect and perhaps 
|administer a SQL database directly via the web, without first having to 
|write a frontend. I like phpMyAdmin for this a lot. It makes it easy to 
|inspect tables, run whatever SQL query, define/redefine tables, tinker 
|with data. I'm looking for a tool that would let me do this via Plone.
|
|Since I posted, I found a couple more links:
|
|Zope MySql admin: http://zope.org/Members/randhir/MysqlAdmin
|Zope Sql Forms: http://www.zope.org/Members/Ioan/SQLForms/
|
|but haven't played with them yet.
[...]