Do you use a visual database designer?

Brook · 04-05-2009, 12:22 AM

If so which one?

Enfernikus · 04-05-2009, 12:49 AM

dry erase board

Krik · 04-05-2009, 02:07 AM

Quote:

Do you use a visual database designer?

I am not sure what you mean by "visual". Data usually is visible.

Now if your talking about a database manager, that allows you to manage your data in tables. Then phpmyadmin is my database manager of choice.

Brook · 04-05-2009, 03:11 AM

I mean programs like Kexi and Open offices 'Base' - I think zend do one too..

Like this: http://www.mysql.com/products/workbench/

Dr John · 04-12-2009, 06:43 PM

The one above is an update based on fabforce.net's db designer (well the chief designer moved there from fabforce) And it's by MySQL / Sun, not Zend...

Randy · 05-24-2009, 07:20 PM

Personally i dont use one and i dont recommend that you do either, By using programs you dont get a personal feel and some things can get messed up, i recommend doing it all by hand in notepad or like Enfernikus suggested a dry erase board which is what i use as well.

allworknoplay · 05-25-2009, 03:05 PM

Quote:

Originally Posted by Randy

Personally i dont use one and i dont recommend that you do either, By using programs you dont get a personal feel and some things can get messed up, i recommend doing it all by hand in notepad or like Enfernikus suggested a dry erase board which is what i use as well.

Agreed. This is the best way to learn mySQL.

CoryMathews · 05-25-2009, 06:06 PM

Quote:

Originally Posted by Randy

Personally i dont use one and i dont recommend that you do either, By using programs you dont get a personal feel and some things can get messed up, i recommend doing it all by hand in notepad or like Enfernikus suggested a dry erase board which is what i use as well.

You may learn some things a little bit better, but in the end you will just waste a lot of time. Maybe just start with no GUI but the time you save with a GUI makes it completely worth it.

Navicat, or phpmyadmin for me btw. I was not much of a fan of the ones that mysql provides..

Enfernikus · 05-25-2009, 06:28 PM

HeidiSQL is my favorite but for the actual design and how things are going to be implemented...Dry Erase board.

dschreck · 06-11-2009, 09:20 AM

I used to always start on the Dry Erase Board... lately i'll just use a UML program like OmniGraffle or Visio to get the idea down. If it's something I'm going to be tinkering with a lot, i'll go ahead and load up MySQL Workbench - just so I can directly export the SQL.

Randy · 06-11-2009, 08:28 PM

@corey it may be faster however if something does not go wrong it is harder to correct it, also many programs that I have used have issues with displaying certain types of information.