SQLite 3.30.0 正式版發布附下載– 嵌入式數據庫引擎
SQLite 3.30.0 發布了，SQLite 是一個C 實現的SQL 數據庫引擎，它的特點是小型、快速、自包含、高可靠性和功能齊全。SQLite 嵌入在所有手機和大多數計算機中，也捆綁在為數眾多的其它應用中，是世界上使用量最大的數據庫引擎。
SQLite，是一款輕型的數據庫，是遵守ACID的關係型數據庫管理系統，它包含在一個相對小的C庫中。它是D.RichardHipp建立的公有領域項目。它的設計目標是嵌入式的，而且目前已經在很多嵌入式產品中使用了它，它佔用資源非常的低，在嵌入式設備中，可能只需要幾百K的內存就夠了。它能夠支持Windows/Linux/Unix等等主流的操作系統，同時能夠跟很多程序語言相結合，比如Tcl、C#、PHP、Java等，還有ODBC接口，同樣比起Mysql、PostgreSQL這兩款開源的世界著名數據庫管理系統來講，它的處理速度比他們都快。
此版本更新內容包括：
- 添加對聚合函數的FILTER 子句的支持
- 添加對ORDER BY 子句中的NULLS FIRST 和NULLS LAST 語法的支持
- 增強了index_info和index_xinfo 編譯指示，以提供有關WITHOUT ROWID 表在磁盤上的表示形式的信息
- 新增sqlite3_drop_modules() 接口，使應用程序可以禁用不需要的自動加載的虛擬表
- 改進CLI 中的.recover dot-command，以便從損壞的數據庫文件中恢復更多內容
- 增強RBU 擴展，以支持表達式索引
- 更改架構解析器，因此如果sqlite_master 表的類型、名稱和tbl_name 列中的任何列已損壞，並且數據庫連接未處於writable_schema 模式，它將出錯
- 現在默認情況下，所有版本中都啟用PRAGMA function_list，PRAGMA module_list 和PRAGMA pragma_list 命令，可使用-DSQLITE_OMIT_INTROSPECTION_PRAGMAS 禁用它們
- 為sqlite3_db_config() 添加SQLITE_DBCONFIG_ENABLE_VIEW 選項
- 添加了TCL 接口配置方法，以便能夠禁用SQLITE_DBCONFIG_ENABLE_VIEW，並從TCL 控制其他sqlite3_db_config() 選項
- 為應用程序定義的SQL 函數添加了SQLITE_DIRECTONLY 標誌，以防止在觸發器和視圖中使用這些函數
- 現在，舊版SQLITE_ENABLE_STAT3 的編譯時選項為空
官網地址： https://www.sqlite.org/
官網更新記錄： https://www.sqlite.org/changes.html
官網下載地址： https://www.sqlite.org/download.html
SQLite Download Page
| Pre-release Snapshots | |||
| sqlite-snapshot-201909271633.tar.gz (2.72 MiB) | The amalgamation source code, the command-line shell source code, configure/make scripts for unix, and a Makefile.msc for Windows. See the change log for more information. (sha1: d7938d263473f77af5f92e48064e9718a157f041) | ||
| Source Code | |||
| sqlite-amalgamation-3300000.zip (2.24 MiB) | C source code as an amalgamation , version 3.30.0. (sha1: 203fe52a4c1967b3383b70e5641b945b4fc79707) | ||
| sqlite-autoconf-3300000.tar.gz (2.72 MiB) | C source code as an amalgamation . Also includes a “configure” script and TEA makefiles for the TCL Interface . (sha1: 785c0f6f00fe1871cb1dd97893267cb50db03b9b) | ||
| Documentation | |||
| sqlite-doc-3300000.zip (9.05 MiB) | Documentation as a bundle of static HTML files. (sha1: 828cf2af20ef4b216620bdc7c86ac1073a7400bf) | ||
| Precompiled Binaries for Android | |||
| sqlite-android-3300000.aar (3.09 MiB) | A precompiled Android library containing the core SQLite together with appropriate Java bindings, ready to drop into any Android Studio project. (sha1: d88a3833d1145a06a7d138454a6bc6f0e4a907d6) | ||
| Precompiled Binaries for Linux | |||
| sqlite-tools-linux-x86-3300000.zip (1.92 MiB) | A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff program, and the sqlite3_analyzer program. (sha1: 9aacaf0f55adca787a3b29b65f3fdd0014efc57c) | ||
| Precompiled Binaries for Mac OS X (x86) | |||
| sqlite-tools-osx-x86-3300000.zip (1.30 MiB) | A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff program, and the sqlite3_analyzer program. (sha1: b3b1b1862eb5bdae2a5761e49ed66e7a5924cb10) | ||
| Precompiled Binaries for Windows | |||
| sqlite-dll-win32-x86-3300000.zip (478.19 KiB) | 32-bit DLL (x86) for SQLite version 3.30.0. (sha1: f84542474b8583f4371749282e5cc4d52661c222) | ||
| sqlite-dll-win64-x64-3300000.zip (788.22 KiB) | 64-bit DLL (x64) for SQLite version 3.30.0. (sha1: 3592b69d36d82e251b526b2b249ee6cf6bd777f0) | ||
| sqlite-tools-win32-x86-3300000.zip (1.72 MiB) | A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff.exe program, and the sqlite3_analyzer.exe program. (sha1: a22ffa0c32a414df29d63ccf9a3dd3d68c561713) | ||
| Universal Windows Platform | |||
| sqlite-uwp-3300000.vsix (7.19 MiB) | VSIX package for Universal Windows Platform development using Visual Studio 2015. (sha1: 30c820f71b522443ad2abfb1c9cdf3394e56f84c) | ||
| Precompiled Binaries for Windows Phone 8 | |||
| sqlite-wp80-winrt-3300000.vsix (4.66 MiB) | A complete VSIX package with an extension SDK and all other components needed to use SQLite for application development with Visual Studio 2012 targeting Windows Phone 8.0. (sha1: 43ca5c7f4dea9deb9ee8ba39837c1e62cf87aebe) | ||
| sqlite-wp81-winrt-3300000.vsix (4.72 MiB) | A complete VSIX package with an extension SDK and all other components needed to use SQLite for application development with Visual Studio 2013 targeting Windows Phone 8.1. (sha1: bcf2a06d174ada436a73b8d6545815ddb1cf2f11) | ||
| Precompiled Binaries for Windows Runtime | |||
| sqlite-winrt-3300000.vsix (7.09 MiB) | A complete VSIX package with an extension SDK and all other components needed to use SQLite for WinRT application development with Visual Studio 2012. (sha1: 4851104eade56fe8b95bed050b5c3c19fec1d30c) | ||
| sqlite-winrt81-3300000.vsix (7.10 MiB) | A complete VSIX package with an extension SDK and all other components needed to use SQLite for WinRT 8.1 application development with Visual Studio 2013. (sha1: 8294e694e594d9246f91a11c39f9831195c71820) | ||
| Precompiled Binaries for .NET | |||
| System.Data.SQLite | Visit the System.Data.SQLite.org website and especially the download page for source code and binaries of SQLite for .NET. | ||
| Alternative Source Code Formats | |||
| sqlite-src-3300000.zip (12.06 MiB) | Snapshop of the complete (raw) source tree for SQLite version 3.30.0. See How To Compile SQLite for usage details. (sha1: e07542078e2252d620a65152aa33fb0c6fa6f8a9) | ||
| sqlite-preprocessed-3300000.zip (2.45 MiB) | Preprocessed C sources for SQLite version 3.30.0. (sha1: 46665c52f60324c0ef5760aeb04a7b2cc0941fa9) |