Topic

#Sqlite

15 articles on Sqlite — news, releases, guides and analysis from the SourceFeed engine.

The 16-Year Race Hiding in SQLite's WAL

Tailscale's corruption post-mortem and a 15-minute simulated repro expose the bug class coverage metrics can't see.

The WAL-reset race hid in every SQLite release since 2010 — and your bundled copy may still carry it.

The WAL-reset race survived the industry's most-tested codebase, because "rare" turned out to depend entirely on your workload.

An S3 bucket replaces the control plane, and even the primitive's creator is cheering on the forks.

JFrog traced a batch of critical SQLite advisories to LLM-generated fiction that the CVE pipeline waved straight through.

Traceway's benchmark is real, but the right takeaway is a two-database pattern, not a switch.

The pragma recipe converged years ago — what still hurts is the single-writer wall and the replication layer beneath it.

Ship a typed CRUD API on Bun's native SQLite driver and Elysia, then benchmark it against Express to see the actual difference.

Footgun defaults for foreign keys and types could evolve without a flag day if the library borrowed from language design.

The open-source PKM tool splits into OG and DB tracks, trading file-canonical storage for sync and collaboration.

Generate SQL from natural language with an LLM, then validate every query against an AST-based guardrail before it touches your database.

SQLite's flexible typing is a historical quirk, but strict tables bring modern type safety to your embedded database.

The architectural trade-offs of stateful edge computing, and what it costs to build your own data plane.

A global TRACE log sink in OpenAI's CLI can write hundreds of terabytes a year to a local SQLite file — and it's been festering for months.

By embedding sandboxed HTML/JS apps directly alongside SQLite databases, Datasette becomes a secure, zero-maintenance internal tool platform.