SQLite Release 3.7.17

SQLite 버전이 업데이트 되었다.


SQLite Release 3.7.17 On 2013-05-20 (3.7.17)

Add support for memory-mapped I/O.

Add the sqlite3_strglob() convenience interface.

Assigned the integer at offset 68 in the database header as the
Application ID for when SQLite is used as an application file-format.
Added the PRAGMA application_id command to query and set the Application ID.

Report rollback recovery in the error log as SQLITE_NOTICE_RECOVER_ROLLBACK.
Change the error log code for WAL recover from
SQLITE_OK to SQLITE_NOTICE_RECOVER_WAL.

Report the risky uses of unlinked database files and
database filename aliasing as SQLITE_WARNING messages in the error log.

Added the SQLITE_TRACE_SIZE_LIMIT compile-time option.

Increase the default value of SQLITE_MAX_SCHEMA_RETRY to 50 and make sure
that it is honored in every place that a schema change might force a statement
retry.

Add a new test harness called "mptester" used to verify correct operation
when multiple processes are using the same database file at the same time.

Enhance the extension loading mechanism to be more flexible (while
still maintaining backwards compatibility) in two ways:

1. If the default entry point "sqlite3_extension_init" is not present in
   the loadable extension, also try an entry point "sqlite3_X_init" where
   "X" is based on the shared library filename. This allows every extension
   to have a different entry point, which allows them to be statically linked
   with no code changes.
   


2. The shared library filename passed to sqlite3_load_extension() may
   omit the filename suffix, and an appropriate architecture-dependent
   suffix (".so", ".dylib", or ".dll") will be added automatically.
   

Added many new loadable extensions to the source tree, including
amatch, closure, fuzzer, ieee754, nextchar, regexp, spellfix,
and wholenumber. See header comments on each extension source file
for further information about what that extension does.

Enhance FTS3 to avoid using excess stack space when there are a huge
number of terms on the right-hand side of the MATCH operator. A side-effect
of this change is that the MATCH operator can only accommodate 12 NEAR
operators at a time.

Enhance the fts4aux virtual table so that it can be a TEMP table.

Added the fts3tokenize virtual table to the full-text search logic.

Query planner enhancement: Use the transitive property of constraints
to move constraints into the outer loops of a join whenever possible,
thereby reducing the amount of work that needs to occur in inner loops.

Discontinue the use of posix_fallocate() on unix, as it does not work on all
filesystems.

Improved tracing and debugging facilities in the Windows VFS.

Bug fix: Fix a potential database corruption bug
in shared cache mode when one
database connection is closed while another is in the middle of a write
transaction.
Ticket e636a050b7

Bug fix:
Only consider AS names from the result set as candidates for resolving
identifiers in the WHERE clause if there are no other matches. In the
ORDER BY clause, AS names take priority over any column names.
Ticket 2500cdb9be05

Bug fix: Do not allow a virtual table to cancel the ORDER BY clause unless
all outer loops are guaranteed to return no more than one row result.
Ticket ba82a4a41eac1.

Bug fix: Do not suppress the ORDER BY clause on a virtual table query if
an IN constraint is used.
Ticket f69b96e3076e.

Bug fix: The command-line shell gives an exit code of 0 when terminated
using the ".quit" command.

Bug fix: Make sure PRAGMA statements appear in sqlite3_trace() output.

Bug fix: When a compound query that uses an ORDER BY clause
with a COLLATE operator, make sure that the sorting occurs
according to the specified collation and that the comparisons associate with
the compound query use the native collation. Ticket
6709574d2a8d8.

Bug fix: Makes sure the authorizer callback gets
a valid pointer to the string "ROWID" for the column-name parameter when
doing an UPDATE that changes the rowid. Ticket
0eb70d77cb05bb2272

Bug fix: Do not move WHERE clause terms inside OR expressions that are
contained within an ON clause of a LEFT JOIN. Ticket
f2369304e4

Bug fix: Make sure an error is always reported when attempting to preform
an operation that requires a collating sequence that is missing.
Ticket 0fc59f908b

SQLITE_SOURCE_ID:
"2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668"

