Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update dates and tags for the 3.17.0 release. Also fix a hyperlink target in the testing.html document. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk | release | version-3.17.0 |
Files: | files | file ages | folders |
SHA1: |
60bb99911d733de0770f168f6a471d50 |
User & Date: | drh 2017-02-13 16:13:37.339 |
Context
2017-02-14
| ||
20:18 | Enhanced documentation for the ".separator" and ".mode quote" commands in the CLI. (check-in: 95afd54c2e user: drh tags: trunk) | |
2017-02-13
| ||
16:13 | Update dates and tags for the 3.17.0 release. Also fix a hyperlink target in the testing.html document. (check-in: 60bb99911d user: drh tags: trunk, release, version-3.17.0) | |
11:53 | Update sessionintro.in to reflect the support for WITHOUT ROWID tables in the sessions module. (check-in: c6eb84e1aa user: dan tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
17 18 19 20 21 22 23 | proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } | | | 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 | proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2017-02-13 (3.17.0)} { <li>Approximately 25% better performance from the [R-Tree extension]. <ul> <li> Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong()) for byteswapping when available. <li> Uses the [sqlite3_blob] key/value access object instead of SQL for pulling content out of R-Tree nodes <li> Other miscellaneous enhancements such as loop unrolling. |
︙ | ︙ | |||
76 77 78 79 80 81 82 83 84 85 86 87 88 89 | into an INNER JOIN. Fix for ticket [https://www.sqlite.org/src/info/25e335f802dd|25e335f802dd]. <li>Use the correct affinity for columns of automatic indexes. Ticket [https://www.sqlite.org/src/info/7ffd1ca1d2ad4ec|7ffd1ca1d2ad4ec]. <li>Ensure that the [sqlite3_blob_reopen()] interface can correctly handle short rows. Fix for ticket [https://www.sqlite.org/src/info/e6e962d6b0f06f46e|e6e962d6b0f06f46e]. } chng {2017-01-06 (3.16.2)} { <li>Fix the [REPLACE] statement for [WITHOUT ROWID] tables that lack secondary indexes so that it works correctly with triggers and foreign keys. This was a new bug caused by performance optimizations added in version 3.16.0. | > > > > | 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 | into an INNER JOIN. Fix for ticket [https://www.sqlite.org/src/info/25e335f802dd|25e335f802dd]. <li>Use the correct affinity for columns of automatic indexes. Ticket [https://www.sqlite.org/src/info/7ffd1ca1d2ad4ec|7ffd1ca1d2ad4ec]. <li>Ensure that the [sqlite3_blob_reopen()] interface can correctly handle short rows. Fix for ticket [https://www.sqlite.org/src/info/e6e962d6b0f06f46e|e6e962d6b0f06f46e]. <p><b>Hashes:</b> <li>SQLITE_SOURCE_ID: "2017-02-13 16:02:40 ada05cfa86ad7f5645450ac7a2a21c9aa6e57d2c" <li>SHA1 for sqlite3.c: cc7d708bb073c44102a59ed63ce6142da1f174d1 } chng {2017-01-06 (3.16.2)} { <li>Fix the [REPLACE] statement for [WITHOUT ROWID] tables that lack secondary indexes so that it works correctly with triggers and foreign keys. This was a new bug caused by performance optimizations added in version 3.16.0. |
︙ | ︙ |
Changes to pages/chronology.in.
︙ | ︙ | |||
24 25 26 27 28 29 30 | # ORDER BY mtime DESC; # # A small amount of manual editing and de-duplication followed. # # Manually edit the list for each subsequent release. # foreach line [split { | | | 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | # ORDER BY mtime DESC; # # A small amount of manual editing and de-duplication followed. # # Manually edit the list for each subsequent release. # foreach line [split { ada05cfa86|2017-02-13|version 3.17.0 a65a62893c|2017-01-06|version 3.16.2 979f043928|2017-01-03|Version 3.16.1 04ac0b75b1|2017-01-02|Version 3.16.0 bbd85d235f|2016-11-28|Version 3.15.2 1136863c76|2016-11-04|Version 3.15.1 707875582f|2016-10-14|Version 3.15.0 29dbef4b85|2016-09-12|Version 3.14.2 |
︙ | ︙ |
Changes to pages/news.in.
︙ | ︙ | |||
15 16 17 18 19 20 21 | regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } | | | | 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt regsub -all {[Tt]icket #(\d+)} $txt \ {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt hd_resolve "<blockquote>$txt</blockquote>" hd_puts "<hr width=\"50%\">" } newsitem {2017-02-13} {Release 3.17.0} { SQLite [version 3.17.0] is a regularly scheduled maintenance release. <p> Most of the changes in this release are performance optimizations. Optimizations to the [R-Tree extension] are especially noticeable. <p> In this release, the default size of the [lookaside buffer] allocated for each database connection is increased from 64,000 to 120,000 bytes. This provides improved performance on many common workloads in exchange for a small increase in memory usage. Applications that value a small memory footprint over raw speed can change the lookaside buffer size back to its old value (or to zero) using the [SQLITE_DEFAULT_LOOKASIDE] compile-time option, or the [SQLITE_CONFIG_LOOKASIDE|sqlite3_config(SQLITE_CONFIG_LOOKASIDE)] |
︙ | ︙ |
Changes to pages/testing.in.
︙ | ︙ | |||
201 202 203 204 205 206 207 | <li value="4">The "speedtest1.c" program estimates the performance of SQLite under a typical workload. <li>The "mptester.c" program is a stress test for multiple processes concurrently reading and writing a single database. <li>The "threadtest3.c" program is a stress test for multiple threads using SQLite simultaneously. <li>The "fuzzershell.c" program is used to | | | 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 | <li value="4">The "speedtest1.c" program estimates the performance of SQLite under a typical workload. <li>The "mptester.c" program is a stress test for multiple processes concurrently reading and writing a single database. <li>The "threadtest3.c" program is a stress test for multiple threads using SQLite simultaneously. <li>The "fuzzershell.c" program is used to run some <a href="#fuzztesting">fuzz tests</a>. </ol> </p> <p>All of the tests above must run successfully, on multiple platforms and under multiple compile-time configurations, before each release of SQLite.</p> |
︙ | ︙ |