ContextQMD
Back to Drizzle Orm

ConnectPostgreSQL

src/mdx/get-started/postgresql/ConnectPostgreSQL.mdx

latest905 B
Original Source

import CodeTabs from "@mdx/CodeTabs.astro";

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

<CodeTabs items={["node-postgres", "node-postgres with config", "your node-postgres driver"]}>

typescript
import 'dotenv/config';
import { drizzle } from 'drizzle-orm/node-postgres';

const db = drizzle(process.env.DATABASE_URL!);
typescript
import 'dotenv/config';
import { drizzle } from 'drizzle-orm/node-postgres';

// You can specify any property from the node-postgres connection options
const db = drizzle({ 
  connection: { 
    connectionString: process.env.DATABASE_URL!,
    ssl: true
  }
});
typescript
import 'dotenv/config';
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 });
</CodeTabs>