top | item 42881823

(no title)

heyoni | 1 year ago

People see uber tech blog and jump straight to upvoting.

discuss

order

PaulHoule|1 year ago

I remember when that blog used to be top notch.

Today it just seems odd that anybody is still using MySQL. Postgres? Sure. SQLlite? Hell yeah! DuckDB? Of course. MySQL? Not so much.

bigmutant|1 year ago

Absolutely not true in my experience. MySQL has its share of issues (all DBs do) but it is rock-solid when using the correct engine (InnoDB for most cases, RocksDB for high-throughput writes, Memory for caching). MySQL is very hard to beat for very high-volume OLTP workloads, both reads and writes. Its replication systems were years ahead of other systems (SQL Server, Postgres, SQLite doesn't have replication). DuckDB AFAIK is OLAP and they don't compete in the same space. Every DB system has "the things its good at" and MySQL really shines at very high-volume OLTP spread across partitions.

kyawzazaw|1 year ago

we are almost all in MySQL. we are also old and 500b