SHA1 for sqlite3.c: 246987605d0503c700a08b9ee99a6b5d67454aab


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

SQLite Release 3.7.14

SQLite Release 3.7.14 On 2012-09-03 (3.7.14)

• Drop built-in support for OS/2. If you need to upgrade an OS/2 application to use this or a later version of SQLite, then add an application-defined VFS using the sqlite3_vfs_register() interface. The code removed in this release can serve as a baseline for the application-defined VFS.
  


• Ensure that floating point values are preserved exactly when reconstructing a database from the output of the ".dump" command of the command-line shell.
  


• Added the sqlite3_close_v2() interface.
  


• Updated the command-line shell so that it can be built using SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT.
  


• Improvements to the windows makefiles and build processes.
  


• Enhancements to PRAGMA integrity_check and PRAGMA quick_check so that they can optionally check just a single attached database instead of all attached databases.
  


• Enhancements to WAL mode processing that ensure that at least one valid read-mark is available at all times, so that read-only processes can always read the database.
  


• Performance enhancements in the sorter used by ORDER BY and CREATE INDEX.
  


• Added the SQLITE_DISABLE_FTS4_DEFERRED compile-time option.
  


• Better handling of aggregate queries where the aggregate functions are contained within subqueries.
  


• Enhance the query planner so that it will try to use a covering index on queries that make use of or optimization.
  


• SQLITE_SOURCE_ID: "2012-09-03 15:42:36 c0d89d4a9752922f9e367362366efde4f1b06f2a"
  


• SHA1 for sqlite3.c: 5fdf596b29bb426001f28b488ff356ae14d5a5a6
  

SQLite 3.7.14 Release Note<

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

SQLite Release 3.7.13

SQLite 가 버전업을 하였다.

이번 배포판부터는 Metro style 응용프로그램을 위한 WinRT API 를 사용한 Dll 파일을 배포하고 있다.




SQLite Release 3.7.13 On 2012-06-11 (3.7.13)

• In-memory databases that are specified using URI filenames are allowed to use shared cache, so that the same in-memory database can be accessed from multiple database connections.
  


• Recognize and use the mode=memory query parameter in URI filenames.
  


• Avoid resetting the schema of shared cache connections when any one connection closes. Instead, wait for the last connection to close before reseting the schema.
  


• In the RTREE extension, when rounding 64-bit floating point numbers to 32-bit for storage, always round in a direction that causes the bounding box to get larger.
  


• Adjust the unix driver to avoid unnecessary calls to fchown().
  


• Add interfaces sqlite3_quota_ferror() and sqlite3_quota_file_available() to the test_quota.c module.
  


• The sqlite3_create_module() and sqlite3_create_module_v2() interfaces return SQLITE_MISUSE on any attempt to overload or replace a virtual table module. The destructor is always called in this case, in accordance with historical and current documentation.
  


• SQLITE_SOURCE_ID: "2012-06-11 02:05:22 f5b5a13f7394dc143aa136f1d4faba6839eaa6dc"
  


• SHA1 for sqlite3.c: ff0a771d6252545740ba9685e312b0e3bb6a641b
  

SQLite Homepage&

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

SQLite Release 3.7.12.1

SQLite 가 3.7.12 버전을 공개한지 얼마 되지 않아 다시 3.7.12.1 버전을 공개하였다.



SQLite Release 3.7.12.1 On 2012 May 22 (3.7.12.1)

• Fix a bug (ticket c2ad16f997) in the 3.7.12 release that can cause a segfault for certain obscure nested aggregate queries.
  


• Fix various other minor test script problems.
  


• SQLITE_SOURCE_ID: "2012-05-22 02:45:53 6d326d44fd1d626aae0e8456e5fa2049f1ce0789"
  


• SHA1 for sqlite3.c: d494e8d81607f0515d4f386156fb0fd86d5ba7df
  

SQLite Homepage

SQLite Download pag

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

SQLite Release 3.7.12

Release 3.7.12 On 2012 May 14

• Add the SQLITE_DBSTATUS_CACHE_WRITE option for sqlite3_db_status().
  


• Optimize the typeof() and length() SQL functions so that they avoid unnecessary reading of database content from disk.
  


• Add the FTS4 "merge" command, the FTS4 "automerge" command, and the FTS4 "integrity-check" command.
  


• Report the name of specific CHECK constraints that fail.
  


• In the command-line shell, use popen() instead of fopen() if the first character of the argument to the ".output" command is "|".
  


• Make use of OVERLAPPED in the windows VFS to avoid some system calls and thereby obtain a performance improvement.
  


• More aggressive optimization of the AND operator when one side or the other is always false.
  


• Improved performance of queries with many OR-connected terms in the WHERE clause that can all be indexed.
  


• Add the SQLITE_RTREE_INT_ONLY compile-time option to force the R*Tree Extension Module to use integer instead of floating point values for both storage and computation.
  


• Enhance the PRAGMA integrity_check command to use much less memory when processing multi-gigabyte databases.
  


• New interfaces added to the test_quota.c add-on module.
  


• Added the ".trace" dot-command to the command-line shell.
  


• Allow virtual table constructors to be invoked recursively.
  


• Improved optimization of ORDER BY clauses on compound queries.
  


• Improved optimization of aggregate subqueries contained within an aggregate query.
  


• Bug fix: Fix the RELEASE command so that it does not cancel pending queries. This repairs a problem introduced in 3.7.11.
  


• Bug fix: Do not discard the DISTINCT as superfluous unless a subset of the result set is subject to a UNIQUE constraint and it none of the columns in that subset can be NULL. Ticket 385a5b56b9.
  


• Bug fix: Do not optimize away an ORDER BY clause that has the same terms as a UNIQUE index unless those terms are also NOT NULL. Ticket 2a5629202f.
  


• SQLITE_SOURCE_ID: "2012-05-14 01:41:23 8654aa9540fe9fd210899d83d17f3f407096c004"
  


• SHA1 for sqlite3.c: 57e2104a0f7b3f528e7f6b7a8e553e2357ccd2e1
  

SQLite 3 Homepage

SQLite 3 Download Page&

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

SQLite 3.7.9 Release (include Library)

SQLite Release 3.7.9 On 2011 November 1 (3.7.9)

• If a search token (on the right-hand side of the MATCH operator) in FTS4 begins with "^" then that token must be the first in its field of the document. ** Potentially Incompatible Change **
  


• Added options SQLITE_DBSTATUS_CACHE_HIT and SQLITE_DBSTATUS_CACHE_MISS to the sqlite3_db_status() interface.
  


• Removed support for SQLITE_ENABLE_STAT2, replacing it with the much more capable SQLITE_ENABLE_STAT3 option.
  


• Enhancements to the sqlite3_analyzer utility program, including the --pageinfo and --stats options and support for multiplexed databases.
  


• Enhance the sqlite3_data_count() interface so that it can be used to determine if SQLITE_DONE has been seen on the prepared statement.
  


• Added the SQLITE_FCNTL_OVERWRITE file-control by which the SQLite core indicates to the VFS that the current transaction will overwrite the entire database file.
  


• Increase the default lookaside memory allocator allocation size from 100 to 128 bytes.
  


• Enhanced the query planner so that it can factor terms in and out of OR expressions in the WHERE clause in an effort to find better indices.
  


• Added the SQLITE_DIRECT_OVERFLOW_READ compile-time option, causing overflow pages to be read directly from the database file, bypassing the page cache.
  


• Remove limits on the magnitude of precision and width value in the format specifiers of the sqlite3_mprintf() family of string rendering routines.
  


• Fix a bug that prevent ALTER TABLE ... RENAME from working on some virtual tables in a database with a UTF16 encoding.
  


• Fix a bug in ASCII-to-float conversion that causes slow performance and incorrect results when converting numbers with ridiculously large exponents.
  


• Fix a bug that causes incorrect results in aggregate queries that use multiple aggregate functions whose arguments contain complicated expressions that differ only in the case of string literals contained within those expressions.
  


• Fix a bug that prevented the page_count and quick_check pragmas from working correctly if their names were capitalized.
  


