Tag: #sqlite

한국어English日本語中文

← All posts

• The SQLite WAL-Reset Bug: A Data Corruption Race That Hid for 15 Years

  On March 3, 2026, SQLite developer Dan found and fixed a data race that could, rarely, corrupt a database in WAL mode. The bug lived in every version from 3.7.0 (2010-07-21), when WAL was introduced, through 3.51.2 (2026

  2026-07-16 · 18 min read #sqlite#wal#database-internals#concurrency#data-race

• SQLite Is Everywhere (and It's Amazing)

  The most-deployed database on Earth is not Oracle or Postgres — it is SQLite. It is in your phone, your browser, even on airplanes. A tour of its serverless single-file design, when it beats a client-server database, WAL

  2026-06-15 · 11 min read #databases#sqlite#engineering

• Local-First Software Design — An Alternative Architecture for the Age of Cloud Fatigue

  As cloud fatigue grows in 2026, local-first architecture is back in the spotlight. From the seven ideals of Ink and Switch to sync engine design, using CRDTs from a design perspective, an ecosystem comparison of Electric

  2026-06-12 · 19 min read #local-first#architecture#crdt#sync-engine#offline-first

• Database Engines 2026 Deep-Dive — Postgres Won the API, ClickHouse and DuckDB Won Analytics

  PostgreSQL 17/18, MySQL 9, MariaDB 12, SQLite + libSQL + Turso, DuckDB 1.x, ClickHouse, StarRocks, Doris, Druid, Pinot, TiDB, CockroachDB 25, YugabyteDB, Cassandra 5, ScyllaDB, Aerospike, Neon, Supabase, PlanetScale, Xat

  2026-05-16 · 17 min read #database#postgresql#mysql#clickhouse#duckdb

• The SQLite Renaissance of 2026 — How a 24-Year-Old Single-File Database Became the Hottest Infrastructure (libSQL, Turso, LiteFS, D1, mvSQLite Deep Dive)

  The most surprising infrastructure trend of 2026 is a 24-year-old single-file database — SQLite. Turso's libSQL embedded replicas made the read-local-write-remote model mainstream, Cloudflare D1 distributed SQLite across

  2026-05-14 · 21 min read #sqlite#libsql#turso#litefs#cloudflare-d1