Repository files navigation

SQLiteC++ (SQLiteCpp) is a lean and easy to use C++ SQLite3 wrapper.

SQLiteC++ offers an encapsulation around the native C APIs of SQLite,with a few intuitive and well documented C++ classes.

Copyright (c) 2012-2025 Sébastien Rombauts (sebastien.rombauts@gmail.com)

Distributed under the MIT License (MIT) (See accompanying file LICENSE.txtor copy athttp://opensource.org/licenses/MIT)

As stated by the MIT License, you are welcome to reuse, modify, and redistribute the SQLiteCpp source codethe way you want it to, be it a git submodule, a subdirectory, or a selection of some source files.

I would love a mention in your README, a web link to the SQLite repository, and a mention of the author,but none of those are mandatory.

SQLite is a library that implements a serverless transactional SQL database engine.It is the most widely deployed SQL database engine in the world.All of the code and documentation in SQLite has been dedicated to the public domain by the authors.http://www.sqlite.org/about.html

• to offer the best of the existing simple C++ SQLite wrappers
• to be elegantly written with good C++11 design, STL, exceptions and RAII idiom
• to keep dependencies to a minimum (C++11 STL and SQLite3)
• to be portable
• to be light and fast
• to be thread-safe only as much as SQLite "Multi-thread" mode (see below)
• to have a good unit test coverage
• to use API names sticking with those of the SQLite library
• to be well documented with Doxygen tags, and with some good examples
• to be well maintained
• to use a permissive MIT license, similar to BSD or Boost, for proprietary/commercial usage

It is designed using the Resource Acquisition Is Initialization (RAII) idiom(seehttp://en.wikipedia.org/wiki/Resource_Acquisition_Is_Initialization),and throwing exceptions in case of SQLite errors (except in destructors,where assert() are used instead).Each SQLiteC++ object must be constructed with a valid SQLite database connection,and then is always valid until destroyed.

Now requires a C++11 compiler. Use branchsqlitecpp-2.x for latest pre-C++11 developments.

Developments and tests are done under the following OSs:

• Ubuntu 14.04, 16.04 and 18.04 (Travis CI and Github Actions)
• Windows 10, and Windows Server 2012 R2, Windows Server 2016, Windows Server 2022 (AppVeyor and Github Actions)
• MacOS 10.11 and 11.7 (Travis CI and Github Actions)
• Valgrind memcheck tool

And the following IDEs/Compilers

• GCC 4.8.4, 5.3.0, 7.1.1 and latest eg 9.4 (C++11, C++14, C++17)
• Clang 5 and 7 (Travis CI)
• AppleClang 8, 9 and 13 (Travis CI and Github Actions)
• Xcode 8 & 9 (Travis CI)
• Visual Studio Community/Entreprise 2022, 2019, 2017, and 2015 (AppVeyor and Github Actions)

• a modern C++11 STL implementation with GCC, Clang, or Visual Studio 2015
• exception support (the class Exception inherits from std::runtime_error)
• the SQLite library (3.7.15 minimum from 2012-12-12) either by linking to it dynamically or statically (install the libsqlite3-dev package under Debian/Ubuntu/Mint Linux),or by adding its source file in your project code base (source code provided in src/sqlite3 for Windows),with theSQLITE_ENABLE_COLUMN_METADATA macro defined (seehttp://www.sqlite.org/compile.html#enable_column_metadata).

To use this wrapper, you need to add the SQLiteC++ source files from the src/ directoryin your project code base, and compile/link against the sqlite library.

The easiest way to do this is to add the wrapper as a library.The "CMakeLists.txt" file defining the static library is provided in the root directory,so you simply have to add_subdirectory(SQLiteCpp) to you main CMakeLists.txtand link to the "SQLiteCpp" wrapper library.

Example for Linux:

add_subdirectory(${CMAKE_CURRENT_LIST_DIR}/thirdparty/SQLiteCpp)add_executable(main src/main.cpp)target_link_libraries(main  SQLiteCpp  sqlite3  pthread  dl  )

Thus this SQLiteCpp repository can be directly used as a Git submodule.See theSQLiteCpp_Example side repository for a standalone "from scratch" example.

Under Debian/Ubuntu/Mint Linux, you can install the libsqlite3-dev package if you don't want to use the embedded sqlite3 library.

Use git to clone the repository. Then init and update submodule "googletest".

git clone https://github.com/SRombauts/SQLiteCpp.gitcd SQLiteCppgit submodule initgit submodule update

Alternatively, you can build and install SQLiteCpp usingvcpkg dependency manager:

git clone https://github.com/Microsoft/vcpkg.gitcd vcpkg./bootstrap-vcpkg.sh./vcpkg integrate install./vcpkg install sqlitecpp

The SQLiteCpp port in vcpkg is kept up to date by Microsoft team members and community contributors. If the version is out of date, pleasecreate an issue or pull request on the vcpkg repository.

If you installed this package to your system, aSQLiteCppConfig.cmake file will be generated & installed to your system.
This file lets you link against the SQLiteCpp library for use in your Cmake project.

Here's an example of using this in your CMakeLists.txt

# You can optionally define a minimum version in this callfind_package(SQLiteCpp REQUIRED)# For this example, lets say you created an target with add_executable (or add_library) called "my_target"# You can optionally declare PUBLIC or PRIVATE linkage here, depending on your needs.target_link_libraries(my_targetPRIVATE SQLiteCpp)

A CMake configuration file is also provided for multi-platform support and testing.

Typical generic build for MS Visual Studio under Windows (frombuild.bat):

mkdir buildcd buildcmake ..        # cmake .. -G"Visual Studio 16 2019"    #for Visual Studio2019@REM Generate a Visual Studio solution for latest version foundcmake -DSQLITECPP_BUILD_EXAMPLES=ON -DSQLITECPP_BUILD_TESTS=ON ..@REM Build default configuration (ie 'Debug')cmake --build .@REM Build and run testsctest --output-on-failure

Generating the Linux Makefile, building in Debug and executing the tests (frombuild.sh):

mkdir Debugcd Debug# Generate a Makefile for GCC (or Clang, depanding on CC/CXX envvar)cmake -DSQLITECPP_BUILD_EXAMPLES=ON -DSQLITECPP_BUILD_TESTS=ON ..# Build (ie 'make')cmake --build.# Build and run unit-tests (ie 'make test')ctest --output-on-failure

You can build SQLiteCpp withmeson using the provided meson project.

you can install meson using pip:pip install meson however you may need to install ninja and other dependencies depending on your platform as an compiler toolchain

Arch Linux:

# install clang (compiler toolchain) and ninja (recommended build system)sudo pacman -Syu clang ninja# install python and pip (required for meson)sudo pacman -Syu python python-pip# install mesonpip install meson

Ubuntu:

# install gcc(compiler toolchain) and ninja (recommended build system)sudo apt install build-essential ninja-build# install python and pip (required for meson)sudo apt install python3 python3-pip# install mesonpip install meson

for example you can build the library using the default options with:

# setup the build directorymeson setup builddir# build sqlitecppmeson compile -C builddir

or if you wish to build with tests and examples:

# setup the build directory with tests and examples enabledmeson setup builddir -DSQLITECPP_BUILD_TESTS=true -DSQLITECPP_BUILD_EXAMPLES=true# build sqlitecppmeson compile -C builddir

please check the examples in the examples folder for usage of SQLiteCpp as a subproject in meson, as for the wrap file you can use the one provided in the subprojects folder calledSQLiteCpp.wrap

keep in mind that even that this wrap should be up to date, it is recommended to check the latest version of SQLiteCpp and update the wrap file accordingly

additionally meson can detect and use the bundled sqlitecpp library included on your system if available, for example with vcpkg you would need to set thePKG_CONFIG_PATH environment variable to the vcpkg directory before running meson setup, and if applies the correspondingPKG-CONFIG executable to the path.

Make sure you have Dogygen installed and configure CMake using theSQLITECPP_RUN_DOXYGEN=ON flag:

cmake -DSQLITECPP_RUN_DOXYGEN=ON   <MORE ARGUMENTS_HERE>

and then execute theSQLiteCpp_doxygen target (or build all targets, see above).The documentation will be generated in the 'doc' subfolder of the source tree.

• For more options on customizing the build, see theCMakeLists.txt file.

Under Linux, if you get multiple linker errors like "undefined reference to sqlite3_xxx",it's that you lack the "sqlite3" library: install the libsqlite3-dev package.

If you get a single linker error "Column.cpp: undefined reference to sqlite3_column_origin_name",it's that your "sqlite3" library was not compiled withtheSQLITE_ENABLE_COLUMN_METADATA macro defined (seehttp://www.sqlite.org/compile.html#enable_column_metadata).You can:

• either recompile the sqlite3 library provided by your distribution yourself (seek help online)
• or turn off theoption(SQLITE_ENABLE_COLUMN_METADATA "Enable Column::getColumnOriginName(). Require support from sqlite3 library." ON) inCMakeFiles.txt (or other build system scripts)
• or turn on theoption(SQLITECPP_INTERNAL_SQLITE "Add the internal SQLite3 source to the project." ON) inCMakeFiles.txt

This project is continuously tested under Ubuntu Linux with the gcc and clang compilersusing the Travis CI community service with the above CMake building and testing procedure.It is also tested in the same way under Windows Server 2012 R2 with Visual Studio 2013 compilerusing the AppVeyor continuous integration service.

Detailed results can be seen online:

• https://travis-ci.org/SRombauts/SQLiteCpp
• https://ci.appveyor.com/project/SbastienRombauts/SQLiteCpp

SQLite supports three modes of thread safety, as describe in "SQLite And Multiple Threads":seehttp://www.sqlite.org/threadsafe.html

This SQLiteC++ wrapper does no add any locks (no mutexes) nor any other thread-safety mechanismabove the SQLite library itself, by design, for lightness and speed.

Thus, SQLiteC++ naturally supports the "Multi Thread" mode of SQLite:"In this mode, SQLite can be safely used by multiple threadsprovided that no single database connection is used simultaneously in two or more threads."

But SQLiteC++ does not support the fully thread-safe "Serialized" mode of SQLite,because of the way it shares the underlying SQLite precompiled statementin a custom shared pointer (See the inner class "Statement::Ptr").

Run valgrind to search for memory leaks in your application, the SQLiteCpp wrapper, or the sqlite3 library.Execute the following command under Unix like OS (Linux, MacOS or WSL2/Ubuntu under Windows Subsystem for Linux):

valgrind --leak-check=full --show-leak-kinds=all --track-origins=yes --verbose build/SQLiteCpp_example1

or uncoment the line at the end ofbuild.sh

try{// Open a database file    SQLite::Databasedb("example.db3");// Compile a SQL query, containing one parameter (index 1)    SQLite::Statementquery(db,"SELECT * FROM test WHERE size > ?");// Bind the integer value 6 to the first parameter of the SQL query    query.bind(1,6);// Loop to execute the query step by step, to get rows of resultwhile (query.executeStep())    {// Demonstrate how to get some typed column valueint         id      = query.getColumn(0);constchar* value   = query.getColumn(1);int         size    = query.getColumn(2);                std::cout <<"row:" << id <<"," << value <<"," << size << std::endl;    }}catch (std::exception& e){    std::cout <<"exception:" << e.what() << std::endl;}

try{    SQLite::Databasedb("transaction.db3", SQLite::OPEN_READWRITE|SQLite::OPEN_CREATE);    db.exec("DROP TABLE IF EXISTS test");// Begin transaction    SQLite::Transactiontransaction(db);    db.exec("CREATE TABLE test (id INTEGER PRIMARY KEY, value TEXT)");int nb = db.exec("INSERT INTO test VALUES (NULL,\"test\")");    std::cout <<"INSERT INTO test VALUES (NULL,\"test\")\", returned" << nb << std::endl;// Commit transaction    transaction.commit();}catch (std::exception& e){    std::cout <<"exception:" << e.what() << std::endl;}

try {     SQLite::Databasedb("test.db3", SQLite::OPEN_READWRITE|SQLite::OPEN_CREATE);    db.exec("DROP TABLE IF EXISTS test");    db.exec("CREATE TABLE test (value INTEGER)");// Begin transaction    SQLite::Transactiontransaction(db);// Prepare query    SQLite::Statement query {db,"INSERT INTO test (value) VALUES (?)"};// Collection to save in database    std::vector<int> values{1,2,3};for (constauto& v: values)    {      query.bind(1, v);      query.exec();      query.reset();    }// Commit transaction    transaction.commit();}catch (std::exception& e){  std::cout <<"exception:" << e.what() << std::endl;}

Exceptions shall not be used in destructors, so SQLiteC++ uses SQLITECPP_ASSERT() to check for errors in destructors.If you don't want assert() to be called, you have to enable and define an assert handler as shown below,and by setting the flag SQLITECPP_ENABLE_ASSERT_HANDLER when compiling the lib.

#ifdef SQLITECPP_ENABLE_ASSERT_HANDLERnamespaceSQLite{/// definition of the assertion handler enabled when SQLITECPP_ENABLE_ASSERT_HANDLER is defined in the project (CMakeList.txt)voidassertion_failed(constchar* apFile,constlong apLine,constchar* apFunc,constchar* apExpr,constchar* apMsg){// Print a message to the standard error output stream, and abort the program.    std::cerr << apFile <<":" << apLine <<":" <<" error: assertion failed (" << apExpr <<") in" << apFunc <<"() with message\"" << apMsg <<"\"\n";std::abort();}}#endif

The most efficient way to help and contribute to this wrapper project is touse the tools provided by GitHub:

• please fill bug reports and feature requests here:https://github.com/SRombauts/SQLiteCpp/issues
• fork the repository, make some small changes and submit them with pull-request

You can also email me directly, I will try to answer questions and requests whenever I get the time for it.

The source code use the CamelCase naming style variant where:

• type names (class, struct, typedef, enums...) begin with a capital letter
• files (.cpp/.h) are named like the class they contain
• function and variable names begin with a lower case letter
• member variables begin with a 'm', function arguments begin with a 'a', booleans with a 'b', pointers with a 'p'
• each file, class, method and member variable is documented using Doxygen tags
• braces on their own lineSee alsohttp://www.appinf.com/download/CppCodingStyleGuide.pdf for good guidelines

See bellow a short comparison of other wrappers done at the time of writing:

• sqdbcpp: RAII design, simple, no dependencies, UTF-8/UTF-16, new BSD license
• sqlite3cc: uses boost, modern design, LPGPL
• sqlite3pp: modern design inspired by boost, MIT License
• SQLite++: uses boost build system, Boost License 1.0
• CppSQLite: famous Code Project but old design, BSD License
• easySQLite: manages table as structured objects, complex
• sqlite_modern_cpp: modern C++11, all in one file, MIT license
• sqlite_orm: modern C++14, header only all in one file, no raw string queries, BSD-3 license