SQLite 3.18 Released With PRAGMA Optimize, Other Enhancements

Written by Michael Larabel in Free Software on 31 March 2017 at 07:14 AM EDT. 1 Comment
FREE SOFTWARE
SQLite 3.18 is now available as the newest feature release to this open-source embedded database library.

A prominent addition to SQLite 3.18 is the PRAGMA optimize command. This will attempt to optimize the database and should be called prior to closing the connection to the database. In the future, they plan to add other automated maintenance tasks with this optimize command.

SQLite 3.18 also now changes its source ID to using a SHA3-256 hash rather than a SHA1 hash, json_patch() was added to the JSON1 extension, enhancements to the LIKE optimization, and a variety of other fixes and enhancements.

More details on SQLite 3.18 via the release announcement at SQlite.org.
Related News
About The Author
Michael Larabel

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter, LinkedIn, or contacted via MichaelLarabel.com.

Popular News This Week