The Database Wizard with Andrew Atkinson

Ruby for All

Content provided by Andrew Mason and Julie J. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Andrew Mason and Julie J or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

1+ y ago 28:38

MP3•Episode home

[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

- Rails Pessimistic Locking

- Rails Optimistic Locking

- Heroku

- Fly.io

69 episodes

#Tech #Podcasting Education #Andrew Mason #Julie J #Technology #Ruby #Software #Rails

The Database Wizard with Andrew Atkinson

Ruby for All

15 subscribers

published 1+ y ago