The Database Wizard with Andrew Atkinson

Ruby for All

Andrew Mason and Julie J에서 제공하는 콘텐츠입니다. 에피소드, 그래픽, 팟캐스트 설명을 포함한 모든 팟캐스트 콘텐츠는 Andrew Mason and Julie J 또는 해당 팟캐스트 플랫폼 파트너가 직접 업로드하고 제공합니다. 누군가가 귀하의 허락 없이 귀하의 저작물을 사용하고 있다고 생각되는 경우 여기에 설명된 절차를 따르실 수 있습니다 https://ko.player.fm/legal.

2+ y ago 28:38

MP3•에피소드 홈

[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 에피소드

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

The Database Wizard with Andrew Atkinson

Ruby for All

13 subscribers

published 2+ y ago