Which one to use postgres vs. sqlx

[alice]

@zwv

when you say checked at compile-time, do you mean the compiler will resolve the variables and construct the queries?

The sqlx library includes some code that it runs during compile time to verify that an SQL query is valid syntax. This is part of its macro.

@zwv

in terms of pool management, seems postgres doesn't have anything built-in. diesel and sqlx have pool management supports.

Yes, for libraries that don't include pool management, you typically want bb8 for async code or r2d2 for non-async code.