We are currently using the batch.rs file recommended to me in Discord by mehcode of SQLx. It works OK, but it's a bit ugly/hard to review/can be made more succinct and clear. Possible suggestions have been to move much of the query building code into a Macro to clean it up a bit.
Code in question is stuff like this:
While doing the refactor of replacing Diesel with SQLx in this project (maybe 3/4 of a year ago), I came across Quaint which I had hoped would develop tighter SQLx integration, esp with prisma/quaint#158. It still might be worth keeping an eye on, though.
We are currently using the
batch.rsfile recommended to me in Discord by mehcode of SQLx. It works OK, but it's a bit ugly/hard to review/can be made more succinct and clear. Possible suggestions have been to move much of the query building code into a Macro to clean it up a bit.Code in question is stuff like this:
substrate-archive/substrate-archive/src/database.rs
Line 154 in 27e3e8c
While doing the refactor of replacing Diesel with SQLx in this project (maybe 3/4 of a year ago), I came across Quaint which I had hoped would develop tighter SQLx integration, esp with prisma/quaint#158. It still might be worth keeping an eye on, though.