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 관리 프로그램 - SQLiteSpy 1.9.0

SQLiteSpy 화면 (출처:홈페이지)

SQLiteSpy 는 작고 간편한 SQLite 관리 프로그램이다.

오랜만에 업데이트가 되었는데 홈페이지가 불안정 해서이지 접속이 원활하지 않은 경우가 많다.



이번 버전은 변경 사항은 아래와 같다.

SQLiteSpy 1.9.0 (2011/03/02)

• Support for loadable extensions compiled with "fastcall" (C++ Builder) or "register" (Delphi) calling conventions.


• Update built-in DB engine to pre SQLite 3.7.6 (DISQLite3 2.3.4).


• On database close, open an in-memory database (:memory:).

SQLiteSpy Homepage

SQLiteSpy_1.9.0.7z

&

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

SQLiteSpy 1.8.16

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

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

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

Download Site1 Site2<

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

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

Firebird Windows에 수동으로 설치하기

우선 운영체제에 맞는 설치 파일을 선택한다. 32비트는 Firebird-2.5.0.26074-0_Win32.zip 를 64비트는 Firebird-2.5.0.26074-0_x64.zip 를 설치하고자 하는 경로에 압축을 풀어놓는다. (Download Site)

여기서는 F:\Firebird64 경로에 압축을 풀고 작업을 했다.

우선 bin 폴더에 있는 install_super.bat 를 실행하여 서비스를 등록한다.

이제 시스템의 서비스 목록을 확인해 보면 Firebird Guardian 과 Firebird Server 가 등록되어 있음을 확인 할 수 있다.

사실 이것 만으로 설치는 끝난것인데 항상 Firebird 를 운영할 일이 없는 개인 PC 에서 서비스 형태로 돌리는 것이 맘이 들지 않아 Application 형태로 필요할 때에 운영을 하려 한다.

우선 F:\Firebird64\system32 폴더에 있는 Firebird2Control.cpl 를 윈도우의 System 폴더(C:\Windows\System32)에 복사를 한다. 복사를 하고 시작 메뉴의 제어판을 보면 Firebird Server Manager 가 등록 된다.

Firebird Server Manager를 실행하면 Firebird Server Control 이 실행 된다.

Firebird Server Control 에서 현재 운영중이라면 서버를 중지시키고 운영 형태(Run)를 Application 으로  시작(Start)를 Manually로 설정하고 Apply 를 누르고 시작을 한다.

그러면 시스템의 서비스 목록에 등록되었던 두 개의 서비스(Firebird Guardian, Firebird Server)가 사라지고 Firebird 는 Application 형태로 운영이 된다. 시스템의 프로세스 목록을 보면 두개의 프로세스가 동작중인 것을 확인 할 수 있다.

<

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

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.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 v3.6.5 Library for C++ Builder, Visual C++

C++ Builder

2008/07/25 - [Dev Story/Tips] - C++ Builder 용 SQLite Library 파일 만들기...

SQLIte3.6.6_builder.7z

Visual C++

2008/07/23 - [Dev Story/Tips] - Visual C++ 2005 에서 간단하게 SQLite Database 사용하기

SQLite3.6.6_vc.7z
Original Post : http://neodreamer-dev.tistory.com/202