📄 oldnews.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><title>SQLite Older News</title><style type="text/css">body { margin: auto; font-family: "Verdana" "sans-serif"; padding: 8px 1%;}a { color: #45735f }a:visited { color: #734559 }.logo { position:absolute; margin:3px; }.tagline { float:right; text-align:right; font-style:italic; width:240px; margin:12px; margin-top:58px;}.toolbar { font-variant: small-caps; text-align: center; line-height: 1.6em; margin: 0; padding:1px 8px;}.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }.toolbar a:visited { color: white; }.toolbar a:hover { color: #80a796; background: white; }.content { margin: 5%; }.content dt { font-weight:bold; }.content dd { margin-bottom: 25px; margin-left:20%; }.content ul { padding:0px; padding-left: 15px; margin:0px; }/* rounded corners */.se { background: url(images/se.png) 100% 100% no-repeat #80a796}.sw { background: url(images/sw.png) 0% 100% no-repeat }.ne { background: url(images/ne.png) 100% 0% no-repeat }.nw { background: url(images/nw.png) 0% 0% no-repeat }</style><meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head><body><div><!-- container div to satisfy validator --><a href="index.html"><img class="logo" src="images/SQLite.gif" alt="SQLite Logo" border="0"></a><div><!-- IE hack to prevent disappearing logo--></div><div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div><table width=100% style="clear:both"><tr><td> <div class="se"><div class="sw"><div class="ne"><div class="nw"> <div class="toolbar"> <a href="about.html">About</a> <a href="sitemap.html">Sitemap</a> <a href="docs.html">Documentation</a> <a href="download.html">Download</a> <a href="copyright.html">License</a> <a href="news.html">News</a> <a href="http://www.sqlite.org/cvstrac/index">Developers</a> <a href="support.html">Support</a> </div></div></div></div></div></td></tr></table> <a name="2007__ov_05"></a><h3>2007-Nov-05 - Version 3.5.2</h3><p> This is an incremental release that fixes several minor problems, adds some obscure features, and provides some performance tweaks. Upgrading is optional.</p><p> The experimental compile-time option SQLITE_OMIT_MEMORY_ALLOCATION is no longer supported. On the other hand, it is now possible to compile SQLite so that it uses a static array for all its dynamic memory allocation needs and never calls malloc. Expect to see additional radical changes to the memory allocation subsystem in future releases.</p><hr width="50%"><a name="2007__ct_04"></a><h3>2007-Oct-04 - Version 3.5.1</h3><p> Fix a long-standing bug that might cause database corruption if a disk-full error occurs in the middle of a transaction and that transaction is not rolled back. <a href="http://www.sqlite.org/cvstrac/tktview?tn=2686">Ticket #2686.</a></p><p> The new VFS layer is stable. However, we still reserve the right to make tweaks to the interface definition of the VFS if necessary.</p><hr width="50%"><a name="2007__ep_04"></a><h3>2007-Sep-04 - Version 3.5.0 alpha</h3><p> The OS interface layer and the memory allocation subsystems in SQLite have been reimplemented. The published API is largely unchanged but the (unpublished) OS interface has been modified extensively. Applications that implement their own OS interface will require modification. See <a href="34to35.html">34to35.html</a> for details.<p></p><p> This is a large change. Approximately 10% of the source code was modified. We are calling this first release "alpha" in order to give the user community time to test and evaluate the changes before we freeze the new design.</p><hr width="50%"><a name="2007__ug_13"></a><h3>2007-Aug-13 - Version 3.4.2</h3><p> While stress-testing the <a href="c3ref/soft_heap_limit.html">soft_heap_limit</a> feature, a bug that could lead to <a href="http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption">database corruption</a> was <a href="http://www.sqlite.org/cvstrac/tktview?tn=2565"> discovered and fixed</a>. Though the consequences of this bug are severe, the chances of hitting it in a typical application are remote. Upgrading is recommended only if you use the <a href="c3ref/soft_heap_limit.html">sqlite3_soft_heap_limit</a> interface.</p><hr width="50%"><a name="2007__ly_20"></a><h3>2007-Jly-20 - Version 3.4.1</h3><p> This release fixes a bug in <a href="lang_vacuum.html">VACUUM</a> that can lead to <a href="http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption"> database corruption</a>. The bug was introduced in version <a href="changes.html#version_3_3_14">3.3.14</a>. Upgrading is recommended for all users. Also included are a slew of other more routine <a href="changes.html#version_3_4_1">enhancements and bug fixes</a>.</p><hr width="50%"><a name="2007__un_18"></a><h3>2007-Jun-18 - Version 3.4.0</h3><p> This release fixes two separate bugs either of which can lead to database corruption. Upgrading is strongly recommended. If you must continue using an older version of SQLite, please at least read about how to avoid these bugs at <a href="http://www.sqlite.org/cvstrac/wiki?p=CorruptionFollowingBusyError"> CorruptionFollowingBusyError</a> and <a href="http://www.sqlite.org/cvstrac/tktview?tn=2418">ticket #2418</a> <p> This release also adds explicit <a href="limits.html">limits</a> on the sizes and quantities of things SQLite will handle. The new limits might causes compatibility problems for existing applications that use excessively large strings, BLOBs, tables, or SQL statements. The new limits can be increased at compile-time to work around any problems that arise. Nevertheless, the version number of this release is 3.4.0 instead of 3.3.18 in order to call attention to the possible incompatibility. </p> There are also new features, including <a href="c3ref/blob_open.html">incremental BLOB I/O</a> and <a href="pragma.html#pragma_incremental_vacuum">incremental vacuum</a>. See the <a href="changes.html#version_3_4_0">change log</a> for additional information.</p><hr width="50%"><a name="2007__pr_25"></a><h3>2007-Apr-25 - Version 3.3.17</h3><p> This version fixes a bug in the forwards-compatibility logic of SQLite that was causing a database to become unreadable when it should have been read-only. Upgrade from 3.3.16 only if you plan to deploy into a product that might need to be upgraded in the future. For day to day use, it probably does not matter.</p><hr width="50%"><a name="2007__pr_18"></a><h3>2007-Apr-18 - Version 3.3.16</h3><p> Performance improvements added in 3.3.14 but mistakenly turned off in 3.3.15 have been reinstated. A bug has been fixed that prevented VACUUM from running if a NULL value was in a UNIQUE column.</p><hr width="50%"><a name="2007__pr_09"></a><h3>2007-Apr-09 - Version 3.3.15</h3><p> An annoying bug introduced in 3.3.14 has been fixed. There are also many enhancements to the test suite. </p><hr width="50%"><a name="2007__pr_02"></a><h3>2007-Apr-02 - Version 3.3.14</h3><p> This version focuses on performance improvements. If you recompile <a href="http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation"> the amalgamation</a> using GCC option -O3 (the precompiled binaries use -O2) you may see performance improvements of 35% or more over version 3.3.13 depending on your workload. This version also adds support for <a href="pragma.html#pragma_locking_mode"> exclusive access mode</a>.</p><hr width="50%"><a name="2007__eb_13"></a><h3>2007-Feb-13 - Version 3.3.13</h3><p> This version fixes a subtle bug in the ORDER BY optimizer that can occur when using joins. There are also a few minor enhancements. Upgrading is recommended.</p><hr width="50%"><a name="2007__an_27"></a><h3>2007-Jan-27 - Version 3.3.12</h3><p> The first published build of the previous version used the wrong set of source files. Consequently, many people downloaded a build that was labeled as "3.3.11" but was really 3.3.10. Version 3.3.12 is released to clear up the ambiguity. A couple more bugs have also been fixed and <a href="pragma.html#pragma_integrity_check"> PRAGMA integrity_check</a> has been enhanced.</p><hr width="50%"><a name="2007__an_22"></a><h3>2007-Jan-22 - Version 3.3.11</h3><p> Version 3.3.11 fixes for a few more problems in version 3.3.9 that version 3.3.10 failed to catch. Upgrading is recommended.</p><hr width="50%"><a name="2007__an_9"></a><h3>2007-Jan-9 - Version 3.3.10</h3><p> Version 3.3.10 fixes several bugs that were introduced by the previous release. Upgrading is recommended.</p><hr width="50%"><a name="2007__an_4"></a><h3>2007-Jan-4 - Version 3.3.9</h3><p> Version 3.3.9 fixes bugs that can lead to database corruption under obscure and difficult to reproduce circumstances. See <a href="http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption"> DatabaseCorruption</a> in the <a href="http://www.sqlite.org/cvstrac/wiki">wiki</a> for details. This release also adds the new <a href="c3ref/prepare.html">sqlite3_prepare_v2()</a> API and includes important bug fixes in the command-line shell and enhancements to the query optimizer. Upgrading is recommended.</p><hr width="50%"><a name="2006__ct_9"></a><h3>2006-Oct-9 - Version 3.3.8</h3><p> Version 3.3.8 adds support for full-text search using the <a href="http://www.sqlite.org/cvstrac/wiki?p=FtsOne">FTS1 module.</a> There are also minor bug fixes. Upgrade only if you want to try out the new full-text search capabilities or if you are having problems with 3.3.7.</p><hr width="50%"><a name="2006__ug_12"></a><h3>2006-Aug-12 - Version 3.3.7</h3><p> Version 3.3.7 includes support for loadable extensions and virtual tables. But both features are still considered "beta" and their APIs are subject to change in a future release. This release is mostly to make available the minor bug fixes that have accumulated since 3.3.6. Upgrading is not necessary. Do so only if you encounter one of the obscure bugs that have been fixed or if you want to try out the new features.</p><hr width="50%"><a name="2006__un_19"></a><h3>2006-Jun-19 - New Book About SQLite</h3><p> <a href="http://www.apress.com/book/bookDisplay.html?bID=10130"> <i>The Definitive Guide to SQLite</i></a>, a new book by <a href="http://www.mikesclutter.com">Mike Owens</a>. is now available from <a href="http://www.apress.com">Apress</a>. The books covers the latest SQLite internals as well as the native C interface and bindings for PHP, Python, Perl, Ruby, Tcl, and Java. Recommended.</p><hr width="50%"><a name="2006__un_6"></a><h3>2006-Jun-6 - Version 3.3.6</h3><p> Changes include improved tolerance for windows virus scanners and faster :memory: databases. There are also fixes for several obscure bugs. Upgrade if you are having problems.</p><hr width="50%"><a name="2006__pr_5"></a><h3>2006-Apr-5 - Version 3.3.5</h3><p> This release fixes many minor bugs and documentation typos and provides some minor new features and performance enhancements. Upgrade only if you are having problems or need one of the new features.</p><hr width="50%"><a name="2006__eb_11"></a><h3>2006-Feb-11 - Version 3.3.4</h3><p> This release fixes several bugs, including a a blunder that might cause a deadlock on multithreaded systems. Anyone using SQLite in a multithreaded environment should probably upgrade.</p><hr width="50%"><a name="2006__an_31"></a><h3>2006-Jan-31 - Version 3.3.3 stable</h3><p> There have been no major problems discovered in version 3.3.2, so we hereby declare the new APIs and language features to be stable and supported.</p><hr width="50%"><a name="2006__an_24"></a><h3>2006-Jan-24 - Version 3.3.2 beta</h3><p> More bug fixes and performance improvements as we move closer to a production-ready version 3.3.x.</p><hr width="50%"><a name="2006__an_16"></a><h3>2006-Jan-16 - Version 3.3.1 alpha</h3><p> Many bugs found in last week's alpha release have now been fixed and the library is running much faster again.</p><p> Database connections can now be moved between threads as long as the connection holds no locks at the time it is moved. Thus the common paradigm of maintaining a pool of database connections and handing them off to transient worker threads is now supported. Please help test this new feature. See <a href="http://www.sqlite.org/cvstrac/wiki?p=MultiThreading"> the MultiThreading wiki page</a> for additional information.</p><hr width="50%"><a name="2006__an_10"></a><h3>2006-Jan-10 - Version 3.3.0 alpha</h3><p> Version 3.3.0 adds support for CHECK constraints, DESC indices, separate REAL and INTEGER column affinities, a new OS interface layer design, and many other changes. The code passed a regression test but should still be considered alpha. Please report any problems.</p><p> The file format for version 3.3.0 has changed slightly to support descending indices and⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -