News for hackers. Stuff that matters.

A comment on DHH: The HEY stack Vanilla Ruby on Rails, MySQL, redis, stimulus, elastic search. Parent comment

Re:DHH: The HEY stack Vanilla Ruby on Rails, MySQL, redis, s... by brobinson on Thursday June 25, 2020 @01:50PM (#23643437)
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...
[ Parent | on HN ]
Re:DHH: The HEY stack Vanilla Ruby on Rails, MySQL, redis, s... by meritt on Thursday June 25, 2020 @03:28PM (#23644527)
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.

[ Parent | on HN ]
Re:DHH: The HEY stack Vanilla Ruby on Rails, MySQL, redis, s... by brobinson on Thursday June 25, 2020 @10:07PM (#23647994)
Good to know, thanks. And I didn't suggest that you suggested that. :-)
[ Parent | on HN ]
Re:DHH: The HEY stack Vanilla Ruby on Rails, MySQL, redis, s... by Kiro on Thursday June 25, 2020 @02:22PM (#23643805)
What do you build that requires those things?
[ Parent | on HN ]
Re:DHH: The HEY stack Vanilla Ruby on Rails, MySQL, redis, s... by brobinson on Thursday June 25, 2020 @03:26PM (#23644492)
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.
[ Parent | on HN ]