Rusqlite Snapshot Testing

 cljoly/rusqlite-snapshot-testing ...

Rusqlite Changelog

Release notes for the rusqlite_migration library. Version 2.7.0 Dependencies Rusqlite was updated from 0.40.0 to 0.41.0. Please see the release notes for 0.41.0. Updated other dev dependencies, see git history for details. Minimum Rust Version rusqlite lowered the MSRV to 1.89.01 (from 1.95.0), this crate follows suit. 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 particular quite a few breaking changes around VTab APIs. ...

Rusqlite Migration

 cljoly/rusqlite_migration ...

SQLite Pragma Cheatsheet for Performance and Consistency

⚡ 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. ...

May 7, 2021 · 6 min