субота, 25 липня 2009 р.

ER tools for PostgreSQL

Indeed, PostgreSQL is a great database engine. It's free and open-source. Great tool for the server.

But what about developers? Which ER tools can we use for database design? I'm not talking about the databases with 5 tables, I mean more complex designs.

  • MySQL Workbench: a tool developed by Sun. It exports design into the MySQL-specific code, thus you have to modify it by hand in the text editor. Pros: you can show the graphic database design to the customer. Contras: MySQL-specific SQL and ... BUGGY !! (at least - the latest version. Just click the "Not NULL" checkbox in the fields list ... and the program dies).
  • Database Designer for PostgreSQL from MicroOLAP. Never used but look at the prices: starting from 124.95 USD for personal use. I think the tool is good, but the price...
Comparing to Microsoft SQL Server: you can buy the Developer edition where diagramming tool is surely pesent just for 60 bucks and be happy. This is a full-featured product which you cannot use in industry. Marvelous!

Any more ideas guys?

1 коментар: