News for hackers. Stuff that matters.
Re:Nine ways to shoot yourself in the foot with PostgreSQL by baq on Tuesday April 25, 2023 @03:41AM (#35697621)
Similar in postgres, depending on version.

SQL Server is a damn fine DB if you can afford it. Highly recommended.

Re:Nine ways to shoot yourself in the foot with PostgreSQL by jaggederest on Tuesday April 25, 2023 @04:12AM (#35697817)
SQL 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.
Re:Nine ways to shoot yourself in the foot with PostgreSQL by albertopv on Tuesday April 25, 2023 @04:15AM (#35697838)
Wow, I didn't know!
Re:Nine ways to shoot yourself in the foot with PostgreSQL by thomasjudge on Tuesday April 25, 2023 @09:08AM (#35699927)
Sybase, actually
Re:Nine ways to shoot yourself in the foot with PostgreSQL by jaggederest on Tuesday April 25, 2023 @12:14PM (#35702506)
The first Sybase grew out of the Ingres project at UCB, so transitively, SQL Server is also a descendant.
Re:Nine ways to shoot yourself in the foot with PostgreSQL by johnthescott on Tuesday April 25, 2023 @05:06PM (#35706813)
bob 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

Re:Nine ways to shoot yourself in the foot with PostgreSQL by jaggederest on Tuesday April 25, 2023 @05:09PM (#35706838)
Neat, thanks for elaborating, I knew BLI grew out of the ingres project but not how closely they were related.
Re:Nine ways to shoot yourself in the foot with PostgreSQL by dx034 on Tuesday April 25, 2023 @04:21AM (#35697874)
I 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.
Re:Nine ways to shoot yourself in the foot with PostgreSQL by sohnakukkar on Tuesday April 25, 2023 @08:08AM (#35699339)
How much SQL Server costs?
Re:Nine ways to shoot yourself in the foot with PostgreSQL by vikingerik on Tuesday April 25, 2023 @09:32AM (#35700206)
You can google it, but the short answer is Enterprise Edition is on the order of tens of thousands of dollars per CPU.
Re:Nine ways to shoot yourself in the foot with PostgreSQL by dx034 on Friday April 28, 2023 @03:59AM (#35738708)
Maybe 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.