PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
What kind of applications do you use for designing the Database and the system itself?
I use Visio for the Database Design (MER, Logic Model), and scripts interactions.
I use a text editor to design the scripts, (en español: pseudocódigo) and sql statements, and then i start coding, .
I think Visio is not a very good help cause it didnt generate SQL statements and those kind of stuff.
I have used some PC client software called Mascon which was ok for designing the database. I recently did some work on a site that has an online tool - phpMyAdmin which was quite handy to use also.
For the actual PHP script and embedded SQL I use EditPlus2 - very good text editor!
I strictly use phpmyadmin for creating my tables. Command line for createing a DB. I really like phpmyadmin. Very easy to use. I have not yet really gotten into the Dreamweaver acess to it yet.
To tell the truth, I usually do initial design sitting at my desk, with pen and paper! The tables and relationships carefully (I Hope!) thought out.
Yes, once everything is all laid out, PHPMyAdmin is a very nice tool.
I suppose you could write your own given a knowledge of the database catalogue - i.e. metadata structure used.
I am using also phpMyAdmin it is easy to install and is easy to create tables with. To make a connection to the database, I use Dreamweaver it has vrey nice tools to acces the database.
You can almoste do everything in dreamweaver based on databases.
haven't felt any need for a database-modeling tool until now. Pen, paper and a cup of coffee do well if I have to create a db-design manually, MysqlFront to access the server.
But this is where I would start my search
eclipse ide, probably there are db-plugins
rational rose (since you're using viso already), maybe they have something for sql, too
products for EJB that handle complete deployment processes, maybe they're using plugins you can use standalone