Artwork

Contenido proporcionado por Jason Charnes, Chris Oliver, Andrew Mason, Jason Charnes, Chris Oliver, and Andrew Mason. Todo el contenido del podcast, incluidos episodios, gráficos y descripciones de podcast, lo carga y proporciona directamente Jason Charnes, Chris Oliver, Andrew Mason, Jason Charnes, Chris Oliver, and Andrew Mason o su socio de plataforma de podcast. Si cree que alguien está utilizando su trabajo protegido por derechos de autor sin su permiso, puede seguir el proceso descrito aquí https://es.player.fm/legal.
Player FM : aplicación de podcast
¡Desconecta con la aplicación Player FM !

Unleashing the Power of Postgres with Andrew Atkinson

50:13
 
Compartir
 

Manage episode 389662533 series 2336598
Contenido proporcionado por Jason Charnes, Chris Oliver, Andrew Mason, Jason Charnes, Chris Oliver, and Andrew Mason. Todo el contenido del podcast, incluidos episodios, gráficos y descripciones de podcast, lo carga y proporciona directamente Jason Charnes, Chris Oliver, Andrew Mason, Jason Charnes, Chris Oliver, and Andrew Mason o su socio de plataforma de podcast. Si cree que alguien está utilizando su trabajo protegido por derechos de autor sin su permiso, puede seguir el proceso descrito aquí https://es.player.fm/legal.

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.

Honeybadger
Honeybadger is an application health monitoring tool built by developers for developers.
Disclaimer: This post contains affiliate links. If you make a purchase, I may receive a commission at no extra cost to you.

  continue reading

Capíttulos

1. Writing a Book on Database Operations (00:00:00)

2. Choosing Postgres for Different Project Contexts (00:11:37)

3. Redis vs Postgres (00:18:52)

4. Optimizing Rails Performance and Database Queries (00:27:57)

5. Loading in Active Record (00:36:07)

6. Performance Optimization Techniques for Rails Applications (00:41:41)

7. Pragmatic Programmers and Book Promotion (00:49:11)

281 episodios

Artwork
iconCompartir
 
Manage episode 389662533 series 2336598
Contenido proporcionado por Jason Charnes, Chris Oliver, Andrew Mason, Jason Charnes, Chris Oliver, and Andrew Mason. Todo el contenido del podcast, incluidos episodios, gráficos y descripciones de podcast, lo carga y proporciona directamente Jason Charnes, Chris Oliver, Andrew Mason, Jason Charnes, Chris Oliver, and Andrew Mason o su socio de plataforma de podcast. Si cree que alguien está utilizando su trabajo protegido por derechos de autor sin su permiso, puede seguir el proceso descrito aquí https://es.player.fm/legal.

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.

Honeybadger
Honeybadger is an application health monitoring tool built by developers for developers.
Disclaimer: This post contains affiliate links. If you make a purchase, I may receive a commission at no extra cost to you.

  continue reading

Capíttulos

1. Writing a Book on Database Operations (00:00:00)

2. Choosing Postgres for Different Project Contexts (00:11:37)

3. Redis vs Postgres (00:18:52)

4. Optimizing Rails Performance and Database Queries (00:27:57)

5. Loading in Active Record (00:36:07)

6. Performance Optimization Techniques for Rails Applications (00:41:41)

7. Pragmatic Programmers and Book Promotion (00:49:11)

281 episodios

Todos los episodios

×
 
Loading …

Bienvenido a Player FM!

Player FM está escaneando la web en busca de podcasts de alta calidad para que los disfrutes en este momento. Es la mejor aplicación de podcast y funciona en Android, iPhone y la web. Regístrate para sincronizar suscripciones a través de dispositivos.

 

Guia de referencia rapida