SQLite 3.8.5, an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine, has been released with an impressive list of changes and improvements.
Most of the SQLite releases are maintenance ones, but from time to time the developers make some important changes. The current update features a few new options, so an update is recommended.
According to the changelog, support has been added for partial sorting from the index, the query planner has been enhanced, improvements have been implemented to the automerge command of FTS4 to better control the index size, the sqlite3_rtree_query_callback() interface has been added to the R-Tree extension, a couple of new URI query parameters called "nolock" and "immutable" have been added, and SQLite now uses less memory by not remembering CHECK constraints.
Also, the ".system" and ".once" commands has been implemented in the command line shell, the SQLITE_TESTCTRL_BYTEORDER test control has been added, the column datatype is now reported correctly, partial index updates no longer causes an assertion fault, a bug in the VDBE code generator that caused crashes has been fixed, a problem in the CSV import, in the command line shell, has been fixed.