The Database Wizard with Andrew Atkinson
Join us for this episode of Ruby for All to hear Andrew (Andy) Atkinson discuss all things databases. He talks about the differences between MySQL and PostgreSQL, transactions, locking, pgbouncer, query optimization, and more. Plus, he shares his preference for PostgreSQL. Come learn about databases with Andy, Andrew, and Julie!
Timestamps
[01:19] Andy tells us a bit about himself, and how his journey led him to becoming a database specialist.
[03:17] How do you pronounce SQL? Andy explains why he pronounces it the way he does and what SQL actually stands for.
[04:38] Have you ever wondered if PostgreSQL is faster than MySQL? What goes into measuring database performance?
[10:19] Andrew asks Andy to dive deeper into transactions and locking in Rails which leads into a longer discussion around what locks are.
[17:08] Julie asks Andy why he prefers PostgreSQL over MySQL and how he arrived at that position.
[20:46] Andrew asks Andy what pgbouncer is and why you may want to add it to your application and when.
[22:51] Julie asks Andy a database archictecture question about when you should use join tables instead of Array or JSON columns.
[27:18] As the show winds down, Andrew asks Andy to come back on the show soon so they can keep discussing this topic.
Sponsor
Links
- MariaDB
- MySql
- Heroku
- Fly.io
Creators and Guests
Host
Andrew Mason
Senior Product Developer at Podia, co-host of the Remote Ruby podcast, and co-editor of the Ruby Radar newsletter
Guest
Andrew Atkinson
(he/him) Software Engineer. Dad. Runner. Ruby on Rails. PostgreSQL. #Timberwolves 🏀 fan.