#databases (72)

37 blogs • 35 notes

2026

(39)

Aug 30

NOTE Schema-Driven Data Modeling Is Essential for Deterministic Agent Memory

AI Systems #ai-systems #agent-memory #ai-agents
Aug 20

NOTE GPU Drivers Adopt Database Wound-Wait Mutex to Prevent Deadlocks

AI Systems #ai-systems #concurrency #concurrency-control
Aug 14

NOTE Fast Stores Can Mask Per-Item State Check Performance Issues

Distributed Systems #distributed-systems #access-patterns #batching
Aug 13

NOTE Visual Prototypes Offer Superior Product Specification Over Design Documents

Software Engineering #software-engineering #ai-agents #career-growth
Aug 10

NOTE Preventing PostgreSQL database-wide recoveries using strict Linux overcommit

Software Engineering #software-engineering #crash-recovery #databases
Aug 08

NOTE Using Plain Integers in MCP Tool Parameters Cuts Agent Errors

AI Systems #ai-systems #agent-errors #ai-agents
Jul 31

BLOG Three Claude Skills I Think Every Org Should Have

AI Systems #ai-systems #databases #leadership
Jul 27

NOTE Huge Pages Optimize Postgres Shared Buffers by Improving TLB Efficiency

Distributed Systems #distributed-systems #caching #databases
Jul 20

NOTE Starting From Scratch Unlocks Radical Innovation By Challenging Assumptions

Distributed Systems #distributed-systems #apache-spark #building-from-scratch
Jul 15

NOTE Fragile staging and end-to-end tests hinder system scalability

Software Engineering #software-engineering #contract-testing #databases
Jul 11

NOTE Good DevOps Practices Are Essential for Reliable AI Agentic Workflows

Software Engineering #software-engineering #agentic-workflows #ai-agents
Jul 06

NOTE Improve MySQL Master Failover Monitoring Using Replica Consensus

Distributed Systems #distributed-systems #consensus #databases
Jun 30

NOTE Optimizations Are Trades Made Within Constraints With No Free Lunch

Career Growth #career-growth #concurrency #concurrency-control
Jun 27

NOTE RocksDB's Sequence Numbers Simplify Database Snapshots and Concurrency

Distributed Systems #distributed-systems #compaction #concurrency
Jun 26

NOTE Hands-on experience with systems reveals their critical failure modes

Software Engineering #software-engineering #databases #failure-modes
Jun 23

NOTE PostgreSQL Uses Histograms and MCVs to Estimate Rows

Distributed Systems #distributed-systems #databases #histograms
Jun 19

NOTE Separating Compute From Storage Enables Serverless Database Pay-Per-Use

Distributed Systems #distributed-systems #compute-storage-separation #databases
Jun 11

NOTE Consecutive 401 Responses Should Trigger Circuit Breakers Not Retries

Distributed Systems #distributed-systems #401-errors #authentication-failure
Jun 11

NOTE Handle Consecutive 401 Errors with Circuit Breakers to Prevent Outages

Distributed Systems #distributed-systems #401-unauthorized #blind-retries
Jun 04

NOTE Successful Big Migrations Require a Plank-by-Plank Replacement Strategy

Distributed Systems #distributed-systems #databases #full-cutover
Jun 04

NOTE Asymmetry in SYN Flood Attacks Makes SYN Cookies an Effective Countermeasure

Software Engineering #software-engineering #asymmetry #clock-synchronization
Jun 03

NOTE Tool Calls Enable Internal Agent Logic Decomposition and Testability

AI Systems #ai-systems #agent-design #ai-agents
Jun 02

NOTE New Hires Should Build Trust and Gather Context Before Suggesting Changes

Career Growth #career-growth #building-trust #communication
May 20

BLOG Temporal Primer - Building Long-Running Systems

Distributed Systems #distributed-systems #ai-agents #career-growth
May 19

NOTE Approximating Least Recently Used Cache Eviction Using Two Random Choices

Distributed Systems #distributed-systems #2-random #approximation
May 01

NOTE Design Systems For Reversibility To Boost Confidence And Speed

Distributed Systems #distributed-systems #architectural-decisions #databases
Apr 29

NOTE Pushdown optimization in pg_clickhouse improves data querying efficiency

Distributed Systems #distributed-systems #clickhouse #data-filtering
Apr 28

BLOG Your Monolith Is Already A Distributed System

Distributed Systems #distributed-systems #databases #information-retrieval
Apr 23

NOTE Relational databases often suffice where graph databases are overengineering

Distributed Systems #distributed-systems #algorithms #databases
Apr 22

NOTE Crashing immediately on startup prevents late-run fixable issues

Distributed Systems #distributed-systems #career-growth #configuration-validation
Apr 11

