Hacker News Reader

Comment by ganomi | Hacker News Reader

Free alternative i have been using for some years now: https://dbeaver.io/

The community edition is updated more often than i would like and sometimes features break but bugs get fixed quickly and they add usefull stuff all the time.

Dont know what i would do if i was stuck with pgAdmin...

View on HN

I'm using it on daily basis but it's not a smooth experience. I'm not sure if it's just me that very time I switch to a new database in dbeaver and start running a different query ... more often than not it's just stuck there for more than half min and eventually told me it's not connected to the new database yet so I had to refresh the connection. For all the SQL tools I've used, dbeaver takes the the longest to realize it's actually not connected to a db. It's not fun.

This is my only real complaint with DBeaver.

You have to invalidate / refresh the DB connection so often and this is really an issue when you use Docker in development.

If you do a docker-compose stop and then docker-compose up, your PostgreSQL connection will drop which means you need to reset it in DBeaver manually.

I quite like Postico (Mac-only though)

https://eggerapps.at/postico/

Using Postico for long time, great so far and is also cheaper.

It's Mac-only, but also Postgres-only! TablePlus has wider datastores support.

Postico is a lot nicer to use, though. I still use it for PostgreSQL databases, even though I have TablePlus for everything else.

As someone who likes Postico but has some frustrations with it, I've been considering giving TablePlus a try. Can you describe some of the ways TablePlus falls short compared to Postico?

I like SequelPro. The UI much simpler, powerful, but it's inactivated, nobody working on it to update for new macOS :(

Which is a big shame. I'm happy to $$$ pay for Sequel Pro, but it's been abandoned for 1-2 years now?

Last commit to master was 7 months ago. Judging by the pull request activity I'd say it's ripe for a community fork.

it seems the guy releasing nightly builds even don't have permission to merge. I don't know why no one folk and release a fix version with active members

I loved it and would pay for it. But after 3 months of restarting it a couple of times a day since the 2018 Mac update, I switched to TablePlus.

I still miss SequelPro, as its search and export features where way better then TablePlus’ way.

There are nightly builds, including in Homebrew. They're not perfect but the only bug I've run into is filtering the query history.

Nightly builds have some fixes, but it does seem to be mostly abandoned.

I've been using mysql workbench for a few years now. Is free, works well, is cross platform and open source.

1990s Java swing clunky UI... would rather use CLI IMHO.

That literally the name of the animal

it's not swing, it's SWT that is why it has the native look

It may be a reliable and useful application, but it definitely does not have anything close to a "native look".

DBeaver is great for MySQL databases. HeidiSQL is another good one for MySQL databases.

pgAdmin is not good.

Reply on news.ycombinator.com