The SQLite package is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
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-3450000.tar.gz
Download MD5 sum: d6150f5dc837ae94b7d735f1b611b634
Download size: 3.1 MB
Estimated disk space required: 79 MB
Estimated build time: 0.4 SBU (Using parallelism=4)
Optional Documentation
Download (HTTP): https://sqlite.org/2024/sqlite-doc-3450000.zip
Download MD5 sum: ffb89f5365b35b65487a79d3df053a59
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-3450000.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.45.0 && cp -v -R sqlite-doc-3450000/* /usr/share/doc/sqlite-3.45.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 ...
: 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.