• Fix a bug that caused VACUUM to fail if the count_changes pragma was engaged.
  


• Fix a bug in virtual table implementation that causes a crash if an FTS4 table is dropped inside a transaction and a SAVEPOINT occurs afterwards.
  

SQLITE_SOURCE_ID: "2011-11-01 00:52:41 c7c6050ef060877ebe77b41d959e9df13f8c9b5e"


SHA1 for sqlite3.c: becd16877f4f9b281b91c97e106089497d71bb47




SQLite website

SQLite3_v3.7.9.0_Libraries_for_VisualCpp.7z

SQLite3_v3.7.9.0_Libraries_for_CppBuilder.7z

<

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

SQLite Release 3.7.8

SQLite 3.7.8 (2011/09/19)

• Orders of magnitude performance improvement for CREATE INDEX on very large tables.
  


• Improved the windows VFS to better defend against interference from anti-virus software.
  


• Improved query plan optimization when the DISTINCT keyword is present.
  


• Allow more system calls to be overridden in the unix VFS - to provide better support for chromium sandboxes.
  


• Increase the default size of a lookahead cache line from 100 to 128 bytes.
  


• Enhancements to the test_quota.c module so that it can track preexisting files.
  


• Bug fix: Virtual tables now handle IS NOT NULL constraints correctly.
  


• Bug fixes: Correctly handle nested correlated subqueries used with indices in a WHERE clause.
  


• SQLITE_SOURCE_ID: "2011-09-19 14:49:19 3e0da808d2f5b4d12046e05980ca04578f581177"
  


• SHA1 for sqlite3.c: bfcd74a655636b592c5dba6d0d5729c0f8e3b4de
  

SQLite homepage&

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

SQLite 3.7.6.2 Released!!

Version 3.7.6.2 (2011 April 17)

• Fix the function prototype for the open(2) system call to agree with POSIX. Without this fix, pthreads does not work correctly on NetBSD.


• SQLITE_SOURCE_ID: "2011-04-17 17:25:17 154ddbc17120be2915eb03edc52af1225eb7cb5e"


• SHA1 for sqlite3.c: 806577fd524dd5f3bfd8d4d27392ed2752bc9701

SQLite Homepage 

SQLite Download page<

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

SQLite 3.7.6.1 Released!!

Version 3.7.6.1 (2011 April 14)

• Fix a bug in 3.7.6 that only appears if the SQLITE_FCNTL_SIZE_HINT
  file control is used with a build of SQLite that makes use of the
  HAVE_POSIX_FALLOCATE compile-time option and which has
  SQLITE_ENABLE_LOCKING_MODE turned off.
  


• SQLITE_SOURCE_ID:
  "2011-04-13 14:40:25 a35e83eac7b185f4d363d7fa51677f2fdfa27695"
  


• SHA1 for sqlite3.c: b81bfa27d3e09caf3251475863b1ce6dd9f6ab66
  

Version 3.7.6 (2011 April 12)

• Added the sqlite3_wal_checkpoint_v2() interface and enhanced the
  wal_checkpoint pragma to support blocking checkpoints.
  


• Improvements to the query planner so that it makes better estimates of
  plan costs and hence does a better job of choosing the right plan,
  especially when SQLITE_ENABLE_STAT2 is used.
  


• Fix a bug which prevented deferred foreign key constraints from being
  enforced when sqlite3_finalize() was not
  called by one statement with a failed foreign key constraint prior to
  another statement with foreign key constraints running.
  


• Integer arithmetic operations that would have resulted in overflow
  are now performed using floating-point instead.
  


• Increased the version number on the VFS object to
  3 and added new methods xSetSysCall, xGetSysCall, and xNextSysCall
  used for doing full-coverage testing.
  


• Increase the maximum value of SQLITE_MAX_ATTACHED from 30 to 62
  (though the default value remains at 10).
  


• Enhancements to FTS4:
  
  
  
  
  1. Added the fts4aux table
     
  
  
  2. Added support for compressed FTS4 content
     
  
  
  
  
  


• Enhance the ANALYZE command to support the name of an index
  as its argument, in order to analyze just that one index.
  


• Added the "unix-excl" built-in VFS on unix and unix-like platforms.
  


• SQLITE_SOURCE_ID:
  "2011-04-12 01:58:40 f9d43fa363d54beab6f45db005abac0a7c0c47a7"
  


• SHA1 for sqlite3.c: f38df08547efae0ff4343da607b723f588bbd66b
  

SQLite Homepage


SQLite Download pag

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

SQLiteSpy 1.8.16

무료 로컬 데이터베이스인 SQLite 를 효과적으로 관리할 수 있는 관리 프로그램이다.

홈페이지에서 다운로드 받기가 너무 어렵다. 접속이 되지 않을 때가 너무 많다.

홈페이지 http://www.yunqa.de

Download Site1 Site2<

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

SQLite 3.7.0 Released!!

모처럼만에 SQLite 가 업데이트 되었다. 이번에 업데이트를 진행하면서 부터인지 웹페이지도 분위기도 로고도 좀 바뀌었다.

SQLite 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().

SQLite 홈페이지

SQLite Release Note

<

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

SQLite 에서 Transaction 사용하기

간단한 데이터 파일을 SQLite 를 이용하여 저장하도록 프로그램을 작성하였는데 엄청난 성능을 보여 주었다. 간단한 저장을 수초에 걸려 처리를 하는 것이였다.



인터넷으로 관련 자료를 찾아보니 Insert 처리 속도가 Transaction 의 사용 여부에 따라 엄청난 결과를 가져왔다.

참고 : Database Speed Comparison



SQLite 의 Transaction Begin stmt 와 Commit stmt 그리고 Rollback stmt 로 구성되는데 구문은 아래와 같다.



begin-stmt:

commit-stmt:

rollback-stmt:

참고 : SQL As Understood By SQLite



C/C++ API 를 이용하는 코드에서는 아래와 같은 명령을 실행 하면 된다.

sqlite3_exec( db, "BEGIN", NULL, NULL, NULL );
:
:
sqlite3_exec( db, "COMMIT", NULL, NULL, NULL );

<

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

SQLite 3.6.22 Released & Library (Static, Dynamic)

3.6.22 ( 2010/01/06 ) 에서 변경된 사항

• 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 miscellanous bug fixes.

SQLite homepage




SQLite Library for C++ Builder (DLL 및 정적라이브러리)

SQLite3_v3.6.22_Libraries_For_CppBuilder.7z

SQLite Library for Visual C++ ( DLL 및 정적라이브러리 32/64bit)

SQLite3_v3.6.22_Libraries_for_VisualCpp.7z

<

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

SQLite 3.6.19 Released

이번 버전에서 수정된 사항

• Added support for foreign key constraints. Foreign key constraints are disabled by default. Use the foreign_keys pragma to turn them on.
• Generalized the IS and IS NOT operators to take arbitrary expressions on their right-hand side.
• The TCL Interface has been enhanced to use the Non-Recursive Engine (NRE) interface to the TCL interpreter when linked against TCL 8.6 or later.
• Fix a bug introduced in 3.6.18 that can lead to a segfault when an attempt is made to write on a read-only database.
  

SQLite homepage
SQLite download
Original Post : http://neodreamer-dev.tistory.com/335

SQLite 3.6.18 Released!!

SQLite가 한달 만에 업데이트가 되었다.

사이트 에서는 이전 버전 3.6.12 이전 버전의 사용자는 업그레이드를 추천하고있다.

이번 버전에서 수정된 사항은 아래와 같다.
SQLite Release 3.6.18 On 2009 Sep 11 (3.6.18)

