4 ms·
No, almost certainly not. Why would I use MSSQL in the first place, when I could just use PostgreSQL? The main reason I could see to use MSSQL would be "you're
by mindcrime 9y ago
No, almost certainly not. Why would I use MSSQL in the first place, when I could just use PostgreSQL? The main reason I could see to use MSSQL would be "you're in a Windows shop already", and if that isn't the case, I don't see much reason for it.
- arethuza 9y agoIn my experience, the main reason why most organizations run things like SQL Server or indeed Oracle is because they want to run applications that depend on those particular databases.
- lmm 9y agoSure - but it would be weird for an application to depend on SQL server and not depend on Windows, and if you're going to be running Windows for some of your servers anyway it's easier to use the same platform for all of them.
- beefhash 9y agoThere are some .NET Core programs that also depend on SQL Server but not Windows necessarily. Bitwarden[1] comes to mind. [1] https://help.bitwarden.com/article/install-on-premise/ https://help.bitwarden.com/article/install-on-premise/
- hungerstrike 9y agoI would have said the same thing if I had never used MSSQL. PG just doesn't have the same quality SQL-dialect or tools as MSSQL though. Some very basic facilities are missing from PG like snapshot and transaction logs, batched triggers and being able to return multiple resultsets from a single trip to the database server. Even the free tools for SQL Server are better than anything you can get for PG and there's nothing like SQL Server Data Tools.
- fish_fan 9y agoHow is the JSON integration and geometry primitives? I had no idea it was competitive with postgres.
- snuxoll 9y ago"JSON" in SQL server is a set of functions layered on top of NVARCHAR(*) columns, so - about where PostgreSQL was when they first introduced the 'json' data-type. Can't say I've investigated the geometry types, but at a glance they're functional (if uglier to work with).
- jenkstom 9y agoThen again, T-SQL is a developer's nightmare. Especially when compared to PostgreSQL's version of SQL scripting. And when you add on all the supported languages it makes MSSQL quite painful from a SQL developer standpoint.
- Neckmeats 9y agoThis sounds like more of a religious issue than anything. All of the dialects of SQL have pros and cons, but if you stick as close to the ANSI standard as possible, the differences are negligible. If today's developers actually cared about relational theory, and spent the time to do it right, they wouldn't really care much of the difference between T-SQL or any other dialect. Like when developers bring up a platform preference based on JSON data type support... you're doing it wrong to begin with.
- fulafel 9y agoYou can return multiple result sets using a sproc or a view. Triggers sound strictly less powerful in SQL Server since "for each row" semantics is missing? Meanwhile there are many PG features missing.
- snuxoll 9y ago> Triggers sound strictly less powerful in SQL Server since "for each row" semantics is missing? Triggers in MS SQL are batched, you get "for each row" semantics by iterating over the contents of the virtual "inserted/updated/deleted" tables. This is honestly a pretty sane design choice, it helps trigger performance immensely when dealing with bulk data manipulation since you can do things like JOIN's on the whole set of triggered data allowing the execution engine to do one index scan or hash join instead of a bunch of index lookups on individual rows. Ironically, after doing salesforce.com development for a while this is one of the things I really wish PostgreSQL offered.
- manigandham 9y agoMSSQL is fast. It's seamless to use with .NET code and it has several features like columnstores, in-memory tables and graph processing that are very useful. Also availability groups are much better than Postgres solutions for high availability today.
- james_anderson 9y agoI really like AGs but I'm not sure I will love them on Linux. It still feels like it's early days for SQL Server's HA on Linux.
- manigandham 9y agoThat's true, although I'm looking forward to a far easier AG setup without Windows Clustering now.