SQLite

SQLite is a lightweight, serverless, self-contained SQL database engine that is widely used for local data storage in applications. Read more here.

Example Usage

Better Auth supports multiple SQLite drivers. Choose the one that best fits your environment:

Better-SQLite3 (Recommended)

The most popular and stable SQLite driver for Node.js:

import { betterAuth } from "better-auth";
import Database from "better-sqlite3";
 
export const auth = betterAuth({
  database: new Database("database.sqlite"),
});

Node.js Built-in SQLite (Experimental)

Starting from Node.js 22.5.0, you can use the built-in SQLite module:

import { betterAuth } from "better-auth";
import { DatabaseSync } from "node:sqlite";
 
export const auth = betterAuth({
  database: new DatabaseSync("database.sqlite"),
});

To run your application with Node.js SQLite:

node your-app.js

Bun Built-in SQLite

You can also use the built-in SQLite module in Bun, which is similar to the Node.js version:

import { betterAuth } from "better-auth";
import { Database } from "bun:sqlite";
export const auth = betterAuth({
  database: new Database("database.sqlite"),
});

Schema generation & migration

The Better Auth CLI allows you to generate or migrate your database schema based on your Better Auth configuration and plugins.

npx @better-auth/cli@latest generate

npx @better-auth/cli@latest migrate

Additional Information

SQLite is supported under the hood via the Kysely adapter, any database supported by Kysely would also be supported. (Read more here)

If you're looking for performance improvements or tips, take a look at our guide to performance optimizations.