5 ms·
I agree Postgres is pretty awesome, but I think the one thing it has going against it is a good GUI client. MySQL has way too many good options wherease Postgre
by slake 10y ago
I agree Postgres is pretty awesome, but I think the one thing it has going against it is a good GUI client. MySQL has way too many good options wherease Postgres is stuck on this front.
- justintocci 10y agoPlease try Postage. It's free for all users, open source, comes in server and desktop distributions, and we listen to our users. You can get it at https://github.com/workflowproducts/postage https://github.com/workflowproducts/postage If it doesn't meet your needs please file an issue, our goal is to remove the no-good-GUI limitation that was imposed on postgres sixteen years ago.
- anarazel 10y agoWhat do you mean with "imposed"?
- justintocci 10y agoImposed, as in, to put something in place on purpose.
- anarazel 10y agoWho imposed it? There's not exactly much central control over postgres in general, and just about none over the tooling built outside the core repo.
- manigandham 10y agoHighly recommend DBeaver http://dbeaver.jkiss.org/ http://dbeaver.jkiss.org/
- fooey 10y agoI've tried really hard to like Postgres, but coming from SQL Server land, the tooling is mind blowingly atrocious. Every few months I go on a google spree trying to find the magic tool to make it less painful, but everything is either just as awful as pgadmin or costs way too much.
- justintocci 10y agoWe'd would love to have your help on Postage. We want to be the Microsoft SQL Server Management Studio of PostgreSQL. Just file issues at Github for bugs and features, we'll do our best to keep up.
- ianamartin 10y agoMicrosoft gets a lot of shit for various and mostly good reasons. But their tooling is seriously top notch. I would murder kittens to get tools like SSMS for postgres. Hell Python Tools for Visual Studio almost makes me want to do python dev work on a PC.
- jamiecurle 10y agoPostico is very nice. I've been using it (and it's predecessor - PG Commander) for a few years. Worth the money I paid for it. https://eggerapps.at/postico/ https://eggerapps.at/postico/
- davyjones 10y agoI developed and use(d) pgxplorer (github.com/pgxplorer). So, I can tell you this: the best out there is psql (CLI). There exists no use case where a GUI is better than psql.
- justinclift 10y agoNot even diagramming relationships between tables?
- davyjones 10y agoThose fall under db authoring/modeling tools. https://github.com/pgmodeler/pgmodeler https://github.com/pgmodeler/pgmodeler is a good pick.
- mythz 10y agoJetBrains DataGrip is also worth considering - another polished quality app from JetBrains: https://www.jetbrains.com/datagrip/ https://www.jetbrains.com/datagrip/
- slake 10y agoI've been meaning to try this. I'll check it out.
- dvcrn 10y agoI worked with people in the past that refused to touch postgres because it doesn't have a UI they like. They insisted on using MySQL for that sole reason.
- cyberferret 10y ago+1. The main reason I didn't jump on to Postgress decades ago was because the tooling was really bad. Third party tools for MySQL were streets ahead, even back then. End result is that I jumped on the MySQL bandwagon, and even all the negative posts against it now and the lauding of Postgres in here all the time cannot make me change tracks. I just have too much data and IP invested in it now.