What client(s) do HN use day-to-day? Why have you chosen it?
I'm looking for recommendations to use for light usage. Ideally, something that would help build the schema visually.
It suffers from 'oh God this was definitely written in Java, wasn't it', but it's mostly good.
Then I happened across pgAdmin recently which probably does everything I want from DBeaver, and has a docker image (it's browser based) but I haven't really tried it properly. Keep meaning to though, I have a hopeful feeling that it'd be 100% what I recommended if I had.
Written in Java has the advantage of supporting any database which supports Java (which means every serious database on the planet)
Its the little things that adds up and make a much better experience when coming from sqlDeveloper and PgAdmin4.
It also supports everything.
psql OPTIONS <<EOF
It doesn't help with visualizing schemas, however.
On rare occasions I still need a GUI tool to explore a database because GUI definitely wins during the exploration phase by a lot.
Ironically enough for report writing I use metabase web ui. it serves most purposes I need from it.
It's not the answer you thought you were looking for, but it's a bloody good framework for modelling data, reporting, and also scripting things around it.
Edit: For day-to-day I use Postico but am playing with beekeeper as soon as JSON and JSONB support are figured out.
#1. DBeaver: Working with spatial/GIS data
#2. pgAdmin4: now offers PostGIS geometry viewer
Here's the decision-tree I'd go with:
Do you want to pay money for it? If not, use a free or open source one.
Are you comfortable with running SQL commands from the command line? If not, go for a GUI one.
This leaves "OS-specific or cross platform" (which should be straightforward to resolve), and "desktop client or web interface". I'd expect a desktop client to be easier to setup.
SQLEditor (https://www.malcolmhardie.com/sqleditor/) is quite good if you're on OS X. It'll generate entire schema or migration since last save.
Truth is I never found a PostgreSQL graphical tool that I was happy with. The one with best PostgreSQL support was pgAdmin and the others were all lacking in that regard. In the end I just bit the bullet and took a week to get psql into my muscle memory. Best decision ever; in combination with a good .psqlrc I rarely find myself wanting for anything more. I work with fairly complex highly normalized schemas (100s of tables) and it tells me what I need to know. Of course, I'm doing a huge amount of database work so a more casual database user may not readily be able to get as much mileage out of psql (graphical data models help for some).
I think OmniDB (https://omnidb.org/) is a tool that seems to try to cover the same bases as pgAdmin, but doing a better job of it. I think I'd likely look there if I really needed graphical tool.
For the record, the last graphical tool I used that I was very pleased with was a tool for Oracle database development PL/SQL Developer (https://www.allroundautomations.com/products/pl-sql-develope...). For me, it hit a sweet spot that I've just not seen duplicated... but I stopped working with Oracle over a decade ago and that was when last I used this tool.
very lite and minimal.
TablePlus when I want to do data exploration.
I've heard good things from colleagues about JetBrain's DataGrip, but I haven't given it a fair go.
I have started to transition more of my work to datagrip because I use pycharm and it's right there.
lightweight and JDBC compatible
This article breaks down the pros and cons, features, and pricing for each of the top PostgreSQL GUI tools: https://scalegrid.io/blog/which-is-the-best-postgresql-gui-2...