On: DHH: The HEY stack Vanilla Ruby on Rails, MySQL, redis, stimulus, elastic search

[brobinson]

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

[meritt → brobinson]

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.

[brobinson → meritt]

Good to know, thanks. And I didn't suggest that you suggested that. :-)

[Kiro → brobinson]

What do you build that requires those things?

[brobinson → Kiro]

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.