#locking articles

Part 2: Pessimistic Locking in Rails – Preventing Race Conditions in Production

Introduction In the previous article, we learned why databases need locking and how PostgreSQL uses MVCC (Multi-Version Concurrency Control) to allow multiple transactions to work simultaneously. Howe

7 min readrailswithyashika.hashnode.dev

Yashika VijayvargiyaJul 13

Understanding Database Locking in Rails & PostgreSQL (Part 1)

Learn database locking in Ruby on Rails from scratch. Understand optimistic locking, pessimistic locking, advisory locks, race conditions, deadlocks, transactions, and real production examples with ActiveRecord.

4 min readrailswithyashika.hashnode.dev

Gautam PatelApr 8

Concurrency Gone Wrong: Fixing Lost Updates with Database Locking

Learn optimistic vs pessimistic locking in databases, prevent lost updates, and handle concurrency with real examples and use cases.

4 min readiamgautam.hashnode.dev

EKASPREET SINGH ATWALMar 16

Concurrency Without the Chaos

A Deep Dive into Optimistic Locking with Spring Boot

3 min readekas-7.hashnode.dev

Surya SathiJan 5

State in a System

Explained through a simple example of a login system

11 min readsystems-notes.hashnode.dev

Quan NguyenJan 11, 2025

Distributed Lock with Redis

Distributed Lock với Redis là một cơ chế khóa phân tán sử dụng Redis như một kho lưu trữ để điều phối và quản lý trạng thái khóa giữa nhiều client trong môi trường phân tán. Cơ chế này đảm bảo rằng tại một thời điểm, chỉ một client duy nhất có thể gi...

11 min readituniverse.hashnode.dev

Quan NguyenJan 8, 2025

Optimistic and Pessimistic Locking in JPA

💡 Khóa (locking) là một cơ chế cho phép thực hiện công việc song song với cùng một dữ liệu trong cơ sở dữ liệu. Khi có nhiều giao dịch (transaction) cố gắng truy cập cùng một dữ liệu cùng lúc, các khóa sẽ được sử dụng để đảm bảo rằng chỉ có mộ...

17 min readituniverse.hashnode.dev

Mahmoud AshourOct 8, 2024

Locked In: The Hidden World of Database Locks

Learn about table-level, row-level, and next-key locks to prevent concurrency issues such as race conditions and phantom reads

7 min readmahmoudashour.hashnode.dev

Jyotiprakash MishraOct 7, 2024

A Primer on Cache Coherence Protocols

In modern multi-core processors, multiple cores operate in parallel, each with its own cache to store frequently accessed data. These caches are designed to reduce the time it takes for a processor to retrieve data from memory, speeding up overall pe...

26 min readblog.jyotiprakash.org

Samuel SorialFeb 8, 2023

Pessimistic Concurrency Control - 2PL

Introduction In today's high-traffic database management systems (DBMS), leveraging the full potential of hardware is essential. With the advent of modern CPUs, the opportunity for parallel processing has increased significantly. However, executing m...

4 min readsamuel-sorial.hashnode.dev

Search Hashnode

Trending tags this week