Hacker News Reader

Comment by qwertox | Hacker News Reader

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?

View on HN

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

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 :)

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-...

https://docs.microsoft.com/en-us/sql/azure-data-studio/exten...

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.

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).

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

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.

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.

phppgadmin or adminer.

Reply on news.ycombinator.com