#Write-Ahead Logging
21 related articles
·3 min
Richard Hipp's Rules of Reliability: How a Small Team Built Software Deployed Trillions of Times
SQLite creator Richard Hipp shares reliability engineering secrets: 100% MC/DC coverage, defensive programming, and zero-dependency design that powers trillions of deployments by a 3-person team.
Read more →
·3 min
Automated Cleanup of Corrupted Media Server Files: FFmpeg Detection with Sonarr Integration
Learn how to fix corrupted media files after power outages using FFmpeg and ffprobe for automated detection, integrated with Sonarr for batch cleanup and re-downloading.
Read more →
·3 min
OneDrive Stuck at 400K Files? A Guide to Self-Hosted Sync Alternatives
OneDrive stalls as file counts approach 400K, causing sync failures and high CPU usage. This guide analyzes the technical causes and compares self-hosted alternatives like Syncthing, Nextcloud, and rsync/rclone.
Read more →
·3 min
OneDrive Stuck at 400K Files? A Guide to Self-Hosted Sync Solutions
OneDrive stalls when file count approaches 400K, causing sync failures and high CPU usage. This guide analyzes the bottleneck and compares Syncthing, Nextcloud, rsync/rclone for self-hosted sync.
Read more →
·3 min
pgtestdb: Accelerating Database Testing with PostgreSQL Template Cloning
Learn how pgtestdb leverages PostgreSQL's native template cloning to reduce database migration costs from O(n) to O(1), enabling millisecond-level test database creation with full parallel isolation.
Read more →
·4 min
SQLite in Production: A Deep Dive into WAL Mode, Concurrency Control, and VFS Optimization
A deep dive into three core SQLite production optimizations: WAL mode for read/write concurrency, single-writer concurrency model best practices, and VFS layer tuning with mmap and custom locking.
Read more →
·5 min
The Five Stages of AI Agent Architecture Evolution: The Real Path from Model Calls to Production Runtime
Deep dive into the five evolution stages of AI Agent architecture: model calls, tool calls, workflows, Agent loops, and production runtime. Learn the responsibility boundaries and design principles.
Read more →
·3 min
Apache Cassandra Explained: A Linearly Scalable and Highly Available Distributed Database
Deep dive into Apache Cassandra's core design: linear scalability, decentralized architecture, tunable consistency, and ideal use cases for engineering teams.
Read more →
sqlite-utils 4.1 Released: The --code …
·7 min
sqlite-utils 4.1 Released: The --code Option, Type Overrides, and AI-Assisted Development in Practice
sqlite-utils 4.1 brings practical new features: the --code option for generating rows via Python, type overrides to solve ZIP-code leading-zero loss, STRICT table mode switching, drop-index, and more. A deep dive into the design and AI-assisted dev workflow.
Read more →
sqlite-utils 4.1 Released: The --code …
·7 min
sqlite-utils 4.1 Released: The --code Option, Type Overrides, and AI-Assisted Development in Practice
sqlite-utils 4.1 brings practical new features: the --code option for generating rows with Python, field type overrides fixing leading-zero ZIP codes, STRICT table mode switching, drop-index, and more. A deep dive into each design and the AI-assisted dev workflow.
Read more →
·3 min
SQLite STRICT Tables Explained: The Type Enforcement Debate and Best Practices
Deep dive into SQLite STRICT tables: is flexible typing a feature or flaw? Covers the author's stance, type vs. validation debate, Turso alternatives, and best practices for type-safe database design.
Read more →
sqlite-utils 4.1.1: Fix for Silent Dat…
·2 min
sqlite-utils 4.1.1: Fix for Silent Data Loss Risk in Foreign Key Transactions
sqlite-utils 4.1.1 fixes a silent data loss risk in table.transform() caused by foreign key cascade actions inside transactions, introducing a TransactionError fail-fast mechanism.
Read more →
·3 min
pgrust: Rewriting Postgres in Rust — 100% Regression Tests Passing
pgrust is an open-source project rewriting PostgreSQL entirely in Rust, claiming 100% regression test passage. This article analyzes the technical motivation, implementation approach, and key challenges.
Read more →
·4 min
Why Do AI Agents Crash the Moment They Go Live? A Practical Guide to Harness Engineering for Runtime
A deep dive into the Claude Code source code, systematically analyzing the five-layer Harness Engineering architecture: environment, tool, control, memory, and evaluation. Build a stable runtime system for production AI Agents.
Read more →
·7 min
ManagedAgents.sh: A Deep Dive into the Model-Agnostic Open-Source Managed Agent Platform
ManagedAgents.sh is a model-agnostic managed agent platform from OpenComputer, supporting Claude, Pi, and Codex runtimes with Slack and GitHub integration.
Read more →
·4 min
Microsoft Fixes Windows 11 Storage Bloat Bug Caused by Runaway CapabilityAccessManager Database File
Microsoft's optional update KB5095093 fixes a Windows 11 bug where the CapabilityAccessManager.db-wal SQLite WAL file bloats to several GBs due to a failed checkpoint mechanism.
Read more →
Tutorials·3 min
LangGraph Multi-Agent Architecture: Graph Structure Principles and Enterprise-Level Implementation Guide
Deep dive into LangGraph's core graph structure design, single and multi-agent collaboration patterns, MCP protocol integration, and Time Travel fault-tolerance, with enterprise-level hybrid multi-agent architecture implementation.
Read more →
Research·3 min
Inside Cursor Composer 2 Training: A Complete Breakdown of Its Distributed Reinforcement Learning Architecture
Deep dive into how Cursor trained Composer 2 on Fireworks: async pipeline architecture, MoE numerical precision challenges, Router Replay, and global distributed GPU coordination.
Read more →
Tutorials·2 min
Getting Started with Django: Why This 20-Year-Old Framework Is Still Worth Learning
Julia Evans shares Django insights: less magic than Rails, built-in Admin, ORM auto-migrations, SQLite over Postgres — why Django's explicit design suits personal projects.
Read more →
Tutorials·3 min
Codex Cache Cleanup Guide: A Hands-On Tutorial for Slimming Down the .codex Folder
Guide to cleaning OpenAI Codex's local .codex folder cache, including deleting conversations with community Python tools, cleaning logs.sqlite, and periodic archiving to slim from 17MB to 41KB.
Read more →