Table-Per-Tenant vs Shared Table: The Multi-Tenancy Tradeoff in Postgres
You are building a SaaS product. Every customer has their own orders, invoices, and documents...
Blog
52 posts
Metric Depth from a Single Camera: How Robots See Without LiDAR
Take a photo of a coffee mug on your desk. Now look at that photo...
When CDC Becomes a Crutch: A Philosophy on Data Replication
Your orders service needs the user's email to send a confirmation. The payments service needs the user's tier to apply a discount...
The Data Structures Behind Text Editors: Gap Buffers, Piece Tables, Ropes, and CRDTs
Open a text editor, type a character, and it appears on screen. That single keystroke triggers a surprisingly deep question: how does the editor represent your document in memory so that insertions, deletions, and cursor movements all feel instant, even on a file with millions of lines...
How Split Brain Happens in Distributed Databases and How It Gets Fixed
. [How Split Brain Happens in Distributed Databases and How It Gets Fixed](split-brain-in-distributed-databases-cover...
How Databases Checkpoint to Disk Without Stopping the World
Your database has gigabytes of dirty pages in memory. At some point they need to hit disk...
Cursor Pagination vs Offset Pagination: Which One Should You Use?
. [Cursor vs Offset Pagination](cursor-pagination-vs-offset-pagination-cover...
How MongoDB Stores Data - WiredTiger Pages vs SQLite
. [MongoDB WiredTiger vs SQLite Storage](mongodb-wiredtiger-vs-sqlite-storage-cover...
SQLite Query Optimisation - How the Planner Thinks and Where It Goes Wrong
. [SQLite Query Optimisation](sqlite-query-optimisation-cover...
How PostgreSQL Handles Large Values - TOAST and What It Costs You
. [How PostgreSQL Handles Large Values](postgres-toast-cover...
Page 1 of 6Next →