3 ms·
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 i
by andrewmcwatters 5y ago
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.
- merb 5y agoif 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.
- andrewmcwatters 5y agoI 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.
- ekzy 5y agoIntelliJ is decent and has drivers for pretty much all database systems. It can be downloaded has a stand-alone too (DataGrip)
- andrewmcwatters 5y agoThank you for the insight!
- kaliszad 5y agoThat is for IntelliJ Ultimate if I am not mistaken: https://www.jetbrains.com/help/idea/connecting-to-a-database.html https://www.jetbrains.com/help/idea/connecting-to-a-database... Otherwise as you mention DataGrip https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/ seems to be really sleek.
- whitepoplar 5y agoYou 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.
- andrewmcwatters 5y agoThank you for sharing this!
- dd444fgdfg 5y agoPGAdmin is really fine for a GUI. Sure it's not beautiful but it's good enough.
- boundlessdreamz 5y agoThere's also https://tableplus.com/ https://tableplus.com/ - which supports an impressive list of databases and is all round amazing