Re:The sudden death and eternal life of Solaris
by pjmlp on Tuesday September 05, 2017 @02:25AM
(#15172926)
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.
Re:The sudden death and eternal life of Solaris
by Tostino on Tuesday September 05, 2017 @08:01AM
(#15174315)
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.
Re:The sudden death and eternal life of Solaris
by pjmlp on Tuesday September 05, 2017 @08:27AM
(#15174453)
And which PostgreSQL developer editor can match SQL Server Management Studio?
Because pgAdmin isn't it, specially after it became an Electron app.
Re:The sudden death and eternal life of Solaris
by Tostino on Tuesday September 05, 2017 @08:32AM
(#15174478)
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.
Re:The sudden death and eternal life of Solaris
by fulminatorz68 on Tuesday September 05, 2017 @09:48AM
(#15175074)
Who actually uses these glorified IDEs? No one I've hired.
Re:The sudden death and eternal life of Solaris
by jen20 on Tuesday September 05, 2017 @08:38AM
(#15174515)
JetBrain's DataGrip is getting there for a wide variety of databases, including Postgres.
Re:The sudden death and eternal life of Solaris
by snuxoll on Tuesday September 05, 2017 @12:09PM
(#15176553)
+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).
Oracle's only redeeming quality seems to be free golf at nice country clubs paid for by Oracle salespeople.