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/drizzle.config.ts | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 pkgs/server/drizzle.config.ts (limited to 'pkgs/server/drizzle.config.ts') diff --git a/pkgs/server/drizzle.config.ts b/pkgs/server/drizzle.config.ts new file mode 100644 index 0000000..0e4596b --- /dev/null +++ b/pkgs/server/drizzle.config.ts @@ -0,0 +1,15 @@ +import { defineConfig } from "drizzle-kit"; + +const databaseUrl = process.env.DATABASE_URL; +if (!databaseUrl) { + throw new Error("DATABASE_URL environment variable is not set"); +} + +export default defineConfig({ + out: "./drizzle", + schema: "./src/db/schema.ts", + dialect: "postgresql", + dbCredentials: { + url: databaseUrl, + }, +}); -- cgit v1.2.3-70-g09d2