Beyond CRUD: the PostgreSQL techniques your Rails app is missing

This talk explores how to build scalable solutions using efficient and simple PostgreSQL features within a Rails application. It discusses the lessons learned from production incidents, focusing on how to rethink system design for better scalability. Key PostgreSQL concepts covered include optimistic and pessimistic locking, advisory locking for concurrent access control, and skip-locked for concurrent workloads. The presentation also touches upon operational best practices such as query timeouts and auto-healing applications during database failovers.