14 subscribers
با برنامه Player FM !
پادکست هایی که ارزش شنیدن دارند
حمایت شده
The Database Wizard with Andrew Atkinson
Manage episode 352929950 series 3375882
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
69 قسمت
Manage episode 352929950 series 3375882
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
69 قسمت
همه قسمت ها
×
1 RailsConf 2024 Workshop Spotlight — Build High Performance Active Record Apps with Andy Atkinson 43:52


1 The Power of Community in Learning Ruby on Rails — Agency of Learning's Role in Shaping Developer Careers 37:19


1 Live From Rubyconf 2023 — Conference Recap, Talk Highlights, Ruby 4, Hacking on OSS, Restaurant Reviews, and Much More 22:56




به Player FM خوش آمدید!
Player FM در سراسر وب را برای یافتن پادکست های با کیفیت اسکن می کند تا همین الان لذت ببرید. این بهترین برنامه ی پادکست است که در اندروید، آیفون و وب کار می کند. ثبت نام کنید تا اشتراک های شما در بین دستگاه های مختلف همگام سازی شود.