|
![]() [ View full size screenshot ] |
| Version | Date Released | Status | Release Notes |
| 3.7.12.1 | May 23, 2012 | New Release | · Add the SQLITE_DBSTATUS_CACHE_WRITE option for sqlite3_db_status(). · Optimize the typeof() and length() SQL functions so that they avoid unnecessary reading of database content from disk. · Add the FTS4 "merge" command, the FTS4 "automerge" command, and the FTS4 "integrity-check" command. · Report the name of specific CHECK constraints that fail. · In the command-line shell, use popen() instead of fopen() if the first character of the argument to the ".output" command is "|". · Make use of OVERLAPPED in the windows VFS to avoid some system calls and thereby obtain a performance improvement. · More aggressive optimization of the AND operator when one side or the other is always false. · Improved performance of queries with many OR-connected terms in the WHERE clause that can all be indexed. · Add the SQLITE_RTREE_INT_ONLY compile-time option to force the R*Tree Extension Module to use integer instead of floating point values for both storage and computation. |
| 3.7.11 | Mar 22, 2012 | New Release | · Enhance the INSERT syntax to allow multiple rows to be inserted via the VALUES clause. · Enhance the CREATE VIRTUAL TABLE command to support the IF NOT EXISTS clause. · Added the sqlite3_stricmp() interface as a counterpart to sqlite3_strnicmp(). · Added the sqlite3_db_readonly() interface. · Added the SQLITE_FCNTL_PRAGMA file control, giving VFS implementations the ability to add new PRAGMA statements or to override built-in PRAGMAs. · Queries of the form: "SELECT max(x), y FROM table" returns the value of y on the same row that contains the maximum x value. · Added support for the FTS4 languageid option. · Documented support for the FTS4 content option. This feature has actually been in the code since version 3.7.9 but is only now considered to be officially supported. · Pending statements no longer block ROLLBACK. Instead, the pending statement will return SQLITE_ABORT upon next access after the ROLLBACK. · Improvements to the handling of CSV inputs in the command-line shell |
| 3.7.10 | Feb 9, 2012 | New Release | · The SQLITE_CONFIG_PCACHE mechanism has been replaced with SQLITE_CONFIG_PCACHE2. If you do not know what this mechanism is (it is an extreme corner-case and is seldom used) then this change will not effect you in the least · The default schema format number for new database files has changed from 1 to 4. SQLite has been able to generate and read database files using schema format 4 for six years. But up unto now, the default schema format has been 1 so that older versions of SQLite could read and write databases generated by newer versions of SQLite. But those older versions of SQLite have become so scarce now that it seems reasonable to make the new format the default · SQLite is changing some of the assumptions it makes above the behavior of disk drives and flash memory devices during a sudden power loss. This change is completely transparent to applications. Read about the powersafe overwrite property for additional information |