[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-announce
Subject:    [sqlite-announce] SQLite version 3.8.0
From:       D. Richard Hipp <drh () hwaci ! com>
Date:       2013-08-26 20:41:31
Message-ID: 3D154534-28AB-4A66-84AB-D7491CFA2BB7 () hwaci ! com
[Download RAW message or body]

SQLite version 3.8.0 is now available on the SQLite website.

     http://www.sqlite.org/
     http://www.sqlite.org/download.html

Important enhancements in this release include a rewritten query planner =
and support for partial indices.  Further detail is available at

     http://www.sqlite.org/releaselog/3_8_0.html

Do not fear the zero in this version number!   The 3.8.0 release might =
easily have been called 3.7.18 instead.  We decided to increase the =
minor version from 7 to 8 because of the rewrite of the query planner.  =
But the software is quite stable and is ready for production use.  =
Remember that SQLite is very carefully tested.  (See =
http://www.sqlite.org/testing.html for an overview of test procedures =
and http://www.sqlite.org/checklists/3080000/index for the release =
testing checklist.)  In addition, beta versions of the new query planner =
have been downloaded from many thousands of distinct IP addresses, and =
presumably tested on some fraction of those, with zero problem reports.  =
The new query planner has been in use internally at SQLite.org for over =
two months with no issues noted.  For simple queries, the new query =
planner should give exactly the same result (though perhaps with a =
little less CPU time spent planning) and for complex queries, the new =
query planner can in many cases provide a much faster answer.  Note that =
in the course of writing the new query planner we discovered several =
latent bugs in the legacy planner which are fixed in the new query =
planner.  So upgrading is recommended.

--
D. Richard Hipp
drh@sqlite.org




[prev in list] [next in list] [prev in thread] [next in thread]