drizzle-team / drizzle-team/drizzle-orm

[BUG]: Vercel Edge + Supabase issues

Open
#1,424 4 comments 1 reaction 0 assignees View on GitHub
bug driver/pg driver/postgresjs priority
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### What version of `drizzle-orm` are you using?

0.28.6

### What version of `drizzle-kit` are you using?

_No response_

### Describe the Bug

I am trying to use drizzle over vercel edge and following the guides with cloudflare workers + supabase shown on the drizzle documentation (as vercel edge is just a cloudflare wrapper)

Doc: https://orm.drizzle.team/docs/quick-postgresql/supabase

This is my code

```
import { NextFetchEvent, NextRequest } from 'next/server';
import { Pool } from 'pg';
import { drizzle } from 'drizzle-orm/node-postgres';
import * as schema from '@/db/schema';
import { users } from '@/db/schema';
import { eq } from 'drizzle-orm';
import { createSuccessResponse } from '../../common/errors-and-responses';

export const runtime = 'edge';
export const dynamic = 'auto';
export const dynamicParams = true;
export const revalidate = false;
export const fetchCache = 'auto';
export const preferredRegion = 'iad1';
export const maxDuration = 5;

export async function GET(request: NextRequest, context: NextFetchEvent) {
const pool = new Pool({ connectionString: process.env.DATABASE_POOL_URL });
const db = drizzle(pool, { schema });
const user = db.query.users.findFirst({
where: eq(users.email, 'myemail@gmail.com')
});
context.waitUntil(pool.end());
return createSuccessResponse({ user });
}
```

This is my error

```
Import trace for requested module:
./node_modules/pg/lib/native/client.js
./node_modules/pg/lib/native/index.js
./node_modules/pg/lib/index.js
./src/app/api/(application)/testing/route.ts
./node_modules/next/dist/build/webpack/loaders/next-app-loader.js?name=app%2Fapi%2F(application)%2Ftesting%2Froute&page=%2Fapi%2F(application)%2Ftesting%2Froute&appPaths=&pagePath=private-next-app-dir%2Fapi%2F(application)%2Ftesting%2Froute.ts&appDir=%2FUsers%2Fsam%2FDocuments%2FGitHub%2Flucky-duck%2Fmybuyside%2Fsrc%2Fapp&pageExtensions=tsx&pageExtensions=ts&pageExtensions=jsx&pageExtensions=js&rootDir=%2FUsers%2Fsam%2FDocuments%2FGitHub%2Flucky-duck%2Fmybuyside&isDev=true&tsconfigPath=tsconfig.json&basePath=&assetPrefix=&nextConfigOutput=&preferredRegion=iad1&middlewareConfig=e30%3D!./src/app/api/(application)/testing/route.ts?__next_edge_ssr_entry__
⚠ ./node_modules/pg/lib/native/client.js
Module not found: Can't resolve 'pg-native' in '/Users/sam/Documents/GitHub/lucky-duck/mybuyside/node_modules/pg/lib/native'
```

normal (non edge) works fine I am using supabase connection pooler also

### Expected behavior

_No response_

### Environment & setup

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.