News for hackers. Stuff that matters.
Re:RethinkDB Postmortem by slake on Tuesday January 17, 2017 @10:56PM (#13423841)
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.
Re:RethinkDB Postmortem by justintocci on Tuesday January 17, 2017 @11:20PM (#13423932)
Please 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

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.

Re:RethinkDB Postmortem by anarazel on Tuesday January 17, 2017 @11:31PM (#13423975)
What do you mean with "imposed"?
Re:RethinkDB Postmortem by justintocci on Tuesday January 17, 2017 @11:36PM (#13423991)
Imposed, as in, to put something in place on purpose.
Re:RethinkDB Postmortem by anarazel on Tuesday January 17, 2017 @11:42PM (#13424022)
Who 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.
Re:RethinkDB Postmortem by fooey on Wednesday January 18, 2017 @01:11AM (#13424440)
I'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.
Re:RethinkDB Postmortem by ianamartin on Wednesday January 18, 2017 @01:54AM (#13424615)
Microsoft 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.

Re:RethinkDB Postmortem by justintocci on Wednesday January 18, 2017 @01:21AM (#13424471)
We'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.
Re:RethinkDB Postmortem by mythz on Wednesday January 18, 2017 @02:17AM (#13424698)
JetBrains DataGrip is also worth considering - another polished quality app from JetBrains: https://www.jetbrains.com/datagrip/
Re:RethinkDB Postmortem by slake on Saturday January 28, 2017 @11:51PM (#13512215)
I've been meaning to try this. I'll check it out.
Re:RethinkDB Postmortem by dvcrn on Wednesday January 18, 2017 @04:10AM (#13425058)
I 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.
Re:RethinkDB Postmortem by cyberferret on Wednesday January 18, 2017 @06:38AM (#13425653)
+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.

Re:RethinkDB Postmortem by manigandham on Wednesday January 18, 2017 @01:06AM (#13424417)
Highly recommend DBeaver http://dbeaver.jkiss.org/
Re:RethinkDB Postmortem by nanch on Wednesday January 18, 2017 @03:20AM (#13424911)
Just downloaded it and it seems effective and well-polished. Thanks for the recommendation, mySQL Workbench has some killer bugs that made me stop using it.
Re:RethinkDB Postmortem by slake on Saturday January 28, 2017 @11:52PM (#13512217)
Will try. Thanks
Re:RethinkDB Postmortem by jamiecurle on Wednesday January 18, 2017 @01:27AM (#13424499)
Postico 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/

Re:RethinkDB Postmortem by davyjones on Wednesday January 18, 2017 @01:59AM (#13424633)
I 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.
Re:RethinkDB Postmortem by justinclift on Wednesday January 18, 2017 @02:47AM (#13424799)
Not even diagramming relationships between tables?
Re:RethinkDB Postmortem by davyjones on Wednesday January 18, 2017 @06:21PM (#13431454)
Those fall under db authoring/modeling tools. https://github.com/pgmodeler/pgmodeler is a good pick.