Drizzle Team•2y ago

using postgres-js for connection

I am trying to setup drizzle with postgres-js package ( as document it be fastest). Referring to this doc: https://orm.drizzle.team/docs/installation-and-db-connection/postgresql/postgresjs How do i define schema using postgres-js ?? I tried import for table to my schema file and typescript shows error: Module '"drizzle-orm/postgres-js"' has no exported member ... How can i import table and other types ?? shoud I use 'drizzle-orm/pg-core' package for schema and 'drizzle-orm/postgres-js' for my index.ts ?? schema.ts :

import { integer, pgEnum, pgTable, serial, uniqueIndex, varchar,boolean,text,timestamp } from 'drizzle-orm/postgres-js';

import { integer, pgEnum, pgTable, serial, uniqueIndex, varchar,boolean,text,timestamp } from 'drizzle-orm/postgres-js';

index .ts :

import { drizzle, PostgresJsDatabase } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';

const connectionString = process.env.DATABASE_URL || "";

const queryClient = postgres(connectionString, { max: 10 });
const db: PostgresJsDatabase = drizzle(queryClient);

import { drizzle, PostgresJsDatabase } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';

const connectionString = process.env.DATABASE_URL || "";

const queryClient = postgres(connectionString, { max: 10 });
const db: PostgresJsDatabase = drizzle(queryClient);

2 Replies

kazdegroot•2y ago

You should import from the Postgres generic package in scheme.ts; drizzle-orm/pg-core if I remember correctly

ockonor#21•2y ago

https://github.com/canduma/nest-drizzle/blob/master/src/schema.ts

GitHub

nest-drizzle/src/schema.ts at master · canduma/nest-drizzle

Integration of Drizzle ORM for Nestjs Framework. Contribute to canduma/nest-drizzle development by creating an account on GitHub.

Gaming

Programming

using postgres-js for connection