macOS
Homebrew已验证 · 100%
brew install sqlitelocal Homebrew formula metadata
MacPorts已验证 · 94%
sudo port install sqlite3MacPorts ports tree · databases/sqlite3/Portfile · 来源: api.github.com
安装
其他安装命令
Linux
Alpine Linux apk已验证 · 92%
sudo apk add sqliteAlpine Linux edge package indexes · sqlite · 来源: dl-cdn.alpinelinux.org
Fedora dnf已验证 · 92%
sudo dnf install sqliteFedora Rawhide package metadata · sqlite · 来源: dl.fedoraproject.org
Nix已验证 · 92%
nix profile install nixpkgs#sqlitenixpkgs package indexes · sqlite · 来源: raw.githubusercontent.com
Arch Linux pacman已验证 · 92%
sudo pacman -S sqliteArch Linux sync databases · sqlite · 来源: geo.mirror.pkgbuild.com
openSUSE zypper已验证 · 92%
sudo zypper install sqlite3openSUSE Tumbleweed package metadata · sqlite3 · 来源: download.opensuse.org
Debian apt已验证 · 92%
sudo apt install sqlite3Debian stable package indexes · sqlite3 · 来源: deb.debian.org
Windows
Chocolatey已验证 · 92%
choco install SQLiteChocolatey community package catalog · SQLite · 来源: community.chocolatey.org
Scoop已验证 · 92%
scoop install main/sqliteScoop official bucket manifest trees · bucket/sqlite.json · 来源: api.github.com
Windows Package Manager已验证 · 92%
winget install --id SQLite.SQLite -eWindows Package Manager source index · SQLite.SQLite · 来源: cdn.winget.microsoft.com
概览
软件包摘要
Command-line interface for SQLite
历史
项目历史与用法
SQLite is an embedded, serverless SQL database engine and one of the most widely deployed software components in everyday computing. In package-manager culture, the `sqlite` package is both a runtime dependency and a tiny command-line database workbench.
项目历史
The SQLite project states that it began on 2000-05-09. Its design centers on a self-contained, zero-configuration, transactional SQL database engine stored in ordinary disk files, with public-domain source code and long-term support goals.
The SQLite command-line program, `sqlite3`, is the officially supported interactive interface to SQLite database files. The CLI is distinct from the SQLite library: it accepts user input and passes SQL to the library, while also providing dot-commands for import, export, schema inspection, archives, recovery, parameters, extensions, and scripting.
采用历史
SQLite's official site calls it the most used database engine in the world and says it is built into all mobile phones and most computers. The most-deployed page lists Android, iOS devices, Macs, Windows 10/11 installations, major browsers, Python, PHP, and many applications as places SQLite appears.
The input shows SQLite packaged across Homebrew, Chocolatey, MacPorts, Nix, Scoop, winget, apk, pacman, and other distribution ecosystems. That breadth matches SQLite's role as a default local database layer and a basic CLI tool developers expect to be available.
使用方式
Developers use the `sqlite3` CLI to open database files, run SQL interactively, script SQL from shell pipelines, import and export CSV or TSV, inspect schemas, dump databases, recover data, load extensions, and experiment with SQL locally.
SQLite is commonly used as an application file format, local cache, data-transfer container, embedded-device database, website database for modest traffic, and quick analysis database for CSV or JSON data.
为什么软件包爱好者会关心
Package nerds care about SQLite because it is the rare package that is simultaneously a library, a database engine, a file format, and a CLI. Installing `sqlite` gives immediate access to `sqlite3`, a portable database file format, and a common dependency shared by many higher-level tools.
SQLite's public-domain status, single-file databases, cross-platform file format, and zero-admin deployment make it especially attractive in package ecosystems: it works as a dependency, debugging tool, fixture format, and data interchange tool without needing a service manager or credentials.
时间线
- 2000: SQLite project started on 2000-05-09.
- 2021: SQLite 3.37.0 added CLI support for multiple open database connections.
- 2025: SQLite documentation states an intent to support the project through 2050.
- 2026: SQLite homepage lists 3.53.3 as the latest release on 2026-06-26.
Related projects
- sqlite3_analyzer and sqlite3_rsync are official SQLite companion utilities.
- sqlite-utils and sqlite3-to-mysql are third-party tools that build workflows around SQLite files.
- SQLite's own docs compare its problem space to local file I/O rather than to client/server database engines.
来源
- https://www.sqlite.org/about.html - official SQLite overview and project start date.
- https://www.sqlite.org/cli.html - official command-line shell documentation.
- https://www.sqlite.org/index.html - official homepage, source-code link, and current release note.
- https://www.sqlite.org/mostdeployed.html - official deployment/adoption discussion.
- https://www.sqlite.org/whentouse.html - official usage guidance.
安全态势
风险级别：blue
doc example: bounded database tool.
风险分类器
blue 风险 · 高 置信度 · tool
原因
- doc example: bounded database tool
信号
- override:sqlite
安装行为
- formula 元数据中未记录 Homebrew post-install 钩子。
- Homebrew bottle 元数据适用于 8 个平台目标。
- 安装时包含 1 个运行时依赖。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
sqlite3 | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-07-10
管理器版本3.53.3
管理器更新时间2026-06-27
本地数据OK
上游not checked
检测到的最新版本未检测到
- 信息Release/tag comparison is only available for GitHub repositories.https://sqlite.org/index.htmlnone 置信度
安装元数据
软件包元数据
| 软件包键 | brew:sqlite |
|---|---|
| 版本 | 3.53.3 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/sqlite |
| 主页 | https://sqlite.org/index.html |
| 仓库 | https://www.sqlite.org/src |
| 上游文档 | https://sqlite.org/cli.html |
| 许可证 | blessing |
| 源码归档 | https://www.sqlite.org/2026/sqlite-autoconf-3530300.tar.gz |
| 最后更新 | 2026-06-27T14:08:56Z |
| Pulse | updated |
| 依赖 | readline |
| Bottle | 可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sequoia, sonoma, tahoe, x86_64_linux) |
| Homebrew post-install | 未定义 |
| 服务 | 未声明 |
注册表事实
源数据库详情
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | sqlite |
| Aliases |
|
| Version Scheme | 0 |
| Revision | 0 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | yes |
| URL Keys |
|
源数据库匹配
其他软件包管理器记录
匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。
Nix95%
sqlite
nix profile install nixpkgs#sqlite- normalized package name match
- 匹配方式：Sqlite
apk95%
sqlite 3.53.2-r0
C library that implements an SQL database engine
sudo apk add sqlite- License: blessing
- Architecture: x86_64
- Source Package: sqlite
- 1 依赖
- 1 提供
- normalized package name match
- 匹配方式：Sqlite
apk95%
sqlite-dev 3.53.2-r0
C library that implements an SQL database engine (development files)
sudo apk add sqlite-dev- License: blessing
- Architecture: x86_64
- Source Package: sqlite
- 1 依赖
- 1 提供
- normalized package name match
- 匹配方式：Sqlite
apk95%
sqlite-doc 3.53.2-r0
C library that implements an SQL database engine (documentation)
sudo apk add sqlite-doc- License: blessing
- Architecture: x86_64
- Source Package: sqlite
- normalized package name match
- 匹配方式：Sqlite
apk95%
sqlite-libs 3.53.2-r0
C library that implements an SQL database engine (libraries)
sudo apk add sqlite-libs- License: blessing
- Architecture: x86_64
- Source Package: sqlite
- 1 依赖
- 1 提供
- normalized package name match
- 匹配方式：Sqlite
apk95%
sqlite-static 3.53.2-r0
C library that implements an SQL database engine (static library)
sudo apk add sqlite-static- License: blessing
- Architecture: x86_64
- Source Package: sqlite
- 1 依赖
- normalized package name match
- 匹配方式：Sqlite
dnf95%
lemon 3.53.2-1.fc45
A parser generator
sudo dnf install lemon- License: blessing
- Category: Unspecified
- Architecture: x86_64
- Source Package: sqlite
- 2 依赖
- 1 提供
- normalized package name match
- 匹配方式：Sqlite
dnf95%
sqlite 3.53.2-1.fc45
Library that implements an embeddable SQL database engine
sudo dnf install sqlite- License: blessing
- Category: Unspecified
- Architecture: i686
- Source Package: sqlite
- 7 依赖
- 2 提供
- normalized package name match
- 匹配方式：Sqlite
dnf95%
sqlite-analyzer 3.53.2-1.fc45
An analysis program for sqlite3 database files
sudo dnf install sqlite-analyzer- License: blessing
- Category: Unspecified
- Architecture: x86_64
- Source Package: sqlite
- 7 依赖
- 1 提供
- normalized package name match
- 匹配方式：Sqlite
dnf95%
sqlite-debug 3.53.2-1.fc45
SQLite shell configured for development and debugging purposes
sudo dnf install sqlite-debug- License: blessing
- Category: Unspecified
- Architecture: x86_64
- Source Package: sqlite
- 6 依赖
- 1 提供
- normalized package name match
- 匹配方式：Sqlite
dnf95%
sqlite-devel 3.53.2-1.fc45
Development tools for the sqlite3 embeddable SQL database engine
sudo dnf install sqlite-devel- License: blessing
- Category: Unspecified
- Architecture: i686
- Source Package: sqlite
- 4 依赖
- 2 提供
- normalized package name match
- 匹配方式：Sqlite
dnf95%
sqlite-doc 3.53.2-1.fc45
Documentation for sqlite
sudo dnf install sqlite-doc- License: blessing
- Category: Unspecified
- Architecture: noarch
- Source Package: sqlite
- 1 提供
- normalized package name match
- 匹配方式：Sqlite
dnf95%
sqlite-libs 3.53.2-1.fc45
Shared library for the sqlite3 embeddable SQL database engine.
sudo dnf install sqlite-libs- License: blessing
- Category: Unspecified
- Architecture: i686
- Source Package: sqlite
- 4 依赖
- 2 提供
- normalized package name match
- 匹配方式：Sqlite
dnf95%
sqlite-tcl 3.53.2-1.fc45
Tcl module for the sqlite3 embeddable SQL database engine
sudo dnf install sqlite-tcl- License: blessing
- Category: Unspecified
- Architecture: x86_64
- Source Package: sqlite
- 6 依赖
- 2 提供
- normalized package name match
- 匹配方式：Sqlite
dnf95%
sqlite-tools 3.53.2-1.fc45
sqlite tools
sudo dnf install sqlite-tools- License: blessing
- Category: Development/Tools
- Architecture: x86_64
- Source Package: sqlite
- 4 依赖
- 1 提供
- normalized package name match
- 匹配方式：Sqlite
pacman95%
sqlite 3.53.2-1
A C library that implements an SQL database engine
sudo pacman -S sqlite- License: LicenseRef-Sqlite
- Architecture: x86_64
- 3 依赖
- 2 提供
- normalized package name match
- 匹配方式：Sqlite
来源线索
由仓库数据生成
此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。
Combined YAML source
View the package source record on GitHub.
使用的来源
- Geiger risk classifier
- Nucleus package database
- av.db category and tag curation
- cross-ecosystem install command graph
- curated package history
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment