The SQLite package is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
Development versions of BLFS may not build or run some packages properly if dependencies have been updated since the most recent stable versions of the book.
Download (HTTP): https://sqlite.org/2022/sqlite-autoconf-3400100.tar.gz
Download MD5 sum: 42175b1a1d23529cb133bbd2b5900afd
Download size: 3.0 MB
Estimated disk space required: 78 MB
Estimated build time: 0.3 SBU (Using parallelism=4)
Optional Documentation
Download (HTTP): https://sqlite.org/2022/sqlite-doc-3400100.zip
Download MD5 sum: f4cc9073ea45b01f62b9652e5e28a383
Download size: 11 MB
libedit and UnZip-6.0 (required to unzip the documentation)
User Notes: https://wiki.linuxfromscratch.org/blfs/wiki/sqlite
If you downloaded the optional documentation, issue the following command to install the documentation into the source tree:
unzip -q ../sqlite-doc-3400100.zip
Install SQLite by running the following commands:
./configure --prefix=/usr \ --disable-static \ --enable-fts5 \ CPPFLAGS="-DSQLITE_ENABLE_FTS3=1 \ -DSQLITE_ENABLE_FTS4=1 \ -DSQLITE_ENABLE_COLUMN_METADATA=1 \ -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 \ -DSQLITE_ENABLE_DBSTAT_VTAB=1 \ -DSQLITE_SECURE_DELETE=1 \ -DSQLITE_ENABLE_FTS3_TOKENIZER=1" && make
This package does not come with a test suite.
Now, as the root
user:
make install
If you downloaded the optional documentation, issue the following
commands as the root
user to
install it:
install -v -m755 -d /usr/share/doc/sqlite-3.40.1 && cp -v -R sqlite-doc-3400100/* /usr/share/doc/sqlite-3.40.1
--disable-static
: This
switch prevents installation of static versions of the libraries.
--enable-fts5
: This switch
enables support for version 5 of the full text search extension.
CPPFLAGS="-DSQLITE_ENABLE_FTS3=1
-DSQLITE_ENABLE_FTS3_TOKENIZER=1 -DSQLITE_ENABLE_FTS4=1
-DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_SECURE_DELETE
-DSQLITE_ENABLE_UNLOCK_NOTIFY=1
-DSQLITE_ENABLE_DBSTAT_VTAB=1"
: Applications such as
SeaMonkey require these options to
be turned on. The only way to do this is to include them in the
CFLAGS
or CPPFLAGS
. We use the latter so the default value (or
any value set by the user) of CFLAGS
won't be affected. For further information on what can be specified
see https://www.sqlite.org/compile.html.