From a882b1c4a2e95f982e4ef77d2889abbd6d912529 Mon Sep 17 00:00:00 2001
From: Karen Arutyunov <karen@codesynthesis.com>
Date: Wed, 31 Jul 2019 19:15:10 +0300
Subject: Upgrade to 3.27.2

---
 README-DEV | 109 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
 1 file changed, 107 insertions(+), 2 deletions(-)

(limited to 'README-DEV')

diff --git a/README-DEV b/README-DEV
index 84fa2bd..34435d2 100644
--- a/README-DEV
+++ b/README-DEV
@@ -8,6 +8,111 @@ that we package separately (see the respective README-DEV files for details).
 We extract the upstream package from the archive and symlink the required files
 into the build2 package subdirectories.
 
-For 3.18.2, that we packaged initially, the archive URL is
-https://www.sqlite.org/2017/sqlite-autoconf-3180200.tar.gz. For the future
+For 3.27.2 the archive URL is
+https://www.sqlite.org/2019/sqlite-autoconf-3270200.tar.gz. For the future
 releases the URL can be deduced from the above.
+
+The upstream package can be configured to contain a specific feature set. We
+reproduce the union of features configured for the upstream source package in
+Debian and Fedora distributions. The configuration options defining these sets
+are specified in the Debian's rules and Fedora's RPM .spec files. Note,
+however, that at the time of this writing Fedora doesn't provide the 3.27.2
+package version, so we will use 3.29.0 instead. These files can be obtained as
+follows:
+
+$ wget http://deb.debian.org/debian/pool/main/s/sqlite3/sqlite3_3.27.2-3.debian.tar.xz
+$ tar xf sqlite3_3.27.2-3.debian.tar.xz debian/rules
+
+$ wget https://kojipkgs.fedoraproject.org//packages/sqlite/3.29.0/2.fc31/src/sqlite-3.29.0-2.fc31.src.rpm
+$ rpm2cpio sqlite-3.29.0-2.fc31.src.rpm | cpio -civ '*.spec'
+
+Some of the features are enabled via the preprocessor macro definitions and
+others via the configure script options. Here are the discovered configuration
+options.
+
+Debian:
+
+  -DSQLITE_SECURE_DELETE
+  -DSQLITE_ENABLE_COLUMN_METADATA
+  -DSQLITE_ENABLE_FTS3
+  -DSQLITE_ENABLE_FTS3_PARENTHESIS
+  -DSQLITE_ENABLE_RTREE=1
+  -DSQLITE_SOUNDEX=1
+  -DSQLITE_ENABLE_UNLOCK_NOTIFY
+  -DSQLITE_OMIT_LOOKASIDE=1
+  -DSQLITE_ENABLE_DBSTAT_VTAB
+  -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1
+  -DSQLITE_ENABLE_LOAD_EXTENSION
+  -DSQLITE_ENABLE_JSON1
+  -DSQLITE_LIKE_DOESNT_MATCH_BLOBS
+  -DSQLITE_THREADSAFE=1
+  -DSQLITE_ENABLE_FTS3_TOKENIZER=1
+  -DSQLITE_USE_URI=1
+  -DSQLITE_MAX_SCHEMA_RETRY=25
+  -DSQLITE_ENABLE_PREUPDATE_HOOK
+  -DSQLITE_ENABLE_SESSION
+  -DSQLITE_ENABLE_STMTVTAB
+  -DSQLITE_MAX_VARIABLE_NUMBER=250000
+
+  --enable-threadsafe
+  --enable-load-extension
+  --enable-json1
+  --enable-fts4
+  --enable-fts5
+
+Fedora:
+
+  -DSQLITE_ENABLE_COLUMN_METADATA=1
+  -DSQLITE_DISABLE_DIRSYNC=1
+  -DSQLITE_ENABLE_FTS3=1
+  -DSQLITE_ENABLE_RTREE=1
+  -DSQLITE_SECURE_DELETE=1
+  -DSQLITE_ENABLE_UNLOCK_NOTIFY=1
+  -DSQLITE_ENABLE_DBSTAT_VTAB=1
+  -DSQLITE_ENABLE_FTS3_PARENTHESIS=1
+  -DSQLITE_ENABLE_JSON1=1
+
+  --enable-fts5
+  --enable-threadsafe
+  --enable-threads-override-locks
+  --enable-load-extension
+
+Translating the configure script options into the macro definitions and adding
+the unconditionally defined macros (see upstream's Makefile.am for details) we
+end up with:
+
+  -DSQLITE_ENABLE_COLUMN_METADATA=1
+  -DSQLITE_ENABLE_DBPAGE_VTAB=1
+  -DSQLITE_ENABLE_DBSTAT_VTAB=1
+  -DSQLITE_ENABLE_EXPLAIN_COMMENTS=1
+  -DSQLITE_ENABLE_FTS3=1
+  -DSQLITE_ENABLE_FTS3_PARENTHESIS=1
+  -DSQLITE_ENABLE_FTS3_TOKENIZER=1
+  -DSQLITE_ENABLE_FTS4=1
+  -DSQLITE_ENABLE_FTS5=1
+  -DSQLITE_ENABLE_JSON1=1
+  -DSQLITE_ENABLE_LOAD_EXTENSION=1
+  -DSQLITE_ENABLE_PREUPDATE_HOOK=1
+  -DSQLITE_ENABLE_RTREE=1
+  -DSQLITE_ENABLE_SESSION=1
+  -DSQLITE_ENABLE_STMTVTAB=1
+  -DSQLITE_ENABLE_UNLOCK_NOTIFY=1
+  -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT=1
+  -DSQLITE_LIKE_DOESNT_MATCH_BLOBS=1
+  -DSQLITE_MAX_SCHEMA_RETRY=25
+  -DSQLITE_MAX_VARIABLE_NUMBER=250000
+  -DSQLITE_OMIT_LOOKASIDE=1
+  -DSQLITE_SECURE_DELETE=1
+  -DSQLITE_SOUNDEX=1
+  -DSQLITE_THREADSAFE=1
+  -DSQLITE_USE_URI=1
+
+As a side note, on Debian and Fedora the library, headers and program are
+packaged as follows:
+
+                libsqlite3   headers        sqlite3
+Debian/Ubuntu:  libsqlite3-0 libsqlite3-dev sqlite3
+Fedora/RHEL:    sqlite-libs  sqlite-devel   sqlite
+
+Search for the Debian and Fedora packages at https://packages.debian.org/search
+and https://apps.fedoraproject.org/packages/.
-- 
cgit v1.1