System.Data.SQLite: Check-in [ab457a3ee7]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview

Comment:	1.0.24.5
Downloads:	Tarball \| ZIP archive
Timelines:	family \| ancestors \| descendants \| both \| sourceforge
Files:	files \| file ages \| folders
SHA1:	ab457a3ee7e3ee8254e8fa3f6968d5ba864855ae
User & Date:	rmsimpson 2006-01-20 15:50:23.000

Context

2006-01-20
15:53		no message check-in: 28d4d37329 user: rmsimpson tags: sourceforge
15:50		1.0.24.5 check-in: ab457a3ee7 user: rmsimpson tags: sourceforge
2006-01-16
15:51		3.3.1 alpha check-in: 2e8d224477 user: rmsimpson tags: sourceforge

Changes

Changes to SQLite.NET.sln.

Changes to SQLite.NET.suo.

cannot compute difference between binary files

Changes to bin/System.Data.SQLite.dll.

cannot compute difference between binary files

Changes to bin/test.exe.

cannot compute difference between binary files

Changes to readme.htm.

1 2 3 4 5 6 7 ~~8 9~~ 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 ~~33 34~~ 35 36 37 38 39 40 41 42 43 44	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title></title> </head> <body> ADO.NET 2.0 SQLite Data Provider<br> ~~Version 1.0.24.4 (beta) - Jan 16, 2006<br> ~~Interop u~~sing SQLite 3.3.1 alpha<br>~~ Written by Robert Simpson (<a href="mailto:robert@blackcastlesoft.com">robert@blackcastlesoft.com</a>)<br> Released to the public domain, use at your own risk!<br> <br> The latest version can be downloaded <a href="http://sourceforge.net/projects/sqlite-dotnet2"> here</a> <br> <br> <b></b> <h2> <b>Features:</b><br> </h2> <UL> <LI> ~~~~Supports the Full~~ and Compact .NET Framework.~~ <LI> On the Compact Framework, it is faster than the newly-introduced Sql Server Mobile, often more than 10x faster at inserts/updates.  SQLite databases are also a fraction of the size of Sql Mobile databases. <LI> ~~~~Full~~ Visual Studio 2005 Design-Time Support.  You can add a SQLite~~ database to the Servers list, design queries with the Query Designer, drag-and-drop tables onto a Typed DataSet, etc. <LI> ~~~~Single file redistributable for the full .net framework (Compact Framework~~ re~~quires 2 bina~~ri~~es)~~.  The core sqlite3 codebase and the ADO.NET wrapper~~ are combined into one multi-module assembly. <LI> ~~~~Native 64-bit multi-module assembl~~ies for Itanium and ~~X64~~ processors.~~ <LI> DbProviderFactory support. <LI> Full support for ATTACH'ed databases.  Exposed as <I>Catalogs</I> in the schema.  When cloning a connection, all attached databases are automatically re-attached to the new connection. <LI>	\| \| > > \| > > > \| < \| \|	1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title></title> </head> <body> ADO.NET 2.0 SQLite Data Provider<br> Version 1.0.24.5 (beta) - Jan 20, 2006<br> Using SQLite 3.3.1 alpha<br> Written by Robert Simpson (<a href="mailto:robert@blackcastlesoft.com">robert@blackcastlesoft.com</a>)<br> Released to the public domain, use at your own risk!<br> <br> The latest version can be downloaded <a href="http://sourceforge.net/projects/sqlite-dotnet2"> here</a> <br> <br> <b></b> <h2> <b>Features:</b><br> </h2> <UL> <LI> Written from scratch on VS2005 specifically for ADO.NET 2.0, implenting all the base classes and features recently introduced in the framework.<li>Supports the Full and Compact .NET Framework, as well as native C/C++ development.  100% binary compatible with the original sqlite3.dll.</li> <LI> On the Compact Framework, it is faster than the newly-introduced Sql Server Mobile, often more than 10x faster at inserts/updates.  SQLite databases are also a fraction of the size of Sql Mobile databases. <li>Encrypted database support.  Encrypted databases are fully encrypted and support both binary and cleartext password types.</li> <LI> Visual Studio 2005 Design-Time Support.  You can add a SQLite database to the Servers list, design queries with the Query Designer, drag-and-drop tables onto a Typed DataSet, etc. <LI> Single file redistributable.  The core sqlite3 codebase and the ADO.NET wrapper are combined into one multi-module assembly. <LI> Binaries included for Itanium, x64, x86 and ARM processors. <LI> DbProviderFactory support. <LI> Full support for ATTACH'ed databases.  Exposed as <I>Catalogs</I> in the schema.  When cloning a connection, all attached databases are automatically re-attached to the new connection. <LI>
︙			︙
60 61 62 63 64 65 66 ~~67 68 69~~ 70 71 72 73 74 75 76	Full support for user-defined scalar and aggregate functions, encapsulated into an easy-to-use base class in which only a couple of overrides are necessary to implement new SQL functions. <LI> Full support for user-defined collating sequences, every bit as simple to implement as user-defined functions and uses the same base class. <LI> ~~Create and encrypt databases using Win2K+ Encrypting File System (EFS).~~ ~~Supports creating NTFS compressed database files.~~ ~~<LI>~~ Full source for the entire engine and wrapper.  No copyrights.  Public Domain.  100% free.  If you want to know if you can use it in your commercial project, please read the previous sentence again -- only slower and sound out the words this time. </LI> </UL> <strong></strong>	< < <	64 65 66 67 68 69 70 71 72 73 74 75 76 77	Full support for user-defined scalar and aggregate functions, encapsulated into an easy-to-use base class in which only a couple of overrides are necessary to implement new SQL functions. <LI> Full support for user-defined collating sequences, every bit as simple to implement as user-defined functions and uses the same base class. <LI> Full source for the entire engine and wrapper.  No copyrights.  Public Domain.  100% free.  If you want to know if you can use it in your commercial project, please read the previous sentence again -- only slower and sound out the words this time. </LI> </UL> <strong></strong>
︙			︙
103 104 105 106 107 108 109 ~~110 111~~ 112 113 ~~114 115 116 117 118 119 120~~ 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139	recompile.  <STRONG>The Compact Framework has no support for enumerating attributes in an assembly, therefore all user-defined collating sequences and functions must be explicitly registered.</STRONG>  See the <STRONG>testce</STRONG> sample application for an example of how to explicitly register user-defined collating sequences and functions.</p> <h2> <b><A name="redist"></A>Distributing The SQLite Engine and ADO.NET Assembly</b></h2> ~~<P>For Win32 platforms, o~~nly the <STRONG>System.Data.SQLite.DLL</STRONG> file in ~~the <STRONG>bin</STRONG> folder should be distributed with your~~ application(s).  This DLL contains both the managed wrapper and the native SQLite3 codebase.</P> ~~<P>For Compact Framework platforms, your application should reference the <STRONG>System.Data.SQLite.DLL</STRONG>~~ ~~file in the <STRONG>bin\CompactFramework</STRONG> folder.  The <STRONG>System.Data.SQLite.DLL</STRONG>~~ ~~and <STRONG>SQLite.Interop.DLL</STRONG> files from the <STRONG>bin\CompactFramework</STRONG>~~ ~~folder must be distributed with your application(s).  They contain the~~ ~~managed wrapper and the native SQLite3 codebase respectively.  The Compact~~ ~~Framework does not currently support managed C++, thus the reason for two~~ ~~files.</P>~~ <H2><B>Development Notes Regarding the SQLite 3 Source Code</B></H2> <p> The SQLite3 source code is compiled almost directly from the SQLite.org release sources.  All builds of sqlite after 3.2.8 have included support for Windows CE (without file locking), but the ADO.NET sources here contain CE locking modifications to the os_win.c.  I hope eventually the locking code will be incorporated into the root sqlite codebase.  Additionally, two minor modifications are made to the sources, those modifications are made automatically by the fixsource.vbs file when the VS2005 solution is compiled.</p> <p></p> <p> <b>Version History</b></p> <p><b>1.0.24.4 beta - January 16, 2006</b></p> <ul> <li>This beta is built from sqlite.org's 3.3.1 alpha and contains development-in-progress code.  Therefore no guarantees can be made regarding its suitability for production use.</li> <li>Fixed a bug in the UTF-16 handling code for preparing statements due to a behavioral change in SQLite 3.3.0.</li> <li>Added pager.c code necessary to cleanup after an encrypted file is closed.</li>	> \| < < < < < < < < > > > > > > > > > > > > > > > > > >	104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151	recompile.  <STRONG>The Compact Framework has no support for enumerating attributes in an assembly, therefore all user-defined collating sequences and functions must be explicitly registered.</STRONG>  See the <STRONG>testce</STRONG> sample application for an example of how to explicitly register user-defined collating sequences and functions.</p> <h2> <b><A name="redist"></A>Distributing The SQLite Engine and ADO.NET Assembly</b></h2> <P> Only the <STRONG>System.Data.SQLite.DLL</STRONG> file needs to be distributed with your application(s).  This DLL contains both the managed wrapper and the native SQLite3 codebase.</P> <H2><B>Development Notes Regarding the SQLite 3 Source Code</B></H2> <p> The SQLite3 source code is compiled almost directly from the SQLite.org release sources.  All builds of sqlite after 3.2.8 have included support for Windows CE (without file locking), but the ADO.NET sources here contain CE locking modifications to the os_win.c.  I hope eventually the locking code will be incorporated into the root sqlite codebase.  Additionally, two minor modifications are made to the sources, those modifications are made automatically by the fixsource.vbs file when the VS2005 solution is compiled.</p> <p></p> <p> <b>Version History</b></p> <p><b>1.0.24.5 beta - January 20, 2006</b></p> <ul> <li>This beta is built from sqlite.org's 3.3.1 alpha and contains development-in-progress code.  Therefore no guarantees can be made regarding its suitability for production use.</li> <li><strong>You no longer need to distribute 2 files on the CompactFramework.  You can delete SQLite.Interop.DLL entirely.  </strong>I wrote a custom tool called "mergebin" (available in the source zip file) which combines the two libraries and gets around a glaring defect in the VS2005 linker for ARM processors which doesn't allow you to link netmodules.</li> <li><strong>x64 and ia64 builds now use the same strong name as the x86 build.</strong>  This means breaking backward compatibility, but it was necessary in order to allow you to drop any of those 3 builds onto a PC and have your .NET program run properly.  Prior to this, you'd get an error if you built your program using the x86 build, and then installed the x64 version on a target machine and tried to run your program against it.</li> <li>The entire source project has been gone over top to bottom.  A debug build no longer combines the binaries into a single module, which was preventing proper debugging.</li></ul> <p><b>1.0.24.4 beta - January 16, 2006</b></p> <ul> <li>This beta is built from sqlite.org's 3.3.1 alpha and contains development-in-progress code.  Therefore no guarantees can be made regarding its suitability for production use.</li> <li>Fixed a bug in the UTF-16 handling code for preparing statements due to a behavioral change in SQLite 3.3.0.</li> <li>Added pager.c code necessary to cleanup after an encrypted file is closed.</li>
︙			︙
156 157 158 159 160 161 162 ~~163~~ 164 165 166 167 168 169 170	connection string, or call ChangePassword() you may use a binary byte array or a text string as the password.</li> <li>Rewrote the locking implementation for the Compact Framework.  It is now more robust and incorporates into the SQLite codebase more efficiently than the previous CE adaptation.</li> <li>Moved some of the embedded schema XML data into a resource file to ease code readability.</li> <li>Automated the fixup of the original sqlite codebase's source prior to compiling, ~~to ease merging with sqlite.org's source.~~ ~~</li>~~ </ul> <p><b>1.0.24.2 - December 30, 2005</b></p> <ul> <li>Fixed the SQLiteDataReader.HasRows property to return the proper value.</li> <li>Implemented the inadvertently neglected RecordsAffected property on SQLiteDataReader. </li> <li>SQLiteFunction static constructor was changed to pre-filter classes with only the	\| > >	168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184	connection string, or call ChangePassword() you may use a binary byte array or a text string as the password.</li> <li>Rewrote the locking implementation for the Compact Framework.  It is now more robust and incorporates into the SQLite codebase more efficiently than the previous CE adaptation.</li> <li>Moved some of the embedded schema XML data into a resource file to ease code readability.</li> <li>Automated the fixup of the original sqlite codebase's source prior to compiling, to ease merging with sqlite.org's source.</li> <li>Fixed a memory leak in SQLiteCommand due to it not removing an internal reference to itself in SQLiteConnection.  </li> </ul> <p><b>1.0.24.2 - December 30, 2005</b></p> <ul> <li>Fixed the SQLiteDataReader.HasRows property to return the proper value.</li> <li>Implemented the inadvertently neglected RecordsAffected property on SQLiteDataReader. </li> <li>SQLiteFunction static constructor was changed to pre-filter classes with only the
︙			︙