SQLite version 3.6.18 is now available for download from the SQLite
website.
http://www.sqlite.org/
The SQLite source code is tracked and managed using the Fossil
distributed configuration management system. See http://www.fossil-scm.org/
for further information on Fossil. SQLite was previously versioned
using CVS. The entire CVS history has been imported into Fossil. The
older CVS repository remains on the website but is not read-only.
There are two major enhancements in SQLite version 3.6.18. The first
is a series or refinements to the query planner that help SQLite to
choose better plans for joins where in the past it was selecting
suboptimal query plans. The SQLITE_ENABLE_STAT2 compile-time option
has been added to cause SQLite to collect histogram data on indices
when the ANALYZE command is run. The use of histograms improve the
query planning performance even more.
The second major enhancement is that SQLite now support recursive
triggers. The older non-recursive behavior of triggers is still the
default behavior. Recursive triggers are activated using the
recursive_triggers pragma. In addition to allowing triggers to call
themselves (either directly or indirectly) the new capability also
fires DELETE triggers on rows that are removed from a table as a
result of REPLACE conflict resolution processing.
Non-recursive triggers are still the default behavior since this is
least likely to cause problems for existing applications. However, we
anticipate that triggers will become recursive by default beginning
with release 3.7.0. At that point, applications that want to continue
using the older non-recursive trigger behavior will need to use the
recursive_triggers pragma to disable recursive triggers.
This version of SQLite also contains bug fixes, though none of the
bugs are serious and all are obscure, so upgrading is optional.
The SQLite core continues to have 100% branch test coverage and so
despite the many changes in this release, the developers believe that
this version of SQLite is stable and ready for production use.
Please let me know if you encounter any problems.
D. Richard Hipp
d...@hwaci.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
