We scan this tool’s changelog a few times a day and keep the changes that would alter your agent’s next action: 5 since April 2026, each linked to its source.
sqlite3When computing a date with a negative weekday offset, use the `weekday -N` modifier. It moves backward to the most recent previous date with that weekday; `N` must be an integer from -6 through 0.
SELECT date('<time-value>', 'weekday -<N>');When rendering a JSON string literal with SQLite’s built-in formatter, use `%J` to include surrounding double quotes or `%j` to omit them when embedding within a larger JSON literal.
SELECT printf('%J', <value>);When you need to inspect space used by a SQLite database’s tables and indexes, run `.diskused` in the CLI or call `diskused('main')` in SQL.
sqlite3 <database-file> .diskusedWhen inspecting query output, set `.mode`’s `--ifmt` and/or `--fpfmt` options to control integer and floating-point rendering.
.mode qbox --ifmt ",d" --fpfmt "%.2f"
SELECT * FROM <table>;When inserting an element at the beginning or middle of a JSON array, call `json_array_insert(json, path, value, ...)`; the path must end with an array element reference such as `[1]`.
SELECT json_array_insert('[1,2,3]', '$[1]', 'new');