LinuxCommandLibrary

sqlx

TLDR

Create database

$ sqlx database create
copy
Run migrations
$ sqlx migrate run
copy
Create migration
$ sqlx migrate add [migration_name]
copy
Revert migration
$ sqlx migrate revert
copy
Prepare offline
$ sqlx prepare
copy
Check queries
$ sqlx prepare --check
copy

SYNOPSIS

sqlx command [options]

DESCRIPTION

sqlx manages SQL in Rust. It's compile-time checked SQL.
Migration management. Version control schema.
Offline mode support. Cached query data.
Compile-time verification. Type-safe queries.
Multiple databases. Postgres, MySQL, SQLite.

PARAMETERS

database

Database operations.
migrate
Migration commands.
prepare
Prepare for offline.
--database-url URL
Connection string.
add
Add migration.
run
Run migrations.

CAVEATS

Rust development tool. DATABASE_URL required. Compile-time checks.

HISTORY

sqlx is a Rust SQL toolkit providing compile-time checked queries and database migrations.

SEE ALSO

diesel(1), psql(1), sqlite3(1)

Copied to clipboard