Changes 3.8.11:

Added the experimental RBU extension. Note that this extension is experimental and subject to change in incompatible ways.
Added the experimental FTS5 extension. Note that this extension is experimental and subject to change in incompatible ways.
Added the sqlite3_value_dup() and sqlite3_value_free() interfaces.
Enhance the spellfix1 extension to support ON CONFLICT clauses.
The IS operator is now able to drive indexes.
Enhance the query planner to permit automatic indexing on FROM-clause subqueries that are implemented by co-routine.
Disallow the use of "rowid" in common table expressions.
Added the PRAGMA cell_size_check command for better and earlier detection of database file corruption.
Added the matchinfo 'b' flag to the matchinfo() function in FTS3.
Improved fuzz-testing of database files, with fixes for problems found.
Add the fuzzcheck test program and automatically run this program using both SQL and database test cases on "make test".
Added the SQLITE_MUTEX_STATIC_VFS1 static mutex and use it in the Windows VFS.
The sqlite3_profile() callback is invoked (by sqlite3_reset() or sqlite3_finalize()) for statements that did not run to completion.
Enhance the page cache so that it can preallocate a block of memory to use for the initial set page cache lines. Set the default preallocation to 100 pages. Yields about a 5% performance increase on common workloads.
Miscellaneous micro-optimizations result in 22.3% more work for the same number of CPU cycles relative to the previous release. SQLite now runs twice as fast as version 3.8.0 and three times as fast as version 3.3.9. (Measured using cachegrind on the speedtest1.c workload on Ubuntu 14.04 x64 with gcc 4.8.2 and -Os. Your performance may vary.)
Added the sqlite3_result_zeroblob64() and sqlite3_bind_zeroblob64() interfaces.

5 files changed, 20 insertions, 16 deletions

diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST
index 9bca7ce92a5..c6d5d94cde6 100644
--- a/databases/sqlite3-docs/PLIST
+++ b/databases/sqlite3-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.42 2015/05/21 10:38:53 adam Exp $
+@comment $NetBSD: PLIST,v 1.43 2015/07/28 07:18:22 adam Exp $
 share/doc/sqlite3/34to35.html
 share/doc/sqlite3/35to36.html
 share/doc/sqlite3/about.html
@@ -166,6 +166,7 @@ share/doc/sqlite3/c3ref/uri_boolean.html
 share/doc/sqlite3/c3ref/user_data.html
 share/doc/sqlite3/c3ref/value.html
 share/doc/sqlite3/c3ref/value_blob.html
+share/doc/sqlite3/c3ref/value_dup.html
 share/doc/sqlite3/c3ref/vfs.html
 share/doc/sqlite3/c3ref/vfs_find.html
 share/doc/sqlite3/c3ref/vtab.html
@@ -257,6 +258,7 @@ share/doc/sqlite3/images/books/aditya.jpg
 share/doc/sqlite3/images/books/das.jpg
 share/doc/sqlite3/images/books/droessler.jpg
 share/doc/sqlite3/images/books/haldar.gif
+share/doc/sqlite3/images/books/haldar2.jpg
 share/doc/sqlite3/images/books/kreibich.gif
 share/doc/sqlite3/images/books/newman.jpg
 share/doc/sqlite3/images/books/nishizawa2.jpg
@@ -509,6 +511,7 @@ share/doc/sqlite3/psow.html
 share/doc/sqlite3/queryplanner-ng.html
 share/doc/sqlite3/queryplanner.html
 share/doc/sqlite3/quickstart.html
+share/doc/sqlite3/rbu.html
 share/doc/sqlite3/releaselog/3_0_0.html
 share/doc/sqlite3/releaselog/3_0_1.html
 share/doc/sqlite3/releaselog/3_0_2.html
@@ -631,6 +634,7 @@ share/doc/sqlite3/releaselog/3_8_1.html
 share/doc/sqlite3/releaselog/3_8_10.html
 share/doc/sqlite3/releaselog/3_8_10_1.html
 share/doc/sqlite3/releaselog/3_8_10_2.html
+share/doc/sqlite3/releaselog/3_8_11.html
 share/doc/sqlite3/releaselog/3_8_2.html
 share/doc/sqlite3/releaselog/3_8_3.html
 share/doc/sqlite3/releaselog/3_8_3_1.html
