Page 1 of 1

Application Design (PHP)

Posted: Fri Jan 17, 2003 3:39 pm
by AVATAr
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.

What do you do???? :D

Posted: Fri Jan 17, 2003 4:27 pm
by BDKR
The closest thing I ever used to a GUI front end for db creation is phpMy or phpPG admin. Otherwise, the rest is done from an editor.

Cheers,
BDKR

Posted: Fri Jan 17, 2003 7:48 pm
by fractalvibes
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!

Phil J.

Posted: Fri Jan 17, 2003 10:33 pm
by oldtimer
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.

yes but.

Posted: Sat Jan 18, 2003 3:49 pm
by AVATAr
I use Phpmyadmin too, but before that I DESIGN de database (Entity Relation Model) -> thats why i use visio.

i think you guys do directly the coding. :wink:

Posted: Sat Jan 18, 2003 9:07 pm
by hob_goblin
I'm not doing anything that gets a ton of traffic so PHPMyAdmin is just fine for me!

Posted: Mon Jan 20, 2003 10:43 pm
by fractalvibes
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.

Phil J.

Posted: Tue Jan 21, 2003 3:14 am
by Skywalker
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.

Posted: Tue Jan 21, 2003 3:30 am
by volka
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
a long shot but .... ;)

Posted: Tue Jan 21, 2003 12:23 pm
by Jabbas
I use System Architect for these purposes. Truly an excellent prog !

Posted: Tue Jan 21, 2003 1:01 pm
by volka
Do you have an url for that product at hand?

Rational

Posted: Tue Jan 21, 2003 2:21 pm
by AVATAr
Rational Rose is a great tool but not for this kind of stuff (i supose)

I start with pen and paper as everybudy does (a must!) but for documentation I use visio....

I've to see System Artichect...

Posted: Wed Jan 22, 2003 2:24 am
by Jabbas
product overview

evaluation download

I don't know the policy of this board, and for now I don't have the time to read it :twisted: so I'll refrain from posting any 'other versions'.
*hint*=irc


ps. active board ! friendly community ! Guess I'll stick around a while.. :)

ok

Posted: Wed Jan 22, 2003 9:16 pm
by AVATAr
lets give it a try then!!! :D