SQLite (64-bit)

最新版本 SQLite 3.25.0 (64-bit)

SQLite 3.25.0 (64-bit)

SQLite 3.25.0 (64-bit)
SQLite 64 位是一個進程內庫,它實現了一個自包含的,無服務器的,零配置的事務性 SQL 數據庫引擎。 SQLite 的代碼是在公共領域,因此可用於任何目的,商業或私人。下載 Windows PC 的 SQLite 離線安裝程序安裝 64 位! SQLite 64 位是世界上部署最廣泛的數據庫,其應用程序數量比我們可以計算的還要多,其中包括幾個高性能項目。6123586
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 Mac





ScreenShot

軟體資訊
檔案版本 SQLite 3.25.0 (64-bit)

檔案名稱 sqlite-dll-win64-x64-3250000.zip
檔案大小 788.48 KB
系統 Windows XP64 / Vista64 / Windows 7 64 / Windows 8 64 / Windows 10 64
軟體類型 免費軟體
作者 Richard Hipp
官網 https://sqlite.org/
更新日期 2018-09-16
更新日誌

What's new in this version:

- Add support for window functions
- 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

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

SQLite 3.25.0 (64-bit) 相關參考資料
Release History Of SQLite

Extra sanity checking added to ALTER TABLE in the 3.25.0 release ... The multiply operator now correctly detects 64-bit integer overflow and promotes to floating ...

https://www.sqlite.org

SQLite (64-bit) Download (2021 Latest) for Windows 10, 8, 7

2021年1月21日 — SQLite 64-bit is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

https://www.filehorse.com

SQLite 3.25.0 (64-bit) Download for Windows 10, 8, 7

2018年9月16日 — Download SQLite 3.25.0 (64-bit) for Windows PC from FileHorse. 100% Safe and Secure ✓ Free Download 64-bit Software Version.

https://www.filehorse.com

SQLite 3.25.1 (64-bit) Download for Windows 10, 8, 7

2018年9月19日 — Download SQLite Offline Installer Setup 64bit for Windows PC! SQLite 64-bit is the most widely deployed database in the world with more ...

https://www.filehorse.com

SQLite 3.25.2 (64-bit) Download for Windows Old Versions ...

2018年9月26日 — SQLite 3.25.0 (64-bit). Date released: 16 Sep 2018 (2 years ago). Download · SQLite 3.24.0 (64-bit). Date released: 05 Jun 2018 (3 years ago).

https://www.filehorse.com

SQLite 3.25.2 (64-bit) Download for Windows 10, 8, 7

2018年9月26日 — Download SQLite Offline Installer Setup 64bit for Windows PC! SQLite 64-bit is the most widely deployed database in the world with more ...

https://www.filehorse.com

SQLite 3.25.2 (64-bit) 檔案下載 - 電腦資訊007情報站

2018年9月26日 — SQLite 3.25.2 (64-bit) 軟體版本sqlite-dll-win64-x64-3250200.zip 檔案下載,SQLite 64 位是一個進程內庫,它實現了一個自包含的,無服務器的 ...

https://file007.com

SQLite 3.25.3 (64-bit) Download for Windows Old Versions ...

2018年11月6日 — SQLite 3.25.0 (64-bit). Date released: 16 Sep 2018 (2 years ago). Download · SQLite 3.24.0 (64-bit). Date released: 05 Jun 2018 (3 years ago).

https://www.filehorse.com

SQLite 3.25.3 (64-bit) Download for Windows 10, 8, 7

2018年11月6日 — SQLite 64-bit is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

https://www.filehorse.com

SQLite Download Page

(3.08 MiB), A precompiled Android library containing the core SQLite together with appropriate Java ... (813.96 KiB), 64-bit DLL (x64) for SQLite version 3.34.1.

https://www.sqlite.org