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.2 platform.
Download (HTTP): https://sqlite.org/2024/sqlite-autoconf-3460100.tar.gz
Download MD5 sum: bde7df8c2a4bce82dbf42f7e4dda0e21
Download size: 3.1 MB
Estimated disk space required: 80 MB
Estimated build time: 0.3 SBU (Using parallelism=4)
Optional Documentation
Download (HTTP): https://sqlite.org/2024/sqlite-doc-3460100.zip
Download MD5 sum: 3f1fc03c5aad4839825d576eea5d93ff
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-3460100.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.46.1 && cp -v -R sqlite-doc-3460100/* /usr/share/doc/sqlite-3.46.1
--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.