-
Diesel is quite nice for SQL imo, but some don't like it. I'd recommend at least giving it a try.
-
CodeRabbit
CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
-
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)
Can't mention Diesel without someone throwing out SQLx, the other major competitor for using SQL from Rust.
-
actix_sqlx_mysql_user_crud
A user crud written in Rust, designed to connect to a MySQL database with full integration test coverage.
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.