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!

Show Notes

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

GoRails

Honeybadger

Links

- Andy on Twitter

- Andy's Website

- MariaDB

- PostgreSQL

- MySql

- Rails Pessimistic Locking

- Rails Optimistic Locking

- Heroku

- Capistrano

- Fly.io

- Kubernetes

- Amazon RDS

- pgbouncer

Creators & Guests

Host

Andrew Mason

Senior Product Developer at Podia, co-host of the Remote Ruby podcast, and co-editor of the Ruby Radar newsletter

Host

Julie J

Software developer at Codecademy

Guest

Andrew Atkinson

(he/him) Software Engineer. Dad. Runner. Ruby on Rails. PostgreSQL. #Timberwolves 🏀 fan.

What is Ruby for All?

A weekly Ruby focused podcast hosted by Andrew Mason and Julie J. Each week we discuss topics ranging from Ruby, Ruby on Rails, learning, how to be a better developer, and more. The focus is on providing a podcast that caters to junior Ruby on Rails developers.