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.4 platform.
Download (HTTP): https://sqlite.org/2025/sqlite-autoconf-3500400.tar.gz
Download MD5 sum: d74bbdca4ab1b2bd46d3b3f8dbb0f3db
Download size: 3.0 MB
Estimated disk space required: 44 MB (with documentation)
Estimated build time: 0.1 SBU (Using parallelism=4)
Optional Documentation
Download (HTTP): https://sqlite.org/2025/sqlite-doc-3500400.zip
Download MD5 sum: faa12e794bcc37ba275fd6268317eb87
Download size: 11 MB
libarchive-3.8.1 (required to unzip the documentation) and libedit
If you downloaded the optional documentation, issue the following command to install the documentation into the source tree:
unzip -q ../sqlite-doc-3500400.zip
Install SQLite by running the following commands:
./configure --prefix=/usr \
--disable-static \
--enable-fts{4,5} \
CPPFLAGS="-D SQLITE_ENABLE_COLUMN_METADATA=1 \
-D SQLITE_ENABLE_UNLOCK_NOTIFY=1 \
-D SQLITE_ENABLE_DBSTAT_VTAB=1 \
-D SQLITE_SECURE_DELETE=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.50.4 && cp -v -R sqlite-doc-3500400/* /usr/share/doc/sqlite-3.50.4
![[Important]](../images/important.png)
Several packages use an sqlite Python plugin. After installing this package, Python-3.13.7 should be rebuilt to create this plugin.
--disable-static: This
switch prevents installation of static versions of the libraries.
--enable-fts{4,5}: These
switches enable support for version 4 and 5 of the full text search
(FTS) extension.
CPPFLAGS="-D
SQLITE_ENABLE_COLUMN_METADATA=1 ... : Some applications
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.