ADR-004: Single Database for Dev and Test Environments

Jul 5 2025 · 1min · adrs

Status:

Accepted

Context:

Need reliable testing strategy without schema drift between development and test databases. Traditional separate test databases create Drizzle ORM schema synchronization complexity and maintenance overhead.

Decision:

Use same database (fjord_dev) for both development and testing with unique test data generation via generateTestId() function.

Consequences:

✅ Eliminates schema drift between environments ✅ Simplifies CI/CD and local development setup ✅ Drizzle migration complexity avoided ✅ Tests use real database constraints for accurate validation ✅ Unique test IDs prevent data collisions naturally ❌ Test data accumulates in development database ❌ Deviates from traditional testing practices