SQLite 3.26 Adds Defensive Option & Optimizations

Written by Michael Larabel in Free Software on 2 December 2018 at 07:27 AM EST. 3 Comments
FREE SOFTWARE
SQLite developers started off December by releasing a new feature update to their widely-used, embed-friendly SQL database library.

The SQLite 3.26 release features an optimization around updates on tables with indexes on expressions, a new SQLITE_DBCONFIG_DEFENSIVE option to disable the ability to create corrupt database files with basic SQL, support for read-only shadow tables in the new defensive mode, a table_xinfo PRAGMA that can show hidden columns on virtual tables, enhanced triggers, improvements to the SQLite Geopoly extension, additions to the SQLite Session extension, and various other changes.

For all of the details on the changes to find with SQLite 3.26, visit the project's documentation 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