diff options
Diffstat (limited to 'README-DEV')
| -rw-r--r-- | README-DEV | 109 |
1 files changed, 107 insertions, 2 deletions
@@ -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/. |