SQLite (32-bit)

最新版本 SQLite 3.27.0 (32-bit)

SQLite 3.27.0 (32-bit)

SQLite 3.27.0 (32-bit)
SQLite 是一個進程內庫,它實現了一個自包含的,無服務器的,零配置的事務性 SQL 數據庫引擎。 SQLite 的代碼是在公共領域,因此可用於任何目的,商業或私人。 SQLite 是世界上應用最廣泛的數據庫,其應用程序數量超過了我們可以計算的數量,其中包括幾個備受矚目的項目。 SQLite 免費下載最新版本的 Windows PC。它是 SQLite 的完全脫機安裝程序安裝程序。

SQLite 功能:
即使在系統崩潰和電源故障後,事務也是原子性,一致性,隔離性和持久性(ACID)。零配置 - 無需安裝或管理。具有高級功能(如部分索引和通用表表達式)的完整 SQL 實現。 (省略功能)完整的數據庫存儲在一個跨平台的磁盤文件中。非常適合用作應用程序文件格式。支持太字節大小的數據庫和千兆字節大小的字符串和 blob。 (請參閱 limits.html。)小代碼佔用空間:小於 500KiB 完全配置或省略可選功能少得多。簡單,易於使用的 API。用 ANSI- C 編寫。包括 TCL 綁定。幾十種其他語言的綁定可單獨提供。備受好評的源代碼,具有 100%的分支測試覆蓋率。可作為一個單一的 ANSI- C 源代碼文件,易於編譯,因此很容易添加到一個更大的項目。獨立:不需要外部依賴。跨平台:開箱即用支持 Android,* BSD,iOS,Linux,Mac,Solaris,VxWorks 和 Windows(Win32,WinCE,WinRT)。易於移植到其他系統。來源是在公共領域。用於任何目的。附帶可用於管理 SQLite 數據庫的獨立命令行界面(CLI)客戶端。也可用:下載 SQLite for Mac



ScreenShot

軟體資訊
檔案版本 SQLite 3.27.0 (32-bit)

檔案名稱 sqlite-amalgamation-3270000.zip
檔案大小 2.2 MB
系統 Windows XP / Vista / Windows 7 / Windows 8 / Windows 10
軟體類型 免費軟體
作者 Richard Hipp
官網 https://sqlite.org/
更新日期 2019-02-07
更新日誌

What's new in this version:

- Added the VACUUM INTO command
- Issue an SQLITE_WARNING message on the error log if a double-quoted string literal is used.
- The sqlite3_normalized_sql() interface works on any prepared statement created using sqlite3_prepare_v2() or sqlite3_prepare_v3(). It is no longer necessary to use sqlite3_prepare_v3() with SQLITE_PREPARE_NORMALIZE in order to use sqlite3_normalized_sql()
- Added the remove_diacritics=2 option to FTS3 and FTS5
- Added the SQLITE_PREPARE_NO_VTAB option to sqlite3_prepare_v3(). Use that option to prevent circular references to shadow tables from causing resource leaks

Enhancements to the sqlite3_deserialize() interface:
- Add the SQLITE_FCNTL_SIZE_LIMIT file-control for setting an upper bound on the size of the in-memory database created by sqlite3_deserialize. The default upper bound is 1GiB, or whatever alternative value is specified by sqlite3_config(SQLITE_CONFIG_MEMDB_MAXSIZE) and/or SQLITE_MEMDB_DEFAULT_MAXSIZE.
- Honor the SQLITE_DESERIALIZE_READONLY flag, which was previously described in the documentation, but was previously a no-op
- Enhance the "deserialize" command of the TCL Interface to give it new "--maxsize N" and "--readonly BOOLEAN" options

Enhancements to the CLI, mostly to support testing and debugging of the SQLite library itself:
- Add support for ".open --hexdb". The "dbtotxt" utility program used to generate the text for the "hexdb" is added to the source tree
- Add support for the "--maxsize N" option on ".open --deserialize"
- Add the "--memtrace" command-line option, to show all memory allocations and deallocations
- Add the ".eqp trace" option on builds with SQLITE_DEBUG, to enable bytecode program listing with indentation and PRAGMA vdbe_trace all in one step
- Add the ".progress" command for accessing the sqlite3_progress_handler() interface
- Add the "--async" option to the ".backup" command
- Add options "--expanded", "--normalized", "--plain", "--profile", "--row", "--stmt", and "--close" to the ".trace" command
- Omit deprecated PRAGMA statements when compiling with SQLITE_OMIT_DEPRECATED
- Increased robustness against malicious SQL that is run against a maliciously corrupted database

Bug fixes:
- Do not use a partial index to do a table scan on an IN operator
- Fix the query flattener so that it works on queries that contain subqueries that use window functions
- Ensure that ALTER TABLE modifies table and column names embedded in WITH clauses that are part of views and triggers
- Fix a parser bug that prevented the use of parentheses around table-valued functions
- Fix a problem with the OR optimization on indexes on expressions
- Fix a problem with the LEFT JOIN strength reduction optimization in which the optimization was being applied inappropriately due to an IS NOT NULL operator
- Fix the REPLACE command so that it is no longer able to sneak a NULL value into a NOT NULL column even if the NOT NULL column has a default value of NULL
- Fix a problem with the use of window functions used within correlated subqueries
- Fix the ALTER TABLE RENAME COLUMN command so that it works for tables that have redundant UNIQUE constraints
- Fix a bug that caused zeroblob values to be truncated when inserted into a table that uses an expression index

SQLite 3.27.0 (32-bit) 相關參考資料