Mastering PostgreSQL Administration [pdf]

Re:Mastering PostgreSQL Administration [pdf] by qwertox on Sunday September 27, 2020 @05:13PM (#24610169)

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?

[ Parent | on HN ]

Re:Mastering PostgreSQL Administration [pdf] by sk5t on Sunday September 27, 2020 @05:36PM (#24610318)

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

[ Parent | on HN ]

Re:Mastering PostgreSQL Administration [pdf] by Topgamer7 on Sunday September 27, 2020 @05:42PM (#24610355)

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

[ Parent | on HN ]

Re:Mastering PostgreSQL Administration [pdf] by SimonDorfman on Sunday September 27, 2020 @07:56PM (#24611311)

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

[ Parent | on HN ]

Re:Mastering PostgreSQL Administration [pdf] by brightball on Sunday September 27, 2020 @06:47PM (#24610805)

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.

[ Parent | on HN ]

Re:Mastering PostgreSQL Administration [pdf] by marcolussetti on Sunday September 27, 2020 @05:16PM (#24610184)

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

[ Parent | on HN ]

Re:Mastering PostgreSQL Administration [pdf] by garethm on Sunday September 27, 2020 @08:43PM (#24611644)

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

[ Parent | on HN ]

Re:Mastering PostgreSQL Administration [pdf] by Cyranix on Tuesday September 29, 2020 @07:43PM (#24634377)

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.

[ Parent | on HN ]

Re:Mastering PostgreSQL Administration [pdf] by hrishios on Wednesday September 30, 2020 @05:56AM (#24637055)

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.

[ Parent | on HN ]

Re:Mastering PostgreSQL Administration [pdf] by gsich on Sunday September 27, 2020 @06:54PM (#24610859)

phppgadmin or adminer.

[ Parent | on HN ]