wxSQLite3 is a C++ wrapper around the public domain SQLite 3.x database and is specifically designed for use in programs based on the wxWidgets library.
wxSQLite3 does not try to hide the underlying database, in contrary almost all special features of the current SQLite3 version are supported, like for example the creation of user defined scalar or aggregate functions.
Since SQLite stores strings in UTF-8 encoding, the wxSQLite3 methods provide automatic conversion between wxStrings and UTF-8 strings. This works best for the Unicode builds of wxWidgets. In ANSI builds the current locale conversion object (wxConvCurrent) is used for conversion to/from UTF-8. Special care has to be taken if external administration tools are used to modify the database contents, since not all of these tools operate in Unicode or UTF-8 mode.
Since version 1.7.0 wxSQLite3 includes a key-based SQLite3 encryption extension using AES encryption. The decision whether to use 128 bit or 256 bit AES encryption had to be made at compile time. Starting with version 4.0.0 the encryption extension allows to select the cipher scheme at runtime.
Currently the following encryption schemes are supported:
- AES 128 Bit CBC - No HMAC (wxSQLite3)
- AES 256 Bit CBC - No HMAC (wxSQLite3)
- ChaCha20 - Poly1305 HMAC (sqleet) (default)
- AES 256 Bit CBC - SHA1/SHA256/SHA512 HMAC (SQLCipher versions 1 - 4)
- RC4 - No HMAC (System.Data.SQLite)
With the release of SQLite version 3.32.0 on May 22, 2020 critical changes to the public SQLite code finally took officially effect, although they weren't officially announced. They were introduced on Feb 7, 2020: "Simplify the code by removing the unsupported and undocumented SQLITE_HAS_CODEC compile-time option". As a consequence, updating the wxSQLite3 encryption extension to support SQLite version 3.32.0 and later was no longer possible.
Since August 2020 a new implementation of an encryption extension, capable of supporting SQLite version 3.32.0 and later, is available as a separate project, SQLite3 Multiple Ciphers. Starting with the release of wxSQLite3 4.6.0 this new implementation is used.
- Version history
- Installation
- Optional features
- Key based database encryption support
- Static SQLite library
- License
- Acknowledgements
- 4.9.3 - March 2023
- Upgrade to SQLite3 Multiple Ciphers version 1.6.1 (SQLite version 3.41.1)
- 4.9.2 - February 2023
- Upgrade to SQLite3 Multiple Ciphers version 1.6.0 (SQLite version 3.41.0)
- Enhanced method wxSQLite3Database::Open allowing to set the VFS to be used
- Added method wxSQLite3Database::IsInterrupted
- 4.9.1 - November 2022
- Upgrade to SQLite3 Multiple Ciphers version 1.5.4 (SQLite version 3.40.0)
- 4.9.0 - September 2022
- Upgrade to SQLite3 Multiple Ciphers version 1.5.3 (SQLite version 3.39.3)
- 4.8.2 - July 2022
- Upgrade to SQLite3 Multiple Ciphers version 1.4.6 (SQLite version 3.39.1)
- 4.8.1 - May 2022
- Upgrade to SQLite3 Multiple Ciphers version 1.4.3 (SQLite version 3.38.5)
- 4.8.0 - April 2022
- Upgrade to SQLite3 Multiple Ciphers version 1.4.2 (SQLite version 3.38.3)
- 4.7.9 - April 2022
- Upgrade to SQLite3 Multiple Ciphers version 1.3.10 (SQLite version 3.38.2)
- 4.7.8 - March 2022
- Upgrade to SQLite3 Multiple Ciphers version 1.3.9 (SQLite version 3.38.1)
- 4.7.7 - February 2022
- Upgrade to SQLite3 Multiple Ciphers version 1.3.8 (SQLite version 3.38.0)
- 4.7.6 - January 2022
- Upgrade to SQLite3 Multiple Ciphers version 1.3.7 (SQLite version 3.37.2)
- 4.7.5 - November 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.3.5 (SQLite version 3.37.0)
- Added build support for Visual C++ 2022
- 4.7.4 - July 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.3.4 (SQLite version 3.36.0)
- 4.7.3 - June 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.3.3 (SQLite version 3.36.0)
- 4.7.2 - May 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.3.2 (SQLite version 3.35.5)
- 4.7.1 - April 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.3.1 (SQLite version 3.35.5)
- 4.7.0 - April 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.3.0 (SQLite version 3.35.5)
- 4.6.10 - April 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.2.5 (SQLite version 3.35.5)
- 4.6.9 - April 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.2.4 (SQLite version 3.35.4)
- 4.6.8 - March 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.2.3 (SQLite version 3.35.3)
- 4.6.7 - March 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.2.2 (SQLite version 3.35.2)
- 4.6.6 - March 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.2.1 (SQLite version 3.35.1)
- 4.6.5 - March 2021
- Upgrade to SQLite3 Multiple Ciphers version 1.2.0 (SQLite version 3.35.0)
- Enabled new SQLite Math Extension
- Fixed a memory leak in method wxSQLite3Database::GetTable
- Adjusted build files (DLL builds with MinGW/GCC used wrong DLL file extension)
- 4.6.4 - December 2020
- Upgrade to SQLite3 Multiple Ciphers version 1.1.3
- Adjusted autotool build files to enable AES hardware support if available
- 4.6.3 - December 2020
- Upgrade to SQLite3 Multiple Ciphers version 1.1.2
- Adjusted build files for MinGW
- 4.6.2 - December 2020
- Upgrade to SQLite3 Multiple Ciphers version 1.1.1
- Upgrade to SQLite version 3.34.0
- Added method
wxSQLite3Database::QueryTransactionState
- 4.6.1 - October 2020
- Added SQLite VSV extension (Variably Separated Values)
- 4.6.0 - August 2020
- Use SQLite encryption extension SQLite3 Multiple Ciphers
- Upgrade to SQLite version 3.33.0
- Added support for System.Data.SQLite's RC4 encryption
- 4.5.1 - January 2020
- Upgrade to SQLite version 3.31.1
- 4.5.0 - January 2020
- Upgrade to SQLite version 3.31.0
- Modified API for wxSQLite3Database::CreateFunction methods
- 4.4.8 - October 2019
- Upgrade to SQLite version 3.30.1
- Adjusted encryption extension to support SQLite's shared cache mode
- 4.4.7 - October 2019
- Upgrade to SQLite version 3.30.0
- 4.4.6 - September 2019
- Fixed missing cipher application in method wxSQLite3Database::ReKey
- 4.4.5 - August 2019
- Fixed broken compatibility with wxWidgets 2.8.12
- 4.4.4 - August 2019
- Upgrade to SQLite version 3.29.0
- Added SQLite logging support
- Added build support for VS2019
- Added CMake support (PR #63)
- Updated build files to overcome problems with static builds (issue #73)
- Eliminated duplication of error messages for different wxWidgets builds (PR #64)
- Fixed missing call to progress callback in wxSQLite3Database::Restore (PR #66)
- Fixed issue #58 with silently failing wxSQLite3Transaction::Commit method
- Fixed issue with named collections which could result in crashes (PR #59)
- 4.4.3 - May 2019
- Upgrade to SQLite version 3.28.0
- 4.4.2 - February 2019
- Upgrade to SQLite version 3.27.2
- 4.4.1 - February 2019
- Upgrade to SQLite version 3.27.1
- 4.4.0 - December 2018
- Upgrade to SQLite version 3.26.0
- Added support for the SQLCipher 4 database format
- 4.3.0 - November 2018
- Upgrade to SQLite version 3.25.3
- Adjusted encryption extension to support cipher configuration via database URI
- 4.2.0 - October 2018
- Added method wxSQLite3Database::GetKeySalt to access the key salt of encrypted databases
- Fixed memory leaks in methods wxSQLite3ResultSet::GetExpandedSQL and wxSQLite3Statement::GetExpandedSQL
- Adjusted encryption extension to support raw key (and salt) for the ChaCha20 (sqleet) encryption scheme
- 4.1.1 - October 2018
- Upgrade to SQLite version 3.25.2
- 4.1.0 - September 2018
- Upgrade to SQLite version 3.25.1
- Added support for SQL window functions
- Adjusted encryption extension to check for matching page sizes on rekeying a database
- 4.0.4 - June 2018
- Upgrade to SQLite version 3.24.0
- 4.0.3 - April 2018
- Adjusted encryption extension to better support the SQLite backup API
- 4.0.2 - April 2018
- Upgrade to SQLite version 3.23.1
- 4.0.1 - April 2018
- Fixed a bug in the rekeying function of the encryption extension
- 4.0.0 - April 2018
- Added multi-cipher support
- Added methods for attaching/detaching databases
- Cleaned up code using statement buffers
- 3.5.9 - January 2018
- Upgrade to SQLite version 3.22.0
- 3.5.8 - November 2017
- Upgrade to SQLite version 3.21.0
- 3.5.7 - September 2017
- Upgrade to SQLite version 3.20.1
- 3.5.6 - August 2017
- Upgrade to SQLite version 3.20.0
- Added support for persistent prepared statements
- Added support for binding pointers (new SQLite pointer-binding interface)
- Added several SQLite extensions (csv, sha3, carray, fileio, series) for the included SQLite library
- Modified build files to expose the parameter SQLITE_MAX_ATTACHED to allow easier adjustment of the maximum number of attached databases
- 3.5.5 - June 2017
- Upgrade to SQLite version 3.19.3
- 3.5.4 - June 2017
- Upgrade to SQLite version 3.19.2
- 3.5.3 - March 2017
- Upgrade to SQLite version 3.18.0
- Minor modification to wxsqlite3.pc.in to fix issue with pkgconfig tool
- 3.5.2 - March 2017
- Upgrade to SQLite version 3.17.0
- Fixed minor issue in SQLite encryption extension related to symbol
SQLITE_DEBUG
- Modified build system for GNU make (support monolithic wxWidgets build)
- 3.5.1 - February 2017
- Added version information as Windows resource for DLL builds on Windows
- Cleaned up premake5 build files for Visual C++ (corrected debug environment settings)
- Resolved wxWidgets library dependencies for Visual C++ using wxWidgets' special setup.h for MSVC
- 3.5.0 - January 2017
- Upgrade to SQLite version 3.16.2
- SQLite3 library now integrated part of wxSQLite3
- Overhaul of build system
- 3.4.1 - October 2016
- Upgrade to SQLite version 3.15.0
- 3.4.0 - August 2016
- Upgrade to SQLite version 3.14.1
- Added method
wxSQLite3Statement::GetExpandedSQL
- Added method
wxSQLite3ResultSet::GetExpandedSQL
- Started to modify the build system to compile and statically link the SQLite3 library together with wxSQLite3
- Added the CSV extension module as part of the SQLite3 library with encryption extension
- 3.3.1 - April 2016
- Upgrade to SQLite version 3.12.1
- Added method
wxSQLite3Database::GetSystemErrorCode
- 3.3.0 - December 2015
- Upgrade to SQLite version 3.9.2 (including adjusted SQLite amalgamation source to fix problem with the user authentication module)
- Transition from SourceForge to GitHub
- 3.2.1 - March 2015
- Upgrade to SQLite version 3.8.8.3
- Fixed a bug in method GetParamName
- 3.2.0 - December 2014
- Upgrade to SQLite version 3.8.7.4
- Added support for the SQLite user authentication module
- 3.1.1 - June 2014
- Upgrade to SQLite version 3.8.5
- 3.1.0 - May 2014
- Upgrade to SQLite version 3.8.4.3
- Added flag
isDeterministic
to methodwxSQLite3Database::CreateFunction
- Added new GUI sample
- Changed implementation of encryption extension (see readme file in sqlite3 subfolder)
- 3.0.6 - December 2013
- Upgrade to SQLite version 3.8.2
- 3.0.5 - September 2013
- Upgrade to SQLite version 3.8.0.2
- Added support for setting the temporary directory for SQLite on Windows
- 3.0.4 - August 2013
- Upgrade to SQLite version 3.8.0
- Added support for querying performance characteristics of prepared statements
- 3.0.3 - March 2013
- Upgrade to SQLite version 3.7.16
- 3.0.2 - Dezember 2012
- Upgrade to SQLite version 3.7.15.1
- Corrected an internal SQLite data structure to avoid compile time warnings
- Changed method
wxSQLite3Exception::ErrorCodeAsString
to return the error messages provided by SQLite
- 3.0.1 - November 2012
- Upgrade to SQLite version 3.7.14.1
- Cleaned up and optimized Finalize methods
- Modified
wxSQLite3Database::Close
to avoid potential memory leaks - Added method
wxSQLite3Database::GetWrapperVersion
- Added method
wxSQLite3Database::IsReadOnly
- Added method
wxSQLite3Statement::BindUnixDateTime
- Added method
wxSQLite3ResultSet::GetUnixDateTime
- Added method
wxSQLite3ResultSet::GetAutomaticDateTime
- Fixed a potential memory leak in method
wxSQLite3Database::ExecuteUpdate
- Added a
wxsqlite3.pc
file on request of the Fedora Project developers - Replaced assert by
wxASSERT
inwxSQLite3Transaction
constructor
- 3.0.0 - January 2012
- Upgrade to SQLite version 3.7.10
- Added method
wxSQLite3Database::Vacuum
- Added method
wxSQLite3Database::GetDatabaseFilename
- Added method
wxSQLite3Database::ReleaseMemory
- Added method
wxSQLite3ResultSet::CursorMoved
- Added method
wxSQLite3Statement::IsBusy
- Fixed a bug in method
operator=
ofwxSQLite3StringCollection
causing an endless recursion on assignment - Dropped the concept of SQLite3 pointer ownership in favor of reference counted pointers allowing much more flexible use of wxSQLite3 classes
- Modified SQLite3 encryption extension (defining int64 datatype for SHA2 algorithm)
- Dropped dbadmin sample from build files
- Added Premake support for SQLite3 library with encryption support and for wxSQLite3 (experimental)
- 2.1.3 - August 2011
- Corrected default behaviour for attached databases in case of an encrypted main database. (Now the attached database uses the same encryption key as the main database if no explicit key is given. Previously the attached database remained unencrypted.)
- Added an optional progress callback for metheods Backup & Restore
- Added method
SetBackupRestorePageCount
to set the number of pages to be copied in one cycle of the backup/restore process
- 2.1.2 - July 2011
- Upgrade to SQLite version 3.7.7.1
- Modified
wxSQLite3Transaction
class to make it exception safe
- 2.1.1 - April 2011
- Upgrade to SQLite version 3.7.6.1
- Added convenience method
wxSQLite3Statement::ExecuteScalar
- Changed write-ahead log checkpoint method to new version (v2)
- 2.1.0 - March 2011
- Upgrade to SQLite version 3.7.5
- Added wxSQLite+, a database administration application written by Fred Cailleau-Lepetit, as a GUI sample for wxSQLite3. Minor adjustments were applied to make wxSQLite+ compatible with wxWidgets 2.9.x. To compile and link wxSQLite+ successfully using wxWidgets 2.8.x it is required to build the "stc" library (scintilla) in the "contrib" folder of wxWidgets. Please note that wxSQLite+ is under GPL license.
- 2.0.2 - December 2010
- Upgrade to SQLite version 3.7.4
- 2.0.1 - October 2010
- Upgrade to SQLite version 3.7.3
- Added parameter
transferStatementOwnership
to methodwxSQLite3Statement::ExecuteQuery
to allow using the returned result set beyond the life time of thewxSQLite3Statement
instance
- 2.0.0.1 - August 2010
- Upgrade to SQLite version 3.7.0.1
- Added missing function interfaces in
wxsqlite3dyn.h
- Adjusted code to eliminate a reference to
sqlite3_mprintf
- 2.0.0 - July 2010
- Upgrade to SQLite version 3.7.0
- Fixed a bug in class
wxSQLite3ResultSet
- Added support for SQLite's write-ahead log journal mode
- Added support for named collections (see class
wxSQLite3NamedCollection
) - Changed UTF-8 string handling to use methods To/FromUTF8 of the wxString class (requires wxWidgets 2.8.4 or higher)
- Compatible with wxWidgets 2.9.1
- 1.9.9 - March 2010
- Upgrade to SQLite version 3.6.23
- Fixed a bug when compiling for dynamic loading of SQLite
- Added static methods to class
wxSQLite3Database
for accessing the run-time library compilation options diagnostics - Added mathod FormatV to class
wxSQLite3StatementBuffer
- 1.9.8 - February 2010
- Upgrade to SQLite version 3.6.22
- Fixed a bug when compiling without precompiled header support (by including wx/arrstr.h)
- Added experimental support for 256 bit AES encryption to the optional key based encryption extension
- 1.9.7 - November 2009
- Upgrade to SQLite version 3.6.20
- Added methods to query, enable or disable foreign key support
- 1.9.6 - September 2009
- Upgrade to SQLite version 3.6.18
- Added method to get the SQLite library source id
- Added
flags
parameter towxSQLite3Database::Open
to allow additional control over the database connection (see http://www.sqlite.org/c3ref/open.html for further information) - Fixed a potential memory leak in
wxSQLite3Statement
class - Converted encryption extension from C++ to pure C to make it compatible with the SQLite amalgamation.
- 1.9.5 - February 2009
- Upgrade to SQLite version 3.6.11
- Added user defined function class for REGEXP operator
- Added support for SQLite backup/restore API, introduced with SQLite 3.6.11
- 1.9.4 - January 2009
- Upgrade to SQLite version 3.6.10
- Added support for SQLite savepoints, introduced with SQLite 3.6.8
- Added IsOk methods to several classes
- 1.9.3 - Dezember 2008
- Upgrade to SQLite version 3.6.7
- Fixed a bug in method
wxSQLite3Table::GetDouble
(conversion from string to double failed in non-US locales) - Build system upgraded using Bakefile 0.2.5
- 1.9.2 - November 2008
- Upgrade to SQLite version 3.6.6
- Added RAII transaction class (see docs for details)
- 1.9.1 - September 2008
- Upgrade to SQLite version 3.6.2
- Introduced own step counting for aggregate user functions since the
sqlite3_aggregate_count
function is now deprecated. - Enhanced
wxSQLite3Database::TableExists
method to query an attached database for existence of a table or to query all open databases.
- 1.9.0 - July 2008
- Upgrade to SQLite version 3.6.0
- The optional key based encryption support has been adapted to support SQLite version 3.6.0.
- Added static methods to initialize and shutdown the SQLite library.
- Changed build system to support static library build against shared wxWidgets build on Linux.
- Changed behaviour of
Close
method of classwxSQLite3Database
to finalize all unfinalized prepared statements.
- 1.8.5 - June 2008
- Upgrade to SQLite version 3.5.9
- Integration of the optional key based encryption support into SQLite has been made easier. Changes to original SQLite source files are no longer necessary.
- 1.8.4 - April 2008
- Upgrade to SQLite version 3.5.8
- Added support for accessing database limits
- Changed method
TableExists
to check a table name case insensitive - Fixed several minor issues in the build files.
- 1.8.3 - January 2008
- Added support for shared cache mode
- Added support for access to original SQL statement for prepared statements (requires SQLite 3.5.3 or above)
- Fixed broken SQLite DLLs
- 1.8.2 - Dezember 2007
- Upgrade to SQLite version 3.5.4
- Fixed a bug in in
wxSQLite3Database::Begin
(wrong transaction type)
- 1.8.1 - November 2007
- Fixed a bug in in
wxSQLite3Database::Close
(resetting flagm_isEncrypted
) - Eliminated several compile time warnings (regarding unused parameters)
- Fixed a compile time bug in
wxSQLite3Database::GetBlob
(missing explicit type cast)
- Fixed a bug in in
- 1.8.0 - November 2007
- Upgrade to SQLite version 3.5.2
- Support for SQLite incremental BLOBs
- Changed source code in the SQLite3 encryption extension to eliminate several warnings
- Changed default wxWidgets version to 2.8.x
- Adjusted sources for SQLite encryption support are included for all SQLite version from 3.3.1 up to 3.5.2
- SQLite link libraries for MinGW on Windows are included
- Added
WXMAKINGLIB_WXSQLITE3
compile time option to support building wxSQLite3 as a static library while using the shared libraries of wxWidgets.
- 1.7.3 - May 2007
- Upgrade to SQLite version 3.3.17
- Fixed a bug in the SQLite3 encryption extension (MD5 algorithm was not aware of endianess on big-endian platforms, resulting in non-portable database files)
- 1.7.2 - February 2007
- Upgrade to SQLite version 3.3.11
- Support for loadable extensions is now optional
- Check for optional wxSQLite3 features at runtime
- wxSQLite3 API independent of optional features
- 1.7.1 - January 2007
- Fixed a bug in the key based database encryption feature (The call to
sqlite3_rekey
inwxSQLite3Database::ReKey
could cause a program crash, when used to encrypt a previously unencrypted database.)
- Fixed a bug in the key based database encryption feature (The call to
- 1.7.0 - January 2007
- Upgrade to SQLite version 3.3.10
- Added support for BLOBs as wxMemoryBuffer objects
- Added support for loadable extensions
- Optional support for key based database encryption
- 1.6.0 - July 2006
- Added support for user-defined collation sequences
- 1.5.3 - June 2006
- Upgrade to SQLite version 3.3.6
- Added support for optional SQLite meta data methods
- 1.5.2 - March 2006
- Fixed a bug in wxSQLite3Database::Prepare
- Added
wxSQLite3Database::IsOpen
for convenience
- 1.5.1 - February 2006
- SQLite DLL upgraded to version 3.3.4
- 1.5 - February 2006
- Upgrade to SQLite version 3.3.3
- Added support for commit, rollback and update callbacks
- 1.4.2 - November 2005
- Optimized code for wxString arguments
- 1.4.1 - November 2005
- Fixed a bug in
TableExists
, eliminated some compiler warnings - Changed handling of Unicode string conversion
- Added support for different transaction types
- Fixed a bug in
- 1.4 - November 2005
- Optionally load SQLite library dynamically at run time
- 1.3.1 - November 2005
- Corrected
wxSQLite3ResultSet::GetInt64
, - Added
wxSQLite3Table::GetInt64
- Corrected
- 1.3 - October 2005
- Added wxGTK build support
- 1.2 - October 2005
- Corrected error in
wxSQLite3Table::FindColumnIndex
- Corrected error in
- 1.1 - October 2005
- Upgrade to SQLite version 3.2.7
- 1.0 - July 2005
- First public release
The build files for Windows platforms are now generated with Premake 5 (version Premake 5.0 alpha 15).
Ready to use project files are provided for Visual C++ 2010, 2012, 2013, 2015, 2017, and 2019. Additionally, GNU Makefiles are provided supporting for example MinGW-w64.
For Visual Studio 2010+ solutions it is possible to customize the build
by creating a wx_local.props
file in the build directory which is used,
if it exists, by the projects. The settings in that file override the
default values for the properties. The typical way to make the file is
to copy wx_setup.props
to wx_local.props
and then edit locally.
For GNU Makefiles the file config.gcc
serves the same purpose as the
file wx_setup.props for Visual C++ projects.
The customization files wx_setup.props
resp. config.gcc
allow to
customize certain settings like for example the version number and the
root directory of the wxWidgets library.
When building on Win32 or Win64, you can use the makefiles or one of the
Microsoft Visual Studio solution files in the build
folder.
The Visual Studio solution files reference the property file wx_setup.props
in the build subdirectory. This file is configured in a way to allow running
AppVeyor CI without any modifications. Especially, specific library directories
are used for different compiler versions (as it is used by the pre-built
wxWidgets libraries) by adding the toolkit version (i.e., 141 for VS 2015,
142 for VS 2019) to the library path name.
To get library path names without toolkit version (as you usually get when
compiling wxWidgets yourself) please adjust the 2 parameters wxCompilerPrefix
and wxMsvcVersionAuto
in file wx_setup.props
as follows:
<wxCompilerPrefix>vc</wxCompilerPrefix>
<wxMsvcVersionAuto></wxMsvcVersionAuto>
Additionally, the property file assumes that the environment variable WXWIN
is defined and points to the root directory of the wxWidgets installation.
Make sure that WXWIN
is set up properly, or replace it by a environment
variable of your choice or by an absolute path specification.
For Visual C++ the debugging properties are set up in such a way that
debugging the sample applications should work right out of the box. For
release builds you may need to copy the wxSQLite3 DLL or add the
lib
folder path to the Windows search path (PATH environment variable).
The SQLite3 library is now compiled as an integrated part of wxSQLite3. The advantage is that SQLite3 and wxSQLite3 are always compiled with matching configuration options. Additionally, the SQLite3 encryption extension is automatically enabled, too.
A precompiled SQLite shell program supporting encrypted databases is provided as a separate download. Use
PRAGMA KEY="encryption key";
to create or open an encrypted database. Use
ATTACH DATABASE x AS y KEY z;
to attach an encrypted database.
When building on an autoconf-based system (like Linux/GNU-based systems), the first setup is to recreate the configure script doing:
autoreconf
Thereafter you should create a build directory
mkdir build-gtk [or any other suitable name]
cd build-gtk
../configure [here you should use the same flags you used to configure wxWidgets]
make
Type ../configure --help
for more info.
The autoconf-based system also supports a make install
target which
builds the library and then copies the headers of the component to
/usr/local/include
and the lib to /usr/local/lib
.
SQLite has many optional features and offers a number of optional extensions. The below table lists the features that are enabled for wxSQLite3 as default. For details, please see SQLite Compile Time Options.
In case of memory constraints it is of course possible to disable unneeded features. However, this will usually require to modify the build files.
Symbol | Description |
---|---|
SQLITE_DQS | Setting for the double-quoted string literal misfeature (default: disabled) |
SQLITE_ENABLE_CARRAY | C array extension |
SQLITE_ENABLE_COLUMN_METADATA | Access to meta-data about tables and queries |
SQLITE_ENABLE_CSV | CSV extension |
SQLITE_ENABLE_DEBUG | Enable additional debug features (default: off) |
SQLITE_ENABLE_DESERIALIZE | Option to enable the serialization interface |
SQLITE_ENABLE_EXPLAIN_COMMENTS | Enable additional comments in EXPLAIN output |
SQLITE_ENABLE_FTS3 | Version 3 of the full-text search engine |
SQLITE_ENABLE_FTS3_PARENTHESIS | Additional operators for query pattern parser |
SQLITE_ENABLE_FTS4 | Version 4 of the full-text search engine |
SQLITE_ENABLE_FTS5 | Version 5 of the full-text search engine |
SQLITE_ENABLE_GEOPOLY | Geopoly extension |
SQLITE_ENABLE_JSON1 | JSON SQL functions |
SQLITE_ENABLE_REGEXP | Regular expression extension |
SQLITE_ENABLE_RTREE | R*Tree index extension |
SQLITE_ENABLE_EXTFUNC | Extension with mathematical and string functions |
SQLITE_ENABLE_FILEIO | Extension with file I/O SQL functions |
SQLITE_ENABLE_SERIES | Series extension |
SQLITE_ENABLE_SHA3 | SHA3 extension |
SQLITE_ENABLE_UUID | Extension for handling handling RFC-4122 UUIDs |
SQLITE_MAX_ATTACHED=10 | Maximum Number Of Attached Databases (max. 125) |
SQLITE_SECURE_DELETE | Overwrite deleted content with zeros |
SQLITE_SOUNDEX | Enable soundex SQL function |
SQLITE_THREADSAFE | Setting the multithreading mode (default: serialized) |
SQLITE_USE_URI | Enable URI file names |
SQLITE_USER_AUTHENTICATION | User authentication extension |
The public release of SQLite contains hooks for key based database encryption, but the code for implementing this feature is not freely available. D. Richard Hipp offers a commercial solution (see http://www.hwaci.com/sw/sqlite/prosupport.html#crypto).
There exist other closed-source commercial solutions, among them:
Both use a slightly different encryption API, which is currently NOT supported by wxSQLite3.
For Windows based systems there exists an open source solution: System.Data.SQLite. For SQLite version 3.32.0 or higher encryption support has been dropped. However, the new encryption extension SQLite3 Multiple Ciphers allows to use this encryption scheme on all supported platforms.
wxSQLite3 uses now the new encryption extension SQLite3 Multiple Ciphers. Precompiled binaries of the SQLite3 DLL and the SQLite3 shell for Windows are now provided by this new separate project.
Starting with wxSQLite3 version 3.5.0 the SQLite3 library is compiled as an integrated part of wxSQLite3. A separate SQLite3 DLL is not required any longer.
wxSQLite3 is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License version 3 or later as published by the Free Software Foundation, with the wxWindows 3.1 exception.
The following people have contributed to wxSQLite3:
- Vadim Zeitlin (revision of the build system)
- Francesco Montorsi (enhancement of the build system)
- Neville Dastur (enhancement of the method TableExists)
- Tobias Langner (RAII class for managing transactions)