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 is officially released, the updates are as follows:
- Added support for compiling SQLite to WASM and running it in a web browser
- Added recovery extension, may be able to recover some content from corrupted database files
- Query Planner Enhancements
- A new type definition called sqlite3_filename has been added to represent the name of a database file.
- increased
sqlite3_value_encoding()
interface. - Security Enhancements: Enhanced
SQLITE_DBCONFIG_DEFENSIVE
to disallow changing schema_version - improved
PRAGMA integrity_check
sentence - Enhance the VACUUM INTO statement to obey the synchronization setting of PRAGMA
- improved
sqlite3_strglob()
andsqlite3_strlike()
APIs that allow them to accept NULL pointers for string parameters and still produce a reasonable result. - provide new
SQLITE_MAX_ALLOCATION_SIZE
A compile-time option to limit the size of memory allocations. - Change the algorithm used by SQLite’s built-in pseudo-random number generator (PRNG) from RC4 to Chacha20.
- Two or more indexes are allowed to have the same name, as long as they are all in different schemas
- Additional performance optimizations reduce CPU cycles used in typical workloads by ~1%
For more details, please check: https://www.sqlite.org/releaselog/3_40_0.html
#SQLite #released #News Fast Delivery