3 ms·
SQL Server has a column-oriented index type. Oracle has a thing that lets you query based on what the data was at a particular (recent) timestamp. They both hav
by guscost 8y ago
SQL Server has a column-oriented index type. Oracle has a thing that lets you query based on what the data was at a particular (recent) timestamp. They both have lots of useful features like that.
However from my experience with Oracle and from what I've heard about their source code, its fundamentals are just disgusting. Decades of haphazardly piled-up features and fixes means that if you're the lucky customer to find a new bug, good luck understanding what the heck is going on by yourself.
I'd like to think MSSQL is in a bit better shape, but they have lots of the same incentives so who knows.
- abraae 8y agoOracle is like America. Its not all the same. The database itself is now one of the most rock solid pieces of software ever built. Other products - yeah, less so.
- SahAssar 8y agoI think this is perhaps referencing a recent HN comment about the code quality of Oracle DB: https://news.ycombinator.com/item?id=18442941 https://news.ycombinator.com/item?id=18442941
- abraae 8y agoHa, that's pretty interesting. Not too sure how much credit to give it though based on this: > It takes 6 months to a year (sometimes two years!) to develop a single small feature (say something like adding a new mode of authentication like support for AD authentication). There's no way in the world I would have imagined that adding AD authentication to any database would be a "single small feature".