from Hacker News

Ask HN: Is there an easy to use PostgreSQL GUI/client for personal life?

by methou on 7/25/24, 12:15 PM with 2 comments

I'm really disappointed by Notion, but the database feature is has no competition. Since a long time ago, I've been wishing to use a psql db for note taking, but when needs changes, adding / removing columns or splitting tables would be a huge pain. So there might be industrial tools that makes this process easier, like python easier, just I haven't heard of?

by tgeorge on 7/25/24, 1:19 PM
I never used Notion before but looks pretty interesting. But, I use Navicat and DBeaver for viewing and editing my Postgres tables.
There's free version now for Navicat I noticed yesterday. https://dbeaver.io/download/ https://navicat.com/en/download/navicat-premium-lite
by phernandez on 7/26/24, 4:55 PM
I use intelij personally (for work and personal development). They also have a standalone product, DataGrip (https://www.jetbrains.com/datagrip/) with affordable/free pricing.
In the past I've just used raw psql from the console, but having an IDE is a big quality of life improvement IMO.