Overview
Learn how to interact with the database in the monorepo.
The database serves as the bakbone for storing data, handling queries and making sure users get what they need fast.
Drizzle
The starter kit uses Drizzle as its data access solution.
Why choose Drizzle? Drizzle is a fast and efficient ORM built for relational databases like PostgreSQL and MySQL. It prioritizes type safety, flexibility and performance, making it a strong choice for modern applications.
Client
Schema
Database driver
The project uses PostgreSQL as the default database provider, ensuring seamless integration. Drizzle also supports MySQL, SQLite, and other relational databases.
For a comprehensive list of supported database drivers, visit Drizzle's Documentation.
Drizzle Studio
Drizzle's visual database editor allows you to view and edit your database records. You can open it with:
pnpm --filter drizzle-studio devMake sure packages/database/.env has a correct DATABASE_URL defined.