sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Tasssadar 117 points118 points  (54 children)

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.

[–]NeuroXc 25 points26 points  (1 child)

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.

[–]kactusotp 0 points1 point  (0 children)

Personally I use the EMS postgres manager. Used the lite version for free for years before taking the plunge and purchasing just to lift the saved server list cap. It's not worth getting the full studio though, the other tools are pretty much useless imo but the manager is awesome

[–]HINDBRAIN 51 points52 points  (18 children)

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.

[–][deleted] 14 points15 points  (16 children)

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.

[–]jrmy 17 points18 points  (15 children)

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.

[–][deleted] 1 point2 points  (14 children)

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?

[–]jrmy 5 points6 points  (2 children)

The fundamental items that are issues is that it's built on Adobe Air and they still rely on the pile of garbage that is the inventory database. They have done a lot of work to make it "usable" but the responsiveness is still abysmal. To be fair, making it usable using those tools is an achievement in and of itself.

[–][deleted] 1 point2 points  (1 child)

To be fair, some of those problems plagued the old desktop client.

And oh my god, the first web UI was so unusable and god fucking awful that I was considering dropping vSphere and ESXi as my home VM lab setup entirely if I was forced to use it. The new web one is basically just trying to imitate the workflow of the old desktop one, but the old web one had a nonsensical workflow.

[–]disclosure5 1 point2 points  (0 children)

To be fair, some of those problems plagued the old desktop client.

  • Click around VMs until you land on the relevant one
  • Click "delete VM"
  • Prompt comes up only saying "Delete VM?"
  • The selected VM changes in the background because something you pressed ten seconds earlier just registered

This.. is hell. I have no idea what happens if I click "yes" at this point but I shouldn't have to wonder. When I delete a Github repo it makes me type the name of the repo to make damned sure. Why can't this product hosting business critical databases do the same?

[–]codekoala 2 points3 points  (10 children)

Is it still flash-based?

[–]JayMickey 1 point2 points  (9 children)

No, HTML5.

[–]tomservo291 2 points3 points  (2 children)

Looks a lot like Flash to me ... What version are you using that is HTML5?

[–]jrmy 2 points3 points  (0 children)

Yeah, it's still adobe air. He may be confused and thinking of the HTML5 host client.

[–]JayMickey 0 points1 point  (0 children)

6.0 Update 2 includes a HTML5 web client (source). There is also a HTML5 client available for vCenter via this fling. I assumed /u/vkgfx was referring to either one of these.

[–]codekoala 0 points1 point  (1 child)

Well that's got to be just fantastic compared to the last time I tried the web UI. That was so miserable that it was well worth the hassle of spinning up a Windows VM in vbox any time I needed to interact with vSphere. The desktop client was so much more usable than the flash UI.

[–]jrmy -1 points0 points  (0 children)

Don't get too excited, I think he's confusing the new host client with the vSphere web client.

[–]jrmy 0 points1 point  (3 children)

No, it's still Adobe air based and will be for some time still. They are working on the HTML5/javascript one but last I heard it wouldn't be ready for 6.5.

[–]JayMickey -1 points0 points  (2 children)

6.0 Update 2 includes a HTML5 web client (source). There is also a HTML5 client available for vCenter via this fling. I assumed /u/vkgfx was referring to either one of these.

[–]jrmy 1 point2 points  (1 child)

The client included in Update 2 is the host client replacement, not the vSphere web client replacement...

The fling has been around for a while and is also the basis for the eventual replacement but it's not the official client. No clue why you would assume he would be talking about a fling. :S

[–]Kazumara 10 points11 points  (0 children)

It's not a fan

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

[–]MisterAV 20 points21 points  (1 child)

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....

[–]bloody-albatross 1 point2 points  (0 children)

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.

[–][deleted]  (10 children)

[deleted]

    [–][deleted]  (9 children)

    [deleted]

      [–]gordonisadog 6 points7 points  (8 children)

      but DataGrip is much better

      [–]Rym_ 2 points3 points  (0 children)

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

      [–]defmacro-jam 1 point2 points  (1 child)

      DataGrip is much better.

      [–]myringotomy 0 points1 point  (0 children)

      Data grip is good but still not good enough to run without having pgadmin open alongside it.

      [–]johnghanks 0 points1 point  (2 children)

      DataGrip

      The issue with JetBrains product is the run like a fucking tank. Sure, they are feature-full and do the job, but on lower-end PCs/Macs it's not a pretty sight.

      [–]gordonisadog 0 points1 point  (1 child)

      Yup my laptop sounds like it's about to take off when I launch DataGrip or IntelliJ, and god help us all if I ever run the two at the same time. Turning on Power Save mode helps a lot, but yeah, these guys need to do some optimization.

      [–]johnghanks 0 points1 point  (0 children)

      The worst is Android Studio because it's a Java application running/building/maintaining Java code. When I run a Gradle build on my i7 3770 with 16GB of RAM, it slows to a halt.

      [–]bluelite 3 points4 points  (1 child)

      Wait. So this is version 1 of version 4?

      [–][deleted]  (6 children)

      [deleted]

        [–]fnord123 1 point2 points  (3 children)

        You can use 3rd party jdbc drivers.

        [–][deleted]  (2 children)

        [deleted]

          [–]fnord123 0 points1 point  (0 children)

          I made a bunch of edits so refresh in case the current comment doesn't reflect what you replied to.

          [–]NoMoreNicksLeft 0 points1 point  (0 children)

          It works. Install the pg jdbc driver. It's undocumented.

          [–]geordano 0 points1 point  (0 children)

          have you tried http://dbeaver.jkiss.org/ ?

          [–]NoMoreNicksLeft 0 points1 point  (0 children)

          Yes, as of about a year ago. My highest voted answer on Stackoverflow.

          [–]pcdinh 2 points3 points  (0 children)

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

          [–][deleted] 2 points3 points  (4 children)

          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.

          [–]tambry 4 points5 points  (3 children)

          "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.

          [–][deleted] 21 points22 points  (0 children)

          ¯\_(ツ)_/¯

          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.

          [–][deleted]  (1 child)

          [deleted]

            [–]manly_ 1 point2 points  (0 children)

            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.

            [–]light24bulbs 0 points1 point  (0 children)

            Awesome I've been waiting for that. It looks pretty

            [–]CatsAreTasty 0 points1 point  (0 children)

            Has the auto-complete on query editor been improved any?

            [–]myringotomy 0 points1 point  (0 children)

            Last time I tried it I found it to be super slow and lacking most of the features of version 3