Hacker News new | ask | show | jobs
by brobinson 2181 days ago
I don't know if I could go back to not having transactional DDL, partial and function-defined indexes, non-blocking ("concurrent") indexing, and so on...
2 comments
meritt 2181 days ago
I'm not sure where I suggested "Hey, long time Postgres users, you should switch to MySQL!". The point is it's a solid modern database and a completely fine option in 2020.

MySQL8 supports functional indexes and concurrent indexing fyi. It still does not have transactional DDL nor partial indexes.

link
brobinson 2181 days ago
Good to know, thanks. And I didn't suggest that you suggested that. :-)
link
Kiro 2181 days ago
What do you build that requires those things?
link
brobinson 2181 days ago
I've used them (via Postgres) to build large database-backed web applications (like Hey), realtime bidding systems (100mm+ records, 250,000+ requests/sec), and so on over the last 10+ years. Recursive CTEs as well, and MySQL finally has those as of a year or two ago. The feature gap is closing, but it's been a very, very slow process.
link