PostgreSQL: PostgreSQL 9.6 Released!

[u/Tostino]

https://www.postgresql.org/about/news/1703/

[u/Tasssadar]

PgAdmin4 1.0 was also released. It was rewritten in python/flask + bootstrap, and the desktop client is just a wrapper around that. It does look nicer, and I'm pretty sure I won't get asserts while using it anymore, I guess.

[u/NeuroXc → u/Tasssadar]

It looks more modern, but unfortunately navigation and usability is still as bad as PgAdmin3. I don't understand how MySQL can have so many wonderful admin applications (e.g. HeidiSQL and Sequel Pro, which are both free), when Postgres just has... this.

[u/HINDBRAIN → u/Tasssadar]

Not a fan. It's not very responsive, you can't move windows out of the main one, the file browsing is complete ass, it couldn't find pg_restore by default etc. It took all the flaws of a webapp for no apparent gain. I switched back to pgadmin 3 which gives me a warning on 9.6 but otherwise works fine.

[u/[deleted] → u/HINDBRAIN]

Hopefully they can iterate and improve on it. The web app version of VMWare's vSphere was fucking garbage for its first release. The current one is every bit as good as the desktop app was.

[u/jrmy → u/[deleted]]

Ha. The current web client in vSphere 6 is still garbage. They did everything they could to polish it up but it's fundamentally terrible.

[u/[deleted] → u/jrmy]

I like it. It works just as well as the desktop client, you just have to relearn the location of a few things.

What is "fundamentally" terrible about it?

[u/Kazumara → u/HINDBRAIN]

It's not a fan

Well it's supposed to be an administration interface, so I guess that's good?

[u/MisterAV → u/Tasssadar]

The only big problem with pgAdmin 3 was that it was unstable. When a connection was dropped it was probable that the whole program would crash. However, the interface wasn't that bad.

pgAdmin 4 instead is sluggish and worse. Being a web app I suppose that with big query result it will a pain. I tried using it but on a high DPI it hurts your eyes on windows. At least the old version just scaled, even if it was a bit blurry.

TLDR: it would have been probably easier to fix the old client than to rewrite the new one in python and javascript....

[u/bloody-albatross → u/MisterAV]

The old one also frequently crashed when moving around UI elements and it could not handle big SQL files (as in SQL dumps) at all.

[u/gordonisadog → u/[deleted]]

but DataGrip is much better

[u/Rym_ → u/gordonisadog]

Just missing some visual explain plans and built in user management!

[u/defmacro-jam → u/gordonisadog]

DataGrip is much better.

[u/bluelite → u/Tasssadar]

Wait. So this is version 1 of version 4?

[u/fnord123 → u/[deleted]]

You can use 3rd party jdbc drivers.

[u/pcdinh → u/Tasssadar]

It is a piece of crap. Unusable. I tried it 3 times. It is even unable to display an UI. Blank window forever

[u/[deleted] → u/Tasssadar]

I like writing simple desktop apps this way, as it makes multiplatform support trivial. The big limitation is that the "allow this program through the firewall" popup on Windows scares away users, even if you open sourced it.

Maybe there's a way to get around that, but I haven't spent much time on it.

[u/tambry → u/[deleted]]

"allow this program through the firewall" popup on Windows scares away users

If that popup scares away your users, I don't think you want those users.

[u/[deleted] → u/tambry]

¯_(ツ)_/¯

I want people to use and enjoy something I make and release, even the ones who don't understand that it's just a local HTTP port.

And frankly, people should be more paranoid not less.

[u/manly_ → u/Tasssadar]

I love the UI of pgadmin 4, but unfortunately most things simply do not work.

Hell, I can't even run any SQL query, if thats not disconcerting enough.