News for hackers. Stuff that matters.
Re:In Praise of PostgreSQL by andrewmcwatters on Thursday August 05, 2021 @05:44PM (#28080351)
I want to use PostgreSQL, because there seems to be a lot of technical discussion around why it's so great, but the tooling I have available to me seems to be immature compared to MySQL's.

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.

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
Re:In Praise of PostgreSQL by merb on Thursday August 05, 2021 @05:50PM (#28080416)
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.
Re:In Praise of PostgreSQL by ekzy on Thursday August 05, 2021 @05:59PM (#28080532)
IntelliJ is decent and has drivers for pretty much all database systems. It can be downloaded has a stand-alone too (DataGrip)
Re:In Praise of PostgreSQL by kaliszad on Thursday August 05, 2021 @06:58PM (#28081165)
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.