pitfalls-drizzle-ormlisted

# Drizzle ORM Pitfalls Common pitfalls and correct patterns for Drizzle ORM. ## When to Use - Defining database schemas - Running migrations (db:push) - Creating insert/select types - Working with array columns - Reviewing Drizzle ORM code ## Workflow ### Step 1: Verify Schema Types Check that types are exported correctly. ### Step 2: Check Array Syntax Verify array columns use correct syntax. ### Step 3: Test Migrations Safely Never change primary key types in production. --- ## Critical Rules ```typescript // ❌ NEVER change primary key types // serial → varchar or varchar → uuid BREAKS migrations // ✅ Array columns - correct syntax allowedTokens: text('allowed_tokens').array() // CORRECT // ❌ WRONG: array(text('allowed_tokens')) // ✅ Always create insert/select types export type Strategy = typeof strategies.$inferSelect; export type NewStrategy = typeof strategies.$inferInsert; // ✅ Use drizzle-zod for validation import { createInsertSchema } from 'drizzle-zod'; export const insertStrategySchema = createInsertSchema(strategies); ``` ## Migration Safety ```bash # Safe schema sync npm run db:push # If data-loss warning and you're sure npm run db:push --force # NEVER in production without backup ``` ## Type Inference Pattern ```typescript // ✅ Infer types from schema import { strategies } from './schema'; type Strategy = typeof strategies.$inferSelect; type NewStrategy = typeof strategies.$inferInsert; // ✅ With Zod validation import { createInsertSche