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. . PostgreSQL 15.1 includes the enhanced partitioning feature, optimizing data retrieval and providing advanced indexing for better query speed.. SQLite Update, Secure Delete Feature, Data Storage Solutions, JSON Functions. . LinuxSecurity.com Team
Get the latest Linux and open source security news straight to your inbox.