• Versioning of the SQLite source code has transitioned from CVS to Fossil.
• Query planner enhancements.
• The SQLITE_ENABLE_STAT2 compile-time option causes the ANALYZE command to collect a small histogram of each index, to help SQLite better select among competing range query indices.
• Recursive triggers can be enabled using the PRAGMA recursive_triggers statement.
• Delete triggers fire when rows are removed due to a REPLACE conflict resolution. This feature is only enabled when recursive triggers are enabled.
• Added the SQLITE_OPEN_SHAREDCACHE and SQLITE_OPEN_PRIVATECACHE flags for sqlite3_open_v2() used to override the global shared cache mode settings for individual database connections.
• Added improved version identification features: C-Preprocessor macro SQLITE_SOURCE_ID, C/C++ interface sqlite3_sourceid(), and SQL function sqlite_source_id().
• Obscure bug fix on triggers ([efc02f9779]).
  
  Original Post : http://neodreamer-dev.tistory.com/321

무료 로컬데이터베이스 SQLite Release 3.6.16

이번 버전에서 바뀐 내용



2009 June 27 (3.6.16)

• Fix a bug (ticket #3929) that occasionally causes INSERT
  or UPDATE operations to fail on an indexed table that has a
  self-modifying trigger.
• Other minor bug fixes and performance optimizations.

SQLite Homepage
SQLite Download P

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

SQLite Release 3.6.15

오랜만에 SQLite 가 업데이트 되었다.
3.6.11 버전 이전이나 3.6.14 또는 3.6.14.1 버전을 사용하고 있을경우 업그레이드를 권장하고 있다.


이번 버전에서 바뀐 내용 (Release 3.6.15 On 2009 June 15)

• Refactor the internal representation of SQL expressions so that they use less memory on embedded platforms.


• Reduce the amount of stack space used


• Fix an 64-bit alignment bug on HP/UX and Sparc


• The sqlite3_create_function() family of interfaces now return SQLITE_MISUSE instead of SQLITE_ERROR when passed invalid parameter combinations.


• When new tables are created using CREATE TABLE ... AS SELECT ... the datatype of the columns is the simplified SQLite datatype (TEXT, INT, REAL, NUMERIC, or BLOB) instead of a copy of the original datatype from the source table.


• Resolve race conditions when checking for a hot rollback journal.


• The sqlite3_shutdown() interface frees all mutexes under windows.


• Enhanced robustness against corrupt database files


• Continuing improvements to the test suite and fixes to obscure bugs and inconsistencies that the test suite improvements are uncovering.
  Original Post : http://neodreamer-dev.tistory.com/303

SQLite 3.6.14 Released!!

SQLite Release 3.6.14 On 2009 May 7 (3.6.14)

• Added the optional asynchronous VFS module.


• Enhanced the query optimizer so that virtual tables are able to make use of OR and IN operators in the WHERE clause.


• Speed improvements in the btree and pager layers.


• Added the SQLITE_HAVE_ISNAN compile-time option which will cause the isnan() function from the standard math library to be used instead of SQLite's own home-brew NaN checker.


• Countless minor bug fixes, documentation improvements, new and improved test cases, and code simplifications and cleanups.

SQLite
SQLite Release Notes
SQLite Download p

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

SQLite 3.6.13 Released!!

3.6.13 버전에서 바뀐 내용

• Fix a bug in version 3.6.12 that causes a segfault when running a count(*) on the sqlite_master table of an empty database. Ticket #3774.


• Fix a bug in version 3.6.12 that causes a segfault that when inserting into a table using a DEFAULT value where there is a function as part of the DEFAULT value expression. Ticket #3791.


• Fix data structure alignment issues on Sparc. Ticket #3777.


• Other minor bug fixes.

SQLite
SQLite Release Notes
SQLite Download page

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

SQLite 3.6.12 Released!!

3.6.12 버전에서 바뀐 내용

• Fixed a bug that caused database corruption when an incremental_vacuum is rolled back in an in-memory database. Ticket #3761.
• Added the sqlite3_unlock_notify() interface.
• Added the reverse_unordered_selects pragma.
• The default page size on windows is automatically adjusted to match the capabilities of the underlying filesystem.
• Add the new ".genfkey" command in the CLI for generating triggers to implement foreign key constraints.
• Performance improvements for "count(*)" queries.
• Reduce the amount of heap memory used, especially by TRIGGERs.
  

SQLite
SQLite Download page
Original Post : http://neodreamer-dev.tistory.com/284