problem:
file:///Users/tjen/dev/svelte-demo/node_modules/drizzle-orm/neon-http/session.js:32
const result = await client(query.sql, params, queryConfig);
^
TypeError: client is not a function
at NeonHttpPreparedQuery.execute (file:///Users/tjen/dev/touchelephant/virtualgate/svelte-demo/node_modules/drizzle-orm/neon-http/session.js:32:26)
at file:///Users/tjen/dev/touchelephant/virtualgate/svelte-demo/node_modules/drizzle-orm/pg-core/query-builders/select.js:690:30
at Object.startActiveSpan (file:///Users/tjen/dev/touchelephant/virtualgate/svelte-demo/node_modules/drizzle-orm/tracing.js:8:14)
at PgSelectBase.execute (file:///Users/tjen/dev/svelte-demo/node_modules/drizzle-orm/pg-core/query-builders/select.js:689:19)
at Module.findAllPeople (/Users/tjen/dev/touchelephant/virtualgate/svelte-demo/src/lib/server/db/index.ts:17:57)
at load (/Users/tjen/dev/touchelephant/virtualgate/svelte-demo/src/routes/database/+page.server.ts:7:34)
at Module.load_server_data (/Users/tjen/dev/touchelephant/virtualgate/svelte-demo/node_modules/@sveltejs/kit/src/runtime/server/page/load_data.js:49:42)
at eval (/Users/tjen/dev/touchelephant/virtualgate/svelte-demo/node_modules/@sveltejs/kit/src/runtime/server/page/index.js:167:41)
Node.js v22.12.0
Solution:
add const sql = neon(DATABASE_URL);
import { DATABASE_URL } from '$env/static/private';
const sql = neon(DATABASE_URL);
export const db = drizzle(sql);
wrong:
import { DATABASE_URL } from '$env/static/public';
wrong:
export const db = drizzle(DATABASE_URL);