SQLite is a C language library that implements a small, fast, independent, highly reliable, full-featured SQL database engine. SQLite is the most used database engine in the world. The source code for SQLite is in the public domain and freely available to everyone for any purpose.

SQLite 3.40.1 is now officially released, with the following updates:

1. Add support for compiling SQLite to WASM and running it in a web browser. Note: The WASM build and its interfaces are considered “beta” and may be subject to minor changes if needed; the interfaces are expected to be finalized in the next release.
2. Add a recovery extension that might be able to recover something from a corrupted database file.
3. Query planner enhancements:
   1. A covering index that identifies tables with more than 63 columns that are used in queries and/or are referenced by the index.
   2. Extracts the value of an expression contained in an expression index when feasible, rather than reevaluating the expression.
   3. The NOT NULL and IS NULL operators (and their equivalents) avoid loading the contents of large string and BLOB values ​​from disk.
   4. Avoid materializing views that perform only one full scan.
   5. Allows flattening as a subquery for the right-hand operand of a LEFT JOIN in an aggregation query.
4. A new type definition called sqlite3_filename has been added to denote the name of a database file. Various interfaces were modified to use new typedefs instead of ‘char*’. This interface change should be fully backward compatible, although it may cause (harmless) compiler warnings when rebuilding some legacy applications.
5. Add sqlite3_value_encoding() interface.
6. Security Enhancement: Enhanced SQLITE_DBCONFIG_DEFENSIVE to disallow changing schema_version. schema_version in defensive mode More details can be found at:becomes read-only.
7. Enhancements to the PRAGMA integrity_check statement:
   1. Columns in non-STRICT tables with TEXT associations should not contain numeric values.
   2. Columns in non-STRICT tables with NUMERIC affinity should not contain TEXT values ​​that can be converted to numbers.
   3. Verify that the rows of the WITHOUT ROWID table are in the correct order.
8. The VACUUM INTO statement is enhanced to support the PRAGMA synchronization setting.
9. Enhance the sqlite3_strglob() and sqlite3_strlike() APIs so that they can accept NULL pointers for their string arguments and still produce reasonable results.
10. A new SQLITE_MAX_ALLOCATION_SIZE compile-time option is provided to limit the size of memory allocations.
11. Changes the algorithm used by SQLite’s built-in pseudo-random number generator (PRNG) from RC4 to Chacha20.
12. Two or more indexes are allowed to have the same name, as long as they are all in different schemas.
13. Additional performance optimizations result in ~1% reduction in CPU cycles used on typical workloads.
14. Fix the CLI’s –safe command-line option to correctly disallow the use of SQL functions that could cause unwanted side effects, such as writefile().
15. Fix potential infinite loop in memsys5 alternate memory allocator. This bug was introduced by a performance optimization in version 3.39.0.
16. Various other fixes.

​​​​​​​​​​​​​​​​​​​​​​​​​​More details can be viewed at:https://www.sqlite.org/releaselog/3_40_1.html