Overview

HTTPS SSH

libsl3, the convenient C++11 interface for SQLite 3.x

libsl3 is designed to enable a comfortable and efficient communication with SQLite 3.x database based on its natural language, which is SQL.

Tested - with 100% code coverage - on:

  • travis-ci: Build Status
  • gcc (Ubuntu 4.8.4-2ubuntu1~14.04.3) 4.8.4, clang version 3.5.0
  • Apple LLVM version 9.1.0 (clang-902.0.39.1)
  • Visual Studio 2015 Build status
  • various newer gcc and clang versions on differnt Linux distributions (RHEL, SUSE, Slackware)

A short usage example

#include <cassert>
#include <iostream>
#include <sl3/database.hpp>

int main()
{
  using namespace sl3;
  // define a db
  Database db(":memory:");
  // run commands against the db
  db.execute("CREATE TABLE tbl(f1 INTEGER, f2 TEXT, f3 REAL);");
  // create a command with parameters
  auto cmd = db.prepare("INSERT INTO tbl (f1, f2, f3) VALUES (?,?,?);");

  //add some data
  cmd.execute(parameters(1, "one", 1.1));
  cmd.execute(parameters(2, "two", 2.2));

  // access the data
  Dataset ds = db.select("SELECT * FROM tbl;");

  // Dataset is a container
  assert(ds.size()==2);

  // A row in a dataset is a container
  auto row = ds[0] ;
  assert(row.size()==3);
  assert ( row[0].type() == Type::Int ) ;
  assert ( row[1].type() == Type::Text ) ;
  assert ( row[2].type() == Type::Real ) ;

  // of course there is also iterator access
  for(const auto& row  :ds) {

      for (const auto& field : row) {
          std::cout << field << " " ;
      }
      std::cout << std::endl;
  }
}

this will output as expected

1 one 1.1
2 two 2.1

Additional samples can be found in the tests and tests/sampes subfolder.

Build requirements

  • CMake, libsl3 builds uses cmake
  • doxygen, optional, for building the documentation

libsl3 inlcudes sqlite, but it can also build and link with an existing sqlite installation.
This is controlled via cmake and the USE_INTERNAL_SQLITE3 variable, which is by default true.

Addtitional information

The online documentation for libsl3 can be found here: http://a4z.bitbucket.io/docs/libsl3/html/index.html

License: https://www.mozilla.org/en-US/MPL/2.0/