Hacker News new | ask | show | jobs
by dhd415 3462 days ago
You're misinformed about the nature of the SQL Server codebase. While it was originally licensed from Sybase, all parts of it have been completely re-worked. I read somewhere that they celebrated "zero Sybase day" or something to that effect in the early 2000s to mark the retirement of the last of the original Sybase code. Some more info here: https://blogs.msdn.microsoft.com/euanga/2006/01/19/sql-mythb...

As for its performance and features, I have run PostgreSQL, MySQL, and SQL Server in production on large workloads and am a big fan of PostgreSQL. That said, I've encountered the fewest sharp edges and disappointments with SQL Server. It is a very respectable RDBMS and it's great that it's now available on Linux.
2 comments
pmelendez 3462 days ago
The main issue I have seen with SQL Server was a constant deadlock (every two weeks or so) over a table with high writes (peak at 800k per sec), which was annoying because the fail-back to the replica affected the DNS entries and meant 5-15min of outage.

But to be fair it was an example of the wrong tool used badly in the wrong situation deployed in a poor environment.

link
frik 3462 days ago
Instead of accusing me, maybe look at yourself. I correctly mentioned that it started as a fork of Sybase, and if you would have spent a minute with my first link, it's clearly mentioned that they refactored the codebase from C to C++ they completed with v2005. Of course there are still many parts in there for various reasons dating back more than 20 years, but it's now maintainable, refactored and internally documented. It's like Internet Explorer which started as a Mosaic fork, and there are still behaviours in IE11 and even in Edge (which started as fork of Trident from IE11) that date back to mid 1990s. Or with Half Life 2 and other Valve's Source-Engine video games - it all started from a Quake 1 engine fork, and you can still spot behaviours and there is still old stuff from ID software in crucial parts, even after like 20 years of refactoring.

And yes, it's good to have a choice. Some software is designed to run in combination with MSSQL. So it's good that they ported it to Linux.

link