grep --tag "SQLite" ./posts

# Tag: SQLite

A Japanese Bigram Index on D1 and FTS5

How normalized adjacent pairs are written to D1 FTS5 with a changes() guard, a separate restore builder, and snapshot-preserving backfill.

D1 Has No Down Migrations: A Forward-Only Recovery Strategy

The Wrangler D1 migration CLI has no down command. Use forward fixes, whole-database Time Travel, and schema compatibility without rewriting history.

Japanese Full-Text Search on D1 with FTS5 Trigram

A D1 search route using LIKE for one or gramless two code points, bigram for valid pairs, trigram for longer terms, and path-specific fallbacks.

Operating D1 site search with FTS5: trigram, bigram, and LIKE

An operations record for isolated public site search that selects LIKE, bigram, or trigram by normalized query shape without merging result sets.