SQLite

You have 3 options for using SQLite:

• node-sqlite (recommended)
• better-sqlite3
• sqlite3

node-sqlite

This driver uses native node:sqlite supported in Node.js >= 22.5 (experimental) and Deno >= 2.2 and requires no dependencies!

import { createDatabase } from "db0";
import sqlite from "db0/connectors/node-sqlite";

const db = createDatabase(
  sqlite({
    name: ":memory:",
  }),
);

better-sqlite3

For this connector, you need to install better-sqlite3 dependency:

npm i better-sqlite3

yarn add better-sqlite3

pnpm i better-sqlite3

bun i better-sqlite3

deno i npm:better-sqlite3

Use better-sqlite3 connector:

import { createDatabase } from "db0";
import sqlite from "db0/connectors/better-sqlite3";

const db = createDatabase(
  sqlite({
    name: ":memory:",
  }),
);

Options

cwd

Working directory to create database. Default is current working directory of project. (It will be ignored if path is provided an absolute path.)

name

Database (file) name. Default is db.

path

Related (to cwd) or absolute path to the sql file. By default it is stored in {cwd}/.data/{name}.sqlite3 / .data/db.sqlite3

sqlite3

For this connector, you need to install sqlite3 dependency:

npm i sqlite3

yarn add sqlite3

pnpm i sqlite3

bun i sqlite3

deno i npm:sqlite3

Use sqlite3 connector:

import { createDatabase } from "db0";
import sqlite from "db0/connectors/sqlite3";

const db = createDatabase(
  sqlite({
    name: ":memory:",
  }),
);

Options

(same as better-sqlite3)