diff --git a/databases/sqlite3-docs/distinfo b/databases/sqlite3-docs/distinfo
index c196c22f5c2..4d04b37d4dd 100644
--- a/databases/sqlite3-docs/distinfo
+++ b/databases/sqlite3-docs/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.42 2015/05/21 10:38:53 adam Exp $
+$NetBSD: distinfo,v 1.43 2015/07/28 07:18:22 adam Exp $
 
-SHA1 (sqlite-doc-3081002.zip) = 2e816999255e4fced7d93b6ad3650a361a446288
-RMD160 (sqlite-doc-3081002.zip) = c6f271aafb6e099d40cd83d68646a40359660ea0
-Size (sqlite-doc-3081002.zip) = 5068441 bytes
+SHA1 (sqlite-doc-3081100.zip) = 8a0011fc13c2544902a6da426091c3b7e70d68aa
+RMD160 (sqlite-doc-3081100.zip) = 9524a66ede5d6e49a4a1e6d4ab59f44be346e387
+Size (sqlite-doc-3081100.zip) = 5103048 bytes
diff --git a/databases/sqlite3-tcl/distinfo b/databases/sqlite3-tcl/distinfo
index 09a745a6a9c..5f2eadab632 100644
--- a/databases/sqlite3-tcl/distinfo
+++ b/databases/sqlite3-tcl/distinfo
@@ -1,6 +1,6 @@
-$NetBSD: distinfo,v 1.55 2015/05/21 10:38:53 adam Exp $
+$NetBSD: distinfo,v 1.56 2015/07/28 07:18:23 adam Exp $
 
-SHA1 (sqlite-autoconf-3081002.tar.gz) = c2f2c17d3dc4c4e179d35cc04e4420636d48a152
-RMD160 (sqlite-autoconf-3081002.tar.gz) = caacc0e5d95147ec56cc725dfaa9e0df8581b240
-Size (sqlite-autoconf-3081002.tar.gz) = 2049387 bytes
+SHA1 (sqlite-autoconf-3081100.tar.gz) = da1322d883548bdb0f6312941b20ed497e3754fa
+RMD160 (sqlite-autoconf-3081100.tar.gz) = 610107f0e5752979c0e2c5d3ecdd2471467696d0
+Size (sqlite-autoconf-3081100.tar.gz) = 2101901 bytes
 SHA1 (patch-aa) = 4a12a16498d04e1031dc0802fda731b73e98a32d
diff --git a/databases/sqlite3/Makefile.version b/databases/sqlite3/Makefile.version
index 72c2edcdc2a..a68f50db421 100644
--- a/databases/sqlite3/Makefile.version
+++ b/databases/sqlite3/Makefile.version
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile.version,v 1.4 2015/05/21 10:38:53 adam Exp $
+# $NetBSD: Makefile.version,v 1.5 2015/07/28 07:18:22 adam Exp $
 # used by databases/sqlite3/Makefile
 # used by databases/sqlite3-docs/Makefile
 # used by databases/sqlite3-tcl/Makefile
 
-SQLITE3_DISTVERSION=	3081002
-SQLITE3_VERSION=	3.8.10.2
+SQLITE3_DISTVERSION=	3081100
+SQLITE3_VERSION=	3.8.11
diff --git a/databases/sqlite3/distinfo b/databases/sqlite3/distinfo
index e4ade5050be..c0006f7236b 100644
--- a/databases/sqlite3/distinfo
+++ b/databases/sqlite3/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.105 2015/05/21 10:38:53 adam Exp $
+$NetBSD: distinfo,v 1.106 2015/07/28 07:18:22 adam Exp $
 
-SHA1 (sqlite-autoconf-3081002.tar.gz) = c2f2c17d3dc4c4e179d35cc04e4420636d48a152
-RMD160 (sqlite-autoconf-3081002.tar.gz) = caacc0e5d95147ec56cc725dfaa9e0df8581b240
-Size (sqlite-autoconf-3081002.tar.gz) = 2049387 bytes
+SHA1 (sqlite-autoconf-3081100.tar.gz) = da1322d883548bdb0f6312941b20ed497e3754fa
+RMD160 (sqlite-autoconf-3081100.tar.gz) = 610107f0e5752979c0e2c5d3ecdd2471467696d0
+Size (sqlite-autoconf-3081100.tar.gz) = 2101901 bytes