I can't believe how hard it is to find a good database client tool that runs on Linux. I spent hours on Sunday looking for something that worked as well as pgadmin3. I don't prefer these Java tools that force you to manage JDBC drivers and usually share dated and cluttered UIs. Plus, I can't stand having to manage connections to each database instead of to each server. Let me connect to the server and then select my dB.
My notes:
- Lists
- https://wiki.postgresql.org/wiki/PostgreSQL_Clients
- https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
- Clients
- Most clients are Java, which is a pain b/c
- they require you to list the DB in the connection
- JDBC drivers can not use a socket connection
- UI isn’t great
- Valentina Studio
- Has free & pro ($199) versions
- Was the easiest to get connected initially, but then found bug that showed it wasn’t using socket connection as expected.
- Navicat
- Linux version is a Wine app
- RazorSQL ($100 / year)
- Is a Java app
- Not much different from SQL Workbench, just use that instead?
- TeamSQL
- Electron, AppImage
- Wanted me to enter an email address just to use the software, became privacy concerned about how much stuff would get sent to their servers
- DbVisualizer ($197, $69 renewal)
- Java
- Downloaded & tried it, typical java app
- SQL Workbench/J (OSS)
- Java
- Datazenit
- web based but still Java?
- PgManage
- too crude
- JetBrains DataGrip ($199 / $159)
- Java
- PgAdmin3
- has lots of errors when used with PostgreSQL 11
- PgAdmin4
- installed, couldn’t get past the splash screen which said it couldn’t find the application server
- Sqlectron
- Electron
- Couldn’t get a DB connection to save
- dbForge
- Windows only
- dbGlass
- No longer developed
- HeidiSQL
- Windows only
- DBeaver
- OSS and enterprise version
My notes: