Build a Finance SaaS Platform -5 (Database Neon)

Sign up Neon

Go to https://neon.tech/ ，Sign up，and get sql connetion string and add it to .env:

DATABASE_URL=postgresql://xxxx

Install drizzle-orm

npm i drizzle-orm @neondatabase/serverless
npm i -D drizzle-kit

Add Drizzle config

Add db/drizzle.ts

import { neon } from '@neondatabase/serverless';
import { drizzle } from 'drizzle-orm/neon-http';

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

Add Schema

Add db/schema.ts

import { pgTable, PgTable, text} from "drizzle-orm/pg-core"

export const accounts = pgTable("accounts", {
  id: text("id").primaryKey(),
  name: text("name").notNull(),
  userId: text("user_id").notNull(),
})

Instal dotenv

npm i -D dotenv

Add migrate file

Add scripts/migrate.ts

import { config } from "dotenv";
import { neon } from "@neondatabase/serverless";
import { drizzle }  from "drizzle-orm/neon-http";
import { migrate } from "drizzle-orm/neon-http/migrator";

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

const sql = neon(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();

Install tsx

npm i tsx

Edit package.json

{
  "name": "finance-demo",
  "version": "0.1.0",
  "private": true,
  "scripts": {
    "dev": "next dev",
    "build": "next build",
    "start": "next start",
    "lint": "next lint",
    "db:generate": "drizzle-kit generate --dialect=postgresql --schema=./db/schema.ts --out=./drizzle",
    "db:migrate": "tsx ./scripts/migrate.ts",
    "db:studio": "drizzle-kit studio"
  },
  ...

Run Script:

npm run db:generate