Posts
All the articles I've posted.
-
Row-Level Security in PostgreSQL: Keep Tenant Data in the Database
A practical guide to PostgreSQL Row-Level Security (RLS): tenant isolation, policies, application identity, common pitfalls, and a production-ready setup.
-
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.