4 ms·
Similar in postgres, depending on version. SQL Server is a damn fine DB if you can afford it. Highly recommended.
by baq 4y ago
Similar in postgres, depending on version.
SQL Server is a damn fine DB if you can afford it. Highly recommended.
- jaggederest 4y agoSQL Server is one of the descendants of Ingres, and PostgreSQL is, as the name might suggest, the successor project for database research after Ingres. They're both great databases really, it's a fun connection in their mutual history.
- albertopv 4y agoWow, I didn't know!
- thomasjudge 4y agoSybase, actually
- jaggederest 4y agoThe first Sybase grew out of the Ingres project at UCB, so transitively, SQL Server is also a descendant.
- johnthescott 4y agobob epstein was vp at brittion-lee when he left to form sybase. BLI built a relational database machine (IDM), which was influenced by ingres but not much was inherited, code wise. sybase used a VM/pcode architecture, very much not like ingres. https://www.google.com/search?q=britton+lee+inc+wikipedia https://www.google.com/search?q=britton+lee+inc+wikipedia
- jaggederest 4y agoNeat, thanks for elaborating, I knew BLI grew out of the ingres project but not how closely they were related.
- dx034 4y agoI second that. I found it by far the most pleasant database to work with, including its tooling. Postgres is probably second. Too bad SQL Server is so expensive.
- sohnakukkar 4y agoHow much SQL Server costs?
- vikingerik 4y agoYou can google it, but the short answer is Enterprise Edition is on the order of tens of thousands of dollars per CPU.
- dx034 4y agoMaybe they'll change it at some point. I believe if SQL Server was free, it would dominate the business. I last used it 7+ years ago and back then it was (from my subjective experience) better than Postgres is now. And I love Postgres. But SQL Server was a dream to work with. Feature rich with amazing tooling. You can get most features in Postgres with plugins and manual work, but SQL Server does it all for you.