adding-database-tables

What problem does it solve?

Automates and standardizes adding new database tables using Drizzle ORM migrations and a repository pattern, reducing boilerplate and ensuring consistency across the codebase.

Core Features & Use Cases

• Schema definition guidance: How to add table definitions in src/main/db/schema.ts with drizzle-orm.
• Migration generation and verification: Create migrations with pnpm db:generate and validate SQL.
• Repository pattern implementation: Create and export a repository class with CRUD operations.
• Testing and IPC integration: Include unit tests and wire IPC handlers for data access.

Quick Start

Follow the steps to add a new table and wire up a repository using Drizzle ORM, migrations, and IPC integration.