drizzle-team / drizzle-team/drizzle-orm
[BUG]: Vercel Edge + Supabase issues
- 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
Assessment
This issue has not been assessed yet.