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

SQLite Release 3.7.3 On 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.

이번 버전에서는 정적 라이브러리를 만들기 위해 컴파일을 시도 하면 sqlite3rtree.h 파일을 찾을 수 없다는 에러 메세지가 발생하였다. 이 문제에 대한 자료를 찾기가 어려워 우선 sqlite3rtree.h 파일을 sqlite-3.7.3.tar.gz 파일에서 찾아(sqlite-3.7.3.tar.gz\sqlite-3.7.3.tar\sqlite-3.7.3\ext\rtree\) 넣어 컴파일을 하였다

SQLite Homepage

SQLite ReleaseNote

SQLite3_v3.7.3.0_Libraries_for_CppBuilder.7z

SQLite3_v3.7.3.0_Libraries_for_VisualCpp.7z

<

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