sqlite-amalgamation

• Release History
• Chronology

This repository mirrors the SQLite
amalgamation, which is the recommended method of building SQLite into larger
projects.
It also supports cmake for building, installing and exporting.

SQLite includes more than 100 files in *.c / *.h, but

The amalgamation contains
everything you need to integrate SQLite into a larger project. Just copy the
amalgamation into your source directory and compile it along with the other C
code files in your project.
(A more detailed discussion of the
compilation process is available.) You may also want to make use of
the “sqlite3.h” header file that defines the programming API for SQLite. The
sqlite3.h header file is available separately. The sqlite3.h file is also
contained within the amalgamation, in the first few thousand lines. So if you
have a copy of sqlite3.c but cannot seem to locate sqlite3.h, you can always
regenerate the sqlite3.h by copying and pasting from the amalgamation.

build / install

A static lib (libsqlite3) and the sqlite3 shell will be generated by the build
system.

$> mkdir .build
$> cd .build
$> cmake /path/to/this/repo  # or cmake .. -G Ninja
$> ccmake .                  # for build options or cmake-gui .
$> make -j 2                 # or ninja
$> make install

usage

to integrate this library into your project simply add these lines to your project
cmake:

find_package(SQLite3 REQUIRED CONFIG)
target_link_libraries(${PROJECT_NAME} SQLite::SQLite3)

the include directory and link library will be automatically added to your target.
If you need to switch your project to use “standard” SQLite remove CONFIG option
in find_package function call.

SQLite3 build options

SQLite3 comes with plenty of
compile options

following cmake build options control some of those compile options:

these recommended compile options are also passed to the compiler by
SQLITE_RECOMMENDED_OPTIONS (on by default):

all compile-time options will go into sqlite3_config.h, you may
use this file to check these options when building your application.

the SQLite3 shell (executable) is disabled by default, to build it just
activate the BUILD_SHELL option.