Hacker News new | past | comments | ask | show | jobs | submit login

For a really nice client for macOS see Postico:

https://eggerapps.at/postico/

(not affiliated, just a fan)




There’s also tableplus https://tableplus.com/


Table Plus is awesome and native on macOS.


And you don't need different app for different databases as it supports quite plenty of them.


Another alternative feature rich client: https://dbeaver.io/download/


It's mentioned and linked in the article. And "[i]t’s made by the same people that maintain Postgres.app."


I was aware it was from the same author and brought it up, didn't realize it was linked on the homepage! Thanks.


I would recommend TablePlus as it supports more than just postgres, and is also on Windows if you need it.

Not affiliated, just an extremely happy customer.


TablePlus is also great, I keep it around for sqlite specifically.


Wow, that looks very nice.


Keep in mind, Windows & Mac version require separate purchase


Oh yeah, I forgot about that bought it so long ago it slipped my mind. But as someone that switches regularly, the "2 computers" purchase for mac+windows was a no brainer for me.


Postico is the only application I miss from the days when I developed exclusively on the mac.

To be fair, I use (and like) TablePlus, but it's no Postico...


What's better with Postico over TablePlus?


Well, I wouldn't say "better" just things I miss and notice that bug me about TablePlus. This is specific to my workflow and my project.

There are a couple quality of life things:

1) Postico can infer that I mean NULL if I delete a column value. TablePlus thinks that if I have clicked into a column, I MUST mean that I want an empty string. It happens to me pretty often where I accidentally click the wrong NULL column to update, and when I click away it sets it to "EMPTY", but maybe the column type is a timestamp or something...so I get an invalid type error when I go to add the one I meant to change manually. It's frustrating, but very common. You have to right click and click, the "SET NULL" option.

2) Postico gives me a toggle for ENUM types and Bool types. I can't remember what ENUM values I can choose in one of my tables, so that can be cumbersome.

3) Postico has DDL right at the bottom of the table

4) Table right click options. In Postico I can right click a table name and Open contents/structure/ddl, Copy Name (really useful for those dumb tables we set up in camelCase in the migration from mysql to postgres...), delete, truncate, Analyze, Vacuum, Reindex, Import CSV, and Export In TablePlus I can Import/Export Delete/Truncate. That's it.

Positive on TablePlus is that they did recently add some nice things to the SQL Query like wrapping my camelcase table name in double quotes for me. If only they could do that for the column names too...but it's not their fault we have our setup this way...

Also, I readily admit that Postico isn't as powerful as others. But I cannot use PGAdmin one more second in my life. I'd rather just use the cli.


Also a fan of Postico. For anyone curious, I emailed support asking if there would be access to multiple query tabs after purchase/activation, but got no response. I'm happy to report that it does work that way, and works well. I hope this is app is still being supported because it's overall it's quite well done.


The thing is that Postico was explicitly made for Postgres so it works flawlessly with it.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: