SQLite 3.18 Released With PRAGMA Optimize, Other Enhancements
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.
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.
1 Comment