NYCPHP Meetup

NYPHP.org

[nycphp-talk] Database code solutions

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


On this topic, I have recently been using a product called NaviCat found at
http://www.mysqlstudio.com/ 

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.

PSaw


-----Original Message-----
From: talk-bounces at lists.nyphp.org [mailto:talk-bounces at lists.nyphp.org] 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:

http://www.casestudio.com

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.

---------------------------------------------=o&o>---------
Steve Manes          http://www.magpie.com
Brooklyn, NY


_______________________________________________
talk mailing list
talk at lists.nyphp.org http://lists.nyphp.org/mailman/listinfo/talk




More information about the talk mailing list