1# sqlite
2
3`sqlite://path/to/database?query`
4
5Unlike other migrate database drivers, the sqlite 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.)
6
7The auxiliary query parameters listed below may be supplied to tailor migrate behavior. All auxiliary query parameters are optional.
8
9| URL Query | WithInstance Config | Description |
10|------------|---------------------|-------------|
11| `x-migrations-table` | `MigrationsTable` | Name of the migrations table. Defaults to `schema_migrations`. |
12| `x-no-tx-wrap` | `NoTxWrap` | Disable implicit transactions when `true`. Migrations may, and should, contain explicit `BEGIN` and `COMMIT` statements. |
13
14## Notes
15
16* Uses the `modernc.org/sqlite` sqlite db driver (pure Go)
17 * Has [limited `GOOS` and `GOARCH` support](https://pkg.go.dev/modernc.org/sqlite?utm_source=godoc#hdr-Supported_platforms_and_architectures)
View as plain text