News for hackers. Stuff that matters.
Re:Show HN: DbGate – open-source, cross-platform SQL+noSQL d... by sam_goody on Thursday April 22, 2021 @07:44AM (#26901627)
Copying from an earlier comment of mine, as it might be useful to someone.

# Mysql Only:

- Sequel Pro (Free, Pretty, Mac only. Has issues with MySQL v8)

- Workbench - https://www.mysql.com/products/workbench (Free, Pretty)

- DBForge - https://www.devart.com/dbforge/mysql/studio/editions.html (Freemium)

- Querious - https://www.araelium.com/querious ($50 one time, Mac only)

- Sequel Ace - https://github.com/Sequel-Ace/Sequel-Ace (Free)

# Postgres Only:

- Postico ($40, Pretty, Mac only)

- PgAdmin - https://www.pgadmin.org (Free, Clunky)

# SQL Server:

- Azure Data Studio - https://docs.microsoft.com/en-us/sql/azure-data-studio (Free, Pretty)

# Multi DB:

- DataGrip ($89 first year, $71 second year, $53/year after that, Clunky, Powerful)

- TablePlus ($50, Pretty, Useful)

- DBeaver (Free version, Clunky, Powerful)

- Heidi (Free, Clunky, Usable)

- SQuirrel (Free, Clunky, Usable)

- http://sequeljoe.ohwg.net (Free, beta)

- Valentina Studio - https://www.valentina-db.com/en/valentina-studio-overview (Freemium, Pretty)

- Aqua Studio - https://www.aquafold.com ($500, Clunky)

- Navicat Premium ($599, Pretty, has good reputation)

- POPSql - https://popsql.com (free for 2 saved DB connections,12/Mo., Pretty)

- Beekeeper Studio (Free, Electron)

- DBGate (Free, Electron)

- VSCode Extensions (Free, Electron)

EDITED based on other comments

If I was getting new, I would definitely check out popsql, tableplus, and datagrip first.

Re:Show HN: DbGate – open-source, cross-platform SQL+noSQL d... by slenk on Thursday April 22, 2021 @08:49AM (#26902136)
I will second DBeaver. It can connect to anything and has made massive improvements since I started using it years ago
Re:Show HN: DbGate – open-source, cross-platform SQL+noSQL d... by WrtCdEvrydy on Thursday April 22, 2021 @06:25PM (#26908890)
I will admit that DBeaver is great but MongoDB is not supported on the community version so we ended up on Robo 3T for just that one use case.
Re:Show HN: DbGate – open-source, cross-platform SQL+noSQL d... by slenk on Thursday April 22, 2021 @06:43PM (#26909019)
I never use MongoDB but I did not know that. That's pretty lame.
Re:Show HN: DbGate – open-source, cross-platform SQL+noSQL d... by void_mint on Thursday April 22, 2021 @11:07AM (#26903597)
I used DBeaver for a few years until I got tired of giving 50% of my machine's resources to it, then switched to TablePlus and have been quite happy. I've never needed more than two tabs so I've never paid, but I absolutely would pay them (it's great).

If I was looking for something new right now, I'd try DataGrip first. I'm a huge fan of Jetbrains' products so I'd be happy to pay them for another useful tool.

Just my 2c. I'm sure others have different experiences/likes/dislikes

Re:Show HN: DbGate – open-source, cross-platform SQL+noSQL d... by vlkr on Thursday April 22, 2021 @11:45AM (#26904068)
i am using dbeaver right now, it uses not much resources, just 250mb of ram
Re:Show HN: DbGate – open-source, cross-platform SQL+noSQL d... by void_mint on Thursday April 22, 2021 @06:55PM (#26909114)
Interesting. I wonder what configuration or issue I was using that caused this problem for me.
Re:Show HN: DbGate – open-source, cross-platform SQL+noSQL d... by 2citizen on Thursday April 22, 2021 @08:11AM (#26901816)
If Azure means Azure Data Studio, it can be extended with other DB via official extensions.
Re:Show HN: DbGate – open-source, cross-platform SQL+noSQL d... by nerdponx on Thursday April 22, 2021 @08:55AM (#26902188)
If Mysql Workbench makes the list, why not Pgadmin?