issue connecting neon with drizzle
Have the following in my index.ts file:
const sql = neon(process.env.DATABASE_URL!);
const db = drizzle({ client: sql });
Yet, seeing this error when I run the file:
➜ /workspaces/codespaces-blank/my-site(db_setup) $ npx tsx src/lib/server/db/index.ts
Database URL:some-text-that-I-will-not-post-here
/workspaces/codespaces-blank/my-site/node_modules/src/neon-serverless/session.ts:60
return client.query(rawQuery, params);
^
TypeError: client.query is not a function
at NeonPreparedQuery.execute (/workspaces/codespaces-blank/my-site/node_modules/src/neon-serverless/session.ts:60:18)
at <anonymous> (/workspaces/codespaces-blank/my-site/node_modules/src/pg-core/query-builders/insert.ts:332:27)
at Object.startActiveSpan (/workspaces/codespaces-blank/my-site/node_modules/src/tracing.ts:27:11)
at QueryPromise.execute (/workspaces/codespaces-blank/my-site/node_modules/src/pg-core/query-builders/insert.ts:331:17)
at QueryPromise.then (/workspaces/codespaces-blank/my-site/node_modules/src/query-promise.ts:31:15)
Node.js v20.17.0
Tried:
"const db = drizzle(sql);" instead of drizzle({ client: sql }). It was also not working.
Here is that error:
TypeError: client.query is not a function
at NeonPreparedQuery.execute (/workspaces/codespaces-blank/my-site/node_modules/src/neon-serverless/session.ts:60:18)
at <anonymous> (/workspaces/codespaces-blank/my-site/node_modules/src/pg-core/query-builders/insert.ts:332:27)
at Object.startActiveSpan (/workspaces/codespaces-blank/my-site/node_modules/src/tracing.ts:27:11)
at QueryPromise.execute (/workspaces/codespaces-blank/my-site/node_modules/src/pg-core/query-builders/insert.ts:331:17)
at QueryPromise.then (/workspaces/codespaces-blank/my-site/node_modules/src/query-promise.ts:31:15)
const sql = neon(process.env.DATABASE_URL!);
const db = drizzle({ client: sql });
Yet, seeing this error when I run the file:
➜ /workspaces/codespaces-blank/my-site(db_setup) $ npx tsx src/lib/server/db/index.ts
Database URL:some-text-that-I-will-not-post-here
/workspaces/codespaces-blank/my-site/node_modules/src/neon-serverless/session.ts:60
return client.query(rawQuery, params);
^
TypeError: client.query is not a function
at NeonPreparedQuery.execute (/workspaces/codespaces-blank/my-site/node_modules/src/neon-serverless/session.ts:60:18)
at <anonymous> (/workspaces/codespaces-blank/my-site/node_modules/src/pg-core/query-builders/insert.ts:332:27)
at Object.startActiveSpan (/workspaces/codespaces-blank/my-site/node_modules/src/tracing.ts:27:11)
at QueryPromise.execute (/workspaces/codespaces-blank/my-site/node_modules/src/pg-core/query-builders/insert.ts:331:17)
at QueryPromise.then (/workspaces/codespaces-blank/my-site/node_modules/src/query-promise.ts:31:15)
Node.js v20.17.0
Tried:
"const db = drizzle(sql);" instead of drizzle({ client: sql }). It was also not working.
Here is that error:
TypeError: client.query is not a function
at NeonPreparedQuery.execute (/workspaces/codespaces-blank/my-site/node_modules/src/neon-serverless/session.ts:60:18)
at <anonymous> (/workspaces/codespaces-blank/my-site/node_modules/src/pg-core/query-builders/insert.ts:332:27)
at Object.startActiveSpan (/workspaces/codespaces-blank/my-site/node_modules/src/tracing.ts:27:11)
at QueryPromise.execute (/workspaces/codespaces-blank/my-site/node_modules/src/pg-core/query-builders/insert.ts:331:17)
at QueryPromise.then (/workspaces/codespaces-blank/my-site/node_modules/src/query-promise.ts:31:15)
