Updated: sqlite3-3.7.3-1

Warren Young warren@etr-usa.com
Wed Dec 1 19:37:00 GMT 2010


Homepage: http://sqlite.org/
License : Public Domain (no, really!)

SQLite is a C library providing local database storage with a SQL 
interface.  Unlike most SQL database systems, SQLite does not accept 
connections from remote users.  Access to the database requires access 
to the file system hosting it; SQLite thus relies on the operating 
system's file security for access control.  In exchange for this 
limitation, you get a smaller, faster database engine that's easy to 
embed within a program.


Changes since previous, 3.6.21-3:

2010 October 08 (3.7.3)

     * Added the sqlite3_create_function_v2() interface that includes a
       destructor callback.
     * Added support for custom r-tree queries using application-
       supplied callback routines to define the boundary of the query
     * The default page cache strives more diligently to avoid using
       memory beyond what is allocated to it by SQLITE_CONFIG_PAGECACHE.
       Or if using page cache is allocating from the heap, it strives to
       avoid going over the sqlite3_soft_heap_limit64(), even if
     * Added the sqlite3_soft_heap_limit64() interface as a replacement
       for sqlite3_soft_heap_limit().
     * The ANALYZE command now gathers statistics on tables even if they
       have no indices.
     * Tweaks to the query planner to help it do a better job of finding
       the most efficient query plan for each query.
     * Enhanced the internal text-to-numeric conversion routines so that
       they work with UTF8 or UTF16, thereby avoiding some UTF16-to-UTF8
       text conversions.
     * Fix a problem that was causing excess memory usage with large WAL
       transactions in win32 systems.
     * The interface between the VDBE and B-Tree layer is enhanced such
       that the VDBE provides hints to the B-Tree layer letting the
       B-Tree layer know when it is safe to use hashing instead of
       B-Trees for transient tables.
     * Miscellaneous documentation enhancements.

2010 August 24 (3.7.2)

     * Fix an old and very obscure bug that can lead to corruption of
       the database free-page list when incremental_vacuum is used.

2010 August 23 (3.7.1)

     * Added new commands SQLITE_DBSTATUS_SCHEMA_USED and
       SQLITE_DBSTATUS_STMT_USED to the sqlite3_db_status() interface,
       in order to report out the amount of memory used to hold the
       schema and prepared statements of a connection.
     * Increase the maximum size of a database pages from 32KiB to 64KiB.
     * Use the LIKE optimization even if the right-hand side string
       contains no wildcards.
     * Added the SQLITE_FCNTL_CHUNK_SIZE verb to the
       sqlite3_file_control() interface for both unix and windows, to
       cause database files to grow in large chunks in order to reduce
       disk fragmentation.
     * Fixed a bug in the query planner that caused performance
       regressions relative to on some complex joins.
     * Fixed a typo in the OS/2 backend.
     * Refactored the pager module.
     * The SQLITE_MAX_PAGE_SIZE compile-time option is now silently
       ignored. The maximum page size is hard-coded at 65536 bytes.

2010 August 04 (

     * Fix a potential database corruption bug that can occur if version
       3.7.0 and version alternately write to the same database
       file. Ticket [51ae9cad317a1]
     * Fix a performance regression related to the query planner
       enhancements of version 3.7.0.

2010 July 22 (3.7.0)

     * Added support for write-ahead logging.
     * Query planner enhancement - automatic transient indices are
       created when doing so reduces the estimated query time.
     * Query planner enhancement - the ORDER BY becomes a no-op if the
       query also contains a GROUP BY clause that forces the correct
       output order.
     * Add the SQLITE_DBSTATUS_CACHE_USED verb for sqlite3_db_status().
     * The logical database size is now stored in the database header so
       that bytes can be appended to the end of the database file
       without corrupting it and so that SQLite will work correctly on
       systems that lack support for ftruncate().

2010 March 30 (

     * Fix a bug in the offsets() function of FTS3
     * Fix a missing "sync" that when omitted could lead to database
       corruption if a power failure or OS crash occurred just as a
       ROLLBACK operation was finishing.

2010 March 09 (3.6.23)

     * Added the secure_delete pragma.
     * Added the sqlite3_compileoption_used() and
       sqlite3_compileoption_get() interfaces as well as the
       compile_options pragma and the sqlite_compileoption_used() and
       sqlite_compileoption_get() SQL functions.
     * Added the sqlite3_log() interface together with the
       SQLITE_CONFIG_LOG verb to sqlite3_config(). The ".log" command is
       added to the Command Line Interface.
     * Improvements to FTS3.
     * Improvements and bug-fixes in support for
     * The integrity_check pragma is enhanced to detect out-of-order
     * The ".genfkey" operator has been removed from the Command Line
     * Updates to the co-hosted Lemon LALR(1) parser generator. (These
       updates did not affect SQLite.)
     * Various minor bug fixes and performance enhancements.

2010 Jan 06 (3.6.22)

     * Fix bugs that can (rarely) lead to incorrect query results when
       the CAST or OR operators are used in the WHERE clause of a query.
     * Continuing enhancements and improvements to FTS3.
     * Other miscellaneous bug fixes.


Standard install.


To install this package, click on the "Install Cygwin now" link on the
<http://cygwin.com/> web page. This downloads setup.exe to your
system. Then, run setup and answer all of the questions. You'll find
the package listed in the "All" category. After installation, read the
documentation at directories:


If you have questions or comments, please send them to the Cygwin
mailing list.


This message has been sent to cygwin-announce list.

If you want to unsubscribe from the mailing list, look at the
"List-Unsubscribe: " tag in the email header of this message. Send
email to the address specified there. It will be in the format:


More information on unsubscribing can be found:


Please read *all* of the information on unsubscribing that is available
starting at the above URL.

More information about the Cygwin-announce mailing list