Small. Fast. Reliable.
Choose any three.
SQLite Release 3.5.8 On 2008 Apr 16 (3.5.8)
- Expose SQLite's internal pseudo-random number generator (PRNG)
via the sqlite3_randomness() interface
- New interface sqlite3_context_db_handle() that returns the
database connection handle that has invoked an application-defined
SQL function.
- New interface sqlite3_limit() allows size and length limits to be
set on a per-connection basis and at run-time.
- Improved crash-robustness: write the database page size into the rollback
journal header.
- Allow the VACUUM command to change the page size of a database file.
- The xAccess() method of the VFS is allowed to return -1 to signal
a memory allocation error.
- Performance improvement: The OP_IdxDelete opcode uses unpacked records,
obviating the need for one OP_MakeRecord opcode call for each index
record deleted.
- Performance improvement: Constant subexpressions are factored out of
loops.
- Performance improvement: Results of OP_Column are reused rather than
issuing multiple OP_Column opcodes.
- Fix a bug in the RTRIM collating sequence.
- Fix a bug in the SQLITE_SECURE_DELETE option that was causing
Firefox crashes. Make arrangements to always test SQLITE_SECURE_DELETE
prior to each release.
- Other miscellaneous performance enhancements.
- Other miscellaneous minor bug fixes.
A complete list of SQLite releases
in a single page is also available. A detailed history of every
check-in is available at
http://www.sqlite.org/src/timeline.