Beyond CRUD: PostgreSQL Techniques Your Rails App Is Missing

Explore advanced PostgreSQL techniques for Rails applications in this 34-minute conference talk from RailsConf 2023. Dive into real-world production outage scenarios and learn how to implement scalable solutions using efficient PostgreSQL features. Discover the proper application of optimistic and pessimistic locking in Rails, illustrated through practical examples powering core customer features. Gain insights on utilizing Postgres mutex for managing concurrent access to shared resources. Benefit from shared experiences and lessons learned from production outages to enhance your application's reliability, improve query patterns, and avoid common operational pitfalls.