SQLite

 cljoly/rusqlite-snapshot-testing ...

Release notes for the rusqlite_migration library. Version 2.2.0 ℹ️ Note The code of this version is identical to Version 2.2.0 Beta 1 Features Implement the Display trait for M. This makes it easier to print errors pertaining to a particular migration (this feature is planned for the future, in the context of more extensive migration checks) Dependencies Rusqlite was updated from 0.35.0 to 0.36.0. Please see the release notes for 0.36.0. Other Update development dependencies Improve tests to cover more cases, in particular around downward migrations Add docs.rs link to Cargo metadata Fix clippy warning in rust 1.87.0 Version 2.2.0 Beta 1 Features Implement the Display trait for M. This makes it easier to print errors pertaining to a particular migration (this feature is planned for the future, in the context of more extensive migration checks) Dependencies Rusqlite was updated from 0.35.0 to 0.36.0. Please see the release notes for 0.36.0. ...

 cljoly/rusqlite_migration ...

TL;DR When Opening the DB PRAGMA journal_mode = wal; -- different implementation of the atomicity properties PRAGMA synchronous = normal; -- synchronise less often to the filesystem PRAGMA foreign_keys = on; -- check foreign key reference, slightly worst performance And check user_version to apply any migrations, for instance with this Rust library. When Closing the DB PRAGMA analysis_limit=400; -- make sure pragma optimize does not take too long PRAGMA optimize; -- gather statistics to improve query optimization Introduction SQL pragma are statements (like SELECT … or CREATE TABLE …) that change the database behaviors or call a special functions. This post is a short list of SQLite pragma I use in my projects built on SQLite, to get better performance and more consistency. ...