使用 Homebrew, Nix, pacman, apk 安装 sqlx-cli

项目链接

• 主页

命令和别名

• cargo-sqlx
• sqlx

项目历史

The SQLx repository's official README describes SQLx as an async, pure-Rust SQL crate with optional compile-time checked queries and support for PostgreSQL, MySQL, MariaDB, and SQLite. The sqlx-cli README describes the CLI as SQLx's associated command-line utility for managing databases, migrations, and offline mode for query macros.

Official repository metadata places the SQLx project in public GitHub development from late 2019. The CLI became important because SQLx's compile-time query checking creates a developer workflow need: capture query metadata with cargo sqlx prepare so projects can build without a live development database.

采用历史

The supplied package-manager facts show sqlx-cli distributed as sqlx-cli or cargo-sqlx through Homebrew, Alpine, Nix, and Arch. That packaging matters because Rust users often need the executable in CI images and developer shells even when the application itself depends on SQLx as a library.

使用方式

The official sqlx-cli README documents cargo install options by database backend and TLS stack, DATABASE_URL via command-line option, environment, or .env file, database create/drop commands, migration creation and execution, reversible migrations, cargo sqlx prepare, the .sqlx metadata directory, and prepare --check for CI.

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

Package nerds care about sqlx-cli because it bridges Rust's compile-time SQL checking with ordinary package-manager workflows. It is a CLI that must stay version-compatible with a Rust library, database drivers, TLS choices, and CI environments.

时间线

• 2019: Official repository metadata reports SQLx public repository creation.
• 2020: Public issue history shows early CLI design work around cargo-sqlx and migration commands.
• 2021: The sqlx-cli README documents reversible migrations using timestamped up/down SQL files.
• 2023: Changelog notes offline query metadata moving toward one file per query invocation.
• 2026: Latest crate/docs metadata continues to describe sqlx-cli as SQLx's command-line utility.

Related projects

• sqlx-cli is tightly coupled to SQLx query macros, Rust's cargo workflow, and database backends including PostgreSQL, MySQL/MariaDB, and SQLite.

来源

• https://docs.rs/crate/sqlx-cli/latest
• https://github.com/launchbadge/sqlx/issues/170
• https://github.com/transact-rs/sqlx
• https://github.com/transact-rs/sqlx/tree/main/sqlx-cli#readme
• source_facts.package-manager