Documentation
SQLite
Cloudflare D1

Cloudflare D1

Due to their official website (opens in a new tab), D1 is Cloudflare's first queryable relational database.

Drizzle ORM fully supports D1 database and Cloudflare Workers environment, we embrace SQL dialects and dialect specific drivers and syntax and mirror most popular SQLite-like all, get, values and run query methods syntax.

npm install drizzle-orm
npm install -D drizzle-kit 
import { drizzle, BetterSQLite3Database } from 'drizzle-orm/better-sqlite3';
import Database from 'better-sqlite3';
 
const sqlite = new Database('sqlite.db');
const db: BetterSQLite3Database = drizzle(sqlite);
 
const result = await db.select().from(users).all()