[ANNOUNCEMENT] Updated: sqlite3-3.7.3-1

[Warren Young <warren at etr-usa dot com>]

PACKAGE DESCRIPTION
===================

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 LAST RELEASE
==========================

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
      region.
    * 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
      SQLITE_ENABLE_MEMORY_MANAGEMENT is not set.
    * 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 3.6.23.1 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 (3.7.0.1)

    * Fix a potential database corruption bug that can occur if version
      3.7.0 and version 3.6.23.1 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 (3.6.23.1)

    * 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
      SQLITE_OMIT_FLOATING_POINT.
    * The integrity_check pragma is enhanced to detect out-of-order
      rowids.
    * The ".genfkey" operator has been removed from the Command Line
      Interface.
    * 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.


INSTALL OR UPGRADE NOTES
========================

Standard install.


CYGWIN INSTALLATION INFORMATION
===============================

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:

    /usr/share/doc/<package-version>/*
    /usr/share/doc/Cygwin/<package-version>.README

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


CYGWIN-ANNOUNCE UNSUBSCRIBE INFO
================================

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:

    cygwin-announce-unsubscribe-you=yourdomain.com@cygwin.com

More information on unsubscribing can be found:

    http://sources.redhat.com/lists.html#unsubscribe-simple

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

--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple