Build a Finance SaaS Platform -16 (Change to Local PG database）

Background

Neon is too slow and sometime can not reach, I decided to change to Local database

BTW, I tried to switch to Mysql but failed, too differences with PG. So, I still use PG.

Don’t use edge

Modify app/api/[[…route]]/route.ts：

...
// export const runtime = 'edge'
...

Change Connenct String

Modify db/drizzle.ts

import { drizzle } from 'drizzle-orm/postgres-js';
import postgres from 'postgres';

export const sql = postgres(process.env.DATABASE_URL!);
export const db = drizzle(sql);

Modify scripts/migrate.ts

import { config } from "dotenv";
import { drizzle } from 'drizzle-orm/postgres-js';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import postgres from 'postgres';

config({ path:".env.local"});

const sql = postgres(process.env.DATABASE_URL!);
const db = drizzle(sql);

const main = async () => {""
  try {
    await migrate(db, { migrationsFolder: "drizzle" });
  } catch (error) {
    console.error("Error during migration:", error );
    process.exit();
  }
};

main();