Reply to: MySQL or PostgreSQL for high-volume high-performance database?

[AtW]

DB2

[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.

[quackhandle]

SQL Server 2016. Yes, really.

qh

[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.

[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.

[BR14]

DB2

high-volume high-performance database.

[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!)

[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.

[jamesbrown]

Asynchronous punched card.

[NickFitz]

CSV

[BR14]

DB2

[fullyautomatix]

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.

[TheCyclingProgrammer]

I haven't done much backend work in recent years (mostly mobile) but PostgreSQL is my goto choice (except for tiny projects where I might even use sqlite). I can't remember the last time I used MySQL. Possibly before Oracle bought it.

[NigelJK]

Or you could learn summink new. I hear good things about NoSQL

[NickFitz]

MySQL 8 apparently introduces a lot of new features: https://mysqlserverteam.com/whats-ne...lly-available/