MySQL or PostgreSQL for high-volume high-performance database?

[BR14]

DB2

[NickFitz]

CSV

[jamesbrown]

Asynchronous punched card.

[Lance]

MySQL is owned by Oracle. Ergo MySQL will never be as good as Oracle as it will be hampered. Therefore PostgreSQL could always become better.

Also MySQL is very bloated since Oracle took over and I hate that. Went from 5MB download to over 80MB almost overnight. I guess it’s probably a gig by now.

[OwlHoot]

CSV

Yep, most of clientco's clients send them data in CSV format.

But most of the baboons who write the code to produce the CSV seem to have no idea there is a CSV standard. So we have endless problems with the data (although it all helps keep me in contract!)

[BR14]

DB2

high-volume high-performance database.

[TheGreenBastard]

If you talking high volume high performance in the context of a financial app handling millions of transactions, MySQL and PostGre do not come any close to Apache Cassandra. In fact even Oracle and MSSQL struggle to cope.

Cassandra doesn't offer the same guarantees of transactional DBs, so Cassabdra certainly is not used for high transactional workloads from my experience, it only has weak pseudo transactions. Financial apps vertically scale things like Oracle/Postgres which still get tens of thousands of tx regardless of what NoSQL hipsters say. Right tool for the workload at the end of the day.

[NickFitz]

Yep, most of clientco's clients send them data in CSV format.

But most of the baboons who write the code to produce the CSV seem to have no idea there is a CSV standard. So we have endless problems with the data (although it all helps keep me in contract!)

Might be worth running them through Simon Willison's csvs-to-sqlite - although SQLite might not be a suitable database for your end product, it's easier to automate the extraction of the data from it after the import so you can get it into wherever it needs to be.

[quackhandle]

SQL Server 2016. Yes, really.

qh

[minestrone]

Call me crude but unless you have less than no money or are working on some kind of massive data real time thing it's probably not going not matter.