Re:In Praise of PostgreSQL
by whitepoplar on Thursday August 05, 2021 @05:55PM
(#28080473)
You need you some Postico*! Absolutely fantastic GUI for Mac.
* Postico 1 is great, but the soon-to-be released Postico 2 is in beta atm and even better.
Re:In Praise of PostgreSQL
by andrewmcwatters on Thursday August 05, 2021 @06:36PM
(#28080949)
Thank you for sharing this!
Re:In Praise of PostgreSQL
by boundlessdreamz on Friday August 06, 2021 @12:17AM
(#28083274)
There's also https://tableplus.com/ - which supports an impressive list of databases and is all round amazing
if you use psql you will be way more productive than using any gui tool. also Sequel Ace is so barbones that using a cli is way way faster.
Re:In Praise of PostgreSQL
by andrewmcwatters on Thursday August 05, 2021 @05:53PM
(#28080451)
I understand that, but I'm not interested in writing everything by hand. I'd rather have tooling work for me instead, and verify correctness by reading the manual for this-or-that. It also helps my staff when I have a recommended tool for those less SQL inclined.
IntelliJ is decent and has drivers for pretty much all database systems. It can be downloaded has a stand-alone too (DataGrip)
That is for IntelliJ Ultimate if I am not mistaken: https://www.jetbrains.com/help/idea/connecting-to-a-database... Otherwise as you mention DataGrip https://www.jetbrains.com/datagrip/ seems to be really sleek.
Re:In Praise of PostgreSQL
by andrewmcwatters on Thursday August 05, 2021 @06:36PM
(#28080952)
Thank you for the insight!
Re:In Praise of PostgreSQL
by dd444fgdfg on Thursday August 05, 2021 @08:08PM
(#28081677)
PGAdmin is really fine for a GUI. Sure it's not beautiful but it's good enough.
And so, I find it really difficult to justify investing time in building up infrastructure to support it for my clients' work, because I need to be effective from day one.
Realistically that has absolutely nothing to do with PostgreSQL but whether or not some little third-party company or one or two individual developers have built something solid like Sequel Ace. That's really troubling for me to think about, but these CLI tools are insufficient for being productive.
This a great example to me as to why a business can't use a potentially superior product because some ecosystem feature is non-existent, or is hard to find.
That being said, I'm not too upset because modern MySQL seems perfectly fine, and still more widely used than PostgreSQL.