Beyond Linux® From Scratch (systemd Edition) - Version 9.1

Chapter 22. Databases

SQLite-3.31.1

Introduction to SQLite

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-9.1 platform.

Package Information

Additional Downloads

Optional Documentation

SQLite Dependencies

Optional

libedit and UnZip-6.0 (required to unzip the documentation)

User Notes: http://wiki.linuxfromscratch.org/blfs/wiki/sqlite

Installation of SQLite

If you downloaded the optional documentation, issue the following command to install the documentation into the source tree: 

unzip -q ../sqlite-doc-3310100.zip

Install SQLite by running the following commands: 

./configure --prefix=/usr     \
            --disable-static  \
            --enable-fts5     \
            CFLAGS="-g -O2                    \
            -DSQLITE_ENABLE_FTS3=1            \
            -DSQLITE_ENABLE_FTS4=1            \
            -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.31.1 &&
cp -v -R sqlite-doc-3310100/* /usr/share/doc/sqlite-3.31.1

Command Explanations

--disable-static: This switch prevents installation of static versions of the libraries.

--enable-fts5: enable version 5 of the full text search extension.

CFLAGS="-g -O2 -DSQLITE_ENABLE_FTS3=1 -DSQLITE_ENABLE_FTS3_TOKENIZER=1 -DSQLITE_ENABLE_FTS4=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 and FTS3/4 are also required. The only way to do this is to include them in the CFLAGS. Also, since Thunderbird-52.5.0, the dual-argument FTS3 tokenizer is required. 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.

Contents

Installed Program: sqlite3
Installed Library: libsqlite3.so
Installed Directory: /usr/share/doc/sqlite-3.31.1

Short Descriptions

sqlite3

A terminal-based front-end to the SQLite library that can evaluate queries interactively and display the results.

libsqlite3.so

contains the SQLite API functions.

Last updated on 2020-02-15 08:54:30 -0800