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.
- Security Enhancements: Enhanced
SQLITE_DBCONFIG_DEFENSIVEto disallow changing schema_version
- Enhance the VACUUM INTO statement to obey the synchronization setting of PRAGMA
sqlite3_strlike()APIs that allow them to accept NULL pointers for string parameters and still produce a reasonable result.
- provide new
SQLITE_MAX_ALLOCATION_SIZEA 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