SQLite 3.20 Released With New Extensions, Command Line Shell Improvements
Written by Michael Larabel in Free Software on 6 August 2017 at 02:02 PM EDT. Add A Comment
SQLite 3.20 was released earlier this week with many improvements to this widely-used, embedded database library.

New extensions with SQLite 3.20 include the SQLITE_STMT virtual table, COMPLETION to provide suggested tab-completions via the interactive interface, and UNION virtual table.

Improvements to the command-line shell include support for the aforementioned COMPLETION extension, the ".cd" command, improvements to .schema/.tables/.import, and more.

SQLite 3.20 also has improvements to the query planner, new pointer passing interfaces, improved date and time functions, PRAGMA secure_delete=FAST command, and much more. SQLite 3.20 has also seen some optimizations that should allow it to see around 2% less CPU cycles.

SQLite 3.20 is one of the biggest SQLite releases in recent times. To learn more about all of the changes in SQLite 3.20, visit SQLite.org.
Related News
About The Author
Author picture

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 or contacted via MichaelLarabel.com.

Popular News This Week