Active Record Database Locking

Pessimistic and optimistic locking strategies in Rails

By Casey Driscoll | Tags: database, active-record | Slides
TL;DR:
Database locks in Rails can prevent bad data. Pessimism freezes the whole record while optimistism is more flexible.

Resources

Optimistic Locking

  1. ActiveRecord::Locking::Optimistic – Rails API
  2. Optimistic Locking in Rails REST APIs – AppSignal Blog
  3. Optimistic Locking using Rails – Medium
  4. Implement Optimistic Locking in Rails – Kiprosh Blogs
  5. A Guide to Optimistic Locking – EngineYard

Pessimistic Locking

  1. ActiveRecord::Locking::Pessimistic – Rails API
  2. A Simple Guide to Pessimistic Locking in Rails – Visuality
  3. Pessimistic Locking in Rails by Example – DEV Community
  4. Pessimistic Locking (Rails Internal) – DEV Community
  5. Pessimistic Locking in Rails – Selleo Blog

Table of Contents