Since most of the rails developers seem to use macs, could someone possibly suggest a good visual db modelling tool to use along with rails and MySQL? So far I've already tested the absolutely unsuable Workbench as well as dbSketch, which was not adequate either.
The tool needn't be free, as long as it is stable, works with MySQL and has a trial version.
Thanks in advance,
DBVisualizer, from minq.se
Its java, so you'll need your MySQL jdbc driver, but I use this to visualize all my tables as well as keep a history of my commands etc.
YourSQL is great for basic stuff:
Navicat is great for advanced stuff (like building complex queries visually): http://www.navicat.com
It also helps to know that a lot of “important” folks (including Apple) use Navicat:
http://www.navicat.com/user_stories.html
Cheers, Joannou.
We have 17,000 applicants for 1,000 retail positions. It’s harder to get a job at an Apple Store than it is to get admitted to Stanford University. - Ron Johnson, Senior Vice President of Retail, Apple Computer, Inc.
I think he was looking for an ER diagraming tool.
The Macintosh world is distressing lacking in this area right now.
The only promising tool in this area was called XERD. Don't know how far it went though.
Thank you, guys for your help!
XERD is not mentioned anymore on its developer's site - it seems to have suffered some sort of data loss, the current version at VersionTracker is reported to have some crashing issues.
Guess, I will stick with DBVisualizer - it seems pretty adequate.
You might want to consider OmniGraffle, from the Omni Group. Although it is a general diagramming tool – sort of like Visio, it includes a template for E-R diagrams and there’s a MySQL one available.
I’ve not used it on a Mac, but DataArchitect is pretty nice: http://www.thekompany.com/products/dataarchitect
Keep up to date with Rails on Twitter and This Week in Rails
Policies: Conduct, License, Maintenance, Security, Trademarks