# 使用 Homebrew, apt, Nix 安装 sqlite-utils 查看 sqlite-utils 的安装路径、可执行文件、元数据以及面向 AI 代理工作流的安全说明。 ## 安装 ```sh sudo av install brew:sqlite-utils ``` 其他安装命令: ### macOS - Homebrew (100%): ```sh brew install sqlite-utils ``` 证据: local Homebrew formula metadata ### Linux - Debian apt (92%): ```sh sudo apt install sqlite-utils ``` 证据: Debian stable package indexes: sqlite-utils from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz - Nix (92%): ```sh nix profile install nixpkgs#sqlite-utils ``` 证据: nixpkgs package indexes: sqlite-utils from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix ## 软件包事实 - **软件包键:** brew:sqlite-utils - **软件包管理器:** Homebrew - **软件包管理器页面:** - **版本:** 4.1.1 - **来源摘要:** CLI utility for manipulating SQLite databases - **主页:** - **仓库:** - **上游文档:** - **许可证:** Apache-2.0 - **源码归档:** - **最后更新:** 2026-07-13T22:15:18Z - **已生成:** 2026-08-04T22:13:35+00:00 ## 可执行文件 - sqlite-utils (cli) - sqlite-utils (别名) ## 依赖 - python@3.14 ## 安装行为 - post-install 钩子: 未定义 - Bottle: 可用 于 all ## 版本和新鲜度 - 页面生成时间: 2026-08-04 - 管理器版本: 4.1.1 - 管理器更新时间: 2026-07-13 - 本地数据: OK - 上游仓库: https://sqlite-utils.datasette.io/ - 信息: Release/tag comparison is only available for GitHub repositories. ## 项目历史与用法 sqlite-utils is a Python library and CLI for creating, loading, querying, and transforming SQLite databases. It is closely associated with the Datasette ecosystem and with command-line data work. ### 项目历史 The official documentation describes sqlite-utils as both a CLI tool and Python library for manipulating SQLite databases, especially for creating databases from existing data. Its changelog records an initial PyPI release in July 2018. The project developed into a broad utility surface around SQLite: import JSON, CSV, and TSV; create and transform tables; manage indexes and foreign keys; enable full-text search; analyze tables; and install plugins. ### 采用历史 The official installation docs document Homebrew, pip, and pipx installation paths. The input also lists Debian, Ubuntu, and Nix package names, showing that the tool moved beyond Python-only packaging into general system package channels. ### 使用方式 CLI users run `sqlite-utils` for one-off data loading, SQL querying, schema inspection, database transformations, and automation around SQLite files. Python users import `sqlite_utils` when they want scriptable helpers without writing raw sqlite3 boilerplate for common database-building tasks. ### 为什么软件包爱好者会关心 Package nerds care because sqlite-utils turns SQLite into a shell-friendly data toolkit. It packages the SQLite file format, Python's bundled sqlite3 module, and Datasette-style publishing workflows into a CLI that can be installed with Homebrew, pipx, or distro packages. ### 时间线 - 2018: 0.2 changelog entry records the initial PyPI release. - 2020: 2.0 release line appears in official release metadata and changelog history. - 2020: 3.0 line appears in the changelog history. - 2025: 3.39 appears in official documentation as a current stable release entry. ### Related projects - The official docs describe sqlite-utils as a useful complement to Datasette. - The installation docs discuss pysqlite3 and sqlean.py as optional replacements for Python's bundled sqlite3 module when newer SQLite features or extension loading are needed. ### 来源 - - - - ## 安全说明 broad file, network, media, or database tool signal. - **Geiger 风险:** blue / 中 - broad file, network, media, or database tool signal ## 源数据库详情 - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** sqlite-utils - **Version Scheme:** 0 - **Revision:** 0 - **Head Version:** HEAD - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** head, stable ## 其他软件包管理器记录 - Debian apt - sqlite-utils - 3.38-1: normalized package name match | Debian stable package indexes: sqlite-utils from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | CLI tool and Python utility functions for manipulating SQLite | https://github.com/simonw/sqlite-utils - Nix - sqlite-utils: normalized package name match | nixpkgs package indexes: sqlite-utils from https://raw.githubusercontent.com/NixOS/nixpkgs/master/pkgs/top-level/all-packages.nix - Ubuntu apt - sqlite-utils - 3.35.2-1: normalized package name match | Ubuntu 24.04 LTS package indexes: sqlite-utils from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | CLI tool and Python utility functions for manipulating SQLite | https://github.com/simonw/sqlite-utils ## 相关链接 - [Secret-risk packages](https://pkg.so/zh-hans/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals. - [Terminal utility packages](https://pkg.so/zh-hans/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://pkg.so/zh-hans/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Language runtime packages](https://pkg.so/zh-hans/language-runtime-packages/) - Matched language runtime, compiler, or interpreter metadata. - [python@3.14](https://pkg.so/zh-hans/brew/python-3-14/) - Runtime dependency declared by Homebrew. - [sqlite](https://pkg.so/zh-hans/brew/sqlite/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [gdbm](https://pkg.so/zh-hans/brew/gdbm/) - Shares pkgdb curated category or tags: cli, data, database, library. - [libmaxminddb](https://pkg.so/zh-hans/brew/libmaxminddb/) - Shares pkgdb curated category or tags: cli, data, database, library. - [lazysql](https://pkg.so/zh-hans/brew/lazysql/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [leveldb](https://pkg.so/zh-hans/brew/leveldb/) - Shares pkgdb curated category or tags: cli, data, database, library. - [rainfrog](https://pkg.so/zh-hans/brew/rainfrog/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [rqlite](https://pkg.so/zh-hans/brew/rqlite/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [sqlite-analyzer](https://pkg.so/zh-hans/brew/sqlite-analyzer/) - Shares pkgdb curated category or tags: cli, data, database, sqlite. - [mysql-to-sqlite3](https://pkg.so/zh-hans/brew/mysql-to-sqlite3/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, python, python-3-14. - [ccm](https://pkg.so/zh-hans/brew/ccm/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, databases, python. - [datasette](https://pkg.so/zh-hans/brew/datasette/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, python, python-3-14. ## Combined YAML source View the package source record on GitHub. [combined/sqlite-utils.yml](https://github.com/mxcl/pkgdb/blob/main/combined/sqlite-utils.yml) ## 来源 - pkg.so package database - Geiger risk classifier - package-page enrichment - curated package history - package version freshness - pkgdb category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph