Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Documentation updates in preparation for release 1.0.78.0. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
b694fa3e06d274bd315f48aef4915b18 |
| User & Date: | mistachkin 2012-01-21 04:51:14 |
Context
|
2012-01-21
| ||
| 05:06 | Update core SQLite version numbers to 3.7.10 in the VS props files. check-in: c5610e4d97 user: mistachkin tags: trunk | |
| 04:51 | Documentation updates in preparation for release 1.0.78.0. check-in: b694fa3e06 user: mistachkin tags: trunk | |
|
2012-01-17
| ||
| 12:42 | Update core SQLite to 3.7.10 release. check-in: 4ec265e1b4 user: mistachkin tags: trunk | |
Changes
Changes to Doc/Extra/version.html.
39 39 </td> 40 40 </tr> 41 41 </table> 42 42 </div> 43 43 <div id="mainSection"> 44 44 <div id="mainBody"> 45 45 <h1 class="heading">Version History</h1> 46 + <p><b>1.0.78.0 - January XX, 2012</b></p> 47 + <ul> 48 + <li>Updated to SQLite 3.7.10 <a href="http://www.sqlite.org/src/info/ebd01a8def">[ebd01a8def]</a>.</li> 49 + <li>Redesign the VS designer support installer and integrate it into the setup packages.</li> 50 + <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li> 51 + <li>Even more enhancements to the build and test automation.</li> 52 + <li>Support parameter binding to more primitive types, including unsigned integer types.</li> 53 + <li>Recognize the TIMESTAMP column data type as the DateTime type. Fix for <a href="http://system.data.sqlite.org/index.html/info/bb4b04d457">[bb4b04d457]</a>.</li> 54 + <li>Prevent logging superfluous messages having to do with library initialization checking. Fix for <a href="http://system.data.sqlite.org/index.html/info/3fc172d1be">[3fc172d1be]</a>.</li> 55 + <li>Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for <a href="http://system.data.sqlite.org/index.html/info/f3ec1e0066">[f3ec1e0066]</a>.</li> 56 + <li>Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for <a href="http://system.data.sqlite.org/index.html/info/4bbf851fa5">[4bbf851fa5]</a>. <b>** Potentially Incompatible Change **</b></li> 57 + </ul> 46 58 <p><b>1.0.77.0 - November 28, 2011</b></p> 47 59 <ul> 48 60 <li>Updated to SQLite 3.7.9 <a href="http://www.sqlite.org/src/info/a499ae3835">[a499ae3835]</a>.</li> 49 61 <li>More enhancements to the build and test automation.</li> 50 62 <li>Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason.</li> 51 63 <li>The SQLite3 class should always attempt to dispose the contained SQLiteConnectionHandle, even when called via the finalizer.</li> 52 64 <li>When compiled with DEBUG defined, emit diagnostic information related to resource cleanup to any TraceListener objects that may be registered.</li> ................................................................................ 54 66 <li>Never attempt to configure the native logging interface if the SQLite core library has already been initialized for the process. Fix for <a href="http://system.data.sqlite.org/index.html/info/2ce0870fad">[2ce0870fad]</a>.</li> 55 67 <li>Allow the SQLiteLog class to be used for logging messages without having an open connection.</li> 56 68 <li>Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for <a href="http://system.data.sqlite.org/index.html/info/566f1ad1e4">[566f1ad1e4]</a>.</li> 57 69 <li>When generating the schema based on the contents of a SQLiteDataReader, skip flagging columns as unique if the data reader is holding the result of some kind of multi-table construct (e.g. a cross join) because we must allow duplicate values in that case. Fix for <a href="http://system.data.sqlite.org/index.html/info/7e3fa93744">[7e3fa93744]</a>.</li> 58 70 <li>When returning schema information that may be used by the .NET Framework to construct dynamic SQL, use a fake schema name (instead of null) so that the table names will be properly qualified with the catalog name (i.e. the attached database name). Partial fix for <a href="http://system.data.sqlite.org/index.html/info/343d392b51">[343d392b51]</a>.</li> 59 71 <li>Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.</li> 60 72 <li>Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite.</li> 61 - <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for <a href="http://system.data.sqlite.org/index.html/info/343d392b51">[343d392b51]</a>.</li> 73 + <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for <a href="http://system.data.sqlite.org/index.html/info/343d392b51">[343d392b51]</a>. <b>** Potentially Incompatible Change **</b></li> 62 74 <li>Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.</li> 63 75 <li>Fix the name of the interop assembly for Windows CE. Add unit tests to prevent this type of issue from happening again. Fix for <a href="http://system.data.sqlite.org/index.html/info/737ca4ff74">[737ca4ff74]</a>.</li> 64 76 <li>Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for <a href="http://system.data.sqlite.org/index.html/info/544dba0a2f">[544dba0a2f]</a>.</li> 65 77 <li>Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for <a href="http://system.data.sqlite.org/index.html/info/84718e79fa">[84718e79fa]</a>.</li> 66 78 </ul> 67 79 <p><b>1.0.76.0 - October 4, 2011</b></p> 68 80 <ul>
Changes to readme.htm.
1 1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 2 2 <html> 3 3 <head> 4 4 <title></title> 5 5 </head> 6 6 <body> 7 7 ADO.NET SQLite Data Provider<br /> 8 -Version 1.0.77.0 November 28, 2011<br /> 9 -Using SQLite 3.7.9 <a href="http://www.sqlite.org/src/info/c7c6050ef0">[c7c6050ef0]</a><br /> 8 +Version 1.0.78.0 January XX, 2012<br /> 9 +Using SQLite 3.7.10 <a href="http://www.sqlite.org/src/info/ebd01a8def">[ebd01a8def]</a><br /> 10 10 Originally written by Robert Simpson<br /> 11 11 Released to the public domain, use at your own risk!<br /> 12 -Official provider website: <a href="http://system.data.sqlite.org/">http://system.data.sqlite.org/</a><br /> 13 -Legacy versions: <a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a><br /> 12 +Official provider website: <a href="http://system.data.sqlite.org/">http://system.data.sqlite.org/</a><br /> 13 +Legacy versions: <a href="http://sqlite.phxsoftware.com/">http://sqlite.phxsoftware.com/</a><br /> 14 14 <br /> 15 -The current development version can be downloaded from <a href="http://system.data.sqlite.org/index.html/timeline?n=20&y=ci"> 16 -http://system.data.sqlite.org/index.html/timeline?n=20&y=ci</a> 15 +The current development version can be downloaded from <a href="http://system.data.sqlite.org/index.html/timeline?y=ci"> 16 +http://system.data.sqlite.org/index.html/timeline?y=ci</a> 17 17 <br /> 18 18 <br /> 19 19 20 20 <h2><b>Features</b></h2> 21 21 22 22 <ul> 23 23 <li> ................................................................................ 52 52 <li> 53 53 Visual Studio design-time Support, works with all versions of Visual Studio 54 54 2005/2008/2010. You can add a SQLite database to the Servers list, design 55 55 queries with the Query Designer, drag-and-drop tables onto a Typed DataSet, 56 56 etc. 57 57 <br /> 58 58 <font color="red"> 59 - Currently not included. We are still updating the design-time support 60 - installer. Due to Visual Studio licensing restrictions, the Express 61 - Editions can no longer be supported. 59 + Due to Visual Studio licensing restrictions, the Express Editions can no 60 + longer be supported. 62 61 </font> 63 62 </li> 64 63 65 64 <li> 66 65 Full SQLite schema editing inside Visual Studio. You can create/edit tables, 67 66 views, triggers, indexes, check constraints and foreign keys. 68 67 </li> ................................................................................ 185 184 at the sqlite.org website. Several additional pieces are compiled on top of 186 185 it to extend its functionality, but the core engine's source is not changed.</p> 187 186 <p> 188 187 </p> 189 188 190 189 <h2><b>Version History</b></h2> 191 190 191 +<p> 192 + <b>1.0.78.0 - January XX, 2012</b> 193 +</p> 194 +<ul> 195 + <li>Updated to SQLite 3.7.10 <a href="http://www.sqlite.org/src/info/ebd01a8def">[ebd01a8def]</a>.</li> 196 + <li>Redesign the VS designer support installer and integrate it into the setup packages.</li> 197 + <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li> 198 + <li>Even more enhancements to the build and test automation.</li> 199 + <li>Support parameter binding to more primitive types, including unsigned integer types.</li> 200 + <li>Recognize the TIMESTAMP column data type as the DateTime type. Fix for [bb4b04d457].</li> 201 + <li>Prevent logging superfluous messages having to do with library initialization checking. Fix for [3fc172d1be].</li> 202 + <li>Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for [f3ec1e0066].</li> 203 + <li>Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for [4bbf851fa5]. <b>** Potentially Incompatible Change **</b></li> 204 +</ul> 192 205 <p> 193 206 <b>1.0.77.0 - November 28, 2011</b> 194 207 </p> 195 208 <ul> 196 209 <li>Updated to SQLite 3.7.9 <a href="http://www.sqlite.org/src/info/a499ae3835">[a499ae3835]</a>.</li> 197 210 <li>More enhancements to the build and test automation.</li> 198 211 <li>Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason.</li> ................................................................................ 202 215 <li>Never attempt to configure the native logging interface if the SQLite core library has already been initialized for the process. Fix for [2ce0870fad].</li> 203 216 <li>Allow the SQLiteLog class to be used for logging messages without having an open connection.</li> 204 217 <li>Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for [566f1ad1e4].</li> 205 218 <li>When generating the schema based on the contents of a SQLiteDataReader, skip flagging columns as unique if the data reader is holding the result of some kind of multi-table construct (e.g. a cross join) because we must allow duplicate values in that case. Fix for [7e3fa93744].</li> 206 219 <li>When returning schema information that may be used by the .NET Framework to construct dynamic SQL, use a fake schema name (instead of null) so that the table names will be properly qualified with the catalog name (i.e. the attached database name). Partial fix for [343d392b51].</li> 207 220 <li>Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.</li> 208 221 <li>Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite.</li> 209 - <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51].</li> 222 + <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51]. <b>** Potentially Incompatible Change **</b></li> 210 223 <li>Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.</li> 211 224 <li>Fix the name of the interop assembly for Windows CE. Add unit tests to prevent this type of issue from happening again. Fix for [737ca4ff74].</li> 212 225 <li>Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for [544dba0a2f].</li> 213 226 <li>Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for [84718e79fa].</li> 214 227 </ul> 215 228 <p> 216 229 <b>1.0.76.0 - October 4, 2011</b>
Changes to www/news.wiki.
1 1 <title>News</title> 2 2 3 3 <b>Version History</b> 4 4 5 +<p> 6 + <b>1.0.78.0 - January XX, 2012 <font color="red">(release pending)</font></b> 7 +</p> 8 +<ul> 9 + <li>Updated to SQLite 3.7.10 <a href="http://www.sqlite.org/src/info/ebd01a8def">[ebd01a8def]</a>.</li> 10 + <li>Redesign the VS designer support installer and integrate it into the setup packages.</li> 11 + <li>Refactor all IDisposable implementations to conform to best practices, potentially eliminating leaks in certain circumstances.</li> 12 + <li>Even more enhancements to the build and test automation.</li> 13 + <li>Support parameter binding to more primitive types, including unsigned integer types.</li> 14 + <li>Recognize the TIMESTAMP column data type as the DateTime type. Fix for [bb4b04d457].</li> 15 + <li>Prevent logging superfluous messages having to do with library initialization checking. Fix for [3fc172d1be].</li> 16 + <li>Support the DateTimeKind and BaseSchemaName connection string properties in the SQLiteConnectionStringBuilder class. Fix for [f3ec1e0066].</li> 17 + <li>Overloads of the SQLiteConvert.ToDateTime and SQLiteConvert.ToJulianDay methods that do not require an instance should be static. Partial fix for [4bbf851fa5]. <b>** Potentially Incompatible Change **</b></li> 18 +</ul> 5 19 <p> 6 20 <b>1.0.77.0 - November 28, 2011</b> 7 21 </p> 8 22 <ul> 9 23 <li>Updated to SQLite 3.7.9 <a href="http://www.sqlite.org/src/info/a499ae3835">[a499ae3835]</a>.</li> 10 24 <li>More enhancements to the build and test automation.</li> 11 25 <li>Plug native memory leak when closing a database connection containing a statement that cannot be finalized for some reason.</li> ................................................................................ 15 29 <li>Never attempt to configure the native logging interface if the SQLite core library has already been initialized for the process. Fix for [2ce0870fad].</li> 16 30 <li>Allow the SQLiteLog class to be used for logging messages without having an open connection.</li> 17 31 <li>Support building the core System.Data.SQLite assemblies using the .NET Framework 4.0 Client Profile. Fix for [566f1ad1e4].</li> 18 32 <li>When generating the schema based on the contents of a SQLiteDataReader, skip flagging columns as unique if the data reader is holding the result of some kind of multi-table construct (e.g. a cross join) because we must allow duplicate values in that case. Fix for [7e3fa93744].</li> 19 33 <li>When returning schema information that may be used by the .NET Framework to construct dynamic SQL, use a fake schema name (instead of null) so that the table names will be properly qualified with the catalog name (i.e. the attached database name). Partial fix for [343d392b51].</li> 20 34 <li>Add SQLiteSourceId property to the SQLiteConnection class to return the SQLite source identifier.</li> 21 35 <li>Add MemoryUsed and MemoryHighwater properties to the SQLiteConnection class to help determine the memory usage of SQLite.</li> 22 - <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51].</li> 36 + <li>Add DateTimeKind connection string property to control the DateTimeKind of parsed DateTime values. Partial fix for [343d392b51]. <b>** Potentially Incompatible Change **</b></li> 23 37 <li>Improve the robustness of the SQLiteLog class when it will be initialized and unloaded multiple times.</li> 24 38 <li>Fix the name of the interop assembly for Windows CE. Add unit tests to prevent this type of issue from happening again. Fix for [737ca4ff74].</li> 25 39 <li>Formally support the SQL type name BOOLEAN in addition to BOOL. Fix for [544dba0a2f].</li> 26 40 <li>Make sure the SQLiteConvert.TypeNameToDbType method is thread-safe. Fix for [84718e79fa].</li> 27 41 </ul> 28 42 <p> 29 43 <b>1.0.76.0 - October 4, 2011</b>