Our great sponsors
-
sqlx
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. (by launchbadge)
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
https://github.com/launchbadge/sqlx#sqlx
Example refinery migrations
Agreed. ORM's seem to do the job 80-90% of the time and make it absolutely painful the remaining 10-20% of the time. Statically checked SQL is pretty much the sweet spot in terms of tradeoffs, but I wouldn't be opposed to something along the lines of serde_postgres but for serialization, so I could use my struct definitions as the single source of truth and simply slap a derive macro on the struct to generate the necessary migrations. I'm not sure whether such an endeavour would be even remotely feasible, though, and it would perhaps be something one would expect to find in Diesel rather than in SQLx.