Naughter Software Logo

SQLiteWrappers v1.08 A set of C++ classes to encapsulate SQLite

Welcome to SQLiteWrappers, a set of C++ classes to encapsulate SQLite v3. The code below shows a simple example to open a database and add a row to a table called "tblTest" with one text column (without any error handling!):

 

SQLite3:CDB db;
db.Open16(L"database.db");
db.Exec("INSERT INTO tblTest VALUES ('sample text');");

 

Here's a further example to run a simple parameterized query to do an INSERT on the previously mentioned "tblTest":

SQLite3::CStatment stmt;
stmt.Prepare16v2(db, L"INSERT INTO tblTest VALUES(?);");
char* szData = "More Sample Text";
stmt.Bind(1, szData);
stmt.Step();

 

The classes provided are as follows:

 

 

Features

 

The enclosed zip file contains the SQLiteWrappers source code and a simple VC 2010 console based application which demonstrates most of the classes functionality.

 

Copyright

 

Updates

V1.08 (20 August 2017)

V1.07 (29 April 2017)

V1.06 (18 March 2017)

V1.05 (25 March 2016)

V1.04 (23 February 2013)

V1.03 (21 July 2012)

V1.02 (7 July 2012)

V1.01 (28 June 2012)

V1.0 (13 June 2012)