On this page you can read all about added features, bugfixes and other changes.
After you read this you can decide whether it is necessary to upgrade to a newer version. ; )


version 1.13.15 (31.03.2024)
- added void SQLiteDatabase::Interrupt()
- added bool SQLiteDatabase::IsInterruptInEffect()
- added 64-bit build configurations in Visual Studio 2019 project files
- updated sqlite to version 3.45.2

version 1.12.15 (03.10.2021)
- usage of MIT license starting with version 1.12.15
- added int SQLiteDatabase::GetTransactionState()
- added void SQLiteDatabase::DropModules()
- added Visual Studio 2019 project files
- fixed a bug in SQLiteStatement::SqlAggregateFuncResult() - removed the unnecessary double
   to float cast because in some cases the numeric result could differ minimally from the correct
   value - as a result the return data type of SqlAggregateFuncResult() changed to double
- updated sqlite to version 3.36.0

version 1.11.14 (17.03.2017)
- added Visual Studio 2017 project files
- ensured upgradability from NetBeans IDE 7 to NetBeans IDE 8
- updated sqlite to version 3.17.0

version 1.11.13 (20.09.2015)
- added SQLiteStatement::BindBlob64()
- added SQLiteStatement::BindString64()
- added SQLiteStatement::BindZeroBlob64()
- moved int64 and uint64 to Kompex namespace
- fixed a bug in SQLiteDatabase::TakeSnapshot() - in case of an error during the save process
   in SQLiteDatabase::SaveDatabaseFromMemoryToFile() it was not possible to close the database
   properly (error message: unable to close due to unfinalized statements or unfinished backups)
- updated sqlite to version 3.8.11.1

version 1.10.12 (20.04.2014)
- enabled "Extended Result Codes"
- added int SQLiteException::GetSqliteResultCode()
- added std::string SQLiteException::GetErrorDescription()
- added std::string SQLiteException::GetFilename()
- added unsigned int SQLiteException::GetLineNumber()
- added int SQLiteDatabase::GetNumberOfCheckedOutLookasideMemorySlots()
- added int SQLiteDatabase::GetHeapMemoryUsedByPagerCaches()
- added int SQLiteDatabase::GetHeapMemoryUsedToStoreSchemas()
- added int SQLiteDatabase::GetHeapAndLookasideMemoryUsedByPreparedStatements()
- added int SQLiteDatabase::GetPagerCacheHitCount()
- added int SQLiteDatabase::GetPagerCacheMissCount()
- added int SQLiteDatabase::GetNumberOfDirtyCacheEntries()
- added int SQLiteDatabase::GetNumberOfUnresolvedForeignKeys()
- added int SQLiteDatabase::GetHighestNumberOfCheckedOutLookasideMemorySlots(bool resetValue)
- added int SQLiteDatabase::GetLookasideMemoryHitCount(bool resetValue)
- added int SQLiteDatabase::GetLookasideMemoryMissCountDueToSmallSlotSize(bool resetValue)
- added int SQLiteDatabase::GetLookasideMemoryMissCountDueToFullMemory(bool resetValue)
- updated sqlite to version 3.8.4.3

version 1.9.11 (23.02.2013)
- added SQLiteDatabase::CreateModule()
- MoveDatabaseToMemory() can move UTF-16 named databases now
- MoveDatabaseToMemory() can move data with UTF-8 or UTF-16 encoding now (default usage is UTF-8)
- SaveDatabaseFromMemoryToFile() can save the database into a UTF-16 named database now
- upgraded and updated NetBeans IDE 6 project files to NetBeans IDE 7
- updated sqlite to version 3.7.15.2

version 1.8.10 (31.03.2012)
- added bool SQLiteDatabase::IsDatabaseReadOnly()
- added void SQLiteDatabase::ReleaseMemory()
- added static std::string Mprintf(const char *sql, ...)
- added static std::string Vmprintf(const char *sql, va_list args)
- fixed bug in SQLiteStatement::GetColumnString() - return of a NULL value caused an access violation
- improved documentation
- updated sqlite to version 3.7.11

