/NLDatabase

Lightweight C++ wrapper for SQLite

MIT LicenseMIT

NLDatabase

Lightweight C++ wrapper for SQLite.

Requirements

  • C++11 compiler
  • SQLite 3

Usage

Let's open a database file and read some rows:

#include "NLDatabase.h"


using namespace std;
using namespace NL::DB;


int main(int argc, const char * argv[]) {

    Database db( "test.sqlite" );
    
    auto results = db.query("SELECT * FROM test WHERE name <> ?", "TOM" );
    
    for ( auto & row : results ) {
        cout << "column[0]=" << row.column_string( 0 ) << endl;
    }
}

Installation

It's a single header, just drop into your project, link sqlite3 and that's it.

Demo

To run the simple demo, use the Xcode project or build it on the command line like this:

sqlite3 test.sqlite < test.sql
clang -o test -std=c++11 -lsqlite3 -lstdc++ main.cpp
./test

Known problems

  • There is no error checking. None. Your queries must be perfect. Also, patches are welcome.
  • If you look at the way the results are retrieved, you will realize that you can only iterate through them ONCE. I didn't see an obvious way to express this in code and make it impossible syntactically, so it's simply something you need to keep in mind.

See also

Goes well with NLTemplate and possibly Mongoose.