[BUG]: Module '"drizzle-orm"' has no exported member 'drizzle'.ts(2305)

[kaitakami]

What version of drizzle-orm are you using?

0.35.2

What version of drizzle-kit are you using?

0.26.2

Describe the Bug

Following this guide: https://orm.drizzle.team/docs/get-started/supabase-new

import { drizzle } from "drizzle-orm"; // Error: Module '"drizzle-orm"' has no exported member 'drizzle'.ts(2305)
import postgres from "postgres";

async function main() {
	const db = drizzle(postgres(process.env.DATABASE_URL!));
}
main();

Changing drizzle-orm to drizzle-orm/postgres-js fixed the issue. However docs use drizzle-orm.

#3058 (closed)

Expected behavior

No response

Environment & setup

pnpm 9.11.0
node.js v20.17.0

[404Wolf]

Was using the docs as a guide to set up drizzle for postgres and I also encountered this issue. drizzle-orm/postgres-js also worked for me.

[Marcel-Panknin]

The drizzle function is not exported directly from the main drizzle-orm package. Instead, it must be imported from a database-specific submodule.

Solution:

For Postgres with postgres-js, use the following code:

import { config } from "dotenv";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";

config({ path: ".env.local" }); // Load your environment variables

// Initialize the PostgreSQL client
const client = postgres(process.env.DATABASE_URL!);

// Initialize Drizzle with the client
export const db = drizzle(client);

Reference:

The correct documentation can be found here:
https://orm.drizzle.team/docs/tutorials/drizzle-with-supabase