version 1.7.9 (02.12.2011)
- more detailed error output in SQLiteDatabase class
- fixed bug in SQLiteDatabase::MoveDatabaseToMemory() - it was not possible to move
   a database to memory if the AUTOINCREMENT feature was used
- updated sqlite to version 3.7.9

version 1.7.8 (14.05.2011)
- removed void SQLiteStatement::FreeAllStatements()
  (please use FreeQuery() instead of the removed method now)
- fixed bug in SQLiteStatement::~SQLiteStatement() which caused that all with the database
  associated statements were deleted

version 1.7.7 (04.05.2011)
- moved int64 and uint64 typedefs from KompexSQLiteStatement.h to KompexSQLitePrerequisites.h
- added Kompex::SQLiteBlob class (responsible for the administration of existing BLOBs)
    - added SQLiteBlob::OpenBlob()
    - added SQLiteBlob::CloseBlob()
    - added SQLiteBlob::GetBlobSize()
    - added SQLiteBlob::ReadBlob()
    - added SQLiteBlob::WriteBlob()
    - added SQLiteBlob::GetBlobHandle()
- added Kompex::SQLiteBlob example
- updated sqlite to version 3.7.6.2

version 1.6.6 (16.04.2011)
- added void SQLiteStatement::BindBool(int column, bool value)
- added bool SQLiteStatement::GetColumnBool(int column)
- added bool SQLiteStatement::GetColumnBool(const std::string &column)
- added sqlite3_stmt *SQLiteStatement::GetStatementHandle()
- added void SQLiteStatement::Execute()
  (repetitive execution of prepared INSERT/UPDATE/DELETE statements is now possible)
- added an example for UPDATE statements
- added an example for the repetitive execution of prepared INSERT/UPDATE/DELETE statements
- updated sqlite to version 3.7.6.1

version 1.5.5 - (22.02.2011)
- fixed bug in SQLiteStatement::GetSqlResultCString()
- fixed bug in SQLiteStatement::GetSqlResultString16()
- fixed bug in SQLiteStatement::GetSqlResultBlob()

version 1.5.4 - (07.02.2011)
- added SQLiteStatement::SqlStatement(const std::wstring &sqlStatement)
- added SQLiteStatement::Sql(const std::wstring &sql)
- added SQLiteStatement::GetColumn%(const std::string &column) methods so that it is
   possible to get the result values via column name
- added and improved out of range checks for all GetColumn%() methods
- added GetColumn%(const std::string &column) example
- updated sqlite to version 3.7.5

version 1.4.3 - (17.10.2010)
- fixed bug in SQLiteException class
- moved sqlite3.h include due to compilation issues
- added SQLITE_ENABLE_RTREE define
- updated sqlite to version 3.7.3

version 1.4.1 - (13.08.2010)
- added SQLiteStatement::GetNumberOfRows()
- added SQLiteStatement::GetSqlResultString()
- added SQLiteStatement::GetSqlResultInt()
- added SQLiteStatement::GetSqlResultInt64()
- added SQLiteStatement::GetSqlResultDouble()
- added SQLiteStatement::GetSqlResultCString()
- added SQLiteStatement::GetSqlResultString16()
- added SQLiteStatement::GetSqlResultBlob()
- added GetSqlResult%() example
- added Visual Studio 2010 project files
- updated sqlite to version 3.7.0.1
- moved SQLITE_ENABLE_COLUMN_METADATA define from project file to sqlite3.c

version 1.3.1 - (15.07.2010)
- added SQLiteStatement::Reset()
- added optional parameter numberOfBytes in SQLiteStatement::BindBlob()
- added prepared statement example

version 1.2.1 - (02.07.2010)
- added SQLiteDatabase::GetLastInsertRowId()
- added SQLiteDatabase::GetMemoryUsage()
- added SQLiteDatabase::GetMemoryHighwaterMark()

version 1.1.1 - (03.06.2010)
- added SQLiteDatabase::MoveDatabaseToMemory()
- added SQLiteDatabase::SaveDatabaseFromMemoryToFile()
- fixed bug in SQLiteStatement::GetTable()

version 1.0.0 - (22.05.2010)
- public release