eng-add-drift-table-or-migration

To add a new table to a Drift SQLite database, you write a versioned migration with step-by-step instructions to define the schema and run integrity checks to ensure consistency. This process handles table creation safely within a transaction.

Managing SQLite schema changes with Drift migrations involves writing versioned, step-by-step migrations that handle adding tables, columns, indices, and CHECK constraints. This structured approach ensures database integrity and consistency across schema evolutions.

Yes, you need both the drift and sqlite3 dependencies to manipulate the local database schema. These dependencies provide the necessary frameworks to execute schema changes and manage migrations effectively.

Drift ensures transactional integrity and crash-safety during database migrations by utilizing Write-Ahead Logging (WAL) and setting synchronous=FULL. This guarantees that schema changes are applied safely without corrupting the database.

Yes, you can add CHECK constraints when modifying an existing SQLite table column through a versioned Drift migration. The process guides you through altering the schema and verifying migration integrity step-by-step.