这是月度维护版本，集中在 bug 修复，性能提升以及测试覆盖。这是 SQLite 核心达到 100% 分支测试覆盖后的首个发布版本。
另外，为方便扩展开发人员，增加了一个新接口 sqlite3_strnicmp()。
这个版本修复的 bug 都不是严重的。所有已修复的 bug 都是不明显的。可选更新。
This is a monthly maintenance release with a focus of bug fixes, performance improvements, and increased test coverage. This is the first release of SQLite since 100% branch test coverage was achieved on the SQLite core.
In addition, a new interface sqlite3_strnicmp() is provided for the convenience of extension writers.
None of the bugs fixed in this release are serious. All bugs are obscure. Upgrading is optional.
A subset of the TH3 test suite was measured by gcov to provide 100% branch test coverage over the SQLite core (exclusive of the VFS backend and of extensions such as FTS3 and RTREE) when compiled for SuSE 10.1 Linux on x86. The SQLite developers pledge to maintain branch test coverage at 100% in all future releases. Ongoing work will strive for 100% branch test coverage on the operating-system backends and extensions as well.
SQLite version 3.6.16 is another general maintenance relase containing performance and robustness enhancements. A single notable bug was fixed (ticket #3929). This bug cause cause INSERT or UPDATE statements to fail on indexed tables that have AFTER triggers that modify the same table and index.
SQLite version 3.6.15 is a general maintenance release containing performance and robustness enhancements and fixes for various obscure bugs.
SQLite version 3.6.14.2 fixes an obscure bug in the code generator (ticket #3879) section of SQLite which can potentially cause incorrect query results. The changes from the prior release consist of only this one bug fix, check-in [6676] and a change to the version number text.
The bug was introduced in version 3.6.14. It is recommended that users of version 3.6.14 and 3.6.14.1 upgrade to this release. Applications are unlikely to hit this bug, but since it is difficult to predict which applications might hit it and which might not, we recommend that all users of 3.6.14 and 3.5.14.1 upgrade to this release.
SQLite version 3.6.14.1 is a patch release to version 3.6.14 with minimal changes that fixes three bugs. Upgrading is only necessary for users who are impacted by one or more of those bugs.
SQLite version 3.6.14 provides new performance enhancements in the btree and pager layers and in the query optimizer. Certain workloads can be as much as twice as fast as the previous release, though 10% faster is a more typical result.
Queries against virtual tables that contain OR and IN operators in the WHERE clause are now able to use indexing.
A new optional asynchronous I/O backend is available for unix and windows. The asynchronous backend gives the illusion of faster response time by pushing slow write operations into a background thread. The tradeoff for faster response time is that more memory is required (to hold the content of the pending writes) and if a power failure or program crash occurs, some transactions that appeared to have committed might end up being rolled back upon restart.
This release also contains many minor bug fixes, documentation enhancements, new test cases, and cleanups and simplifications to the source code.
There is no compelling reason to upgrade from versions 3.6.12 or 3.6.13 if those prior versions are working. Though many users may benefit from the improved performance.
SQLite version 3.6.13 fixes several minor issues that appeared in previous version, including Ticket #3774, ticket #3791, and ticket #3777. This is a bug-fix release only. There are no new features or enhancements.
SQLite version 3.6.12 fixes a database corruption bug. If an incremental_vacuum is rolled back in an in-memory database, the database will often go corrupt. This only happens for in-memory databases. On-disk databases are unaffected. And the corruption only appears if an incremental vacuum is rolled back. Nevertheless, upgrading is recommended for all applications, especially those that make use of in-memory databases and/or incremental vacuum. See ticket #3761.
SQLite version 3.6.12 also adds support for the sqlite3_unlock_notify() interface and the reverse_unordered_selects pragma and the new ".genfkey" command in the CLI. There are also performance improvements in many count(*) SQL statements.
During testing of version 3.6.12, a bug in the lookaside memory allocator as it relates to shared cache mode was found that effects all prior versions of SQLite back to version 3.6.1. If you are using shared cache mode you should either disable lookaside memory allocation or upgrade to version 3.6.12. See ticket #3743.
SQLite version 3.6.11 adds support for the hot-backup interface. This interface can be used to create a backup copy of an SQLite database while it is in use. The same interface can be used to initialize an in-memory database from a persistent disk image or to save an in-memory database into a persistent disk image. Usage examples can be found at Using the SQLite Online Backup API.
SQLite version 3.6.10 fixes a cache coherency bug (Ticket #3584) introduced by check-in [5864] which was part of version 3.6.5. This bug might lead to database corruption, hence we felt it was important to get it out as quickly as possible, even though there had already been two prior releases this week.
Some concern has been expressed that we are releasing too frequently. (Three releases in one week is a lot!) The concern is that this creates the impression of volatility and unreliability. We have been told that we should delay releases in order to create the impression of stability. But the SQLite developers feel that truth is more important than perception, not the other way around. We think it is important to make the highest quality and most stable version of SQLite available to users at all times. This week has seen two important bugs being discovered shortly after a major release, and so we have issued two emergency patch releases after the regularly scheduled major release. This makes us look bad. This puts "egg on our face." We do not like that. But, three releases also ensures that the best quality SQLite code base is available available to you at all times.
It has been suggested that "beta" releases might find these kinds of bugs prior to a major release. But our experience indicates otherwise. The two issues that prompted releases 3.6.9 and 3.6.10 were both discovered by internal testing and review - not by external users. And, indeed, most the problems found in SQLite these days are discovered by our rigorous internal testing protocol, not bug reports from the field.
It has also been argued that we should withhold releases "until testing is finished." The fallacy there is that we never finish testing. We are constantly writing new test cases for SQLite and thinking of new ways to stress and potentially break the code. This is a continuous, never-ending, and on-going process. All existing tests pass before each release. But we will always be writing new tests the day after a release, regardless of how long we delay that release. And sometimes those new tests will uncover new problems.
All this is to say that we believe that SQLite version 3.6.10 is the most stable, most thoroughly tested, and bug-free version of SQLite that has ever existed. Please do not be freaked out by three releases occurring in one week.
Internal stress testing revealed a corner case where the cost function on the query optimizer might mislead the query optimizer into making a poor indexing choice. That choice could then tickle another bug in the VDBE which might result in an incorrect query result. This release fixes both problems. The chances of actually hitting this combination of problems in a real application seems remote. Nevertheless upgrading is recommended.
SQLite version 3.6.8 adds support for nested transactions and improved optimization of WHERE clauses with OR-connected terms. There is also a new compile-time option that changes the way full-text search patterns are parsed so that they can contain nested parentheses.
These are substantial changes. Even so, the release testing for SQLite has become so extensive that the developers have high confidence that this release is stable and ready for production use.
SQLite version 3.6.7 contains a major cleanup of the Unix driver, and support for the new Proxy Locking mechanism on MacOSX. Though the Unix driver is reorganized, its functionality is the same and so applications should not notice a difference.
This release fixes a bug that was introduced into SQLite version 3.6.6 and which seems like it might be able to cause database corruption. This bug was detected during stress testing. It has not been seen in the wild. An analysis of the problem suggests that the bug might be able to cause database corruption, however focused efforts to find a real-world test cases that actually causes database corruption have so far been unsuccessful. Hence, the likelihood of this bug causing problems is low. Nevertheless, we have decided to do an emergency branch release out of an abundance of caution.
The version 3.6.6.2 release also fixes a obscure memory leak that can occur following a disk I/O error.
This release fixes a bug that was introduced into SQLite version 3.6.4 and that can cause database corruption in obscure cases. This bug has never been seen in the wild; it was first detected by internal stress tests and required substantial analysis before it could be shown to potentially lead to corruption. So we feel that SQLite versions 3.6.4, 3.6.5, and 3.6.6 are safe to use for development work. But upgrading to this patch release or later is recommended prior to deploying products that incorporate SQLite.
We have taken the unusual step of issuing a patch release in order to get the fix for this bug into circulation quickly. SQLite version 3.6.7 will continue on its normal path of development with an anticipated release in mid December.
SQLite version 3.6.5 is released. This is a quick turn-around release that fixes a bug in virtual tables and FTS3 that snuck into version 3.6.5. This release also adds the new application-defined page cache mechanism.
SQLite version 3.6.5 is released. There are various minor feature enhancements and numerous obscure bug fixes. The change log contains the details. Upgrading is optional.
The SQLite developers are honored to announce that Bloomberg has joined the SQLite Consortium.
SQLite version 3.6.4 adds new features designed to help applications detect when indices are not being used on query. There are also some important performance improvements. Upgrading is optional.
SQLite version 3.6.3 fixes a bug in SELECT DISTINCT that was introduced by the previous version. No new features are added. Upgrading is recommended for all applications that make use of DISTINCT.
SQLite version 3.6.2 contains rewrites of the page-cache subsystem and the procedures for matching identifiers to table columns in SQL statements. These changes are designed to better modularize the code and make it more maintainable and reliable moving forward. Nearly 5000 non-comment lines of core code (about 11.3%) have changed from the previous release. Nevertheless, there should be no application-visible changes, other than bug fixes.
SQLite version 3.6.1 is a stabilization and performance enhancement release.
Version 3.6.0 makes changes to the VFS 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 35to36.html document for details.
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.
Version 3.5.9 adds a new experimental PRAGMA: journal_mode. 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.
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 sqlite3_vfs 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 3.4.2 to 3.5.0 transaction that occurred last September.
This release of SQLite is considered stable and ready for production use.
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: sqlite3_randomness() provides access to SQLite's internal pseudo-random number generator, sqlite3_limit() allows size limits to be set at run-time on a per-connection basis, and sqlite3_context_db_handle() is a convenience routine that allows an application-defined SQL function implementation to retrieve its database connection handle.
This release of SQLite is considered stable and ready for production use.
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.
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.
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.
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.
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.
The SQLite Consortium was launched today with Mozilla and Symbian as charter members. As noted in the press release, the Consortium's goal is to promote the continuing vitality and independence of SQLite.
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.
The prebuilt binaries and the amalgamation found on the download 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.
This is an incremental release that fixes several minor problems, adds some obscure features, and provides some performance tweaks. Upgrading is optional.
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.
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. Ticket #2686.
The new VFS layer is stable. However, we still reserve the right to make tweaks to the interface definition of the VFS if necessary.
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 34to35.html for details.
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.
While stress-testing the soft_heap_limit feature, a bug that could lead to database corruption was discovered and fixed. 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 sqlite3_soft_heap_limit interface.
This release fixes a bug in VACUUM that can lead to database corruption. The bug was introduced in version 3.3.14. Upgrading is recommended for all users. Also included are a slew of other more routine enhancements and bug fixes.
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 CorruptionFollowingBusyError and ticket #2418
This release also adds explicit limits 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.
There are also new features, including incremental BLOB I/O and incremental vacuum. See the change log for additional information.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.
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.
An annoying bug introduced in 3.3.14 has been fixed. There are also many enhancements to the test suite.
此版本主要着眼于性能提升。如果你使用 GCC -O3 参数(预编译的二进制文件使用 -O2) 重新编译 the amalgamation，可以发现相对于 3.3.13 有 35% 的性能提升，当然，这取决于你的工作负载。这个版本同时增加了对 exclusive access mode 的支持。
This version focuses on performance improvements. If you recompile the amalgamation 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 exclusive access mode.
此版本修复了使用 joins 时在 ORDER BY 优化中存在的bug，同时还有些细小的改进。推荐升级。
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.
前一版本的第一次公开build使用了错误的源代码。结果有很多人下载了错误标记为 "3.3.11" 的版本，实际上是 3.3.10。 因此发布版本 3.3.12 以消除歧义性。修正了一部分错误并增强了 PRAGMA integrity_check。
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 PRAGMA integrity_check has been enhanced.
版本 3.3.11 修正了一些 3.3.9 中的问题，在 3.3.10 中没有抓到。 推荐升级。
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.
版本 3.3.10 修正了前一个版本中引入的几个bug。推荐升级。
Version 3.3.10 fixes several bugs that were introduced by the previous release. Upgrading is recommended.
版本 3.3.9 修正了一些难以重现的导致数据库损坏的bug。更多细节可以查看 wiki 中的 数据库损坏 部分。此版本同时增加了新的 sqlite3_prepare_v2() API，并包含了命令行工具中的重大bug修正和请求优化的增强。建议升级。
Version 3.3.9 fixes bugs that can lead to database corruption under obscure and difficult to reproduce circumstances. See DatabaseCorruption in the wiki for details. This release also adds the new sqlite3_prepare_v2() API and includes important bug fixes in the command-line shell and enhancements to the query optimizer. Upgrading is recommended.
版本 3.3.8 开始支持全文检索，使用了 FTS1 模块. 同时还有一些细小的bug修正。如果使用3.3.7有问题，或者你想尝试一下新的全文检索功能，请升级到这一版本。
Version 3.3.8 adds support for full-text search using the FTS1 module. 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.
版本 3.3.7 包括了对可加载扩展和虚表的支持。但这些特性仍处于 beta 阶段，相应的 API 也会在未来的版本中有所变化。这个版本主要修复了 3.3.6 累计的细小的 bug。没有必要升级，除非你遇到这些不明显的 bug 中的一个，或者你想要尝试一下新特性。
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.
The Definitive Guide to SQLite，由 Mike Owens 所著的新书， 目前已经由 Apress 出版。 这本书涵盖了最新的 SQLite 技术内幕，包括原生 C 接口，提供给 PHP，Python，Perl，Ruby，Tcl 和 Java 语言的绑定。推荐。
The Definitive Guide to SQLite, a new book by Mike Owens. is now available from Apress. 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.
改进了对Windows下病毒扫描器的兼容性以及更快的内存 (:memory:) 型数据库。 同时修正了一些不明显的错误。旧版本有问题的话可以升级。
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.
这次发布修正了许多小bug并提供了一些细微的新功能和性能上的增强。如果之前有问题或者需要一个新的特性的话可以升级到这一版本。
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.
这次发布修正了几个bug，包括在多线程系统上可能造成死锁的严重问题。 所有在多线程环境使用SQLite的用户都应升级到这一版本。
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.
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.
More bug fixes and performance improvements as we move closer to a production-ready version 3.3.x.
Many bugs found in last week's alpha release have now been fixed and the library is running much faster again.
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 the MultiThreading wiki page for additional information.
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.
The file format for version 3.3.0 has changed slightly to support descending indices and a more efficient encoding of boolean values. SQLite 3.3.0 will read and write legacy databases created with any prior version of SQLite 3. But databases created by version 3.3.0 will not be readable or writable by earlier versions of the SQLite. The older file format can be specified at compile-time for those rare cases where it is needed.
These versions contain one-line changes to 3.2.7 and 2.8.16 to fix a bug that has been present since March of 2002 and version 2.4.0. That bug might possibly cause database corruption if a large INSERT or UPDATE statement within a multi-statement transaction fails due to a uniqueness constraint but the containing transaction commits.
This version fixes several minor and obscure bugs. Upgrade only if you are having problems.
This version fixes a bug that can result in database corruption if a VACUUM of a 1 gibibyte or larger database fails (perhaps do to running out of disk space or an unexpected power loss) and is later rolled back.
Also in this release: The ORDER BY and GROUP BY processing was rewritten to use less memory. Support for COUNT(DISTINCT) was added. The LIKE operator can now be used by the optimizer on columns with COLLATE NOCASE.
This release fixes a few more lingering bugs in the new code. We expect that this release will be stable and ready for production use.
This release fixes a bug in the new optimizer that can lead to segfaults when parsing very complex WHERE clauses.
This release adds the ANALYZE command, the CAST operator, and many very substantial improvements to the query optimizer. See the change log for additional information.
SQLite and its primary author D. Richard Hipp have been honored with
a 2005 Open Source
Award from Google and O'Reilly.
This release includes numerous minor bug fixes, speed improvements, and code size reductions. There is no reason to upgrade unless you are having problems or unless you just want to.
This release fixes a memory allocation problem in the new ALTER TABLE ADD COLUMN command.
The primary purpose for version 3.2.0 is to add support for ALTER TABLE ADD COLUMN. The new ADD COLUMN capability is made possible by AOL developers supporting and embracing great open-source software. Thanks, AOL!
Version 3.2.0 also fixes an obscure but serious bug that was discovered just prior to release. If you have a multi-statement transaction and within that transaction an UPDATE or INSERT statement fails due to a constraint, then you try to rollback the whole transaction, the rollback might not work correctly. See Ticket #1171 for details. Upgrading is recommended for all users.
Version 3.1.6 fixes a critical bug that can cause database corruption when inserting rows into tables with around 125 columns. This bug was introduced in version 3.0.0. See Ticket #1163 for additional information.
Version 3.1.4 fixes a critical bug that could cause database corruption if the autovacuum mode of version 3.1.0 is turned on (it is off by default) and a CREATE UNIQUE INDEX is executed within a transaction but fails because the indexed columns are not unique. Anyone using the autovacuum feature and unique indices should upgrade.
Version 3.1.5 adds the ability to disable the F_FULLFSYNC ioctl() in OS-X by setting "PRAGMA synchronous=on" instead of the default "PRAGMA synchronous=full". There was an attempt to add this capability in 3.1.4 but it did not work due to a spelling error.
Version 3.1.3 cleans up some minor issues discovered in version 3.1.2.
A critical bug in the VACUUM command that can lead to database corruption has been fixed in both the 2.x branch and the main 3.x line. This bug has existed in all prior versions of SQLite. Even though it is unlikely you will ever encounter this bug, it is suggested that all users upgrade. See ticket #1116. for additional information.
Version 3.1.2 is also the first stable release of the 3.1 series. SQLite 3.1 features added support for correlated subqueries, autovacuum, autoincrement, ALTER TABLE, and other enhancements. See the release notes for version 3.1.0 for a detailed description of the changes available in the 3.1 series.
Version 3.1.1 (beta) is now available on the website. Verison 3.1.1 is fully backwards compatible with the 3.0 series and features many new features including Autovacuum and correlated subqueries. The release notes From version 3.1.0 apply equally to this release beta. A stable release is expected within a couple of weeks.
Version 3.1.0 (alpha) is now available on the website. Verison 3.1.0 is fully backwards compatible with the 3.0 series and features many new features including Autovacuum and correlated subqueries. See the release notes for details.
This is an alpha release. A beta release is expected in about a week with the first stable release to follow after two more weeks.
There was a talk on the architecture of SQLite and how to optimize SQLite queries at the 2004 International PHP Conference in Frankfurt, Germany. Slides from that talk are available.
Version 3.0.8 of SQLite contains several code optimizations and minor bug fixes and adds support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. This is an incremental release. There is no reason to upgrade from version 3.0.7 if that version is working for you.
There will be a talk on the use of SQLite in Tcl/Tk at the 11th Tcl/Tk Conference this week in New Orleans. Visit http://www.tcl.tk/ for details. Slides from the talk are available.
Version 3.0 has now been in use by multiple projects for several months with no major difficulties. We consider it stable and ready for production use.
Because of some important changes to sqlite3_step(), we have decided to do an additional beta release prior to the first "stable" release. If no serious problems are discovered in this version, we will release version 3.0 "stable" in about a week.
The fourth beta release of SQLite version 3.0 is now available. The next release is expected to be called "stable".
The third beta release of SQLite version 3.0 is now available. This new beta fixes several bugs including a database corruption problem that can occur when doing a DELETE while a SELECT is pending. Expect at least one more beta before version 3.0 goes final.
The second beta release of SQLite version 3.0 is now available. This new beta fixes many bugs and adds support for databases with varying page sizes. The next 3.0 release will probably be called a final or stable release.
Version 3.0 adds support for internationalization and a new more compact file format. Details. The API and file format have been fixed since 3.0.2. All regression tests pass (over 100000 tests) and the test suite exercises over 95% of the code.
SQLite version 3.0 is made possible in part by AOL developers supporting and embracing great Open-Source Software.
SQLite version 2.8.15 is a maintenance release for the version 2.8 series. Version 2.8 continues to be maintained with bug fixes, but no new features will be added to version 2.8. All the changes in this release are minor. If you are not having problems, there is there is no reason to upgrade.
The first beta release of SQLite version 3.0 is now available. Version 3.0 adds support for internationalization and a new more compact file format. Details. As of this release, the API and file format are frozen. All regression tests pass (over 100000 tests) and the test suite exercises over 95% of the code.
SQLite version 3.0 is made possible in part by AOL developers supporting and embracing great Open-Source Software.
The www.sqlite.org website was hacked sometime around 2004-Jun-22 because the lead SQLite developer failed to properly patch CVS. Evidence suggests that the attacker was unable to elevate privileges above user "cvs". Nevertheless, as a precaution the entire website has been reconstructed from scratch on a fresh machine. All services should be back to normal as of 2004-Jun-28.
The first alpha release of SQLite version 3.0 is available for public review and comment. Version 3.0 enhances internationalization support through the use of UTF-16 and user-defined text collating sequences. BLOBs can now be stored directly, without encoding. A new file format results in databases that are 25% smaller (depending on content). The code is also a little faster. In spite of the many new features, the library footprint is still less than 240KB (x86, gcc -O1). Additional information.
Our intent is to freeze the file format and API on 2004-Jul-01. Users are encouraged to review and evaluate this alpha release carefully and submit any feedback prior to that date.
The 2.8 series of SQLite will continue to be supported with bug fixes for the foreseeable future.
SQLite version 2.8.14 is a patch release to the stable 2.8 series. There is no reason to upgrade if 2.8.13 is working ok for you. This is only a bug-fix release. Most development effort is going into version 3.0.0 which is due out soon.
Anonymous access to the CVS repository will be suspended for 2 weeks beginning on 2004-June-04. Everyone will still be able to download prepackaged source bundles, create or modify trouble tickets, or view change logs during the CVS service interruption. Full open access to the CVS repository will be restored on 2004-June-18.
Work has begun on version 3 of SQLite. Version 3 is a major changes to both the C-language API and the underlying file format that will enable SQLite to better support internationalization. The first beta is schedule for release on 2004-July-01.
Plans are to continue to support SQLite version 2.8 with bug fixes. But all new development will occur in version 3.0.