A minor update SQLite Release 3.14.1 has been released as a fix to the previously released SQLite tool. This update is known as the PI release (3.14).
SQLite software library is designed as a drop-in replacement, server-less transactional database engine. The SQL database engine is self-contained and requires zero configurations. The library is open source and cross-platform and sits in the public domain.
What’s new in SQLite Release 3.14.1
SQLite Release 3.14.1 fixes the page-cache “truncate” and results in a performance enhancement. Changes in version 3.14 include a few bug fixes such as the ALTER TABLE bug where descending indexes where being corrupted when adding a column in the legacy file format.
There was also a NULL pointer dereference crash when a WHERE clause references a non-existent collating sequence. A performance regression in the ORDER BY LIMIT has also been fixed.
There are also several new features within the json1_extension. There is a new database hash utility now in the release. There is an improved algorithm for running queries with both an ORDER BY and a LIMIT.
The CSV virtual table for reading RFC 4180 formatted comma-separated value files has been added in this release.
There is also an improvement within the query planner. This helps the OR optimization on virtual tables even if one or more of the disjuncts use the LIKE, GLOB, REGEXP, MATCH operators.
To see the whole list of changes you can visit the release log page here.
Found this article interesting? Follow Brightwhiz on Facebook, Twitter, and YouTube to read and watch more content we post.