ContextQMD
Back to Drizzle Orm

Drizzle Turso Database

src/content/docs/connect-turso-database.mdx

latest1.6 KB
Original Source

import Npm from "@mdx/Npm.astro"; import Callout from '@mdx/Callout.astro'; import AnchorCards from '@mdx/AnchorCards.astro'; import Steps from '@mdx/Steps.astro'; import WhatsNextPostgres from "@mdx/WhatsNextPostgres.astro"; import Prerequisites from "@mdx/Prerequisites.astro"; import CodeTabs from "@mdx/CodeTabs.astro"; import LibsqlTable from "@mdx/LibsqlTable.mdx"; import LibsqlTabs from "@mdx/LibsqlTabs.mdx";

Drizzle <> Turso Database

<Prerequisites> - Database [connection basics](/docs/connect-overview) with Drizzle - Turso Database - [website](https://docs.turso.tech/introduction) - Turso Database driver - [website](https://docs.turso.tech/connect/javascript) & [GitHub](https://github.com/tursodatabase/turso/tree/main/bindings/javascript) </Prerequisites>

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> drizzle-orm@beta @tursodatabase/database -D drizzle-kit@beta </Npm>

Step 2 - Initialize the driver and make a query

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

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

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

If you need to provide your existing drivers:

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

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

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

What's next?

<WhatsNextPostgres/>