from Hacker News

Postage – A fast replacement for pgAdmin

by justintocci on 7/30/17, 2:51 AM with 127 comments

  • by skrebbel on 7/30/17, 4:58 AM

    Pretty off topic, but this appears to be made by a family that's also a software company. Or the other way around. Awesome team page: https://www.workflowproducts.com/about.html

  • by jafingi on 7/30/17, 6:37 AM

    PGAdmin 4 is one of the worst software releases I have ever experienced. Version 3 worked fine, but everything was destroyed with 4. So many things not working, UI bugs, and you have to click multiple times to get to the same point as you could in one click in 3.

  • by alexpetralia on 7/30/17, 1:14 PM

    Still highly recommend DBeaver for working with Postgres.

    My own post on the topic: http://alexpetralia.com/posts/2016/6/8/you-should-be-using-d...

  • by Posibyte on 7/30/17, 4:47 AM

    Is there a reason this was linked to the issues page rather than the repo root?

    By the way, this looks really nice. It's an electron app, but it references having "a small fast C core library in the style of Node.js and NGINX." Can you go into more detail about the architecture of this and how it's related to Node and NGINX?

  • by pw on 7/30/17, 6:05 AM

    If you're on Mac, another great, albeit not free, Postgres admin app is Postico (https://eggerapps.at/postico/).

  • by hendzen on 7/30/17, 9:20 AM

    You guys are offering free phone support? For a FOSS product. That is pretty cool.

    Also I would really recommend putting some of the screenshots on the Github readme page.

    See bottom - https://www.workflowproducts.com/postage.html

  • by sandGorgon on 7/30/17, 9:06 AM

    Serious suggestion - do this : http://sidekiq.org/products/pro

    Remember, it is very hard to donate...But very, very, very easy to pay for invoices.

    This is one of the coolest postgres apps, that actually works on Linux as well. I would love to see this supported.

  • by bdcravens on 7/30/17, 4:40 AM

    Screenshots on https://www.workflowproducts.com/postage.html should be clickable thumbnails for larger preview. Otherwise those are too small to see much detail

  • by temp on 7/30/17, 6:31 AM

    >electron

    Not a big fan of it so I think I'll continue using PSequel and pgAdmin3.

    With Slack already running, I can't have another battery hog running simultaneously.

  • by scient on 7/30/17, 2:01 PM

    A link to Github issues and a GH page with zero screenshots. Thats not how to promote your OS project :(

  • by taneem on 7/30/17, 5:35 AM

    Does this support JSONB column types? I was using Jetbrains Datagrip, which I've been very happy with except for the fact that it doesn't seem to support JSONB columns. I've switched back to PgAdmin 4, but the UI lag is really distracting.

  • by rosser on 7/30/17, 5:31 AM

    This looks great! You sold me with the object dependency graph alone.

    As someone who's fed himself as a PostgreSQL DBA for over a decade now, I'm excited to see what this can do for me. Thank you!

  • by acmecorps on 7/30/17, 11:29 AM

    My personal favorite - Valentina Studio.

    Available in windows, mac and linux. Can work with MySQL, PostgreSQL, SQLite.

    https://www.valentina-db.com/en/valentina-studio-overview

  • by unlimit on 7/30/17, 10:13 AM

    Great work, I will surely check this out. At this moment I use pgAdmin 4.1 and I don't really like it.

    There is a typo in the Description field of your https://www.workflowproducts.com/about.html page.

    Desktop is written as destop.

  • by kkoppenhaver on 7/30/17, 8:03 AM

    On a related note, a former co-worker built a similar tool. It's been helpful for me!

    https://sosedoff.github.io/pgweb/

  • by vdijkbas on 7/31/17, 6:45 PM

    I wrote a PR[1] for NixOS that adds a postage service. Just add the following to your configuration.nix to enable a postage web server:

      {
   services.postage = {
     enable = true;
     connections = {
       "local" = "hostaddr=127.0.0.1 port=5432 dbname=postgres";
     };
   };
  }
    BTW the postage devs were very helpful in fixing packaging issues.

    [1] https://github.com/NixOS/nixpkgs/pull/27796

  • by yellowapple on 7/30/17, 3:31 PM

    "Compiling Postage from source will only give you the server version and all first time users should try the desktop version first."

    Sorry what? How does one go about "compiling" the desktop version, then? Or the installers that are supposedly great?

    Something really reeks of red flags over here.

  • by spacetexas on 7/30/17, 6:49 AM

    Looks great! This is another option I've been using which I can suggest. https://github.com/web-pal/DBGlass

    Also based on Electron

  • by makkesk8 on 7/30/17, 10:04 AM

    Looks great! Decided to install it and test it only to be met with a blank screen, the dev console contains no errors as well. Anyone else having this issue? (windows 10, latest release)

  • by patrickbolle on 7/30/17, 6:55 AM

    Thanks for this, PGAdmin is painfully slow and clunky for me. Will give this a shot tomorrow morning!

  • by jaequery on 7/30/17, 5:27 PM

    it is good to see some one working on this, because Postgres really comes short when it comes to GUI clients when compared to Mysql.

  • by drew___ on 7/30/17, 10:04 AM

    Any plans for Linux support? I'm desperate for a postgresql admin suite that runs on Linux and in particular copes well with HiDPI displays.

  • by executive on 7/30/17, 3:58 PM

    Any PostGIS support?

  • by opmac on 7/30/17, 4:51 AM

    How is this any better than any other database admin tool?