Beyond Linux® From Scratch - Version 2012-01-16

Chapter 21. Databases

SQLite-3.7.8

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

Package Information

  • Download (HTTP): http://sqlite.org/sqlite-autoconf-3070800.tar.gz

  • Download MD5 sum: 6bfb46d73caaa1bbbcd2b52184b6c542

  • Download size: 1.7 MB

  • Estimated disk space required: 46 MB (includes optional documentation)

  • Estimated build time: 0.4 SBU

Additional Downloads

Optional Documentation

SQLite Dependencies

Optional

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

Install SQLite by running the following commands: 

CFLAGS="-g -O2 -DSQLITE_SECURE_DELETE -DSQLITE_ENABLE_UNLOCK_NOTIFY=1" \
            ./configure --prefix=/usr \
            --enable-threadsafe \
            --enable-readline \
            --enable-dynamic-extensions &&
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.7.8 &&
cp      -v -R       sqlite-doc-3070800/* \
                    /usr/share/doc/sqlite-3.7.8

Command Explanations

CFLAGS="-g -O2 -DSQLITE_SECURE_DELETE -DSQLITE_ENABLE_UNLOCK_NOTIFY=1" : Applications such as firefox require secure delete and enable unlock notify to be turned on. 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.

--enable-threadsafe: Though the documentation and running ./configure --help indicate that this is the default, it is not. You must add this parameter if you want a threadsafe library.

--enable-readline: This parameter enables command line editing capability to the sqlite3 program.

--enable-dynamic-extensions: This creates library modules that are dynamically linked as needed instead of statically linking them into the main SQLite library.

Contents

Installed Program: sqlite3
Installed Library: libsqlite3.{so,a}
Installed Directories: None

Short Descriptions

sqlite3

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

libsqlite3.{so,a}

Contains the SQLite API functions.

Last updated on 2011-10-30 02:40:46 +0000