src/mdx/get-started/postgresql/ConnectNile.mdx
import Callout from '@mdx/Callout.astro'; 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"]}>
import 'dotenv/config';
import { drizzle } from 'drizzle-orm/node-postgres';
const db = drizzle(process.env.NILEDB_URL!);
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.NILEDB_URL!,
ssl: true
}
});
import 'dotenv/config';
import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";
const pool = new Pool({
connectionString: process.env.NILEDB_URL!,
});
const db = drizzle({ client: pool });