Database

The Database module manages data persistence using PostgreSQL (via Supabase) and Drizzle ORM.

Overview

• Location: database/ (root) and modules/database (feature-specific).
• Key Directories:
  • database/migrations: SQL migration files generated by Drizzle.
  • database/schemas: Database schema definitions (tables, relations).
  • src/lib/drizzle.ts: Database client instance and connection logic.

Schema Definition

Schemas are defined using Drizzle’s pg-core functions. Example:

Migrations

Run the following commands to manage the database schema:

• pnpm db:generate: Generate SQL migrations from schema changes.
• pnpm db:migrate: Apply migrations to the database.
• pnpm db:studio: Open Drizzle Studio to inspect data.