Posts
All the articles I've posted.
-
JSON vs JSONB in PostgreSQL
PostgreSQL offers both JSON and JSONB types for flexible schemas. Discover how JSONB binary format, TOAST compression, and GIN indexes make it the superior choice for querying, while JSON remains ideal for simple storage.
-
Multi-Tenant CRM Schema Design: Typed Columns vs JSONB
How do you design a database schema for a multi-tenant CRM where each company has different fields and data requirements? Explore two proven approaches: typed columns with EAV pattern and flexible JSONB documents.
-
CDN Evolution: From Static Cache to Edge Compute
CDNs started as simple caching layers for static content. Today, they run code at the edge with Edge Functions. Discover how CDNs evolved into global compute networks and how Edge Functions differ from traditional Serverless.
-
Redis: Single Thread vs Multithreading
Redis is one of the fastest in-memory databases, yet it runs on a single thread. Discover how eliminating locks, context switching, and synchronization overhead can outperform dozens of threads across multiple cores.
-
Binary Trees vs B-Trees in Databases
At first glance, binary trees seem perfect for databases with their O(log n) complexity. But when data moves from memory to disk, everything changes. Discover why databases choose B-Trees over binary trees and how I/O costs reshape algorithmic efficiency.