From 328710be69d218007477fc46f6642a71ac0e385f Mon Sep 17 00:00:00 2001 From: nsfisis Date: Wed, 3 Dec 2025 05:06:00 +0900 Subject: feat(db): add Drizzle ORM setup MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Add Drizzle ORM with PostgreSQL for database access. Includes: - Schema definitions for users, decks, cards, and review_logs tables - Database connection with node-postgres driver - Drizzle Kit configuration for migrations - npm scripts for db:generate, db:migrate, db:push, db:studio 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude --- pkgs/server/src/db/index.ts | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 pkgs/server/src/db/index.ts (limited to 'pkgs/server/src/db/index.ts') diff --git a/pkgs/server/src/db/index.ts b/pkgs/server/src/db/index.ts new file mode 100644 index 0000000..6730947 --- /dev/null +++ b/pkgs/server/src/db/index.ts @@ -0,0 +1,12 @@ +import { drizzle } from "drizzle-orm/node-postgres"; +import * as schema from "./schema"; + +const databaseUrl = process.env.DATABASE_URL; + +if (!databaseUrl) { + throw new Error("DATABASE_URL environment variable is not set"); +} + +export const db = drizzle(databaseUrl, { schema }); + +export * from "./schema"; -- cgit v1.2.3-70-g09d2