This is really exciting. I choose Postgres for side projects and new consulting work.
But there are often times when you just don't have a choice. Sometimes it's SQL Server or bust, and you have to work with it. Hell, sometimes, it's MySQL, and you don't have a choice.
I don't hate it at all. I wish it had more of the PL parts of PL/SQL because that would make my life sometimes easier.
I had to implement some very crazy/stupid statistical procedures with SQL Server. It kind of sucked in ways that would have been a lot better in Postgres.
Lots and lots of fun with dynamic SQL where you're stuffing SQL into variables and interpolating column names from variables into those strings.
It was awful. But it worked.
If SQL Server would bring in even some of the PL features of Postgres or Oracle, I would use in a heartbeat.
The tooling that MS provides for SQL Server is second to none. I love me some open source, but the tooling we have available for Postgres and MySQL is just absolute crap compared to SSMS.
But there are often times when you just don't have a choice. Sometimes it's SQL Server or bust, and you have to work with it. Hell, sometimes, it's MySQL, and you don't have a choice.
I don't hate it at all. I wish it had more of the PL parts of PL/SQL because that would make my life sometimes easier.
I had to implement some very crazy/stupid statistical procedures with SQL Server. It kind of sucked in ways that would have been a lot better in Postgres.
Lots and lots of fun with dynamic SQL where you're stuffing SQL into variables and interpolating column names from variables into those strings.
It was awful. But it worked.
If SQL Server would bring in even some of the PL features of Postgres or Oracle, I would use in a heartbeat.
The tooling that MS provides for SQL Server is second to none. I love me some open source, but the tooling we have available for Postgres and MySQL is just absolute crap compared to SSMS.