After experimenting with various ORM solutions in our Turborepo setup, Drizzle has emerged as a clear winner. Its TypeScript-first approach and minimal runtime overhead make it particularly well-suited for monorepo architectures.
The key to our setup is maintaining a shared database schema package that other apps and packages can import. This ensures type consistency across the entire monorepo while allowing each service to maintain its own database connection and migration history. The schema package also serves as a single source of truth for our data models.
One particularly elegant aspect of this setup is how well it works with Turborepo's caching. Schema changes automatically invalidate dependent builds, ensuring type safety across the entire project. Combined with Drizzle's migration system, we've achieved a robust and developer-friendly database workflow.