SQLite 3.24.0 軟體資訊交流 Mac

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

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

SQLite 3.24.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.24.0
檔案名稱 sqlite-tools-osx-x86-3240000.zip
檔案大小 307.2 KB
系統 Mac OS X
軟體類型 免費軟體
作者 Richard Hipp
更新日期 https://sqlite.org/
軟體類型 2018-06-05

What's new in this version:

- Add support for PostgreSQL-style UPSERT
- Add support for auxiliary columns in r-tree tables
- Add C-language APIs for discovering SQL keywords used by SQLite: sqlite3_keyword_count(), sqlite3_keyword_name(), and sqlite3_keyword_check()
- Add C-language APIs for dynamic strings based on the sqlite3_str object
- Enhance ALTER TABLE so that it recognizes "true" and "false" as valid arguments to DEFAULT
- Add the sorter-reference optimization as a compile-time option. Only available if compiled with SQLITE_ENABLE_SORTER_REFERENCES
- Improve the format of the EXPLAIN QUERY PLAN raw output, so that it gives better information about the query plan and about the relationships between the various components of the plan
- Added the SQLITE_DBCONFIG_RESET_DATABASE option to the sqlite3_db_config() API

CLI Enhancements:
- Automatically intercepts the raw EXPLAIN QUERY PLAN output and reformats it into an ASCII-art graph
- Lines that begin with "#" and that are not in the middle of an SQL statement are interpreted as comments
- Added the --append option to the ".backup" command
- Added the ".dbconfig" command

- UPDATE avoids writing database pages that do not actually change. For example, "UPDATE t1 SET x=25 WHERE y=?" becomes a no-op if the value in column x is already 25. Similarly, when doing UPDATE on records that span multiple pages, only write the subset of pages that contain the changed value(s)
- Queries that use ORDER BY and LIMIT now try to avoid computing rows that cannot possibly come in under the LIMIT. This can greatly improve performance of ORDER BY LIMIT queries, especially when the LIMIT is small relative to the number of unrestricted output rows
- The OR optimization is allowed to proceed even if the OR expression has also been converted into an IN expression. Uses of the OR optimization are now also more clearly shown in the EXPLAIN QUERY PLAN output
- The query planner is more aggressive about using automatic indexes for views and subqueries for which it is not possible to create a persistent index
- Make use of the one-pass UPDATE and DELETE query plans in the R-Tree extension where appropriate
- Performance improvements in the LEMON-generated parser

Bug fixes:
- For the right-hand table of a LEFT JOIN, compute the values of expressions directly rather than loading precomputed values out of an expression index as the expression index might not contain the correct value. Ticket 7fa8049685b50b5aeb0c2
- Do not attempt to use terms from the WHERE clause to enable indexed lookup of the right-hand table of a LEFT JOIN. Ticket 4ba5abf65c5b0f9a96a7a
- Fix a memory leak that can occur following a failure to open error in the CSV virtual table
- Fix a long-standing problem wherein a corrupt schema on the sqlite_sequence table used by AUTOINCREMENT can lead to a crash. Ticket d8dc2b3a58cd5dc2918a1
- Fix the json_each() function so that it returns valid results on its "fullkey" column when the input is a simple value rather than an array or object

檔案下載 檔案下載