sqlite3://path/to/database?query
Unlike other migrate database drivers, the sqlite3 driver will automatically wrap each migration in an implicit transaction by default. Migrations must not contain explicit BEGIN
or COMMIT
statements. This behavior may change in a future major release. (See below for a workaround.)
Refer to upstream documentation for a complete list of query parameters supported by the sqlite3 database driver. The auxiliary query parameters listed below may be supplied to tailor migrate behavior. All auxiliary query parameters are optional.
URL Query | WithInstance Config | Description |
---|---|---|
x-migrations-table |
MigrationsTable |
Name of the migrations table. Defaults to schema_migrations . |
x-no-tx-wrap |
NoTxWrap |
Disable implicit transactions when true . Migrations may, and should, contain explicit BEGIN and COMMIT statements. |
- Uses the
github.com/mattn/go-sqlite3
sqlite db driver (cgo)