Gaming Linux® From Scratch (System V Edition) - Version #f2b2

Chapter 3. Shared Dependencies

SQLite-3.49.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 required by Firefox.

Package Information

SQLite Dependencies

Optional

libedit

Installation of SQLite

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

Command Explanations

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

Contents

Installed Program: sqlite3
Installed Library: libsqlite3.so
Installed Directory: None

Short Descriptions

sqlite3

is 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