SQLite 3.21.0 軟體資訊交流 Mac

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

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

SQLite 3.21.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.21.0
檔案名稱 sqlite-tools-osx-x86-3210000.zip
系統 Mac OS X
軟體類型 免費軟體
作者 Richard Hipp
更新日期 https://sqlite.org/
軟體類型 2017-10-25

What's new in this version:

- Take advantage of the atomic-write capabilities in the F2FS filesystem when available, for greatly reduced transaction overhead. This currently requires the SQLITE_ENABLE_BATCH_ATOMIC_WRITE compile-time option
- Allow ATTACH and DETACH commands to work inside of a transaction
- Allow WITHOUT ROWID virtual tables to be writable if the PRIMARY KEY contains exactly one column
-The "fsync()" that occurs after the header is written in a WAL reset now uses the sync settings for checkpoints. This means it will use a "fullfsync" on macs if PRAGMA checkpoint_fullfsync set on
-The sqlite3_sourceid() function tries to detect if the source code has been modified from what is checked into version control and if there are modifications, the last four characters of the version hash are shown as "alt1" or "alt2". The objective is to detect accidental and/or careless edits. A forger can subvert this feature
-Improved de-quoting of column names for CREATE TABLE AS statements with an aggregate query on the right-hand side
-Fewer "stat()" system calls issued by the unix VFS
-Enhanced the LIKE optimization so that it works with an ESCAPE clause
-Enhanced PRAGMA integrity_check and PRAGMA quick_check to detect obscure row corruption that they were formerly missing. Also update both pragmas so that they return error text rather than SQLITE_CORRUPT when encountering corruption in records
- The query planner now prefers to implement FROM-clause subqueries using co-routines rather using the query flattener optimization. Support for the use of co-routines for subqueries may no longer be disabled
- Pass information about !=, IS, IS NOT, NOT NULL, and IS NULL constraints into the xBestIndex method of virtual tables
- Enhanced the CSV virtual table so that it accepts the last row of input if the final new-line character is missing
- Remove the rarely-used "scratch" memory allocator. Replace it with the SQLITE_CONFIG_SMALL_MALLOC configuration setting that gives SQLite a hint that large memory allocations should be avoided when possible
- Added the swarm virtual table to the existing union virtual table extension
- Added the sqlite_dbpage virtual table for providing direct access to pages of the database file. The source code is built into the amalgamation and is activated using the -DSQLITE_ENABLE_DBPAGE_VTAB compile-time option
- Add a new type of fts5vocab virtual table - "instance" - that provides direct access to an FTS5 full-text index at the lowest possible level
- Remove a call to rand_s() in the Windows VFS since it was causing problems in Firefox on some older laptops
- The src/shell.c source code to the command-line shell is no longer under version control. That file is now generated as part of the build process
- Miscellaneous microoptimizations reduce CPU usage by about 2.1%

Bug fixes:
- Fix a faulty assert() statement discovered by OSSFuzz
- Fix an obscure memory leak in sqlite3_result_pointer()
- Avoid a possible use-after-free error by deferring schema resets until after the query planner has finished running
- Only use indexes-on-expressions to optimize ORDER BY or GROUP BY if the COLLATE is correct
- Fix an assertion fault that was coming up when the expression in an index-on-expressions is really a constant
- Fix an assertion fault that could occur following PRAGMA reverse_unordered_selects
- Fix a segfault that can occur for queries that use table-valued functions in an IN or EXISTS subquery
- Fix a potential integer overflow problem when compiling a particular horrendous common table expression. This was another problem discovered by OSSFuzz
- Fix a potential out-of-bound read when querying a corrupt database file, a problem detected by Natalie Silvanovich of Google Project Zero

檔案下載 檔案下載