See Demo
General
Database

Overview

Learn how to interact with the database in the starter kit.

The database serves as the backbone 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.

Client

Learn how to use basic database operations with the Drizzle database client.

Schema

Learn how to update your database schema and migrate changes with Drizzle.

Migrations

Learn how to manage database migrations with Drizzle.

Studio

Learn how to use Drizzle Studio to view and interact with your database.

Database driver

The project uses PostgreSQL as the default database provider, ensuring seamless integration. Drizzle also supports MySQL, SQLite, and other relational databases.

If you want to use a different database than PostgreSQL, you will need to configure the database provider in the database client configuration.

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:

Terminal
npm run db:studio

Make sure .env has a correct DATABASE_URL defined.