SQLite 3.17.0 軟體資訊交流 Mac

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

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

SQLite 3.17.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.17.0
檔案名稱 sqlite-tools-osx-x86-3170000.zip
檔案大小 1.1 MB
系統 Mac OS X
軟體類型 免費軟體
作者 Richard Hipp
更新日期 https://sqlite.org/
軟體類型 2017-02-14

What's new in this version:

- Add the SQLITE_DEFAULT_LOOKASIDE compile-time option
- Increase the default lookaside size from 512,125 to 1200,100 as this provides better performance while only adding 56KB of extra memory per connection. Memory-sensitive applications can restore the old default at compile-time, start-time, or run-time
- Use compiler built-ins __builtin_sub_overflow(), __builtin_add_overflow(), and __builtin_mul_overflow() when available. (All compiler built-ins can be omitted with the SQLITE_DISABLE_INTRINSIC compile-time option.)
- Added the SQLITE_ENABLE_NULL_TRIM compile-time option, which can result in significantly smaller database files for some applications, at the risk of being incompatible with older versions of SQLite
- Change SQLITE_DEFAULT_PCACHE_INITSZ from 100 to 20, for improved performance
- Added the SQLITE_UINT64_TYPE compile-time option as an analog to SQLITE_INT64_TYPE
- Perform some UPDATE operations in a single pass instead of in two passes
- Enhance the session extension to support WITHOUT ROWID tables
- Fixed performance problems and potential stack overflows when creating views from multi-row VALUES clauses with hundreds of thousands of rows
- Added the sha1.c extension
- In the command-line shell, enhance the ".mode" command so that it restores the default column and row separators for modes "line", "list", "column", and "tcl"
- Enhance the SQLITE_DIRECT_OVERFLOW_READ option so that it works in WAL mode as long as the pages being read are not in the WAL file
- Enhance the LEMON parser generator so that it can store the parser object as a stack variable rather than allocating space from the heap and make use of that enhancement in the amalgamation
- Other performance improvements. Uses about 6.5% fewer CPU cycles

Approximately 25% better performance from the R-Tree extension:
- Uses compiler built-ins (ex: __builtin_bswap32() or _byteswap_ulong()) for byteswapping when available
- Uses the sqlite3_blob key/value access object instead of SQL for pulling content out of R-Tree nodes
- Other miscellaneous enhancements such as loop unrolling

Bug Fixes:
- Throw an error if the ON clause of a LEFT JOIN references tables to the right of the ON clause. This is the same behavior as PostgreSQL. Formerly, SQLite silently converted the LEFT JOIN into an INNER JOIN
- Use the correct affinity for columns of automatic indexes
- Ensure that the sqlite3_blob_reopen() interface can correctly handle short rows

檔案下載 檔案下載