ContextQMD
Back to Drizzle Orm

Drizzle Bun SQL

src/content/docs/connect-bun-sql.mdx

latest1.4 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";

Drizzle <> Bun SQL

<Prerequisites> - Database [connection basics](/docs/connect-overview) with Drizzle - Bun - [website](https://bun.sh/docs) - Bun SQL - native bindings for working with PostgreSQL databases - [read here](https://bun.sh/docs/api/sql) </Prerequisites>

According to the official website, Bun is a fast all-in-one JavaScript runtime.

Drizzle ORM natively supports bun sql module and it's crazy fast 🚀

Step 1 - Install packages

<Npm> drizzle-orm -D drizzle-kit </Npm>

Step 2 - Initialize the driver and make a query

typescript
import 'dotenv/config';
import { drizzle } from 'drizzle-orm/bun-sql';

const db = drizzle(process.env.DATABASE_URL);

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

If you need to provide your existing driver:

typescript
import 'dotenv/config';
import { drizzle } from 'drizzle-orm/bun-sql';
import { SQL } from 'bun';

const client = new SQL(process.env.DATABASE_URL!);
const db = drizzle({ client });

What's next?

<WhatsNextPostgres/>