SQLite at the Edge: Sub-Millisecond Queries Without Daemons
How embedded SQLite with WAL mode delivers microsecond database performance with zero infrastructure complexity.
Tag Archive
#sqlite
4 articles filed under this tag
Write-Ahead Logging (WAL) in Production: Under the Hood
Deep-dive into SQLite transaction durability, lock-free concurrent readers, and checkpointing strategies.
Zero-Daemon Search: Microsecond Full-Text Search with FTS5
Sub-millisecond tokenized searching and bm25 ranking across thousands of posts without Elasticsearch or Algolia.
From 10 to 10,000 Posts: Stress-Testing Embedded Databases
Benchmarking 10,000 articles on single-file SQLite: deep pagination in 0.11ms and full-text searches in 0.8ms.
