SQLite 3.22 Brings Zipfile Module For Interacting With Zip Archives

Written by Michael Larabel in Free Software on 23 January 2018 at 05:54 AM EST. 5 Comments
FREE SOFTWARE
SQLite 3.22 is now available as the latest version of this widely-used, embedded database library.

A bit peculiar about SQLite 3.22.0 is the new Zipfile extension. The Zipfile support allows for reading and writing to ZIP Archives. SELECT'ing from a Zipfile returns all of the contained files/paths and other file metadata, creating a virtual table makes a new Zipfile, and adding files/directories to a Zipfile is done using the INSERT syntax. And, yes, using SQLite UPDATE and DELETE syntax you can edit or remove files from a zip archive. Basically, the Zip file is treated as the database with this virtual table / extension. More details on it via the documentation.

SQLite 3.22.0 also adds a few interfaces, an sqlite_btreeinfo virtual table, Append VFS, query planner enhancements, some minor performance optimizations, and various improvements to the command-line shell.

The complete list of changes for SQLite 3.22 can be found 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