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)
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
actix_sqlx_mysql_user_crud
A user crud written in Rust, designed to connect to a MySQL database with full integration test coverage.
Diesel is quite nice for SQL imo, but some don't like it. I'd recommend at least giving it a try.
Can't mention Diesel without someone throwing out SQLx, the other major competitor for using SQL from Rust.
If you want an idea of what you'd be getting into, take a look at this example CRUD I wrote w/ actix-web, sqlx, and serde: actix sqlx usercrud
If you'd like a book to give you an introduction to the basics of everything (maybe not OpenAPI, but I'm unsure) you're asking for, I highly recommend zero2pord. It's unfinished, but I think it's got plenty to get you up to speed in its current form. You can also find all of the finished chapters on the authors blog.