📄 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> <?xml version="1.0" encoding="Windows-1252"?><a name="2008__uly_16"></a><h3>2008-July-16 - Version 3.6.0 beta</h3><p> Version 3.6.0 makes changes to the <a href="c3ref/vfs.html">VFS</a> object in order to make SQLite more easily portable to a wider variety of platforms. There are potential incompatibilities with some legacy applications. See the <a href="35to36.html">35to36.html</a> document for details.</p><p> Many new interfaces are introduced in version 3.6.0. The code is very well tested and is appropriate for use in stable systems. We have attached the "beta" designation only so that we can make tweaks to the new interfaces in the next release without having to declare an incompatibility.</p><hr width="50%"><a name="2008__ay_12"></a><h3>2008-May-12 - Version 3.5.9</h3><p> Version 3.5.9 adds a new experimental <a href="pragma.html#syntax">PRAGMA</a>: <a href="pragma.html#pragma_journal_mode">journal_mode</a>. Setting the journal mode to PERSIST can provide performance improvement on systems where deleting a file is expective. The PERSIST journal mode is still considered experimental and should be used with caution pending further testing.</p><p> Version 3.5.9 is intended to be the last stable release prior to version 3.6.0. Version 3.6.0 will make incompatible changes to the <a href="c3ref/vfs.html">sqlite3_vfs</a> VFS layer in order to address deficiencies in the original design. These incompatibilities will only effect programmers who write their own custom VFS layers (typically embedded device builders). The planned VFS changes will be much smaller than the changes that occurred on the <a href="34to35.html">3.4.2 to 3.5.0 transaction</a> that occurred last September.</p><p> This release of SQLite is considered stable and ready for production use.</p><hr width="50%"><a name="2008__pr_16"></a><h3>2008-Apr-16 - Version 3.5.8</h3><p> Version 3.5.8 includes some important new performance optimizations in the virtual machine code generator, including constant subexpression factoring and common subexpression elimination. This release also creates new public interfaces: <a href="c3ref/randomness.html">sqlite3_randomness()</a> provides access to SQLite's internal pseudo-random number generator, <a href="c3ref/limit.html">sqlite3_limit()</a> allows size limits to be set at run-time on a per-connection basis, and <a href="c3ref/context_db_handle.html">sqlite3_context_db_handle()</a> is a convenience routine that allows an application-defined SQL function implementation to retrieve its <a href="c3ref/sqlite3.html">database connection</a> handle.</p><p> This release of SQLite is considered stable and ready for production use.</p><hr width="50%"><a name="2008__ar_17"></a><h3>2008-Mar-17 - Version 3.5.7</h3><p> Version 3.5.7 fixes several minor and obscure bugs, especially in the autoconf-generated makefile. Upgrading is optional. This release of SQLite is considered stable and ready for production use.</p><hr width="50%"><a name="2008__eb_6"></a><h3>2008-Feb-6 - Version 3.5.6</h3><p> Version 3.5.6 fixes a minor regression in 3.5.5 - a regression that had nothing to do with the massive change ove the virtual machine to a register-based design. No problems have been reported with the new virtual machine. This release of SQLite is considered stable and ready for production use.</p><hr width="50%"><a name="2008__an_31"></a><h3>2008-Jan-31 - Version 3.5.5</h3><p> Version 3.5.5 changes over 8% of the core source code of SQLite in order to convert the internal virtual machine from a stack-based design into a register-based design. This change will allow future optimizations and will avoid an entire class of stack overflow bugs that have caused problems in the past. Even though this change is large, extensive testing has found zero errors in the new virtual machine and so we believe this to be a very stable release.</p><hr width="50%"><a name="2007__ec_14"></a><h3>2007-Dec-14 - Version 3.5.4</h3><p> Version 3.5.4 fixes an long-standing but obscure bug in UPDATE and DELETE which might cause database corruption. (See ticket #2832.) Upgrading is recommended for all users.</p><p> This release also brings the processing of ORDER BY statements into compliance with standard SQL. This could, in theory, cause problems for existing applications that depend on the older, buggy behavior. See ticket #2822 for additional information.</p><hr width="50%"><a name="2007__ec_12"></a><h3>2007-Dec-12 - SQLite Consortium Announced</h3><p> The <a href="consortium.html">SQLite Consortium</a> was launched today with <a href="http://www.mozilla.org/">Mozilla</a> and <a href="http://www.symbian.com/">Symbian</a> as charter members. As noted in the <a href="pressrelease-20071212.html">press release</a>, the Consortium's goal is to promote the continuing vitality and independence of SQLite. </p><hr width="50%"><a name="2007__ov_27"></a><h3>2007-Nov-27 - Version 3.5.3</h3><p> This is an incremental release that fixes several minor problems. Upgrading is optional. If Version 3.5.2 or 3.5.1 is working fine for you, then there is no pressing need to change to 3.5.3.</p><p> The prebuilt binaries and the amalgamation found on the <a href="download.html">download</a> page include the FTS3 fulltext search extension module. We are doing this on an experimental basis and are not promising to provide prebuilt binaries with FTS3 in the future.</p><hr width="50%"><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 <a href="compile.html#omitfeatures">SQLITE_OMIT_MEMORY_ALLOCATION</a> 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 ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -