13.Lock StylizedMotherboard

SQLite 3.42 is now available as the newest update to this widely-used, embed-friendly SQL database option that is used by countless applications and other software for lightweight and speedy data storage purposes.

Most notable with SQLite 3.42 is the introduction of the FTS5 secure-delete command. When this option is used, all forensic traces are then removed from the FTS5 inverted index when content is deleted rather than potentially leaving latent information around post-deletion.  

SQLite 3.42 also improves its JSON SQL functions to support JSON5 extensions, new database configuration options added, query planner improvements, more keyword support for application-defined SQL functions, and various other fixes and performance optimizations.

The link for this article located at Phoronix is no longer available.