From 63847496f14c813a5d80efd5b7de0f1294ffe1e3 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 16:07:11 +0200 Subject: Adding upstream version 3.45.1. Signed-off-by: Daniel Baumann --- www/releaselog/3_40_0.html | 181 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 181 insertions(+) create mode 100644 www/releaselog/3_40_0.html (limited to 'www/releaselog/3_40_0.html') diff --git a/www/releaselog/3_40_0.html b/www/releaselog/3_40_0.html new file mode 100644 index 0000000..a529bf3 --- /dev/null +++ b/www/releaselog/3_40_0.html @@ -0,0 +1,181 @@ + + + + + +SQLite Release 3.40.0 On 2022-11-16 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.40.0 On 2022-11-16

    +
  1. Add support for compiling SQLite to WASM + and running it in web browsers. NB: The WASM build and its interfaces + are considered "beta" and are subject to minor changes if the need + arises. We anticipate finalizing the interface for the next release. +
  2. Add the recovery extension that might be able to recover some content + from a corrupt database file. +
  3. Query planner enhancements: +
      +
    1. Recognize covering indexes on tables with more than 63 columns where + columns beyond the 63rd column are used in the query and/or are + referenced by the index. +
    2. Extract the values of expressions contained within expression indexes + where practical, rather than recomputing the expression. +
    3. The NOT NULL and IS NULL operators (and their equivalents) avoid + loading the content of large strings and BLOB values from disk. +
    4. Avoid materializing a view on which a full scan is performed + exactly once. Use and discard the rows of the view as they are computed. +
    5. Allow flattening of a subquery that is the right-hand operand of + a LEFT JOIN in an aggregate query. +
    +
  4. A new typedef named sqlite3_filename is added and used to represent + the name of a database file. Various interfaces are + modified to use the new typedef instead of "char*". This interface + change should be fully backwards compatible, though it might cause + (harmless) compiler warnings when rebuilding some legacy applications. +
  5. Add the sqlite3_value_encoding() interface. +
  6. Security enhancement: SQLITE_DBCONFIG_DEFENSIVE is augmented to prohibit + changing the schema_version. The schema_version + becomes read-only in defensive mode. +
  7. Enhancements to the PRAGMA integrity_check statement: +
      +
    1. Columns in non-STRICT tables with TEXT affinity should not contain numeric values. +
    2. Columns in non-STRICT tables with NUMERIC affinity should not + contain TEXT values that could be converted into numbers. +
    3. Verify that the rows of a WITHOUT ROWID table are in the correct order. +
    +
  8. Enhance the VACUUM INTO statement so that it honors the + PRAGMA synchronous setting. +
  9. Enhance the sqlite3_strglob() and sqlite3_strlike() APIs so that they are able + to accept NULL pointers for their string parameters and still generate a sensible + result. +
  10. Provide the new SQLITE_MAX_ALLOCATION_SIZE compile-time option for limiting + the size of memory allocations. +
  11. Change the algorithm used by SQLite's built-in pseudo-random number generator (PRNG) + from RC4 to Chacha20. +
  12. Allow two or more indexes to have the same name as long as they are all in + separate schemas. +
  13. Miscellaneous performance optimizations result in about 1% fewer CPU cycles + used on typical workloads. +

    Hashes: +

  14. SQLITE_SOURCE_ID: 2022-11-16 12:10:08 89c459e766ea7e9165d0beeb124708b955a4950d0f4792f457465d71b158d318 +
  15. SHA3-256 for sqlite3.c: ab8da6bc754642989e67d581f26683dc705b068cea671970f0a7d32cfacbad19 + +

+ +

A complete list of SQLite releases + in a single page and a chronology are both also available. + A detailed history of every + check-in is available at + + SQLite version control site.

+ + -- cgit v1.2.3