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-7.9 platform.
Download (HTTP): http://sqlite.org/2016/sqlite-autoconf-3110000.tar.gz
Download MD5 sum: a6cdc3e0a6e5087d620037ae0c48720d
Download size: 2.3 MB
Estimated disk space required: 83 MB (with Optional Documentation)
Estimated build time: 0.6 SBU
Optional Documentation
Download (HTTP): http://sqlite.org/2016/sqlite-doc-3110000.zip
Download MD5 sum: 4e881ce616b44dbb1f2f7fb554bbe0be
Download size: 5.2 MB
libedit and UnZip-6.0 (required to unzip the documentation)
User Notes: http://wiki.linuxfromscratch.org/blfs/wiki/sqlite
This package does not support parallel build.
If you downloaded the optional documentation, issue the following command to install the documentation into the source tree:
unzip -q ../sqlite-doc-3110000.zip
Install SQLite by running the following commands:
./configure --prefix=/usr --disable-static \ CFLAGS="-g -O2 -DSQLITE_ENABLE_FTS3=1 \ -DSQLITE_ENABLE_COLUMN_METADATA=1 \ -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 \ -DSQLITE_SECURE_DELETE=1 \ -DSQLITE_ENABLE_DBSTAT_VTAB=1" && make -j1
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.11.0 && cp -v -R sqlite-doc-3110000/* /usr/share/doc/sqlite-3.11.0
--disable-static
: This
switch prevents installation of static versions of the libraries.
CFLAGS="-g -O2 -DSQLITE_ENABLE_FTS3=1
-DSQLITE_ENABLE_COLUMN_METADATA=1 -DSQLITE_SECURE_DELETE
-DSQLITE_ENABLE_UNLOCK_NOTIFY=1
-DSQLITE_ENABLE_DBSTAT_VTAB=1"
: Applications such as
Firefox require secure delete and
enable unlock notify to be turned on. Since firefox-41 the dbstat virtual table is also
required. The only way to do this is to include them in the CFLAGS.
By default, these are set to "-g -O2"
so we specify that to preserve those settings. You may, of course,
wish to omit the '-g'
if you do not
wish to create debugging information. For further information on
what can be specified see http://www.sqlite.org/compile.html.
Last updated on 2016-02-21 12:38:55 -0800