2010/08/30

SQLite Release 3.7.2.0 (정적/동적 라이브러리 포함)




SQLite 가 3.7.2 버전을 공개하였고 이하의 버전을 사용하는 경우 업그레이드를 권고하고 있다.



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






<

Original Post : http://neodreamer-dev.tistory.com/457

2010/08/05

SQLite Release 3.7.0.1 (정적/동적 라이브러리 포함)

이번 버전에서 바뀐 사항

  • Fix a potential database corruption problem that can result if the same database file is alternately written by version 3.7.0 and 3.6.23.1. See ticket [51ae9cad31] for details.

  • Fix a possible performance regression caused by the introduction of automatic indexing.