Hacker News Reader

Open source databases still don't have a developer environment that matches what Oracle or SQL Server offer.

Same applies to their stored procedures languages and deployment options.

See, once I actually started using pl/pgsql, I found it really powerful and a match for T-SQL. Never used PL/SQL though, so can't compare.

And which PostgreSQL developer editor can match SQL Server Management Studio?

Because pgAdmin isn't it, specially after it became an Electron app.

You're not wrong there. I miss SSMS.

pgAdmin3 wasn't a terrible application. Nowhere near SSMS, but not terrible (other than stability... it's shit there).

pgAdmin4 is unusable.

Who actually uses these glorified IDEs? No one I've hired.

JetBrain's DataGrip is getting there for a wide variety of databases, including Postgres.

+1 for DataGrip, I use in nearly exclusively for MSSQL and PostgreSQL (I only fire up SSMS when I need to manipulate some features of the database I can never remember the T-SQL incantation for, because Microsoft has to make shit as obtuse as possible).

Reply on news.ycombinator.com