cloudflare-d1

Cloudflare D1 lets you create and manage SQLite databases directly from Workers. Use wrangler to create databases, configure bindings in your worker configuration, and execute queries with prepared statements for type safety and performance.

D1 migrations are SQL files you create and apply using wrangler commands. Write idempotent migration scripts, apply them locally for testing, then deploy to your live database. Migrations run in sequence to evolve your schema safely.

Yes, D1 enforces prepared statements with parameter binding to prevent SQL injection. Batch multiple queries together for better performance, and use the `.first()` or `.all()` methods to retrieve results efficiently.

D1 provides error handling patterns for query failures and connection issues. Wrap queries in try-catch blocks, validate input bindings, and implement fallback logic to ensure your Worker handles database errors gracefully.

D1 supports local development workflows using the wrangler CLI, letting you test migrations and queries offline. Switch to remote databases by deploying your Worker, with the same code working seamlessly in both environments.

D1 runs SQLite on Cloudflare's edge network, eliminating external database latency and infrastructure complexity. It integrates natively with Workers, reduces query round trips, and simplifies deployment by colocating compute and storage.