5 ms·

Can anyone suggest any better alternatives, even paid ones? I absolutely love PGSQL and it's a great software, but it severely lacks in good tools.

napsterbr 8y ago
I have used DbSchema and it's worked great for me. Highly recommend.
sudhirj 8y ago
I use DataGrip, part of the IntelliJ / Idea Suite. It’s a bit fiddly in terms of UI, but that’s a one time learning curve - everything else from there is a breeze. Also has excellent integration with the other Idea tools, if you use them.
oneweekwonder 8y ago
> it severely lacks in good tools. I'm happy with pgadmin4 3.1. Liked and used pgModeler for a while now. The pgwiki on tooling[0] contains thousands of tools. Effort is needed in cleaning it up. Also found a cleaner version on postgresql.org[1] > even paid ones? Heard good things about navicat. [0]: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS... [1]: https://www.postgresql.org/download/products/1-administrationdevelopment-tools/ https://www.postgresql.org/download/products/1-administratio... edit: what kind of db tools are you looking for?
- Cthulhu_ 8y ago
  pgadmin's UX is pretty bad though, definitely on macos - lots of default OS specific keybinds that don't work, basic editing features that are missing, etc.
hagope 8y ago
dbeaver is great
- baq 8y ago
  seconded. very nice tool, actively developed.
zmmmmm 8y ago
It's ugly and dated but I still love SquirrelSQL. (It's not PGSQL specific, but that's part of why I love it ...)
tnolet 8y ago
I’m using TablePlus and it’s pretty good. https://tableplus.io/ https://tableplus.io/
nablaone 8y ago
If you're looking for db modeling tool try vertabelo.com (work here) I use psql console for other tasks (db management/data access).
sdnguyen90 8y ago
Postico is nice and simple if you're on OSX. Its very similar to Sequel Pro. I like Datagrip as well but it has too many features for me since most of my queries are just SELECT's with maybe a JOIN.
gregn610 8y ago
Toad Modeler for modelling. Handles defered constraints, inheritance, keys etc. Very scriptable tho the scripting IDE isn't great.
nova1313 8y ago
I really like E/R Studio for modeling work. It is expensive, but I've not found a nicer tool to do it across multiple database platforms. Their website shows they don't officially support the latest versions of PostgreSQL. It does work, but the menus haven't been updated for all the latest features. If you want to use syntax from a newer release, you'll need to do a SQL override until they update the tool. Their team version keeps the metadata in a database, instead of a file. The locking/unlocking of individual tables is cumbersome. The metadata database doesn't support using PostgreSQL for storing the metadata. I tend to store the models in Git and use the built in model diff tool to do model merges. ER Studio gets slow when you are north of 10k tables/views in a single model. As a work around, I use sub-models and do not touch the large master model. On a large main model, their visualization tool I believe tries to render all 10k tables. It starts taking 1-2 seconds between clicks. Smaller sub-models (1-2k) off that large main model do not have that issue. The scripting extension for ER Studio is decent, not great, but significantly improved in the last few versions. It is close to being VBScript. Scripting makes updating really large models a breeze. I use it a lot for storage/index parameter parameter changes during hardware/software upgrades.
nxie 8y ago
I use TeamSQL and have been finding it pretty good so far

napsterbr 8y ago

I have used DbSchema and it's worked great for me. Highly recommend.

sudhirj 8y ago

I use DataGrip, part of the IntelliJ / Idea Suite. It’s a bit fiddly in terms of UI, but that’s a one time learning curve - everything else from there is a breeze. Also has excellent integration with the other Idea tools, if you use them.

oneweekwonder 8y ago

> it severely lacks in good tools. I'm happy with pgadmin4 3.1. Liked and used pgModeler for a while now. The pgwiki on tooling[0] contains thousands of tools. Effort is needed in cleaning it up. Also found a cleaner version on postgresql.org[1] > even paid ones? Heard good things about navicat. [0]: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS... [1]: https://www.postgresql.org/download/products/1-administrationdevelopment-tools/ https://www.postgresql.org/download/products/1-administratio... edit: what kind of db tools are you looking for?

Cthulhu_ 8y ago
pgadmin's UX is pretty bad though, definitely on macos - lots of default OS specific keybinds that don't work, basic editing features that are missing, etc.

hagope 8y ago

dbeaver is great

baq 8y ago
seconded. very nice tool, actively developed.

zmmmmm 8y ago

It's ugly and dated but I still love SquirrelSQL. (It's not PGSQL specific, but that's part of why I love it ...)

tnolet 8y ago

I’m using TablePlus and it’s pretty good. https://tableplus.io/ https://tableplus.io/

nablaone 8y ago

If you're looking for db modeling tool try vertabelo.com (work here) I use psql console for other tasks (db management/data access).

sdnguyen90 8y ago

Postico is nice and simple if you're on OSX. Its very similar to Sequel Pro. I like Datagrip as well but it has too many features for me since most of my queries are just SELECT's with maybe a JOIN.

gregn610 8y ago

Toad Modeler for modelling. Handles defered constraints, inheritance, keys etc. Very scriptable tho the scripting IDE isn't great.

nova1313 8y ago

I really like E/R Studio for modeling work. It is expensive, but I've not found a nicer tool to do it across multiple database platforms. Their website shows they don't officially support the latest versions of PostgreSQL. It does work, but the menus haven't been updated for all the latest features. If you want to use syntax from a newer release, you'll need to do a SQL override until they update the tool. Their team version keeps the metadata in a database, instead of a file. The locking/unlocking of individual tables is cumbersome. The metadata database doesn't support using PostgreSQL for storing the metadata. I tend to store the models in Git and use the built in model diff tool to do model merges. ER Studio gets slow when you are north of 10k tables/views in a single model. As a work around, I use sub-models and do not touch the large master model. On a large main model, their visualization tool I believe tries to render all 10k tables. It starts taking 1-2 seconds between clicks. Smaller sub-models (1-2k) off that large main model do not have that issue. The scripting extension for ER Studio is decent, not great, but significantly improved in the last few versions. It is close to being VBScript. Scripting makes updating really large models a breeze. I use it a lot for storage/index parameter parameter changes during hardware/software upgrades.

nxie 8y ago

I use TeamSQL and have been finding it pretty good so far