Drizzle <> Turso Database

According to the official website, Turso is the small database to power your big dreams in the age of AI.

Step 1 - Install packages

npm i drizzle-orm@rc @tursodatabase/database
npm i -D drizzle-kit@rc

yarn add drizzle-orm@rc @tursodatabase/database
yarn add -D drizzle-kit@rc

pnpm add drizzle-orm@rc @tursodatabase/database
pnpm add -D drizzle-kit@rc

bun add drizzle-orm@rc @tursodatabase/database
bun add -D drizzle-kit@rc

Step 2 - Initialize the driver and make a query

import { drizzle } from 'drizzle-orm/tursodatabase/database';

const db = drizzle('sqlite.db');

const result = await db.all('select 1');

If you need to provide your existing drivers:

import { Database } from '@tursodatabase/database';
import { drizzle } from 'drizzle-orm/tursodatabase/database';

const client = new Database('sqlite.db');
const db = drizzle({ client });

const result = await db.all('select 1');

Transaction modes

You can set the transaction mode with the behavior option. Drizzle passes it to the driver, which opens the transaction with BEGIN <mode>. Without behavior, a plain BEGIN is used, which SQLite runs as deferred.

import { drizzle } from 'drizzle-orm/tursodatabase/database';
import { users } from './schema';

const db = drizzle('sqlite.db');

await db.transaction(async (tx) => {
  await tx.insert(users).values({ name: 'Dan' });
}, {
  behavior: 'immediate', // 'deferred' | 'immediate' | 'exclusive' | 'concurrent'
});

• deferred - takes the lock on the first read or write
• immediate - takes the write lock at the start of the transaction
• exclusive - takes the write lock at the start and blocks other connections
• concurrent - lets several write transactions run at the same time. It needs MVCC to be turned on in Turso Database

Nested tx.transaction() calls use savepoints and don’t take a behavior option.

What’s next?