使用 Homebrew, apk, dnf, pacman, chocolatey 安装 sqlite-analyzer

项目链接

• 主页

命令和别名

• sqlite3_analyzer

项目历史

The SQLite documentation presents sqlite3_analyzer as a utility program that measures and reports how efficiently tables and indexes use space in a database file. It belongs to the broader SQLite toolchain rather than being a separate upstream project.

采用历史

Package-manager records in the input show sqlite-analyzer packaged by Homebrew and several Linux distributions. That split packaging reflects a common packaging pattern around SQLite: the core library and shell are ubiquitous, while specialist diagnostics are available as add-on utilities.

使用方式

Users run `sqlite3_analyzer database.sqlite` to generate a human-readable text report about database-file space utilization. The output is useful when tuning page usage, index bloat, or the storage impact of table design.

为什么软件包爱好者会关心

Package nerds care because sqlite3_analyzer exposes SQLite internals in a portable CLI form. It is the kind of diagnostic binary that database-heavy developers install from a package manager when they need to understand why a single-file database grew or how its indexes consume space.

时间线

• Current: SQLite documents sqlite3_analyzer as the official command-line utility for database space-utilization reports.
• Current: Homebrew packages the utility as `sqlite-analyzer`.

Related projects

• SQLite provides the database engine, source tree, command-line shell, and related utilities such as sqlite3_analyzer.

来源

• https://www.sqlite.org/sqlanalyze.html - official sqlite3_analyzer documentation.
• https://www.sqlite.org/src - official SQLite source repository.
• source_facts.package-manager - package-manager availability supplied in input.