Drizzle <> Turso

According to the official website, Turso is a libSQL powered edge SQLite database as a service.

Drizzle ORM natively supports libSQL driver, we embrace SQL dialects and dialect specific drivers and syntax and mirror most popular SQLite-like all, get, values and run query methods syntax.

Step 1 - Install packages

npm i drizzle-orm @libsql/client
npm i -D drizzle-kit

yarn add drizzle-orm @libsql/client
yarn add -D drizzle-kit

pnpm add drizzle-orm @libsql/client
pnpm add -D drizzle-kit

bun add drizzle-orm @libsql/client
bun add -D drizzle-kit

Step 2 - Initialize the driver and make a query

import { drizzle } from 'drizzle-orm/connect';

const db = await drizzle('libsql', { connection: {
  url: process.env.DATABASE_URL, 
  authToken: process.env.DATABASE_AUTH_TOKEN 
}});

const result = await db.select().from(...)

If you need a synchronous connection, you can use our additional connection API, where you specify a driver connection and pass it to the Drizzle instance.

import { drizzle } from 'drizzle-orm/libsql';
import { createClient } from '@libsql/client';

const client = createClient({ 
  url: process.env.DATABASE_URL,
  authToken: process.env.DATABASE_AUTH_TOKEN
});

const db = drizzle(client);

const result = await db.select().from(users).all()

What’s next?