Distributed snapshots: determining global states of distributed systems
Dec 11, 2025 · 1 min read · Chandy and Lamport, ACM TOCS 1985 SummaryThe main idea of the paper is to determine the consistent global state of the asynchronous system and ascertain whether a stable property holds for that state. The author presents a marker-based algorithm in w...
Join discussionSolutions to Dirty Read Concurrency Problem
Sep 27, 2025 · 4 min read · This article is part of my concurrency series where I break down common problems like race conditions, dirty reads, phantom reads, and deadlocks in simple, glocal terms. Again, system design is not something to joke with as a backend engineer.One of ...
Join discussion
Important Database Concepts (Part-3)
Jul 5, 2025 · 15 min read · Welcome to the third part of our DBMS blog series! In this section, we’ll delve into more advanced and performance-critical concepts that form the backbone of modern database systems. From Indexes that speed up data retrieval to Concurrency Control t...
Join discussion
Untangling PostgreSQL Locks: Your Guide to Conquering Database Contention
May 25, 2025 · 7 min read · Database performance can feel like a dark art, especially when faced with slowdowns caused by a hidden force: database locks. In PostgreSQL, locks are the unsung heroes of data integrity, the guardians ensuring your transactions run correctly in a bu...
Join discussionHandling Concurrency in Entity Framework Core: A Guide for SQLite and Relational Databases
Oct 17, 2024 · 6 min read · Concurrency issues can be a silent nemesis in any application dealing with data persistence. Recently, I found myself grappling with such issues while working on a .NET Core project using Entity Framework Core (EF Core) with a SQLite database. In thi...
Join discussionCrawling with Proxies and Multi-threading: Improving Efficiency and Stability
Oct 12, 2024 · 9 min read · Data collection and competitive analysis is now becoming critical in a variety of industries. If you want to collect large amounts of data, whether it's keyword rankings or competitor analysis, large-scale crawling will inevitably involve concurrency...
Join discussionSolutions To Lost Update Concurrency Problem
Aug 16, 2024 · 8 min read · What is Concurrency? Concurrency involves multiple processes or transactions executing at the same time, potentially interacting with shared data. Imagine a social media platform where several users react to a post simultaneously. Each reaction is an...
Join discussion
Distributed Concurrency Control
Oct 1, 2023 · 9 min read · Scenario Many concurrent request tries to book the same Movie theatre Seat. Details: If we have many requests to book the same theatre seat then the status will be confirmed for all the users though the seat can be alloted only for one user. Critical...
Join discussion