wxsqlite3-3.0.0.1
所属分类:加密解密
开发工具:C/C++
文件大小:4588KB
下载次数:42
上传日期:2012-08-20 15:37:22
上 传 者:
lihaicg
说明: 这个是加密版的sqlite3,也是一个开源的项目。支持数据库的加密(aes),压缩包中有相对应的源码,可以自己修改。
(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-3.0.0 (0, 2012-01-19)
wxsqlite3-3.0.0\build (0, 2012-01-19)
wxsqlite3-3.0.0\build\.bakefile_gen.state (26444, 2008-07-13)
wxsqlite3-3.0.0\build\aclocal.m4 (62462, 2010-10-14)
wxsqlite3-3.0.0\build\acregen.sh (2029, 2009-10-16)
wxsqlite3-3.0.0\build\autoconf_inc.m4 (7983, 2011-03-13)
wxsqlite3-3.0.0\build\Bakefiles.bkgen (358, 2008-06-21)
wxsqlite3-3.0.0\build\config.guess (44073, 2009-10-16)
wxsqlite3-3.0.0\build\config.sub (32344, 2009-10-16)
wxsqlite3-3.0.0\build\configure.ac (4445, 2012-01-18)
wxsqlite3-3.0.0\build\GNUmakefile (13007, 2012-01-19)
wxsqlite3-3.0.0\build\Info.plist.in (1125, 2010-04-15)
wxsqlite3-3.0.0\build\install.sh (11, 2008-06-21)
wxsqlite3-3.0.0\build\mac_bundles.bkl (3884, 2011-01-18)
wxsqlite3-3.0.0\build\makefile.bcc (14862, 2012-01-18)
wxsqlite3-3.0.0\build\makefile.gcc (12521, 2012-01-18)
wxsqlite3-3.0.0\build\makefile.vc (15058, 2012-01-18)
wxsqlite3-3.0.0\build\makefile.wat (15465, 2012-01-18)
wxsqlite3-3.0.0\build\wxmac.icns (36901, 2010-04-15)
wxsqlite3-3.0.0\build\wxsqlite3.bkl (7133, 2012-01-18)
wxsqlite3-3.0.0\build\wxsqlite3_vc6.dsw (686, 2012-01-18)
wxsqlite3-3.0.0\build\wxsqlite3_vc6_minimal.dsp (83388, 2009-11-07)
wxsqlite3-3.0.0\build\wxsqlite3_vc6_wxsqlite3.dsp (87821, 2010-01-31)
wxsqlite3-3.0.0\build\wxsqlite3_vc7.sln (20701, 2012-01-18)
wxsqlite3-3.0.0\build\wxsqlite3_vc7_minimal.vcproj (80477, 2011-02-24)
wxsqlite3-3.0.0\build\wxsqlite3_vc7_wxsqlite3.vcproj (83726, 2011-02-24)
wxsqlite3-3.0.0\build\wxsqlite3_vc8.sln (20723, 2012-01-18)
wxsqlite3-3.0.0\build\wxsqlite3_vc8_minimal.vcproj (92571, 2011-02-24)
wxsqlite3-3.0.0\build\wxsqlite3_vc8_wxsqlite3.vcproj (92462, 2011-02-24)
wxsqlite3-3.0.0\build\wxsqlite3_vc9.sln (20724, 2012-01-18)
wxsqlite3-3.0.0\build\wxsqlite3_vc9_minimal.vcproj (90123, 2011-02-24)
wxsqlite3-3.0.0\build\wxsqlite3_vc9_wxsqlite3.vcproj (91582, 2011-02-24)
wxsqlite3-3.0.0\build29 (0, 2012-01-19)
wxsqlite3-3.0.0\build29\aclocal.m4 (56249, 2008-06-21)
wxsqlite3-3.0.0\build29\acregen.sh (1978, 2009-10-16)
wxsqlite3-3.0.0\build29\autoconf_inc.m4 (6997, 2011-02-09)
wxsqlite3-3.0.0\build29\Bakefiles-w64.bkgen (407, 2011-02-09)
wxsqlite3-3.0.0\build29\Bakefiles.bkgen (358, 2008-06-21)
wxsqlite3-3.0.0\build29\config.guess (45570, 2008-06-21)
wxsqlite3-3.0.0\build29\config.sub (32344, 2009-10-16)
... ...
wxSQLite3 component info
------------------------
Website: http://wxcode.sourceforge.net/components/wxsqlite3
Version: 3.0.0
Description:
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 3.7.10 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.
Version history
---------------
3.0.0 - 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= of wxSQLite3StringCollection
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 int*** 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 - 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 - Upgrade to SQLite version 3.7.7.1
Modified wxSQLite3Transaction class to make it exception safe
2.1.1 - 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 - 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 - Upgrade to SQLite version 3.7.4
2.0.1 - Upgrade to SQLite version 3.7.3
Added parameter transferStatementOwnership to method
wxSQLite3Statement::ExecuteQuery to allow using the returned
result set beyond the life time of the wxSQLite3Statement instance
2.0.0.1 - 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 - 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 - 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 - 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 - Upgrade to SQLite version 3.6.20
Added methods to query, enable or disable foreign key support
1.9.6 - Upgrade to SQLite version 3.6.18
Added method to get the SQLite library source id
Added flags parameter to wxSQLite3Database::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 - 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 - 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 - 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 - Upgrade to SQLite version 3.6.6
Added RAII transaction class (see docs for details)
1.9.1 - 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 - 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 class wxSQLite3Database to
finalize all unfinalized prepared statements.
1.8.5 - 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 - 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 - 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 - Upgrade to SQLite version 3.5.4
Fixed a bug in in wxSQLite3Database::Begin (wrong transaction type)
1.8.1 - Fixed a bug in in wxSQLite3Database::Close (resetting flag m_isEncrypted)
Eliminated several compile time warnings (regarding unused parameters)
Fixed a compile time bug in wxSQLite3Database::GetBlob (missing explicit type cast)
1.8.0 - 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 - 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 - 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 - Fixed a bug in the key based database encryption feature
(The call to sqlite3_rekey in wxSQLite3Database::ReKey
could cause a program crash, when used to encrypt a previously
unencrypted database.)
1.7.0 - 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 - Added support for user-defined collation sequences
1.5.3 - Upgrade to SQLite version 3.3.6
Added support for optional SQLite meta data methods
1.5.2 - Fixed a bug in wxSQLite3Database::Prepare
Added wxSQLite3Database::IsOpen for convenience
1.5.1 - SQLite DLL upgraded to version 3.3.4
1.5 - Upgrade to SQLite version 3.3.3
Added support for commit, rollback and update callbacks
1.4.2 - Optimized code for wxString arguments
1.4.1 - Fixed a bug in TableExists, eliminated some compiler warnings
Changed handling of Unicode string conversion
Added support for different transaction types
1.4 - Optionally load SQLite library dynamically at run time
1.3.1 - Corrected wxSQLite3ResultSet::GetInt***,
added wxSQLite3Table::GetInt***
1.3 - Added wxGTK build support
1.2 - Corrected error in wxSQLite3Table::FindColumnIndex
1.1 - Upgrade to SQLite version 3.2.7
1.0 - First public release
Installation
------------
a) wxMSW
When building on win32, you can use the makefiles in the BUILD folder.
SQLite version 3.7.10 DLL is included. The included link library was
built with MS Visual C++ 6. For other compilers it can be necessary to
regenerate the link library based on the sqlite.def file in the LIB
folder.
mingw: dlltool -d sqlite3.def -D sqlite3.dll -l sqlite3.a
(As demanded by several users sqlite3.a for mingw is now included.)
The directory sqlite3/lib contains the original DLL from the SQLite
distribution.
In prior versions of wxSQLite3 the directory sqlite3/meta contained
a special DLL version including support for the optional SQLite meta
data methods. Since meta data support is now enabled in the SQLite binary
distribution as a default, the DLL has been dropped from the wxSQLite3
distribution.
To get the sample application to work the SQLite DLL to be used has to
be copied to the samples directory.
If you want to use the optional SQLite meta data methods SQLite needs
to be compiled with SQLITE_ENABLE_COLUMN_METADATA (as is the case for
the DLL version in directory sqlite3/meta). Additionally the
preprocessor symbol WXSQLITE3_HAVE_METADATA must be defined when
compiling wxSQLite3.
All included SQLite DLLs have the FTS3 module enabled.
On user request a precompiled SQLite shell program supporting encrypted
databases is included. Use
PRAGMA KEY="encryption key";
to create or open an encrypted database. Use
ATTACH DATABASE x AS y KEY z;
to attach an encryted database.
b) wxGTK
When building on an autoconf-based system (like Linux/GNU-based
systems), you can use the existing configure script in the component's
ROOT folder or you can recreate the configure script doing:
cd build
./acregen.sh
cd ..
./configure [here you should use the same flags you used to configure wxWidgets]
make
Type "./configure --help" for more info.
Note: Recreating the configure script requires the following prerequisites:
- automake 1.9.6 or higher
- bakefile 0.2.5
- wxCode autoconf and bakefile files (to be downloaded from CVS or SVN)
The autoconf-based systems also support 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 version 3.7.10 is NOT included. You have to download the current
version of SQLite from http://www.sqlite.org and to install it on your
system before you can install wxSQLite3.
Use the configure option --with-sqlite3-prefix to specify the path to your
SQLite3 installation.
Optional Meta Data support
--------------------------
If you want to use the optional SQLite meta data methods SQLite needs
to be compiled with SQLITE_ENABLE_COLUMN_METADATA. Additionally the
preprocessor symbol WXSQLITE3_HAVE_METADATA must be defined when
compiling wxSQLite3.
Optional key based database encryption support
----------------------------------------------
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).
If you want to use the optional SQLite key based database encryption
you need to have the implementation of this feature and you have to
compile SQLite with the option SQLITE_HAS_CODEC.
Additionally the preprocessor symbol WXSQLITE3_HAVE_CODEC must be
defined when compiling wxSQLite3.
There exist other commercial solutions, among them:
http://www.sqlcrypt.com
http://www.sqlite-crypt.com
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 (see http://sqlite.phxsoftware.com). Encrypted
database files can be shared across Windows platforms only.
The author of wxSQLite3 has created a key based AES database encryption
implementation for SQLite such that sharing encrypted database files
across different platforms is supported. The implementation is based on
knowledge gained from implementing encryption support for the wxCode
component wxPdfDocument and from inspecting the source code of
System.Data.SQLite. The code implementing this feature is available in
directory sqlite3/secure/src. You may use this code on your own risk.
The subdirectory codec-c contains the necessary source files; the
SQLite amalgamation source code is included. Optionally SQLite can be
compiled including the extension function module created by Liam Healy.
Starting with the release of wxSQLite3 1.9.6 the encryption extension has
been converted from C++ to pure C and is now compatible with the SQLite
amalgamation source distribution. Just compile the file sqlite3secure.c
which includes all required source files. (The C++ version is still
included in directory codec, but it is deprecated and it's use is not
recommended anymore.)
Starting with the release of wxSQLite3 1.9.8 the encryption extension
includes an experimental implementation of 256 bit AES encryption. The
code comes without any warranty, use it at your own risk.
Currently the decision whether to use 128 bit or 256 bit AES encryption
has to be made at compile time. To enable 256 bit AES encryption define
CODEC_TYPE=CODEC_TYPE_AES256 (Default: CODEC_TYPE=CODEC_TYPE_AES128).
Don't forget to specify the preprocessor symbols from the following list
corresponding to your needs to get a valid SQLite library.
The following 2 symbols enable encryption support:
SQLITE_HAS_CODEC
CODEC_TYPE=CODEC_TYPE_AES128
In the latter symbol you may specify CODEC_TYPE_AES256 instead of
CODEC_TYPE_AES128 to enable the (experimental) support for AES 256 bit
encryption.
The following 2 symbols are usually always required resp. recommended:
SQLITE_CORE
THREADSAFE=1
The following 3 symbols are optional to enable specific SQLite features:
SQLITE_SECURE_DELETE
SQLITE_SOUNDEX
SQLITE_ENABLE_COLUMN_METADATA
The following 3 symbols enable optional extension modules:
SQLITE_ENABLE_FTS3
SQLITE_ENABLE_FTS3_PARENTHESIS
SQLITE_ENABLE_RTREE
For wxMSW the directory sqlite3/secure/aes128 resp. sqlite3/secure/aes128
contains a special DLL version including support for the optional SQLite
meta data methods and the optional key based database encryption
(128 resp. 256 bit AES). The modules FTS3, RTREE and ExtensionFunctions
are included as well.
Using statically linked SQLite library on Windows
-------------------------------------------------
If you want or need to compile wxSQLite3 lib in such a way that it
does not require the sqlite3.dll at run-time, you have to build a
static sqlite3 library. No modifications to wxSQLite3 are required.
The following steps are required:
- You have to download the complete source code for sqlite from
http://www.sqlite.org/download.html. Look for the SQLite amalganation
archive since it already includes all generated sources and is ready
to compile without the need for additional tools.
- Unfortunately no makefile is included. That is, you have to create a
makefile or project file yourself. You have to build a static library
from the amalgamation C source files.
- Replace the file sqlite3.lib in the wxSQLite3 distribution by the
sqlite3.lib created as stated above and compile wxSQLite3 as a static
library.
- Don't forget to set USE_DYNAMIC_SQLITE3_LOAD=0.
Acknowledgements
----------------
The following people have contributed to wxSQLite3:
Francesco Montorsi (enhancement of the build system)
Neville Dastur (enhancement of the method TableExists)
Tobias Langner (RAII class for managing transactions)
Known bugs
----------
None
Authors' info
-------------
Ulrich Telle utelle@users.sourceforge.net
近期下载者:
相关文件:
收藏者: