I'm starting a new project soon and I'd like to try to use some better tools this time around. The last project, I wrote all my Database creation SQL by hand for MySQL. I'm hoping there are some good tools out there for creating, maintaining and modifying database schema in MySQL. My budget is out-of-my-own-pocket, so free (as in beer) would probably be best. :)
+8
A:
MySQL Workbench : http://dev.mysql.com/workbench/
It is free and very easy to use. I usually create schema diagrams and export it as a .sql file to use with phpMyAdmin
HyperCas
2009-02-28 18:34:30
I hadn't tried this one before because it didn't have a Linux version. New project allows me to use Windows if I want. So far this tool seems pretty easy to use. Already made a pretty basic schema.
Drew
2009-02-28 20:42:48
+3
A:
http://dev.mysql.com/downloads/gui-tools/5.0.html offers a list of GUI tools to use.
TheTXI
2009-02-28 18:37:42
A:
Mac options, try Querious or Sequel Pro - here's a comparison:
http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/
Kendall Helmstetter Gelner
2009-02-28 18:42:37
+1
A:
MySQL Workbench 5.1 (Beta 1) should be out March 6,2009. It will be available on MacOS, Fedora, Ubuntu, Windows. These are native C++ implementations on each platform. WB 5.1 is focused on Data Modeling (replacing Mike Zinner’s popular DBDesigner product).
MySQL Workbench 5.2 (Alpha 1) should be out mid April 2009 (around the MySQL Users Conference 2009). This will include a ground up rewrite of the MySQL Query Browser.
A:
You can check our free database tools. The profiler - Actively queries data at a given interval and lets you know of data changes that occur over time.
Or the Beta ver, and the lite-weight version of the query tool is also for free.
other database tools cost money ;-), but not too much...
Itamar
2009-03-01 19:24:00