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.
Aaron & Colleen from Hammerstone
For the love of Sass & Podia's new Free plan
How Thoughtbot Works with Steve “Four-peat” Polito
Live(ish) Podcast Panel from Railsconf 2022!
Steve Three-peat Polito
Dealing With Perfectionism As A Developer
Twitter Q&A and Railsconf Advice For First Timers
José Valim, creator of Elixir and form Rails core contributor
Power Rangers & Building Products
Heroku Incident, SIM Swapping, and security tools
Ruby 3.2, Conventional Commits, and release-please
Its Always Sinny In Las Vegas aka Sin City Ruby
Ruby & Rails Tips with Sebastien Auriault
Load Testing Rails Applications & Rails Conferences
Parsers, Interpreters, and YJIT with Kevin Newton
Taylor Otwell, creator of the Laravel Framework
Bridgetown 1.0 with Jared White
Jason and Andrew Answer the Twitters
Partying Hard with John Nunemaker
Ben Orenstein - From Developer To CEO of Tuple
Create your
podcast in
minutes
It is Free
Navigating Life After 40
Science of Reading: The Podcast
How To!
The Minimal Mom
Old Fashioned On Purpose