sqlx VS actix_sqlx_mysql_user_crud

For PostgreSQL, the most relevent part of the code is here. With this in mind I changed some things around to rely on schemas instead of databases and even simplified some parts of the implementation as this was always meant to be for internal use only..

What exactly are you missing? I haven't really written "boring corporate backend stuff" in a few years but something like sqlx provides everything I've ever needed there.

Badges are the little rectangles you typically see at the top of a crate's README: https://github.com/launchbadge/sqlx/blob/main/README.md

SQLX has entered the chat [1].

[1] https://github.com/launchbadge/sqlx

Database : SqLite (using sqlx).

The current (well, removed) MSSQL sqlx driver also doesn't support encrypted connections (https://github.com/launchbadge/sqlx/issues/1552), so it might work locally on an unnamed instance but not over the network until they add in the newer driver (which will be closed source but for an OSS project you should be able to request a free license I think)

I'm considering making my own wrapper over lower-level database drivers. There are a lot of features in sqlx that I don't need, and the latest version seems to have removed useful data structures that SQLPage is using. It also removed support for SQL Server.

add Ed25519 to AuthPlugin enum on https://github.com/launchbadge/sqlx/blob/061fdcabd72896d9bc3abb4ea4af6712a04bc0a8/sqlx-core/src/mysql/connection/auth.rs and implement them using these crates:

Lastly, I wrote a CRUD a while ago that's on the Actix Web examples, which is a simple CRUD that has full test coverage. I didn't do any mocking, but you can take a look at the code and see if any of the TDD patterns I used are helpful.

actix sqlx mysql user crud

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

I use the pool here

I use the pool here ``` use super::{Group, User}; use sqlx::mysql::MySqlRow; use sqlx::{FromRow, MySqlPool}; use std::sync::Arc;

This is how I did a CRUD using Actix and SQLx. I, personally, did not use compile time queries. They are a good concept, I just think they need to be wrapped behind framework where they can be switched on an off by a macro or something like that.

Let the best practice win. I made this CRUD modular with full test coverage: https://github.com/jamesjmeyer210/actix_sqlx_mysql_user_crud

I don't have a direct answer for you but I think the best way to solve this would be to write extensive test coverage to verify the behavior of your middle-ware. Here is a CRUD application I build with full test coverage that is listed as an example on the Actix Example repo. Feel free to use the tests I wrote as a template for your own.