From 02ae938c238c9d18448d17a8ec92c0edd8c17463 Mon Sep 17 00:00:00 2001 From: Bertrand Yuan Date: Tue, 16 Dec 2025 00:12:49 +0800 Subject: feat(back-end): introduce payload Payload is the next.js Headless CMS and App Framework, I would like to pick it up and modify it as it is MIT licensed. Many features in Payload is not applicable for our project. So, I modify it so that it is light and clear. --- src/server/db/index.ts | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'src/server/db/index.ts') diff --git a/src/server/db/index.ts b/src/server/db/index.ts index 8579424..6a8821e 100644 --- a/src/server/db/index.ts +++ b/src/server/db/index.ts @@ -1,13 +1,15 @@ -import { neon } from '@neondatabase/serverless'; -import { drizzle } from 'drizzle-orm/neon-http'; +import { Pool } from 'pg'; +import { drizzle } from 'drizzle-orm/node-postgres'; import { env } from '@/env'; import * as schema from './schema'; -const sql = neon(env.DATABASE_URL); +const pool = new Pool({ + connectionString: env.DATABASE_URL, +}); export const db = drizzle({ - client: sql, + client: pool, schema, casing: 'snake_case', }); -- cgit v1.2.3