8.52. Sqlite-3500400

Le paquet Sqlite est une bibliothèque logicielle qui implémente un moteur de base de données SQL auto-contenue, sans serveur, sans configuration et transactionnel.

Temps de construction approximatif: 0,4 SBU
Espace disque requis: 71 Mo

8.52.1. Installation of Sqlite

Unpack the documentation:

tar -xf ../sqlite-doc-3500400.tar.xz

Prepare Sqlite for compilation with:

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

The meaning of the make option:

--enable-fts{4,5}

These switches enable support for version 4 and 5 of the full text search (FTS) extension.

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.

Compile the package:

make

This package does not come with a test suite.

Install the package:

make install

If desired, install the documentation:

install -v -m755 -d /usr/share/doc/sqlite-3.50.4
cp -v -R sqlite-doc-3500400/* /usr/share/doc/sqlite-3.50.4

8.52.2. Contents of Sqlite

Installed programs: sqlite3
Installed libraries: libsqlite3.so
Installed directories: /usr/share/doc/sqlite-3.50.4

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