SQLite

 cljoly/rusqlite-snapshot-testing ...

Release notes for the rusqlite_migration library. Version 2.6.0 Dependencies Rusqlite was updated from 0.39.0 to 0.40.0. Please see the release notes for 0.40.0. There are in paricular quite a few breaking changes around VTab APIs. Update other dev dependencies, see git history for details. Also factored out the rusqlite package dependency details into the workspace-level Cargo.toml. Version 2.5.0 Dependencies Rusqlite was updated from 0.38.0 to 0.39.0. Please see the release notes for 0.39.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. ...