[HN Gopher] PgManage: Modern, cross platform graphical database ...
___________________________________________________________________
PgManage: Modern, cross platform graphical database client
Author : thunderbong
Score : 103 points
Date : 2024-07-21 12:20 UTC (10 hours ago)
(HTM) web link (github.com)
(TXT) w3m dump (github.com)
| jand wrote:
| Is there an existing comparison between pgManage and pgAdmin
| somewhere?
|
| At first glance, it seems they serve the same purpose. Am i
| missing something? (besides the support for some other DBs - but
| pgManage states to target postgres primarily)
| janice1999 wrote:
| This is a fork and the new developers have no companies or social
| media profiles linked from their GitHub profiles. After the
| attempted XZ Utils backdoor attempt, that is a major red flag for
| me.
| justinclift wrote:
| While I don't personally think this'll be useful for me as it
| doesn't seem to support unix socket connections, the company
| that's providing it is Command Prompt, Inc.
|
| They've been involved with the PostgreSQL Community for at
| least 2 decades (as have I), so it's super unlikely this is
| something malicious.
| janice1999 wrote:
| That's good to know. I've been looking for an alternative to
| DBeaver.
| ezst wrote:
| Just curious, what's wrong with dbeaver?
| muhehe wrote:
| I'd like to know too, because I think it's really great
| cachvico wrote:
| It can be pretty awkward to work with, although I've not
| found anything comparable, free, and cross-platform.
|
| Sometimes the FK links in cells break. Other times views
| don't get invalidated when pressing refresh until a
| reboot. There are different refresh buttons all over the
| place for different contexts. Lots of minor quibbles
| despite almost weekly updates. It does have a gamut of
| features though - and it's free and cross-platform
| though, so it's one of those love-hate relationships for
| me.
| mixmastamyk wrote:
| Mostly great, but I had an intermittent key remapping bug
| on the Mac not fixed for years. The default home/end
| document on Mac is not useful. Annoying enough to
| consider options.
| awesan wrote:
| For me, the biggest problem is its startup time (it takes
| at least 30-60s on my work laptop). It also randomly
| crashes for me when viewing any postgis related result
| sets.
| mjaniczek wrote:
| My biggest issue with it is how everytime I open it, it
| asks me to install a new version. Like, I am glad they're
| working on the software, but I'm getting fatigued from
| the inevitable popup
| bogwog wrote:
| Me too. I ended up going with DbGate (https://dbgate.org/).
| It's a little rough around the edges, but it has a lot of
| features.
| infamia wrote:
| Dbgate looks really interesting, do you know if it
| supports debugging (especially in postgres)? I didn't see
| anything on their site, but maybe it is offered via a
| plugin or something?
| bbkane wrote:
| I really like https://www.beekeeperstudio.io/ for my simple
| needs (view tables, run/format SQL, edit tables like
| spreadsheets)
| jawngee wrote:
| command prompt is pretty well known in the postgres world.
| justinclift wrote:
| Just tried this out, and although it visually looks ok it doesn't
| seem to even support basic connectivity options like unix
| sockets.
|
| eg the hostname field for new connections _must_ be a hostname or
| IP address, and can 't take things like `/var/run/postgresql`.
|
| That's super unfortunate. :(
|
| ---
|
| As a data point, the program seems to create config files (on
| Linux) under `~/.config/PgManage` and `~/.pgmanage`. If you
| delete the application after testing, you might as well nuke
| those two dirs as well.
| mst wrote:
| libpq normally connects to a unix socket by being given
| 'localhost' as the hostname or no hostname at all.
|
| IIRC it'll also accept a path -as- a hostname but I'm guessing
| from your phrasing the field validation won't.
| uhoh-itsmaciek wrote:
| Are you sure about localhost? I'm not familiar with other
| libpq clients, but psql definitely always resolves localhost
| to an IP address for me.
|
| You're right about it accepting a path (and defaulting to a
| compile-time selected UNIX socket path).
| justinclift wrote:
| > libpq normally connects to a unix socket by being given
| 'localhost' as the hostname or no hostname at all.
|
| 'localhost' for a unix socket doesn't sound right.
| 'localhost' is a specific network address and has a default
| configuration in pg_hba.conf (127.0.0.1) for itself. It's
| different to the 'local' entry in pg_hba.conf that's
| specifically for unix sockets.
|
| And yeah, the field validation in the IDE _required_ some
| kind of value in the hostname field, and wouldn 't take a
| path (ie /var/...etc), so no kind of fallback behaviour
| seemed workable. :(
| Asmod4n wrote:
| looks like you can just use a connection URL,
| https://www.postgresql.org/docs/current/libpq-
| connect.html#L..., it's possible to use it to connect to a unix
| socket that way.
| justinclift wrote:
| Ahhh cool, good thinking. I've already moved on, but might
| take another look at a future point. :)
| switch007 wrote:
| IntelliJ's database client is excellent too (available in many of
| their IDEs, cross platform - but only available in the paid
| versions I believe). Auto complete, many export options, editing,
| record views, results diffing, vast amounts of supported engines,
| and so much more
|
| I don't think I've ever encountered a bug in 5 plus years of
| using it
|
| https://www.jetbrains.com/help/idea/relational-databases.htm...
| justinclift wrote:
| > I don't think I've ever encountered a bug in 5 plus years of
| using it
|
| I have. There was a time a few years ago when the PG connection
| library it used to download would crash the whole IDE. The
| problem went away after a while (few weeks?), but I don't
| remember the details.
| martinsnow wrote:
| Haven't had that issue and I've used it since 2015.
| justinclift wrote:
| Well, good for you. ;)
| kspacewalk2 wrote:
| Their standalone client, DataGrip, is excellent, and free for
| educational institutions.
| switch007 wrote:
| You can also download the EAP ("beta") builds for free :)
| ekzy wrote:
| They also have it as a standalone database IDE, called
| datagrip. It's really good if you're not already using the
| plugin.
| microflash wrote:
| DataGrip, Jetbrains' standalone database IDE, is also
| excellent. I have been using it for several years to work with
| Postgres, Oracle and Redis.
| hk1337 wrote:
| I've even used it to connect to sql server
| tempest_ wrote:
| This looks nice.
|
| I have been looking for a DB client for postgres that seems to
| match the correct amount of features and interface that
| phpmyadmin has.
|
| Not really a fan of pgadmin, I just find the interface to be too
| clunky.
| tlh wrote:
| Thoughts on TablePlus? It's my goto and have never been left
| disappointed by it
| dewey wrote:
| If you are interested in this there's of course also the mature
| https://www.pgadmin.org. It's available for many platforms as an
| app or Docker image.
| infamia wrote:
| This is great! OmniDB, which PgManage is based off of, was one of
| the very few free SQL IDEs that supported a debugger. Granted,
| the debugger UI was pretty clunky, but it did work.
|
| https://github.com/OmniDB/plpgsql_debugger
| adultSwim wrote:
| I've been using Azure Data Studio with the Postgres plugin.
| https://azure.microsoft.com/en-us/products/data-studio
| tomjen3 wrote:
| How does this compare with something like DBeaver, my goto
| graphical DB client?
| hgyjnbdet wrote:
| DBeaver is my go-to as well, came here to ask the same
| question.
| eqvinox wrote:
| nit: it's not a graphical database client, it's a browser-hosted
| database client.
|
| A "graphical" database client would be running as a standalone
| application outside any browser.
|
| [... according to the definitions I'm familiar with ...]
___________________________________________________________________
(page generated 2024-07-21 23:04 UTC)