Menu
I am looking for an alternative to the free pgAdmin III that works on windows. I basically need it for managing my tables / views / SP / etc. If it did ER diagrams, that is a huge plus, and I like them to make sure all my tables are linking together.
I am used to SQL Server Management Studio and Workbench, so I am looking for for something updated to that. pgAdmin III works, but lacks key things. Example, if I update a SP (function), I have to actually refresh the app so it notices it. Else if I go to re-edit it, it loads my old SP. This caused me to mess up several times. Also ER diagrams is a huge feature it's lacking.
While I do not mind a commercial alternative, I am not looking for a $500 bill. I would really like to keep under 250 is possible.
Please note, I have already tried PostgreSQL Maestro. It works nice, but commonly locks up. I would prefer something a bit more stable and thread safe. Example, once a query is running I can't cancel. It has the option but says, its already running so I have to end the process to stop it. I am also aware of [http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools] however I am looking for feedback by people who actually used the tools. I really do not want to try our 15 different options.
Thanks all in advance!
265
Typically users consider DBeaver to have better performance than pgAdmin which tends to be slower. One of the reasons for this is that pgAdmin requires more cores and memory than a typical desktop app. Its dashboard is continuously updated with health metric values by default.
pgAdmin is the community client for using PostgreSQL. It is usually installed along with PostgreSQL. While psql is a simple command-line tool, pgAdmin is a graphical user interface that provides pretty much the same functionality.
DataGrip/ IntelliJ IDEA Ultimate Edition
If you are already a user of Jetbrains tools, you may try DataGrip (or the database plugin, when you are an IntelliJ IDEA Ultimate edition user). This is quite new, but suitable for most use cases.
https://www.jetbrains.com/datagrip/
DBVisualizer
DBVisualizer is a very good solution for connecting to "any" DBMS with lots of features. There is a free version avaible, but the pro version is really worth the money:
http://www.dbvis.com/
HeidiSQL
A free and very good client for MySQL, PostgreSQL and SQL Server. It really evolved the last years.
http://www.heidisql.com
Squirrel SQL
Another quite good tool is Squirrel SQL. It's not the most intuitiv and beautiful tool, but has many useful features too:
http://squirrel-sql.sourceforge.net/
DBeaver
Another open source tool with a free community edition. This is something for Eclipse users, as it is build upon Eclipse and can be installed as Eclipse plugin as well.
https://dbeaver.io
MySQL Workbench
This is not for PostgreSQL, but my answer is quite generic, so I wanted to add this as well.
MySQL Workbench is the officiel tool from Oracle for connecting to MySQL. It is really good for working with MySQL.
https://www.mysql.de/products/workbench/
Others:
118
this is a very good alternative to PgAdmin, cross platform:
http://navicat.com/en/products/navicat_pgsql/pgsql_overview.html
Hope this helps (approx. $100-$200).
25
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
