4 ms·

I have a bookmarking system built with MongoDB as the database. It has user and device management, real-time synchronization. I am seriously considering migrat

I have a bookmarking system built with MongoDB as the database. It has user and device management, real-time synchronization. I am seriously considering migrating it to PostgreSQL, rewriting the entire backend. One of the greatest things about MongoDB is the existence of Studio 3T, a really good administration software for MongoDB, and I wouldn't want to miss it. I spent a couple of years coding with MySQL and used phpMyAdmin. I wouldn't want to go back to such a tool, and I think that pgAdmin is what would be PostgreSQL's alternative to phpMyAdmin. The only software which I found to suite me was DataGrip. Are those the only two reasonable administration tools for PostgreSQL? DataGrip and pgAdmin?

brightball 6y ago
I’m personally a huge fan of Navicat. It was always the best tool of those I’d tried and it was my most missed piece of software when I moved from OSX to Ubuntu full time. They finally released a native Linux version and I’ve been on cloud nine ever since.
marcolussetti 6y ago
I'd suggest that for MySQL, MySQL Workbench is a closer comparison to Studio 3T, and in my limited experience quite good. (I really like their diagramming tool, but haven't used the rest of the toolset in some years).
sk5t 6y ago
Dbeaver is quite good. IMHO pgAdmin should be avoided. psql and pgcli are really nice at the command line. https://github.com/dhamaniasad/awesome-postgres https://github.com/dhamaniasad/awesome-postgres
- Topgamer7 6y ago
  Yep, use DBeaver for all my sql management needs. I recommend it to everyone after TeamSQL gave up the ghost. SSH tunneling for aws is handy :)
gsich 6y ago
phppgadmin or adminer.
SimonDorfman 6y ago
Azure Data Studio (which I like for Microsoft databases) has an extension to connect to Postgres. Maybe worth trying. https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is https://docs.microsoft.com/en-us/sql/azure-data-studio/what-... https://docs.microsoft.com/en-us/sql/azure-data-studio/extensions/postgres-extension https://docs.microsoft.com/en-us/sql/azure-data-studio/exten...
garethm 6y ago
I use DataGrip with PostgreSQL and am generally happy with it.
Cyranix 6y ago
I love Postico on OSX. Not 100% certain that it does 100% of what other apps do, but it has been a real breath of fresh air for my development needs.
- hrishios 6y ago
  Postico is amazing. I recently moved out of MacOS, and I can honestly say that it's the only tool that keeps making me want to move back. pgAdmin is a right pain.

brightball 6y ago

I’m personally a huge fan of Navicat. It was always the best tool of those I’d tried and it was my most missed piece of software when I moved from OSX to Ubuntu full time. They finally released a native Linux version and I’ve been on cloud nine ever since.

marcolussetti 6y ago

I'd suggest that for MySQL, MySQL Workbench is a closer comparison to Studio 3T, and in my limited experience quite good. (I really like their diagramming tool, but haven't used the rest of the toolset in some years).

sk5t 6y ago

Dbeaver is quite good. IMHO pgAdmin should be avoided. psql and pgcli are really nice at the command line. https://github.com/dhamaniasad/awesome-postgres https://github.com/dhamaniasad/awesome-postgres

Topgamer7 6y ago
Yep, use DBeaver for all my sql management needs. I recommend it to everyone after TeamSQL gave up the ghost. SSH tunneling for aws is handy :)

gsich 6y ago

phppgadmin or adminer.

SimonDorfman 6y ago

Azure Data Studio (which I like for Microsoft databases) has an extension to connect to Postgres. Maybe worth trying. https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is https://docs.microsoft.com/en-us/sql/azure-data-studio/what-... https://docs.microsoft.com/en-us/sql/azure-data-studio/extensions/postgres-extension https://docs.microsoft.com/en-us/sql/azure-data-studio/exten...

garethm 6y ago

I use DataGrip with PostgreSQL and am generally happy with it.

Cyranix 6y ago

I love Postico on OSX. Not 100% certain that it does 100% of what other apps do, but it has been a real breath of fresh air for my development needs.

hrishios 6y ago
Postico is amazing. I recently moved out of MacOS, and I can honestly say that it's the only tool that keeps making me want to move back. pgAdmin is a right pain.