SQLite 3.7.5 Release

2011.02.01 에 SQLite 3.7.5 버전이 공개가 되었다.

명절을 지낸 후에야 소식을 접할 수 있었다.

아래는 3.7.5 버전에서 변경된 사항이다.

2011 February 01 (3.7.5)

• Added the sqlite3_vsnprintf() interface.
• Added the SQLITE_DBSTATUS_LOOKASIDE_HIT, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE, and SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL options for the sqlite3_db_status() interface.
• Added the SQLITE_OMIT_AUTORESET compile-time option.
• Added the SQLITE_DEFAULT_FOREIGN_KEYS compile-time option.
• Updates to sqlite3_stmt_readonly() so that its result is well-defined for all prepared statements and so that it works with VACUUM.
• Added the "-heap" option to the command-line shell
• Fix a bug involving frequent changes in and out of WAL mode and VACUUM that could (in theory) cause database corruption.
• Enhance the sqlite3_trace() mechanism so that nested SQL statements such as might be generated by virtual tables are shown but are shown in comments and without parameter expansion. This greatly improves tracing output when using the FTS3/4 and/or RTREE virtual tables.
• Change the xFileControl() methods on all built-in VFSes to return SQLITE_NOTFOUND instead of SQLITE_ERROR for an unrecognized operation code.
• The SQLite core invokes the SQLITE_FCNTL_SYNC_OMITTED file control to the VFS in place of a call to xSync if the database has PRAGMA synchronous set to OFF.

보기에는 바뀐게 많지 않아 보이는데 정적 라이브러리를 만들기 위해 소스를 보니 ICU 옵션이 추가되었다. VC 에서는 문제가 없었지만 BC (Embarcadero C++ Builder) 에서는 문제가 되는 것 같다. 

이 글에서는 새 버전에 대한 글만 올리고 라이브러리 관련된 것은 변화가 있기때문에 테스트를 거친후에 올려야 겠다.