Sqlx is powerful but overkill for this project in its current form, and fiddling with database migrations and compile time checks for the db when an sqlx env variable isnt' present are making more problems than are worth it.
the first iteration of this project used r2d2 for db pooling and rusqlite for the db wrapper. That worked really well and should be more than sufficient for any multi threading or async.
There will need to be some retooling but it should greatly simplify the backend for development purposes.
see commits from May 7, 2024. This has been fully implemented, though painfully. While there is room for improvement in readability and implementation, is funcitonal now. Marking closed
Sqlx is powerful but overkill for this project in its current form, and fiddling with database migrations and compile time checks for the db when an sqlx env variable isnt' present are making more problems than are worth it.
the first iteration of this project used r2d2 for db pooling and rusqlite for the db wrapper. That worked really well and should be more than sufficient for any multi threading or async.
There will need to be some retooling but it should greatly simplify the backend for development purposes.