import Tab from '@mdx/Tab.astro'; import Tabs from '@mdx/Tabs.astro'; import Npm from "@mdx/Npm.astro"; import Callout from '@mdx/Callout.astro'; import Steps from '@mdx/Steps.astro'; import AnchorCards from '@mdx/AnchorCards.astro'; import Prerequisites from "@mdx/Prerequisites.astro"; import CodeTabs from '@mdx/CodeTabs.astro'; import CodeTab from '@mdx/CodeTab.astro'; import Section from "@mdx/Section.astro"; import LinksList from "@mdx/LinksList.astro" import Flex from "@mdx/Flex.astro" # Database connection with Drizzle Drizzle ORM runs SQL queries on your database via **database drivers**. ```ts import { drizzle } from "drizzle-orm/node-postgres" import { users } from "./schema" const db = drizzle(process.env.DATABASE_URL); const usersCount = await db.$count(users); ``` ``` ┌──────────────────────┐ │ db.$count(users) │ <--- drizzle query └──────────────────────┘ │ ʌ select count(*) from users -│ │ │ │- [{ count: 0 }] v │ ┌─────────────────────┐ │ node-postgres │ <--- database driver └─────────────────────┘ │ ʌ 01101000 01100101 01111001 -│ │ │ │- 01110011 01110101 01110000 v │ ┌────────────────────┐ │ Database │ └────────────────────┘ ``` ```ts import { pgTable, integer, text } from "drizzle-orm"; export const users = pgTable("users", { id: integer("id").generateAlwaysAsIdentity(), name: text("name"), }) ``` Under the hood Drizzle will create a **node-postgres** driver instance which you can access via `db.$client` if necessary

```ts import { drizzle } from "drizzle-orm/node-postgres" const db = drizzle(process.env.DATABASE_URL); const pool = db.$client; ``` ```ts // above is equivalent to import { drizzle } from "drizzle-orm/node-postgres"; import { Pool } from "pg"; const pool = new Pool({ connectionString: process.env.DATABASE_URL, }); const db = drizzle({ client: pool }); ```

Drizzle is by design natively compatible with every **edge** or **serverless** runtime, whenever you'd need access to a serverless database - we've got you covered ```ts import { drizzle } from "drizzle-orm/neon-http"; const db = drizzle(process.env.DATABASE_URL); ``` ```ts import { drizzle } from "drizzle-orm/neon-serverless"; const db = drizzle(process.env.DATABASE_URL); ``` ```ts import { drizzle } from "drizzle-orm/vercel-postgres"; const db = drizzle(); ``` ```ts import { drizzle } from "drizzle-orm/planetscale"; const db = drizzle(process.env.DATABASE_URL); ``` ```ts import { drizzle } from "drizzle-orm/d1"; const db = drizzle({ connection: env.DB }); ``` And yes, we do support runtime specific drivers like [Bun SQLite](/docs/connect-bun-sqlite) or [Expo SQLite](/docs/connect-expo-sqlite):

```ts import { drizzle } from "drizzle-orm/bun-sqlite" const db = drizzle(); // <--- will create an in-memory db const db = drizzle("./sqlite.db"); ``` ```ts import { drizzle } from "drizzle-orm/expo-sqlite"; import { openDatabaseSync } from "expo-sqlite"; const expo = openDatabaseSync("db.db"); const db = drizzle(expo); ```

#### Database connection URL Just in case if you're not familiar with database connection URL concept ``` postgresql://alex:AbC123dEf@ep-cool-darkness-123456.us-east-2.aws.neon.tech/dbname └──┘ └───────┘ └─────────────────────────────────────────────┘ └────┘ ʌ ʌ ʌ ʌ role -│ │ │- hostname │- database │ │- password ``` #### Next steps Feel free to check out per-driver documentations {/* TODO: @AndriiSherman ["AWS Data API", "/docs/get-started/aws-data-api"], */}

database-connection