SQLite 3.40 Released With WASM Support For Web Browsers, Recovery Extension

Written by Michael Larabel in Programming on 16 November 2022 at 02:00 PM EST. 26 Comments
While Microsoft is celebrating the GA release today of SQL Server 2022, open-source developers have SQLite 3.40 premiering today as the newest version of this embed-friendly SQL database implementation widely used by many cross-platform applications and other software for lightweight SQL database engine needs.

One of the notable changes with SQLite 3.40 is now having the ability to compile to WebAssembly (WASM). SQLite WASM'ed is intended for use within web browsers while it should also work for the various WASM desktop run-time implementations too. For SQLite 3.40 the WASM implementation is considered of beta state and expected to be production ready in SQLite 3.41.

The other big change with SQLite 3.40 is introducing a recovery extension. While SQLite database files are known to be very robust, in the rare chance they become corrupted there is at least now this means of attempting to recover as much data as possible.

The SQLite recovery extension exposes an API for trying to salvage as much of the corrupted database file as possible. With the SQLite command-line interface is also now the ".recover" command for attempting to recover an SQLite database file from the CLI while the Recovery API allows for nice application-level integration.

SQLite 3.40 also delivers on query planner enhancements, small performance optimizations leading to around 1% fewer CPU cycles, and various other additions.

Downloads and more details on the SQLite 3.40 release 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