NOTE It Depends Must Be Followed By Explanation

Distributed Systems #distributed-systems #consistency #databases
Apr 02

NOTE Premature Optimization Adds Complexity, Reduces Readability

Software Engineering #software-engineering #code-correctness #code-maintainability
Mar 12

NOTE The Value of Spiky Teams in the Tech Industry

Career Growth #career-growth #candidate-assessment #databases
Mar 08

BLOG Databases Were Not Designed For This

Distributed Systems #distributed-systems #ai-agents #caching
Mar 04

BLOG BM25

Algorithms & Data Structures #algorithms-and-data-structures #databases #information-retrieval
Feb 24

BLOG JOIN Algorithms

Distributed Systems #distributed-systems #data-structures #databases
Jan 27

BLOG Multi-Paxos - Consensus in Distributed Databases

Distributed Systems #distributed-systems #clock-synchronization #consensus
Jan 26

NOTE Intentionally Go Deep Based on Curiosity and Career

Career Growth #career-growth #abstraction-layers #career-direction
Jan 16

BLOG MySQL Replication Internals

Distributed Systems #distributed-systems #concurrency #databases

2025

(7)

Dec 23

BLOG Clock Synchronization Is a Nightmare

Distributed Systems #distributed-systems #clock-synchronization #consistency
Oct 20

BLOG How Writes Work in Apache Cassandra

Distributed Systems #distributed-systems #consistency #databases
Sep 29

NOTE You Can't Fix Everything on Day One

Career Growth #career-growth #communication #databases
Sep 06

BLOG Why Distributed Systems Need Consensus Algorithms Like Raft

Distributed Systems #distributed-systems #clock-synchronization #communication
Sep 05

BLOG Why Do Databases Deadlock and How Do They Resolve It

Distributed Systems #distributed-systems #concurrency #databases
May 26

NOTE Availability Bias Leads to Optimizing Visible Not Actual Problems

Leadership #leadership #availability-bias #communication
Jan 01

BLOG Theta sketches: set algebra over massive streams

Algorithms & Data Structures #algorithms-and-data-structures #databases #hashing

2024

(2)

Aug 13

NOTE The Unexpected Benefit of Reading Random Engineering Articles

Career Growth #career-growth #communication #databases
Jun 20

NOTE Do This, Once You Are Out of the Interview Cycle

Career Growth #career-growth #databases #interviews

2021

(11)

Nov 28

BLOG Multi-Master Replication - Why Conflicts Happen

Distributed Systems #distributed-systems #databases #replication
Nov 03

BLOG Multi-Master Replication - Scaling Writes Across Geographies

Distributed Systems #distributed-systems #databases #replication
Sep 07

BLOG What Happens When a Master or Replica Fails

Distributed Systems #distributed-systems #databases #replication
Aug 15

BLOG Replication Formats - Statement vs Row-based

Distributed Systems #distributed-systems #databases #networking
Aug 07

BLOG Master-Replica Replication

Distributed Systems #distributed-systems #databases #replication
Jul 19

BLOG Decoding Durability - The D in ACID

Distributed Systems #distributed-systems #consistency #databases
Jul 07

BLOG Decoding Isolation - The I in ACID

Distributed Systems #distributed-systems #concurrency #consistency
Jul 02

BLOG Decoding Atomicity - The A in ACID

Distributed Systems #distributed-systems #consistency #databases
Jul 02

BLOG Decoding Consistency - The C in ACID

Distributed Systems #distributed-systems #consistency #databases
Jun 22

BLOG Architectural Patterns for Distributed Systems

Distributed Systems #distributed-systems #databases #system-design
Apr 19

BLOG Modeling Udemy's Categories in a Relational Database

Distributed Systems #distributed-systems #databases #python-internals

2017

(3)

Mar 24

BLOG Analyzing MongoDB Pagination Performance Differences

Distributed Systems #distributed-systems #databases #evaluation
Mar 23

BLOG MongoDB Pagination - Skip is Slow

Distributed Systems #distributed-systems #databases
Mar 22

BLOG MongoDB Pagination - Two Approaches You Need to Know

Distributed Systems #distributed-systems #databases

Writings and Learnings

Courses

Applied AI Masterclass

System Design Masterclass

System Design for Beginners

Legal and Contact

Everything Else

Arpit's Newsletter read by 145,000 engineers

Weekly essays on real-world system design, distributed systems, or a deep dive into some super-clever algorithm.

Subscribe on LinkedIn Subscribe on Substack

The courses listed on this website are offered by

Relog Deeptech Pvt. Ltd.
203, Sagar Apartment, Camp Road, Mangilal Plot, Amravati, Maharashtra, 444602
GSTIN: 27AALCR5165R1ZF