cloudflare-d1

Cloudflare D1 lets you deploy SQLite databases directly to edge locations and query them from Workers. Create a D1 database, configure wrangler bindings in wrangler.jsonc, and use prepared statements with .bind() to safely execute queries at the edge without roundtrips to a central server.

D1 uses versioned SQL migrations managed through wrangler. Create migration files in your project, configure them in wrangler.jsonc bindings, and apply them to both local development and remote environments. This ensures schema changes are tracked and reproducible across deployments.

Yes. D1 supports prepared statements with the .bind() method, which safely binds parameters to queries and prevents SQL injection. Use this pattern for all dynamic queries, and handle null values explicitly in your type-safe implementation.

D1 includes batch query support via the .batch() method, allowing you to execute multiple queries in a single request. This reduces latency and improves throughput for operations that don't require sequential dependencies.

Create indexes during migrations to speed up frequent queries on large datasets. D1 supports standard SQLite index syntax. Monitor query performance in both local and remote environments, and use prepared statements with input validation to maintain efficiency at edge scale.