@miniflare/d1

Workers D1 module for Miniflare: a fun, full-featured, fully-local simulator for Cloudflare Workers. See 📦 D1 for more details.

Example

import { createSQLiteDB } from "@miniflare/shared";
import { D1Database, D1DatabaseAPI } from "@miniflare/d1";

const sqliteDb = await createSQLiteDB(":memory:");
const db = new D1Database(new D1DatabaseAPI(sqliteDb));
await db.exec(
  `CREATE TABLE my_table (cid INTEGER PRIMARY KEY, name TEXT NOT NULL);`
);
const response = await db.prepare(`SELECT * FROM sqlite_schema`).all();
console.log(await response);
/*
{
  "success": true,
  "results": [
    {
      "type": "table",
      "name": "my_table",
      "tbl_name": "my_table",
      "rootpage": 2,
      "sql": "CREATE TABLE my_table (cid INTEGER PRIMARY KEY, name TEXT NOT NULL)"
    }
  ],
  ...
}
*/