[nycphp-talk] Database code solutions

pswebcode, nyc psaw at
Wed Aug 13 10:27:53 EDT 2003

On this topic, I have recently been using a product called NaviCat found at 

Provides very nice graphical interface on MySQL servers, including
import/export data transfer of tables and/or whole databases from server to
server, backup and user management. Exposes SQL schema code that makes up
tables. Run queries from Query window.

30-day full-functioning demo.


-----Original Message-----
From: talk-bounces at [mailto:talk-bounces at] On
Behalf Of Steve Manes
Sent: Wednesday, August 13, 2003 7:44 AM
To: NYPHP Talk
Subject: Re: [nycphp-talk] Database code solutions

Ophir Prusak wrote:
> I'm looking for something that will reduce my development time on 
> database related code. I know there are several packages, classes, etc 
> that will help with this, but I don't have time to research all the 
> possibilities and was hoping to hear from nyphp members their 
> experiences and recommendations (or non-recommendations).
> I'm looking for any solution, commercial or open source.

Hey Ophir,

One thing I've found that dramatically helps me deal with database 
issues is a good database design tool to help me visualize what's going 
on.  I found something recently that I really like, CaseStudio:

After a couple of hours learning the demo Lite version, I bought it. 
The Pro version has a reverse engineering feature that logs into an 
RDBMS and creates a model from an existing database.  I demoed this as 
well and found a couple of things I should have been doing to optimize 
my digest archive.  Supports MySQL 4 and PosgreSQL 7.x too.

Steve Manes
Brooklyn, NY

talk mailing list
talk at

More information about the talk mailing list