The SQLite package is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
This package is known to build and work properly using an LFS-10.1 platform.
Download (HTTP): https://sqlite.org/2021/sqlite-autoconf-3350400.tar.gz
Download MD5 sum: 9cf453a9cd0e40cdbc8e6f008acfc4fb
Download size: 2.8 MB
Estimated disk space required: 139 MB
Estimated build time: 0.3 SBU (Using parallelism=4)
Optional Documentation
Download (HTTP): https://sqlite.org/2021/sqlite-doc-3350400.zip
Download MD5 sum: 7dd0b0b5edc42929638702382e8ead13
Download size: 9.8 MB
libedit and UnZip-6.0 (required to unzip the documentation)
User Notes: http://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-3350400.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.35.4 && cp -v -R sqlite-doc-3350400/* /usr/share/doc/sqlite-3.35.4
--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 http://www.sqlite.org/compile.html.
Last updated on 2021-04-03 11:58:31 -0500