Database race conditions

[matheusbaptistella]

Hello everyone, I'm working on a project to build an api in Rust using Axum and Sqlx. I have implemented some functions to read from the database and functions to write to it. I am running 2 instances of this api simultaneously using Docker compose and they interact with the same db. I was wondering if there could be potential issues with race conditions (and how to address them) or if Sqlx's connection pool prevents it from happening. I currently supply the connection pool as an axum::State for my handler functions.

I thought about using RwLock as a wrapper for my connection pool:

type DbPool = Arc<RwLock<PgPool>>;

would this be the best approach?

[francois-random]

No. Let the database manage writes, and use a single pool.
Never use a mutex for that.
Look to what ACID means for a database.