SQLite3 3.7.12.1 freeware    

Author Richard Hipp OS WinXP, Windows Vista, Windows Vista x64, Windows 7, Windows 7 x64 Date Released May 23, 2012 Downloads 65 Filesize 256 kB Keywords SQLite Database, Access Database, SQL Command, SQLite, Database, Access Your Rating   - click to rate - you will be first!

[ View full size screenshot ]

Download SQLite3   Save Freeware   Report Spyware

SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects. ...

Download SQLite3   Save Freeware   Report Spyware

Disk optimization - SQLite3 freeware - Download Notice

SQLite3 Free Download - we do not host any SQLite3 torrent files or links of SQLite3 on rapidshare.com, depositfiles.com, megaupload.com etc. All SQLite3 download links are direct SQLite3 full download from publisher site or their selected mirrors.

Disk optimization - SQLite3 freeware - Latest User Reviews

 Write a Review   

Disk optimization - SQLite3 freeware - The Latest Versions History

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