SQLite 3.33 Released With PostgreSQL-Inspired UPDATE FROM, Database Files Up To 281 TB

Written by Michael Larabel in Programming on 16 August 2020 at 10:11 AM EDT. 1 Comment
SQLite 3.33 is out as the latest update to this widely-used, embed-friendly database library used by countless applications and other software.

With SQLite 3.33 the maximum size of database files has been increased to now allow up to 281 TB files.

Another significant addition with SQLite 3.33 is support for the UPDATE FROM syntax, based on the PostgreSQL implementation. UPDATE FROM is for performing an UPDATE statement using data driven by other tables. More details on SQLite's UPDATE FROM implementation via the documentation.

SQLite 3.33 also adds a decimal extension for performing arbitrary-precision decimal arithmetic. This is for numbers stored as text strings while the exposed math functions are decimal_add(), decimal_sub(), and decimal_mul(). No division is yet available.

Rounding out SQLite 3.33 are also various command line interface improvements, enhancements to the query planner, and other changes. More details on this significant SQLite 3.33 release 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