SQLite 3.26.0 軟體資訊交流 Mac

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

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

SQLite 3.26.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.26.0
檔案名稱 sqlite-tools-osx-x86-3260000.zip
檔案大小 1.2 MB
系統 Mac OS X
軟體類型 免費軟體
作者 Richard Hipp
更新日期 https://sqlite.org/
軟體類型 2018-12-28

What's new in this version:

- Optimization: When doing an UPDATE on a table with indexes on expressions, do not update the expression indexes if they do not refer to any of the columns of the table being updated
- Allow the xBestIndex() method of virtual table implementations to return SQLITE_CONSTRAINT to indicate that the proposed query plan is unusable and should not be given further consideration
- Added the SQLITE_DBCONFIG_DEFENSIVE option which disables the ability to create corrupt database files using ordinary SQL
- Added support for read-only shadow tables when the SQLITE_DBCONFIG_DEFENSIVE option is enabled
- Added the PRAGMA legacy_alter_table command, which if enabled causes the ALTER TABLE command to behave like older version of SQLite (prior to version 3.25.0) for compatibility
- Added PRAGMA table_xinfo that works just like PRAGMA table_info except that it also shows hidden columns in virtual tables
- Added the explain virtual table as a run-time loadable extension
- Add a limit counter to the query planner to prevent excessive sqlite3_prepare() times for certain pathological SQL inputs
- Added support for the sqlite3_normalized_sql() interface, when compiling with SQLITE_ENABLE_NORMALIZE
- Enhanced triggers so that they can use table-valued functions that exist in schemas other than the schema where the trigger is defined

Enhancements to the CLI:
- Improvements to the ".help" command
- The SQLITE_HISTORY environment variable, if it exists, specifies the name of the command-line editing history file
- The --deserialize option associated with opening a new database cause the database file to be read into memory and accessed using the sqlite3_deserialize() API. This simplifies running tests on a database without modifying the file on disk

Enhancements to the geopoly extension:
- Aways stores polygons using the binary format, which is faster and uses less space
- Added the geopoly_regular() function
- Added the geopoly_ccw() function

Enhancements to the session extension:
- Added the sqlite3changeset_start_v2() interface and the SQLITE_CHANGESETSTART_INVERT flag
- Added the changesetfuzz.c test-case generator utility

檔案下載 檔案下載