cloudflare-d1

Status : Production Ready ✅ Last Updated : 2026-01-20 Dependencies : cloudflare-worker-base (for Worker setup) Latest Versions : wrangler@4.59.2, @cloudflare/workers-types@4.20260109.0 Recent Updates (2025) : Add to your wrangler.jsonc : CRITICAL: Edit the migration file: Migrations are automatically versioned: Rules: Type Definitions: prepare() - PRIMARY METHOD (always use for user input): Why: Prevents SQL injection, reusable, better performance, type-safe Query Result Methods: batch() - CRITICAL FOR PERFORMANCE: exec() - AVOID IN PRODUCTION: Common Error Types: Common Errors and Fixes: CRITICAL : D1 queries fail transiently with errors like "Network connection lost", "storage operation exceeded timeout", or "isolate exceeded its memory limit". Cloudflare documentation states "a handful of errors every several hours is not unexpected" and recommends implementing retry logic. ( D1 FAQ ) Common Transient Errors: Retry Pattern (Recommended): Automatic Retries (Sept 2025): D1 automatically retries read-only queries (SELECT, EXPLAIN, WITH) up to 2 times on retryable errors. Check meta.total_attempts in response for retry count. Write queries should still implement custom retry logic. Index Best Practices: PRAGMA optimize (Feb 2025): Query Optimization: Local vs Remote (Nov 2025 - Remote Bindings GA): Known Issue : When using remote D1 bindings ( { "remote": true } ), the...