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

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.