Skip to main content
Drizzle is an ORM that supports both a SQL-like “query builder” API and an ORM-like Queries API. It supports the bun:sqlite built-in module.
Let’s get started by creating a fresh project with bun init and installing Drizzle.
terminal
bun init -y
bun add drizzle-orm
bun add -D drizzle-kit
Then we’ll connect to a SQLite database using the bun:sqlite module and create the Drizzle database instance.
https://mintcdn.com/bun-1dd33a4e/Hq64iapoQXHbYMEN/icons/typescript.svg?fit=max&auto=format&n=Hq64iapoQXHbYMEN&q=85&s=c6cceedec8f82d2cc803d7c6ec82b240db.ts
import {drizzle} from 'drizzle-orm/bun-sqlite';
import {Database} from 'bun:sqlite';

const sqlite = new Database('sqlite.db');
export const db = drizzle(sqlite);
To see the database in action, add these lines to index.ts.
https://mintcdn.com/bun-1dd33a4e/Hq64iapoQXHbYMEN/icons/typescript.svg?fit=max&auto=format&n=Hq64iapoQXHbYMEN&q=85&s=c6cceedec8f82d2cc803d7c6ec82b240index.ts
import {db} from './db';
import {sql} from 'drizzle-orm';

const query = sql`select "hello world" as text`;
const result = db.get<{text: string}>(query);
console.log(result);
Then run index.ts with Bun. Bun will automatically create sqlite.db and execute the query.
terminal
bun run index.ts

{
  text: "hello world"
}
Lets give our database a proper schema. Create a schema.ts file and define a movies table.
https://mintcdn.com/bun-1dd33a4e/Hq64iapoQXHbYMEN/icons/typescript.svg?fit=max&auto=format&n=Hq64iapoQXHbYMEN&q=85&s=c6cceedec8f82d2cc803d7c6ec82b240schema.ts
import {sqliteTable, text, integer} from 'drizzle-orm/sqlite-core';

export const movies = sqliteTable('movies', {
	id: integer('id').primaryKey(),
	title: text('name'),
	releaseYear: integer('release_year'),
});
We can use the drizzle-kit CLI to generate an initial SQL migration.
terminal
bunx drizzle-kit generate --dialect sqlite --schema ./schema.ts
This creates a new drizzle directory containing a .sql migration file and meta directory.
File Tree
drizzle
├── 0000_ordinary_beyonder.sql
└── meta
    ├── 0000_snapshot.json
    └── _journal.json
We can execute these migrations with a simple migrate.ts script. This script creates a new connection to a SQLite database that writes to sqlite.db, then executes all unexecuted migrations in the drizzle directory.
https://mintcdn.com/bun-1dd33a4e/Hq64iapoQXHbYMEN/icons/typescript.svg?fit=max&auto=format&n=Hq64iapoQXHbYMEN&q=85&s=c6cceedec8f82d2cc803d7c6ec82b240migrate.ts
import {migrate} from 'drizzle-orm/bun-sqlite/migrator';

import {drizzle} from 'drizzle-orm/bun-sqlite';
import {Database} from 'bun:sqlite';

const sqlite = new Database('sqlite.db');
const db = drizzle(sqlite);
migrate(db, {migrationsFolder: './drizzle'});
We can run this script with bun to execute the migration.
terminal
bun run migrate.ts
Now that we have a database, let’s add some data to it. Create a seed.ts file with the following contents.
https://mintcdn.com/bun-1dd33a4e/Hq64iapoQXHbYMEN/icons/typescript.svg?fit=max&auto=format&n=Hq64iapoQXHbYMEN&q=85&s=c6cceedec8f82d2cc803d7c6ec82b240seed.ts
import {db} from './db';
import * as schema from './schema';

await db.insert(schema.movies).values([
	{
		title: 'The Matrix',
		releaseYear: 1999,
	},
	{
		title: 'The Matrix Reloaded',
		releaseYear: 2003,
	},
	{
		title: 'The Matrix Revolutions',
		releaseYear: 2003,
	},
]);

console.log(`Seeding complete.`);
Then run this file.
terminal
bun run seed.ts

Seeding complete.
We finally have a database with a schema and some sample data. Let’s use Drizzle to query it. Replace the contents of index.ts with the following.
https://mintcdn.com/bun-1dd33a4e/Hq64iapoQXHbYMEN/icons/typescript.svg?fit=max&auto=format&n=Hq64iapoQXHbYMEN&q=85&s=c6cceedec8f82d2cc803d7c6ec82b240index.ts
import * as schema from './schema';
import {db} from './db';

const result = await db.select().from(schema.movies);
console.log(result);
Then run the file. You should see the three movies we inserted.
terminal
bun run index.ts

[
  {
    id: 1,
    title: "The Matrix",
    releaseYear: 1999
  }, {
    id: 2,
    title: "The Matrix Reloaded",
    releaseYear: 2003
  }, {
    id: 3,
    title: "The Matrix Revolutions",
    releaseYear: 2003
  }
]
Refer to the Drizzle website for complete documentation.