THE LOG

Every entry, chronological. System build logs, engineering references, and the growth log behind the work. Filter by type. Each entry belongs to exactly one stream.

INDEX: LOG_ROOT
ENTRIES: 52 TOTAL
SOURCE: MDX
⌘ RSS FEED Subscribe in any RSS reader
// FILTER: 52 / 52 ENTRIES
JUN 20 GROWTH The first oneGROWTH · BUILD IN PUBLIC 3 MIN › JUN 19 CONCEPT REFRESH MATERIALIZED VIEW CONCURRENTLY: How It Works, How to Break ItCONCEPTS · POSTGRESQL 5 MIN › JUN 18 SYSTEM An Idempotent ELT Pipeline With SKIP LOCKED and Phase CommitsSPECTRUM · BUILD e5d2a8 8 MIN › JUN 17 SYSTEM JSONB Staging: Keep Raw Events UnmodifiedSPECTRUM · BUILD b7c4f1 8 MIN › JUN 16 SYSTEM The Circuit Breaker That Tripped Before the Demo StartedPHRONIS · ANOMALY 5 MIN › JUN 15 SYSTEM You Can't Bind to a ClusterIP: Redpanda on KubernetesPHRONIS · ANOMALY 5 MIN › JUN 14 SYSTEM The Init Container That Couldn't Reach localhostPHRONIS · ANOMALY 4 MIN › JUN 13 SYSTEM An Em-Dash Broke My PowerShell ScriptPHRONIS · ANOMALY 4 MIN › JUN 12 SYSTEM Asking Your Pipeline Questions: An MCP Server for ClaudePHRONIS · BUILD 2a7b15 5 MIN › JUN 11 SYSTEM I Built a Self-Hosted Amplitude With Pure PostgreSQLSPECTRUM · BUILD a3f292 7 MIN › JUN 10 GROWTH I Chose a Boring Stack on PurposeGROWTH · PHILOSOPHY 5 MIN › JUN 09 SYSTEM NOW() Was Silently Wrecking My CONCURRENTLY RefreshSPECTRUM · ANOMALY 8 MIN › JUN 08 CONCEPT Incremental Materialized Views, ExplainedCONCEPTS · STREAMING SQL 5 MIN › JUN 07 CONCEPT Star Schema vs Snowflake — When to Actually Use EachCONCEPTS · DIMENSIONAL MODELING 6 MIN › JUN 06 SYSTEM Funnels and Retention in Pure SQLSPECTRUM · BUILD f47a90 6 MIN › JUN 05 SYSTEM Real-Time Circuit Breaking for AI Agents — What Batch Tools Can't DoPHRONIS · BUILD 7e3fa2 6 MIN › JUN 04 SYSTEM Semantic Search Over 100 PDFs: Meaning, Not Ctrl+FCONTEXTFLOW · BUILD 42cf08 5 MIN › JUN 03 SYSTEM Sessionization in Pure SQLSPECTRUM · BUILD 8a3c72 6 MIN › JUN 02 SYSTEM A/B Experiments With Wilson Score Intervals in SQLSPECTRUM · BUILD 6b08e1 6 MIN › JUN 01 GROWTH Fifty-Four Bugs, Documented in PublicGROWTH · BUILD IN PUBLIC 5 MIN › MAY 31 CONCEPT Schema Registry: Producers That Can Never Break ConsumersCONCEPTS · DATA CONTRACTS 4 MIN › MAY 30 SYSTEM The IMDS Saga: Five Bugs, One Wrong Parameter NamePHRONIS · ANOMALY 7 MIN › MAY 29 CONCEPT The Circuit-Breaker Pattern, Applied to AI AgentsCONCEPTS · RESILIENCE 5 MIN › MAY 28 SYSTEM "Unknown" Was the Most Dangerous Row in My WarehouseSPECTRUM · ANOMALY 6 MIN › MAY 27 SYSTEM 2.5MB Through a 48KB Door: The XCom Size LimitCONTEXTFLOW · ANOMALY 5 MIN › MAY 26 CONCEPT Streaming vs Batch: Why Sub-Second Aggregation MattersCONCEPTS · STREAM PROCESSING 7 MIN › MAY 25 SYSTEM Sub-500ms Detection: TUMBLE Windows in RisingWavePHRONIS · BUILD 04ab7e 9 MIN › MAY 24 CONCEPT Idempotency in Data PipelinesCONCEPTS · DATA ENGINEERING 5 MIN › MAY 23 SYSTEM The SDK: @agent / @tool Decorators and ~1ms Event EmissionPHRONIS · BUILD 5f9e3d 6 MIN › MAY 22 SYSTEM The Star Schema, Monthly Partitions, and Why I Indexed That WaySPECTRUM · BUILD 2c91d5 7 MIN › MAY 21 GROWTH Why I Write Before I Have the AnswersGROWTH · PROCESS 4 MIN › MAY 20 SYSTEM The Kill Switch: ~600ms to Halt, Persisted in PostgreSQLPHRONIS · BUILD c52d19 7 MIN › MAY 19 SYSTEM One User, Every Tenant's RetentionSPECTRUM · ANOMALY 5 MIN › MAY 18 SYSTEM Cleaning Multilingual PDFs: Ligatures, IPA, and Broken UnicodeCONTEXTFLOW · BUILD 96d0f3 9 MIN › MAY 17 SYSTEM The Partition That Existed But Couldn't Be FoundSPECTRUM · ANOMALY 6 MIN › MAY 16 SYSTEM NULL ≠ NULL: A Duplicate-Geography BugSPECTRUM · ANOMALY 5 MIN › MAY 15 SYSTEM Chunking With Provenance: 512 Chars, 64 Overlap, Full LineageCONTEXTFLOW · BUILD c3a8e9 5 MIN › MAY 14 CONCEPT Embeddings Explained: From Text to Cosine SimilarityCONCEPTS · VECTOR SEARCH 9 MIN › MAY 13 SYSTEM The Airflow DAG: Validate, Extract, Transform, Load, NotifyCONTEXTFLOW · BUILD 0e9d54 6 MIN › MAY 12 SYSTEM Shipping It to Kubernetes: Kind + Podman + HelmPHRONIS · BUILD d9e063 8 MIN › MAY 11 SYSTEM Deterministic Chunk IDs: Idempotency as Structure, Not a FlagCONTEXTFLOW · BUILD 71fa2b 5 MIN › MAY 10 SYSTEM 384 Dimensions, Zero API Cost: Local EmbeddingsCONTEXTFLOW · BUILD 1ba7e6 8 MIN › MAY 09 GROWTH Building Alone, in PublicGROWTH · DEEP WORK 5 MIN › MAY 08 SYSTEM Cold Storage That Time-Travels: Iceberg on MinIOPHRONIS · BUILD 31c8f4 5 MIN › MAY 07 SYSTEM The Sidebar That Mutated Global StateCONTEXTFLOW · ANOMALY 4 MIN › MAY 06 SYSTEM Why My .env Was Silently IgnoredCONTEXTFLOW · ANOMALY 4 MIN › MAY 05 CONCEPT FOR UPDATE SKIP LOCKED: Queue Processing Without a QueueCONCEPTS · POSTGRESQL 6 MIN › MAY 04 SYSTEM structlog Is Not logging: The %s TrapCONTEXTFLOW · ANOMALY 4 MIN › MAY 03 CONCEPT The Protocol Pattern: Swappable Embedders With Duck TypingCONCEPTS · PYTHON DESIGN 4 MIN › MAY 02 CONCEPT RAG Provenance: Why Every Chunk Must Know Where It Came FromCONCEPTS · RAG 4 MIN › MAY 01 CONCEPT Chunking for RAG: Size, Overlap, and the Separator HierarchyCONCEPTS · RAG 5 MIN › APR 30 GROWTH The Long Detour Into EngineeringGROWTH · REFLECTION 5 MIN ›