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.
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.
SQL Server is a damn fine DB if you can afford it. Highly recommended.