database-schema

To generate database migrations using Drizzle ORM and Bun, edit your schema.ts file to define changes, then run bun db:generate to create migration files ensuring application models and database structures stay synchronized.

Code-defined schema evolution manages database structure changes through a version-controlled schema.ts file, enabling repeatable migrations and safer deployments across PostgreSQL or SQLite backends using Drizzle ORM.

Yes, you can apply Drizzle ORM migrations to different backends by running bun db:migrate for standard PostgreSQL or SQLite deployments, and db:migrate:pglite specifically for PGLite environments.

You can inspect database state after running Drizzle ORM migrations by using the db:studio command, which provides a visual interface to verify that your database structure matches your defined application models.

Code-defined schema changes ensure parity between application models and the database by versioning edits in schema.ts, generating repeatable migrations, and preventing structural drift during deployments across PostgreSQL and SQLite environments.