Small. Fast. Reliable.
Choose any three.
- Add the FTS5 secure-delete command. This option causes all forensic traces
to be removed from the FTS5 inverted index when content is deleted. - Enhance the JSON SQL functions to support JSON5 extensions.
- The SQLITE_CONFIG_LOG and SQLITE_CONFIG_PCACHE_HDRSZ calls to sqlite3_config()
are now allowed to occur after sqlite3_initialize(). - New sqlite3_db_config() options: SQLITE_DBCONFIG_STMT_SCANSTATUS and
SQLITE_DBCONFIG_REVERSE_SCANORDER. - Query planner improvements:
- Enable the “count-of-view” optimization by default.
- Avoid computing unused columns in subqueries.
- Improvements to the push-down optimization.
- Enhancements to the CLI:
- Add the –unsafe-testing command-line option. Without this option, some
dot-commands (ex: “.testctrl”) are now disabled because those commands
that are intended for testing only and can cause malfunctions misused. - Allow commands “.log on” and “.log off”, even in –safe mode.
- “–” as a command-line argument means all subsequent arguments that
start with “-” are interpreted as normal non-option argument. - Magic para
- Add the –unsafe-testing command-line option. Without this option, some
