Ever wondered why a seasoned software engineer would transition into becoming an author? Meet our guest for today, Andrew Atkinson, a software veteran who is about to launch his book focusing on database operations for Rails developers. Andrew's rich 15-year career as a software engineer has culminated in this exciting new venture, as he peels back the layers of database operations, specifically in the Ruby on Rails landscape.
In our lively discussion, we delve into the heart of relational databases - comparing the merits of Postgres and MongoDB, and when to use one over the other. Andrew demystifies the assumption that one necessarily needs multiple databases, discussing how Postgres could be potentially used as a catch-all solution. Not stopping there, we journey through the thorny terrain of data synchronization challenges across multiple databases and the treasures of transactional consistency.
Finally, we discuss the importance of performance optimization in Rails applications and the role of database internals. Andrew dispenses nuggets of wisdom on how to optimize Rails performance and database queries. We also talk about the benefits of strict loading in active record - a key player in avoiding the notorious n plus one query problem. Wrapping up our discussion, Andrew guides us to the Pragmatic Bookshelf where his upcoming book awaits all keen Rails developers. So, lean in and listen, as we uncover layers of database operations that could dramatically level-up your projects.
Continuous Delivery and Continuous Self-Improvement
Irina Nazarova from Evil Martians
Code, Confessions, and Casinos - Sin City Ruby
RailsConf 2024 with Ufuk Kayserilioglu
Struggles and Strategies-Dev Dilemmas
Andy Croll - Railsconf - Free Chicken
Exploring Dependabot-Unraveling Rails LSP-Vim Customization
Ridges on the Scroll Wheel
You Know What, Lets Just Get Into It & ONCE Campfire
Embracing Simplicity in Code: Smart Home Automation, Ruby Upgrades, and the Future of Rails
Cracking the Code: Marketing, Security, and Startups in Rails with Wafers' Ryan and Mike
Decoding Postgres: A Journey Through User-Friendly Database Experiences with Craig Kerstiens
Scaling Buzzsprout: A Deep Dive into Podcast Hosting, CDN, Rails, and Business Happiness with Tom Rossi
Unlocking the Power of State Machines in Code Development with Elise Schaefer
Rails World 2023 Recap & Rails Foundation Plans with Amanda Perino
Turbo Morph & ActiveRecord Encryption with Jorge Manrubia
Live at Rails World 2023
DHH on Rails World 2023 & Rails 7.1
Live with Adam Wathan at Rails World 2023
Create your
podcast in
minutes
It is Free
LifeBlood
The Minimal Mom
Science of Reading: The Podcast
Old Fashioned On Purpose
How To!