postgresql or mysql?

[User 9031882]

Hi.

I have to choose between MySQL and PostgreSQL. I like use MS SQL, but it expensive for the customer.
Database have about 100 tables with max. 200 thousands rows.
Front application is .NET (winform) ,dataset or entity framework.

It's critical application, reliability is required.

Please advice me.

Karol

[Lost User]

Member 9076609 wrote:

It's critical application, reliability is required.

Sounds like Oracle or SQL Server are the only two choices to consider.

[Tim Carmichael]

If it isn't too big, consider SQLServer Express. You may need to get creative in access, but that can be done. Don't forget to build some database maintenance, backup, etc.

[Lost User]

Member 9076609 wrote:

Please advice me.

Leave the choice to the customer. Program against the IDb-interfaces and use ANSI-92 SQL :)

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

[Jorgen Andersson]

Well, there's a lot of comparisons out there to read if you want to. But the tl;dr is: Performance and scalability -> MySql Reliability, data integrity and standard compliance -> PostGreSQL. While MySQL has gotten a lot better with the last versions it's still lacking a lot of functionality. And while it also can be (a lot) faster, it's only in certain scenarios. If you do a lot of paging, PostGres is the one outperforming everyone else. My personal choice would be PostGres, but mostly because it's more familiar as I have mostly used Oracle and SQLServer.

Wrong is evil and must be defeated. - Jeff Ello

[jonyj]

SQL Server if you can.