4 ms·
For a really nice client for macOS see Postico: https://eggerapps.at/postico/ https://eggerapps.at/postico/ (not affiliated, just a fan)
by jamil7 5y ago
For a really nice client for macOS see Postico:
https://eggerapps.at/postico/ https://eggerapps.at/postico/
(not affiliated, just a fan)
- b6z 5y agoIt's mentioned and linked in the article. And "[i]t’s made by the same people that maintain Postgres.app."
- jamil7 5y agoI was aware it was from the same author and brought it up, didn't realize it was linked on the homepage! Thanks.
- kentiko 5y agoAnother alternative feature rich client: https://dbeaver.io/download/ https://dbeaver.io/download/
- rubyist5eva 5y agoI 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.
- sigzero 5y agoWow, that looks very nice.
- nguyenkien 5y agoKeep in mind, Windows & Mac version require separate purchase
- rubyist5eva 5y agoOh 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.
- jamil7 5y agoTablePlus is also great, I keep it around for sqlite specifically.
- elpatoisthebest 5y agoPostico 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...
- mekster 5y agoWhat's better with Postico over TablePlus?
- elpatoisthebest 5y agoWell, 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.
- Eikon 5y agoThere’s also tableplus https://tableplus.com/ https://tableplus.com/
- sergiomattei 5y agoTable Plus is awesome and native on macOS.
- mekster 5y agoAnd you don't need different app for different databases as it supports quite plenty of them.
- ultrarunner 5y agoAlso 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.
- rzr999 5y agoThe thing is that Postico was explicitly made for Postgres so it works flawlessly with it.