Back to Drizzle Orm

ConnectPlanetScale

src/mdx/get-started/mysql/ConnectPlanetScale.mdx

latest709 B
Original Source

Create a index.ts file in the src/db directory and initialize the connection:

typescript
import { drizzle } from "drizzle-orm/planetscale-serverless";

const db = drizzle({ connection: {
  host: process.env.DATABASE_HOST!,
  username: process.env.DATABASE_USERNAME!,
  password: process.env.DATABASE_PASSWORD!,
}});

If you need to provide your existing driver

typescript
import { drizzle } from "drizzle-orm/planetscale-serverless";
import { Client } from "@planetscale/database";

const client = new Client({
  host: process.env.DATABASE_HOST!,
  username: process.env.DATABASE_USERNAME!,
  password: process.env.DATABASE_PASSWORD!,
});

const db = drizzle({ client: client });