SQLite 3.25.0 軟體資訊交流 Mac

winXmac軟體社群 Mac 開發工具 Richard Hipp 免費軟體 Rate 100

SQLite for Mac,軟體教學,軟體下載,軟體社群,Windows軟體,Mac軟體

SQLite 3.25.0 Mac

SQLite for Mac 是一個實現自包含,無服務器,零配置,事務 SQL 數據庫引擎的進程內庫。 SQLite 的代碼是在公共領域,因此可用於任何目的,商業或私人。 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 Windows

檔案版本 SQLite 3.25.0
檔案名稱 sqlite-tools-osx-x86-3250000.zip
檔案大小 1.2 MB
系統 Mac OS X
軟體類型 免費軟體
作者 Richard Hipp
更新日期 https://sqlite.org/
軟體類型 2018-09-17

What's new in this version:

- Use a separate mutex on every inode in the unix VFS, rather than a single mutex shared among them all, for slightly better concurrency in multi-threaded environments
- Enhance the PRAGMA integrity_check command for improved detection of problems on the page freelist
- Output infinity as 1e999 in the ".dump" command of the command-line shell
- Added the SQLITE_FCNTL_DATA_VERSION file-control
- Added the Geopoly module

Add support for window functions:
Enhancements the ALTER TABLE command:
- Add support for renaming columns within a table using ALTER TABLE table RENAME COLUMN oldname TO newname
- Fix table rename feature so that it also updates references to the renamed table in triggers and views

Query optimizer improvements:
- Avoid unnecessary loads of columns in an aggregate query that are not within an aggregate function and that are not part of the GROUP BY clause
- The IN-early-out optimization: When doing a look-up on a multi-column index and an IN operator is used on a column other than the left-most column, then if no rows match against the first IN value, check to make sure there exist rows that match the columns to the right before continuing with the next IN value
- Use the transitive property to try to propagate constant values within the WHERE clause. For example, convert "a=99 AND b=a" into "a=99 AND b=99"

Bug fixes:
- The ORDER BY LIMIT optimization might have caused an infinite loop in the byte code of the prepared statement under very obscure circumstances, due to a confluence of minor defects in the query optimizer
- On an UPSERT when the order of constraint checks is rearranged, ensure that the affinity transformations on the inserted content occur before any of the constraint checks
- Avoid using a prepared statement for ".stats on" command of the CLI after it has been closed by the ".eqp full" logicc
- The LIKE optimization was generating incorrect byte-code and hence getting the wrong answer if the left-hand operand has numeric affinity and the right-hand-side pattern is '/%' or if the pattern begins with the ESCAPE character

檔案下載 檔案下載