Drizzle ORM TypeSafe Database Access

Lightweight, headless TypeScript ORM with zero dependencies. Drizzle excels at:

• Type inference — Full TypeScript types from schema; no generated types or separate schema language
• Relational queries — Fetch nested data with .with() without manual joins
• Prepared statements — Pre-compile queries for repeated execution; significant performance boost
• Migrations — Version-controlled schema changes with drizzle-kit; rollback support
• Transactions — Atomic multi-operation commits with savepoints for nested transactions

Core patterns: one table per file, relational API for nested queries, prepared statements for hot paths, transactions for consistency.

Workflow

When working with Drizzle ORM:

1. Design schema — Tables, columns, constraints; one file per table
2. Define relations — defineRelations() for one-to-many, many-to-many; enables nested queries
3. Choose query style — Relational API for nested data (prefer), SQL builder for flexibility
4. Optimize hot paths — Use prepared statements with placeholders for repeated queries