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 12.0 platform.
Download (HTTP): https://sqlite.org/2023/sqlite-autoconf-3420000.tar.gz
Download MD5 sum: 0c5a92bc51cf07cae45b4a1e94653dea
Download size: 3.1 MB
Estimated disk space required: 76 MB
Estimated build time: 0.3 SBU (Using parallelism=4)
Optional Documentation
Download (HTTP): https://sqlite.org/2023/sqlite-doc-3420000.zip
Download MD5 sum: f3cb6b67a82bc586a096459085616e4f
Download size: 11 MB
If you downloaded the optional documentation, issue the following command to install the documentation into the source tree:
unzip -q ../sqlite-doc-3420000.zip
Install SQLite by running the following commands:
./configure --prefix=/usr \
--disable-static \
--enable-fts{4,5} \
CPPFLAGS="-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.42.0 && cp -v -R sqlite-doc-3420000/* /usr/share/doc/sqlite-3.42.0
--disable-static: This
switch prevents installation of static versions of the libraries.
--enable-fts{4,5}: These
switches enable support for version 3, 4 and 5 of the full text
search (FTS) extension. Note that the --enable-fts4 switch enables support for both FTS
version 4 and FTS version 3.
CPPFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA=1
-DSQLITE_ENABLE_UNLOCK_NOTIFY=1 -DSQLITE_ENABLE_DBSTAT_VTAB=1
-DSQLITE_SECURE_DELETE=1
-DSQLITE_ENABLE_FTS3_TOKENIZER=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.