#databases (76)

37 blogs • 39 notes

2026

(38)

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

Career Growth #distributed-systems #access-patterns #batching
Aug 13

NOTE Visual Prototypes Offer Superior Product Specification Over Design Documents

Career Growth #software-engineering #ai-agents #career-growth
Aug 10

NOTE Preventing PostgreSQL database-wide recoveries using strict Linux overcommit

Systems Internals #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

Systems Internals #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 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

Distributed Systems #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

Career Growth #distributed-systems #career-growth #configuration-validation
Apr 11

NOTE It Depends Must Be Followed By Explanation

Career Growth #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

(6)

2023

(2)

Aug 10

NOTE Most databases use B+ Trees to hold the data, but

Algorithms & Data Structures #databases
Mar 12

NOTE How databases are upgraded in production

Distributed Systems #system-design #databases

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