macOS
Homebrew已验证 · 100%
brew install sqldifflocal Homebrew formula metadata
安装
其他安装命令
概览
软件包摘要
Displays the differences between SQLite databases
历史
项目历史与用法
sqldiff is the SQLite project's command-line database difference utility. It compares two SQLite databases and usually emits SQL that transforms the first database into the second.
项目历史
sqldiff is documented as part of the official SQLite toolset rather than as a separate standalone project. The SQLite source repository is managed in Fossil at sqlite.org/src, and the SQLite README emphasizes that this Fossil repository contains the official source history.
采用历史
As a small companion utility to SQLite, sqldiff is mostly adopted through SQLite-oriented packaging. The input metadata lists a Homebrew formula with the sqldiff executable, giving macOS and Linuxbrew users an easy way to install the database-diff tool without building SQLite source utilities themselves.
使用方式
The basic invocation is sqldiff database1.sqlite database2.sqlite. Options can emit summaries, limit comparison to schema or a table, wrap output in a transaction, or produce a binary changeset for SQLite's session extension.
为什么软件包爱好者会关心
Package nerds care about sqldiff because it is a tiny, official SQLite-adjacent CLI that does one packageable job well: inspect and script differences between database files. It is useful in migrations, fixtures, reproducible tests, and debugging binary database changes.
时间线
- 2000: SQLite source history begins, according to the SQLite source README.
- Current docs: sqldiff is documented as sqldiff.exe, a command-line database difference utility.
- 2023: sqldiff documentation page last updated on 2023-01-06.
Related projects
- sqldiff is related to SQLite itself and to the SQLite session extension when using the --changeset mode.
来源
- https://github.com/sqlite/sqlite#readme
- https://www.sqlite.org/sqldiff.html
- https://www.sqlite.org/src
- input.source_facts.package-manager
安全态势
尚未找到受保护工具覆盖
没有找到 sqldiff 的匹配本地密钥处理 manifest。Nucleus 软件包元数据仍在此发布，以便未来覆盖拥有稳定的软件包 URL。
安装行为
- formula 元数据中未记录 Homebrew post-install 钩子。
- Homebrew bottle 元数据适用于 8 个平台目标。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
sqldiff | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-07-25
管理器版本3.53.3
管理器更新时间2026-06-27
本地数据OK
上游not checked
检测到的最新版本未检测到
https://www.sqlite.org/sqldiff.html
- 信息Release/tag comparison is only available for GitHub repositories.https://www.sqlite.org/sqldiff.htmlnone 置信度
安装元数据
软件包元数据
| 软件包键 | brew:sqldiff |
|---|---|
| 版本 | 3.53.3 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/sqldiff |
| 主页 | https://www.sqlite.org/sqldiff.html |
| 仓库 | https://www.sqlite.org/src |
| 上游文档 | https://www.sqlite.org/sqldiff.html |
| 许可证 | blessing |
| 源码归档 | https://www.sqlite.org/2026/sqlite-src-3530300.zip |
| 最后更新 | 2026-06-27T14:08:56Z |
| Pulse | updated |
| 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 | sqldiff |
| Version Scheme | 0 |
| Revision | 0 |
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
来源线索
由仓库数据生成
此页面由 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
- package relationship graph
- package version freshness
- package-page enrichment