Re:Amazon’s Consumer Business Turned Off Final Oracle Database
by olavgg on Tuesday October 15, 2019 @04:11PM
(#21263158)
I have worked with both databases over a decade. The biggest difference between SQL Server and Postgresql is neither tooling or performance(both are excellent), but the community and culture.
By far, PostgreSQL has more knowledge sharing and documented edge cases. Not to mention that the official PostgreSQL documentation is probably one of the best documented software systems ever. This makes PostgreSQL a lot easier to learn and use and that also affects the amount of money you need to spend.
SQL Server has some annoying edge cases, licensing is a real pain point these days, but so are the technical issues like lack of schema support in the JDBC driver. Other things are that you cannot pipe the backup. I would love to take backup of an Azure SQL service to my local machine with SSH.
Re:Amazon’s Consumer Business Turned Off Final Oracle Database
by fanf2 on Tuesday October 15, 2019 @04:37PM
(#21263459)
Instead of a table-valued parameter, wouldn’t you use an array of a composite type in PostgreSQL? What are the relative good and bad points?
Re:Amazon’s Consumer Business Turned Off Final Oracle Database
by philliphaydon on Wednesday October 16, 2019 @02:19AM
(#21267590)
Yeah. And you don’t need to create a custom type to handle it as a parameter. So it’s easier.
The only thing SQLServer has over PostgreSQL is multiply resultsets. That’s it. I really wish that existed in PostgreSQL to prevent round trips.
If you're a tiny startup, the differences won't amount to all that much, and it will be hard to justify MSSQL's price tag, which is fine, because, yeah, you can't afford it, anyway. If you're an enterprise or otherwise have large database needs, the differences can very quickly become apparent, and easily worth the money.