Rusqlite Migration is a simple schema migration library for rusqlite using user_version instead of an SQL table to maintain the current schema version.
It aims for:
- simplicity: define a set of SQL statements. Just add more SQL statement to change the schema. No external CLI, no macro.
performance: no need to add a table to be parsed, the
user_versionfield is at a fixed offset in the sqlite file format.
It works especially well with other small libraries complementing rusqlite, like serde_rusqlite.
Here, we define SQL statements to run with Migrations::new and run these (if necessary) with .to_latest().
Please see the examples folder for more, in particular:
- migrations with multiple SQL statements (using for instance
- use of lazy_static
- migrations to previous versions (downward migrations)
I’ve also made a cheatsheet of SQLite pragma for improved performance and consistency.
To test that the migrations are working, you can add this in your test module:
Contributions (documentation or code improvements in particular) are welcome, see contributing!
I would like to thank all the contributors, as well as the authors of the dependencies this crate uses.