Documentation Source Text

Check-in [854c6fc854]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add news and adjust the date for the 3.8.10 release.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 854c6fc854bdce63eb8aa3d380f7e2f0f5a6c54e
User & Date: drh 2015-05-06 17:25:18.157
Context
2015-05-07
11:32
Fix typos. (check-in: 73e4989d49 user: drh tags: trunk)
2015-05-06
17:25
Add news and adjust the date for the 3.8.10 release. (check-in: 854c6fc854 user: drh tags: trunk)
2015-05-05
19:59
Fix a typo in the documentation for fts3 matchinfo option 'y'. (check-in: 9dff844fd9 user: dan tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2015-06-00 (3.8.10)} {
<li>Added the [sqldiff.exe] utility program for computing the differences between two
    SQLite database files.
<li>Added the <a href="fts3.html#matchinfo-y">y format string</a> to the 
    [matchinfo()] function of [FTS3].
<li>Performance optimizations for [ORDER BY], [VACUUM], [CREATE INDEX],
    [PRAGMA integrity_check], and [PRAGMA quick_check].
<li>Fix many obscure problems discovered while [SQL fuzzing].
<li>Identify all methods for important objects in the interface documentation.
    ([sqlite3_context|example])
<li>Made the [American Fuzzy Lop fuzzer]
    a standard part of SQLite's [testing|testing strategy].
<li>Add the ".binary" and ".limits" commands to the [command-line shell].







|




|







14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2015-05-08 (3.8.10)} {
<li>Added the [sqldiff.exe] utility program for computing the differences between two
    SQLite database files.
<li>Added the <a href="fts3.html#matchinfo-y">y format string</a> to the 
    [matchinfo()] function of [FTS3].
<li>Performance improvements for [ORDER BY], [VACUUM], [CREATE INDEX],
    [PRAGMA integrity_check], and [PRAGMA quick_check].
<li>Fix many obscure problems discovered while [SQL fuzzing].
<li>Identify all methods for important objects in the interface documentation.
    ([sqlite3_context|example])
<li>Made the [American Fuzzy Lop fuzzer]
    a standard part of SQLite's [testing|testing strategy].
<li>Add the ".binary" and ".limits" commands to the [command-line shell].
Changes to pages/download.in.
186
187
188
189
190
191
192





193
194
195
196
197
198
199
200
201
202
203





204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223





224
225
226
227
228
229
230
  The [command-line shell] program (version VERSION).
}

Product YEAR/sqlite-analyzer-linux-x86-VVV.zip {
  A program to analyze how space is allocated inside an SQLite database
  file (version VERSION).
}






Heading {Precompiled Binaries for Mac OS X (x86)} mac

Product YEAR/sqlite-shell-osx-x86-VVV.zip {
  The [command-line shell] program (version VERSION).
}

Product YEAR/sqlite-analyzer-osx-x86-VVV.zip {
  A program to analyze how space is allocated inside an SQLite database
  file (version VERSION).
}






Heading {Precompiled Binaries for Windows} win32

set start $nDownload
Product YEAR/sqlite-shell-win32-x86-VVV.zip {
  The [command-line shell] program (version VERSION).
}

Product YEAR/sqlite-dll-win32-x86-VVV.zip {
  32-bit DLL (x86) for SQLite verison VERSION.
}

Product YEAR/sqlite-dll-win64-x64-VVV.zip {
  64-bit DLL (x64) for SQLite version VERSION.
}

Product YEAR/sqlite-analyzer-win32-x86-VVV.zip {
  A program to analyze how space is allocated inside an SQLite database
  file (version VERSION).
}






Heading {Precompiled Binaries for Windows Phone 8} wp8


Product YEAR/sqlite-wp80-winrt-VVV.vsix {
  A complete VSIX package with an extension SDK and all other components
  needed to use SQLite for application development with Visual Studio







>
>
>
>
>











>
>
>
>
>




















>
>
>
>
>







186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
  The [command-line shell] program (version VERSION).
}

Product YEAR/sqlite-analyzer-linux-x86-VVV.zip {
  A program to analyze how space is allocated inside an SQLite database
  file (version VERSION).
}

Product YEAR/sqldiff-linux-x86-VVV.zip {
  A program to display differences between two SQLite database files.
  (version VERSION).
}

Heading {Precompiled Binaries for Mac OS X (x86)} mac

Product YEAR/sqlite-shell-osx-x86-VVV.zip {
  The [command-line shell] program (version VERSION).
}

Product YEAR/sqlite-analyzer-osx-x86-VVV.zip {
  A program to analyze how space is allocated inside an SQLite database
  file (version VERSION).
}

Product YEAR/sqldiff-osx-x86-VVV.zip {
  A program to display differences between two SQLite database files.
  (version VERSION).
}

Heading {Precompiled Binaries for Windows} win32

set start $nDownload
Product YEAR/sqlite-shell-win32-x86-VVV.zip {
  The [command-line shell] program (version VERSION).
}

Product YEAR/sqlite-dll-win32-x86-VVV.zip {
  32-bit DLL (x86) for SQLite verison VERSION.
}

Product YEAR/sqlite-dll-win64-x64-VVV.zip {
  64-bit DLL (x64) for SQLite version VERSION.
}

Product YEAR/sqlite-analyzer-win32-x86-VVV.zip {
  A program to analyze how space is allocated inside an SQLite database
  file (version VERSION).
}

Product YEAR/sqldiff-win32-x86-VVV.zip {
  A program to display differences between two SQLite database files.
  (version VERSION).
}

Heading {Precompiled Binaries for Windows Phone 8} wp8


Product YEAR/sqlite-wp80-winrt-VVV.vsix {
  A complete VSIX package with an extension SDK and all other components
  needed to use SQLite for application development with Visual Studio
Changes to pages/news.in.
14
15
16
17
18
19
20









21
22
23
24
25
26
27
  hd_puts "<h3>$date - $title</h3>"
  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 {2015-04-08} {Release 3.8.9} {
<p>SQLite version 3.8.9 is a regularly scheduled maintenance release.
   New features in this release include the 
   [PRAGMA index_xinfo] command, the [sqlite3_status64()] interface,
   and the ".dbinfo" command of the [command-line shell].
   See the <a href='releaselog/3_8_9.html'>release notes</a> for







>
>
>
>
>
>
>
>
>







14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
  hd_puts "<h3>$date - $title</h3>"
  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 {2015-05-08} {Release 3.8.10} {
<p>SQLite version 3.8.10 is a regularly scheduled maintenance release.
   This release features performance improvements, fixes to several
   arcane bugs found by the AFL fuzzer, the new "sqldiff.exe" command-line
   utility, improvements to the documentation, and other enhancements.
   See the <a href='releaselog/3_8_10.html'>release notes</a> for 
   additional information.
}

newsitem {2015-04-08} {Release 3.8.9} {
<p>SQLite version 3.8.9 is a regularly scheduled maintenance release.
   New features in this release include the 
   [PRAGMA index_xinfo] command, the [sqlite3_status64()] interface,
   and the ".dbinfo" command of the [command-line shell].
   See the <a href='releaselog/3_8_9.html'>release notes</a> for