SQLite 3.31 Released With Support For Generated Columns

Written by Michael Larabel in Programming on 26 January 2020 at 12:02 AM EST. 11 Comments
PROGRAMMING
The widely-used SQLite embedded database library saw its first major release of 2020 this week.

This first big release of 2020 is SQLite 3.31. One of the major features of SQLite 3.31 is support for generated/computed columns. With generated columns, the columns of a table are values returned by a function of other columns in the same row. These auto-generated columns are read-only and have other limitations but are open to a variety of interesting use-cases.

SQLite 3.31 also has new options around hard leap limits, a new option to prevent SQLite from opening symbolic links, various new APIs, faster SQLite3 interrupt performance, better look-aside memory allocator performance, and other changes.

More details on SQLite 3.31 and its many changes via 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