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_DEFENSIVEto disallow changing schema_version
  • improved PRAGMA integrity_check sentence
  • Enhance the VACUUM INTO statement to obey the synchronization setting of PRAGMA
  • improved sqlite3_strglob() and sqlite3_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

Leave a Comment

Your email address will not be published. Required fields are marked *