Multi-Tenant Monolith Database Design: Shared Tables vs Schema per Tenant
Compare shared tables with row-level security against schema per tenant for a multi-tenant monolith: isolation, migrations, performance, lifecycle, and cost.
15 min read
Archive
All articles
298 published
How to Extract a Service from a Monolith: Picking the First Seam
Learn how to extract your first service from a monolith by choosing a clean seam, untangling data, cutting over safely, and budgeting for platform work.
13 min read
PostgreSQL EXPLAIN ANALYZE Slow Query Tuning with pg_stat_statements
Rank slow queries by total cost with pg_stat_statements, then use EXPLAIN (ANALYZE, BUFFERS) to find row misestimates and fix the real cause.
13 min read
Nx Affected in GitHub Actions: Getting Base and Head SHAs Right
Learn how nx affected picks what to run, why GitHub Actions defaults give wrong SHAs, and how to set correct bases for pushes and PRs with nx-set-shas.
15 min read
Transactional Outbox Pattern: Reliable Events from PostgreSQL
Solve the dual write problem in PostgreSQL with the transactional outbox pattern: table design, polling and CDC relays, idempotent consumers and ordering.
15 min read
Webhook Delivery Design: Signatures, Retries and Replay Protection
Design webhooks as signed, timestamped, idempotent at-least-once events: HMAC verification, replay windows, retries with backoff, and key rotation.
13 min read
Spring Boot Virtual Threads: When They Help and When They Don't
How Spring Boot virtual threads work, which workloads gain from them, where bottlenecks move, and how to limit concurrency, detect pinning and roll out safely.
13 min read
Service Discovery in Microservices: How Load Balancing Really Works
Learn how service discovery and load balancing fit together in microservices: DNS, Kubernetes Services, client-side balancing, proxies, and rollout pitfalls.
13 min read
Nx Docker Build with a Pruned Lockfile for Lean Node Images
Use Nx generatePackageJson to emit a per-app package.json and pruned lockfile, then build a lean multi-stage Docker image for an Nx Node app.
14 min read
Nx Conformance Rules: Governing Large Workspaces Without Stalling Teams
Learn how Nx conformance rules, tags, and module boundaries govern large monorepos, and how to roll out enforcement in stages without blocking every team.
13 min read
Node.js Streams Backpressure: Handling Large Payloads Safely
Learn how Node.js streams backpressure works, why ignoring it causes memory leaks, and how pipeline() and async iteration handle large uploads safely.
14 min read
Monolith Caching Strategies: In-Process vs Shared Cache
Compare in-process and shared caches in a monolith, covering hit rates under scaling, invalidation, cache stampede fixes, two-tier design and what to measure.
13 min read