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_3_14.html | 168 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 168 insertions(+) create mode 100644 www/releaselog/3_3_14.html (limited to 'www/releaselog/3_3_14.html') diff --git a/www/releaselog/3_3_14.html b/www/releaselog/3_3_14.html new file mode 100644 index 0000000..0a79dbc --- /dev/null +++ b/www/releaselog/3_3_14.html @@ -0,0 +1,168 @@ + + + + + +SQLite Release 3.3.14 On 2007-04-02 + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ +

SQLite Release 3.3.14 On 2007-04-02

    +
  1. Fix a bug (ticket #2273) + that could cause a segfault when the IN operator + is used one term of a two-column index and the right-hand side of + the IN operator contains a NULL.
    2. +
  2. Added a new OS interface method for determining the sector size + of underlying media: sqlite3OsSectorSize().
    3. +
  3. A new algorithm for statements of the form + INSERT INTO table1 SELECT * FROM table2 + is faster and reduces fragmentation. VACUUM uses statements of + this form and thus runs faster and defragments better.
    4. +
  4. Performance enhancements through reductions in disk I/O: +
      +
    1. Do not read the last page of an overflow chain when + deleting the row - just add that page to the freelist.
      2. +
    2. Do not store pages being deleted in the + rollback journal.
      3. +
    3. Do not read in the (meaningless) content of + pages extracted from the freelist.
      4. +
    4. Do not flush the page cache (and thus avoiding + a cache refill) unless another process changes the underlying + database file.
      5. +
    5. Truncate rather than delete the rollback journal when committing + a transaction in exclusive access mode, or when committing the TEMP + database.
      6. +
    5. +
  5. Added support for exclusive access mode using + + "PRAGMA locking_mode=EXCLUSIVE"
    6. +
  6. Use heap space instead of stack space for large buffers in the + pager - useful on embedded platforms with stack-space + limitations.
    7. +
  7. Add a makefile target "sqlite3.c" that builds an amalgamation containing + the core SQLite library C code in a single file.
    8. +
  8. Get the library working correctly when compiled + with GCC option "-fstrict-aliasing".
    9. +
  9. Removed the vestigal SQLITE_PROTOCOL error.
    10. +
  10. Improvements to test coverage, other minor bugs fixed, + memory leaks plugged, + code refactored and/or recommended in places for easier reading.
    11. + +

+ +

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