October 21, 2021

Compiling sqlx with offline mode.


Without needing to access to the database for code generation. You can generate a file, and reffer to the file on compile time. I use docker to compile for deployment, and i didn't want my container to access to the database on each compilation.


Edit Cargo.toml and add offline feature to sqlx.

sqlx = { version = "0.4.1", features = [ "postgres", "runtime-actix-rustls", "offline" ] }

Edit .env and enable SQLX_OFFLINE mode.


Install sqlx-cli, and run cargo sqlx prepare.

cargo install sqlx-cli
cargo sqlx prepare

This will create sqlx-data.json, which has the schema information needed on compile time.

My blog is hosted on Github. If you'd like to leave a comment, report a problem, or contact me, then that's a fine place to do so.
Written by...
Kazushi Kawamura
Software Engineer based in Tokyo.
2019 © Kazushi Kawamura.