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.

1 files changed, 6 insertions, 4 deletions

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',
 });