December Meetup

Agenda:
18:00 Welcome
18:15 How not to sell the same ticket to two different people by Jose Muñoz (ClickHouse)
19:00 Online schema changes at Scale with TiDB by Mattias Jonsson (PingCAP)
19:45 Lightning Sessions
20:15 Pizza & networking

How not to sell the same ticket to two different people by Jose Muñoz (ClickHouse)
Summary:
Let’s say we build an app to sell movie theater tickets using your favorite database and framework. We design a stunning interface, pack it with amazing features, and ensure every detail of accessibility is perfect. We deploy it to production, and once users start arriving, we notice some very strange things happening: some customers have purchased the same seat for the same movie at the same time, and in some showings, people are sitting on the floor because we've sold more tickets than there are seats. What could have gone wrong?

In this talk, we’ll explore how these kinds of issues can occur when we don’t use transactions, share some real-world cases, and examine techniques modern databases use to help us avoid these problems.

Bio:
Jose is a software engineer with close to nine years of experience building data-centric products at companies such as Tuenti and Tinybird. He now works at ClickHouse, where he maintains the dbt connector. Passionate about community, he has helped organize events with GDG Cáceres and Databeers Madrid and tries to share what he learns by speaking at meetups and conferences.

Online schema changes at Scale with TiDB by Mattias Jonsson (PingCAP)
Summary:
ALTER TABLE in production databases are tricky, this talk will go through some of the challenges, as well as how the Distributed SQL database TiDB solves the issues as well as providing high speed index addition and more.

Bio:
Mattias has worked as a Principal Software Engineer at PingCAP working on TiDB, since April 2021. Previously he worked with MySQL at Booking.com and before that working on MySQL server at Oracle. So more than 20 years of Database experiences, mostly in the MySQL community.