TAG SEARCH

#D1

D1 Migrations Can't Go Back: A Rollback Strategy for Forward-Only Schemas

Cloudflare D1 has no down migrations. How to change schemas safely anyway: pre-written rollback SQL, idempotent backfills, the DROP COLUMN trigger trap, and dual-schema application code.

Japanese Full-Text Search on D1 (SQLite): FTS5 Trigram with Layered Fallbacks

How do you search Japanese text without a morphological analyzer? Using FTS5's trigram tokenizer on Cloudflare D1, with LIKE for short queries and prefix search for English — a three-stage fallback design.

Building a Blog on Cloudflare Workers + D1 + Next.js: Architecture and Design Decisions

Using this blog itself as the case study: the architecture, design decisions, and pitfalls of running a personal blog on Cloudflare Workers with D1, R2, and a Next.js-compatible runtime.