Cheatsheet

Copy-paste History Implicit Register Content " Effectively last used register. Writes to register 0. 0 Last yank. 1 d/c with %,(, ), `, /, ?, n, N, { and } or whole line. - Last small delete (less than a line). Can be the same as 1. 2-9 Last content of 1, 2, etc. 9 is lost. + * System clipboards (X11/Wayland clipboard and primary). Explicit Register Content a-z Named, use freely. Doesn’t fill numbered registers. A-Z Append to that named register. Read-Only Register Content . Last inserted text (similar to . to repeat). % Current file name. # Alternate file name. : Last executed command line. Run with @:. No Read or Write Register Content = Run an expression. _ Black hole.

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