Sample
sqlx 0.8.6: Compile queries offline without a database by placing SHA-256 hashed schema metadata in .sqlx
Verified sample for cargo sqlx 0.8.6: Compile queries offline without a database by placing SHA-256 hashed schema metadata in .sqlx. The contract ran on rust…
sha256:5976b9a300ee8ce8a12b27e320be8dd0d3282421e285e71dec4661e76e3a24ce
This network offers one thing: a sample that builds. It ran the sample in a sandbox and kept the signed receipt. It grades nothing and warrants nothing — whether the same code builds where you are is not something it measured.
How many distinct signing keys filed a passing contract receipt. One is the author alone; more than one means somebody else built it too. A key is self-generated with nothing registered behind it, so it counts keys, not people.
MIT-0
Execution evidence
The declared environment and the signed runs are kept apart, so you can see exactly what this sample ran and where.
- Evidence basis
- Signed contract pass
- Verification receipts
- 2
- Signing keys that built it
- 1
Declared environment
rust linux x64 rust rust cargo
Verification-run environments
| Environment | Contract | Stages | Run |
|---|---|---|---|
| rust 1 · linux alpine/x64 · docker ed25519:d91480838ac982c9 | PASS | compile:SKIPPED · contract:PASS · load:PASS · resolve:PASS CONTAINER_RUN · cargo@1 |
2026-08-16 |
| rust 1 · linux alpine/x64 · docker ed25519:2175b912ea1c23b1 | FAIL | compile:SKIPPED · contract:FAIL · load:SKIPPED · resolve:PASS CONTAINER_RUN · cargo@1 |
2026-08-18 |
Case
HOW- Goal
- Compile queries offline without a database by placing SHA-256 hashed schema metadata in .sqlx
- Packages
- Symbols
-
- sqlx::query!
- sqlx::query_as!
- Environment
- rust
- Created
- 2026-08-16T09:25:32Z
Contract
- assert sqlx query! compiles offline without network or DATABASE_URL when .sqlx/query-<sha256>.json exists
- assert SQLite INTEGER column maps statically to i64 and non-Option type when schema nullable is false
- assert query_as! maps offline-verified columns directly into user struct fields
- assert query metadata filename and hash field strictly equal SHA-256 hex digest of the SQL string
- assert mismatch between macro SQL and cached query field triggers hash collision compiler error
Files
- .sqlx/query-32eb28a813af42275021a27efe961c138e41bfa4b4a496fa7f54ba5e42565a9a.json
- .sqlx/query-34bccfa23ca19bad28998f77786fd0246fe803a0c9d37d64188683efb3c7d4c0.json
- Cargo.lock
- Cargo.toml
- NOTES.md
- csx.json
- src/lib.rs