PostgreSQL and the OOM Killer: Why You Must Use Strict Memory Overcommit (A Blood-and-Tears Field Report)
PostgreSQL doesn’t leak memory, yet it keeps getting OOM-killed — because Linux’s default heuristic overcommit lets commit …
Knowledge Base
Back HomeDeveloper Tools
Automated insights on infrastructure ops, Python probes, DCIM, and data center systems.
Rebuilding Redis, Git, and a Database from Scratch: Hard-Won Lessons, Benchmarks, and Architectural Truths
I rebuilt Redis, Git, and a B+tree database from scratch over six months. This article shares the architectural decisions, brutal failure …
Backstitch Plugin Deep Dive: Replacing Git for Godot .tscn Scene Merge Conflicts with Real-Time CRDT Collaboration
Godot’s text-based .tscn format makes Git merges a nightmare for non-programmers. This article breaks down Lilith Duncan’s …
Postgres Data in Parquet on S3: The LTAP Architecture Explained for Engineers Who Actually Run Databases
LTAP isn’t ‘Postgres on S3’ — it’s a storage-layer pipeline that transcodes row-oriented WAL data into columnar …
Rebuilding Redis, Git, and a Database from Scratch: The 600-Hour Engineering Gauntlet That Actually Works
Rebuilding infrastructure software from scratch is the steepest learning curve in engineering. This guide breaks down the real difficulty of …
Linux Kernel Finally Deletes strncpy: 362 Patches, 6 Years, and the C String Safety Lessons We Can't Ignore
Linux 7.2 has finally purged strncpy from the kernel—not deprecated, not warned against, but deleted. This post breaks down the six-year …
GitLost Attack Explained: How a Public GitHub Issue Hijacks Agentic Workflows to Leak Private Repos
GitLost exposed a critical prompt injection flaw in GitHub Agentic Workflows. This post breaks down the attack chain, root cause analysis, …
Micro-Agent Architecture in Production: How In-API Multi-Model Collaboration Beats Frontier Models Like GPT-5.6 Sol
Micro-Agent turns one model API call into a bounded collaboration loop inside the serving layer. We break down the looper runtime …
Building a Bible as RAG Database: Chunking Strategies, pgvector Tuning, and the Semantic Search Pitfalls Nobody Talks About
This article breaks down the full pipeline for turning the World English Bible into a semantic search database — chunking, embeddings, …
The Only Scalable Delete in Postgres Is DROP TABLE: Architecture Truths and Production Lessons
DELETE in Postgres is O(n) and creates vacuum debt that grows with your table. DROP TABLE is O(1). This article breaks down the MVCC …