Drizzle ORM v1 BETA with SQLite for database schema, relations, and queries. Activate when working with database operations, schema definitions, or migrations.
We are using the BETA version of Drizzle v1 with SQLite. You can check the .env file to see where the local database is stored. You may make READ-only queries to the database if you need more information from the database.
NEVER run any drizzle-kit cli commands. Instead ask the user to execute them. This includes pushing to the database or generating a migration.
If the tests fail due to a database issue, its likely because we used db push for local development and did not generate the migration which the tests rely on. You may let the user know that you suspect the tests are failing due to a missing migration and let them resolve it. DO NOT migrate yourself.
Since the BETA version is completely new and not in your training data, please thoroughly read the docs: https://rqbv2.drizzle-orm-fe.pages.dev/docs/overview
More specifically:
src/db/schema/ - Drizzle schemas (auth schema auto-generated)src/db/schema/utils/base.ts - Common fields (id, createdAt, updatedAt)src/db/relations/ - Drizzle relations, currently just a single filesrc/db/index.ts - Drizzle instance