I absolutely love PGSQL and it's a great software, but it severely lacks in good tools.
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.
I'm happy with pgadmin4 3.1.
Liked and used pgModeler for a while now.
The pgwiki on tooling contains thousands of tools. Effort is needed in cleaning it up. Also found a cleaner version on postgresql.org
> even paid ones?
Heard good things about navicat.
edit: what kind of db tools are you looking for?
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.
I use psql console for other tasks (db management/data access).
I'm guessing its based on some pg internals but a tool doesn't has to follow it.
Saw this in multiply tools for pgsql
That would make it easier for users not having administrator access to evaluate if PgModeler fits their requirements. :)
Otherwise, I really could use great tool to model databases ie. Postgres.
You can download the tool and run it locally.
I used this tool a lot on Arch which had PKGBUILD for it on AUR but I wasn't able to build it on MacOS.
I was actually vaguely contemplating purchasing it until that uncertainty made me think paying them might give me something worse than free (ie: something that would break at an inopportune moment in 6 months).