CVS commit: pkgsrc/databases

[Adam Ciarcinski <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Aug 27 09:50:22 UTC 2010

Modified Files:
        pkgsrc/databases/sqlite3: Makefile distinfo
        pkgsrc/databases/sqlite3-tcl: Makefile distinfo

Log Message:
Changes 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.

Changes 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 regresssions
  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.


To generate a diff of this commit:
cvs rdiff -u -r1.31 -r1.32 pkgsrc/databases/sqlite3/Makefile
cvs rdiff -u -r1.52 -r1.53 pkgsrc/databases/sqlite3/distinfo
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/sqlite3-tcl/Makefile
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/sqlite3-tcl/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.