
Cloudflare D1 Has a Free API: SQLite at the Edge with Zero Latency
What is Cloudflare D1? Cloudflare D1 is a serverless SQL database built on SQLite, running at Cloudflare's edge network. Your database is milliseconds from your users — everywhere in the world. Free tier: 5 GB storage, 5M reads/day, 100K writes/day . Quick Start npm install -g wrangler wrangler login # Create database wrangler d1 create my-db # Run SQL wrangler d1 execute my-db --command "CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT, email TEXT UNIQUE)" Use in Workers // src/index.ts export default { async fetch ( request : Request , env : Env ) { const url = new URL ( request . url ); if ( url . pathname === " /users " && request . method === " GET " ) { const { results } = await env . DB . prepare ( " SELECT * FROM users ORDER BY id DESC LIMIT 20 " ). all (); return Response . json ( results ); } if ( url . pathname === " /users " && request . method === " POST " ) { const { name , email } = await request . json (); const result = await env . DB . prepare ( " INSERT INTO use
Continue reading on Dev.to Tutorial
Opens in a new tab

