The SQLite package is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
![[Note]](../images/note.png)
Development versions of BLFS may not build or run some packages properly if LFS or dependencies have been updated since the most recent stable versions of the books.
Download (HTTP): https://sqlite.org/2024/sqlite-autoconf-3470200.tar.gz
Download MD5 sum: 6bf0697af5b609e186cc223eca9c2cb1
Download size: 3.2 MB
Estimated disk space required: 47 MB
Estimated build time: 0.3 SBU (Using parallelism=4)
Optional Documentation
Download (HTTP): https://sqlite.org/2024/sqlite-doc-3470200.zip
Download MD5 sum: 21181287a1a4baf18d714e5fd282df1e
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-3470200.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.47.2 && cp -v -R sqlite-doc-3470200/* /usr/share/doc/sqlite-3.47.2
--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="-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.