4 ms·

We use postgresql at http://massify.com http://massify.com I don't have enough experience with MySQL to be objective. I chose PostgreSQL because it had a feat

by jawngee 19y ago

We use postgresql at http://massify.com http://massify.com I don't have enough experience with MySQL to be objective. I chose PostgreSQL because it had a feature set relatively on parity with Oracle and the other big boys. So far I haven't been disappointed. Well, except for tool support. I'm still looking for a good schema diff tool for it (something as brilliant as SQL Compare by red gate) and a good ER tool (something as simple but functional as Enterprise Manager for SQL Server). Otherwise, I really haven't considered looking at anything else.

jm4 19y ago
Have you tried DbVisualizer? I don't think it does schema diff, but it covers quite a few other features in Enterprise Manager and can extract ERDs from your schema. It's relatively cheap too (or free with limitations) and works with any database with a JDBC driver. There's also Aqua Data Studio. I've never used it, but it looks pretty awesome. A little pricey, though. http://dbvis.com/products/dbvis/ http://dbvis.com/products/dbvis/ http://www.aquafold.com/ http://www.aquafold.com/
- jawngee 19y ago
  Haven't tried dbvisualizer. Huge fan of Aqua Data Studio though, great tool.
dcminter 19y ago
I rather like Enterprise Architect as an ER tool.
subwindow 19y ago
That's pretty much my exact same story. I came from an Oracle shop and wanted the same power that Oracle offered, but without paying $250k/yr in licensing fees. Postgres came the closest, and I've been really happy with it so far.
1gor 19y ago
>and a good ER tool HappyFish (http://www.polderij.nl/happyfish/gallery.html http://www.polderij.nl/happyfish/gallery.html) is elegant, simple, inexpensive and powerful and works with Postgres and MySQL. I have run it under wine on linux.
babul 19y ago
I been looking at tools too. My friend recommends http://www.datanamic.com http://www.datanamic.com as his lecturer at Imperial says it is good, but I have yet to try.

by jawngee 19y ago

jm4 19y ago

Have you tried DbVisualizer? I don't think it does schema diff, but it covers quite a few other features in Enterprise Manager and can extract ERDs from your schema. It's relatively cheap too (or free with limitations) and works with any database with a JDBC driver. There's also Aqua Data Studio. I've never used it, but it looks pretty awesome. A little pricey, though. http://dbvis.com/products/dbvis/ http://dbvis.com/products/dbvis/ http://www.aquafold.com/ http://www.aquafold.com/

jawngee 19y ago
Haven't tried dbvisualizer. Huge fan of Aqua Data Studio though, great tool.

dcminter 19y ago

I rather like Enterprise Architect as an ER tool.

subwindow 19y ago

That's pretty much my exact same story. I came from an Oracle shop and wanted the same power that Oracle offered, but without paying $250k/yr in licensing fees. Postgres came the closest, and I've been really happy with it so far.

1gor 19y ago

>and a good ER tool HappyFish (http://www.polderij.nl/happyfish/gallery.html http://www.polderij.nl/happyfish/gallery.html) is elegant, simple, inexpensive and powerful and works with Postgres and MySQL. I have run it under wine on linux.

babul 19y ago

I been looking at tools too. My friend recommends http://www.datanamic.com http://www.datanamic.com as his lecturer at Imperial says it is good, but I have yet to try.