Re: [PHP] Re: MySQL Workbench coming for Linux
so it's like Microsoft Access? I don't get it... 2008/9/18 Ross McKay [EMAIL PROTECTED] Bastien Koert wrote: what about dia on llinux? Not quite as nice as visio...but livable The Enterprise Architect version of Visio lets you add column definitions to your entities, add foreign key relationships, add indices, add comments at the table and column level, and then generate a build script. It also has a reporting tool for generating a data dictionary. In short, it makes a pretty good stab at being a data modelling tool (imperfectly, but sufficiently for my needs). Dia is just a diagramming tool (unless you can tell me otherwise). -- Ross McKay, Toronto, NSW Australia Nobody ever rioted for austerity - George Monbiot -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Luke Slater
Re: [PHP] Re: MySQL Workbench coming for Linux
Luke wrote: so it's like Microsoft Access? I don't get it... No, Microsoft Access is a development environment sitting on top of a simplistic database (JET). Access gives you a nice GUI to help you interactively build up your database, and it makes a great prototyping tool and data massage tool, but it isn't very good for data modelling. I'm talking about proper data modelling tools, where you design the conceptual and physical databases, then generate scripts to build them (e.g. in Oracle, Microsoft SQL Server, MySQL, etc.) and generate nice documentation including diagrams that help you understand your database at a quick glance. Usually, they can also suck a live database back in (reverse engineer) to help you document whatever nasty hack you've inherited from your predecessors in a legacy application ;-) MySQL Workbench is what I really want, or something similar. I just happen to already have a copy of Visio Enterprise Architect that comes close enough to doing the job, so I use that until Workbench is up and working properly on Linux. I hack the generated SQL scripts (minimally) to make them MySQL friendly, and I hack the generated RTF data dictionary files to make them more to my liking, and load them into OOo and embed the ER diagrams, to get nice, easily referenced documentation on my DBs. See here for more information about data modelling tools in general, and a couple of specific ones: http://en.wikipedia.org/wiki/Entity-relationship_model http://en.wikipedia.org/wiki/CA_ERwin_Data_Modeler http://en.wikipedia.org/wiki/ER/Studio http://en.wikipedia.org/wiki/Toad_Data_Modeler http://en.wikipedia.org/wiki/MySQL_Workbench -- Ross McKay, Toronto, NSW Australia Before enlightenment: chop wood, carry water; After enlightenment: chop wood, carry water - Wu Li -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: MySQL Workbench coming for Linux
Ross McKay wrote: Posting this here, because a few people responded when I mentioned not having a Linux-native data modelling tool. Apparently, MySQL Workbench should be alpha-ready by end of the month... I've been waiting for this. I'm getting tired of DBDesigner4's bugs and all. -- Dax Solomon Umaming http://blog.knightlust.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: MySQL Workbench coming for Linux
What is it? I'm only familiar with the MySQL tools such as Query Browser and Admin? 2008/9/17 Dax Solomon Umaming [EMAIL PROTECTED] Ross McKay wrote: Posting this here, because a few people responded when I mentioned not having a Linux-native data modelling tool. Apparently, MySQL Workbench should be alpha-ready by end of the month... I've been waiting for this. I'm getting tired of DBDesigner4's bugs and all. -- Dax Solomon Umaming http://blog.knightlust.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Luke Slater
Re: [PHP] Re: MySQL Workbench coming for Linux
On Wed, 17 Sep 2008 09:00:45 +0100, Luke wrote: What is it? I'm only familiar with the MySQL tools such as Query Browser and Admin? http://dev.mysql.com/downloads/workbench/5.0.html In short, it's a data modelling tool. Such things are very handy for designing and building databases, and usually also for documenting them. If your DB has more than a handful of tables, it's well worth the effort. -- Ross McKay, Toronto, NSW Australia Let the laddie play wi the knife - he'll learn - The Wee Book of Calvin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: MySQL Workbench coming for Linux
On Wed, Sep 17, 2008 at 4:13 AM, Ross McKay [EMAIL PROTECTED] wrote: On Wed, 17 Sep 2008 09:00:45 +0100, Luke wrote: What is it? I'm only familiar with the MySQL tools such as Query Browser and Admin? http://dev.mysql.com/downloads/workbench/5.0.html In short, it's a data modelling tool. Such things are very handy for designing and building databases, and usually also for documenting them. If your DB has more than a handful of tables, it's well worth the effort. -- Ross McKay, Toronto, NSW Australia Let the laddie play wi the knife - he'll learn - The Wee Book of Calvin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php what about dia on llinux? Not quite as nice as visio...but livable -- Bastien Cat, the other other white meat
Re: [PHP] Re: MySQL Workbench coming for Linux
Bastien Koert wrote: what about dia on llinux? Not quite as nice as visio...but livable The Enterprise Architect version of Visio lets you add column definitions to your entities, add foreign key relationships, add indices, add comments at the table and column level, and then generate a build script. It also has a reporting tool for generating a data dictionary. In short, it makes a pretty good stab at being a data modelling tool (imperfectly, but sufficiently for my needs). Dia is just a diagramming tool (unless you can tell me otherwise). -- Ross McKay, Toronto, NSW Australia Nobody ever rioted for austerity - George Monbiot -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php