Whats new in version 3.8.5:
- Added support for partial sorting by index.
- Enhance the query planner so that it always prefers an index that uses a superset of WHERE clause terms relative to some other index.
- Improvements to the automerge command of FTS4 to better control the index size for a full-text index that is subject to a large number of updates.
- Added the sqlite3_rtree_query_callback() interface to R-Tree extension
- Added new URI query parameters "nolock" and "immutable".
- Use less memory by not remembering CHECK constraints on read-only database connections.
- Enable the OR optimization for WITHOUT ROWID tables.
- Render expressions of the form "x IN (?)" (with a single value in the list on the right-hand side of the IN operator) as if they where "x==?", Similarly optimize "x NOT IN (?)"
- Add the ".system" and ".once" commands to the command-line shell.
- Added the SQLITE_IOCAP_IMMUTABLE bit to the set of bits that can be returned by the xDeviceCharacteristics method of a VFS.
- ...
Publisher review:SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world.
Operating system:Mac OS X