Comment Comment by thesuperbigfrog I used SQLx with an SQLite database and ran into connection pool problems that would cause the database to be unexpectedly dropped.The issues I saw seem to be related to these issues:https://github.com/launchbadge/sqlx/issues/3080https://github.com/launchbadge/sqlx/issues/2510The problems did not manifest until the application was under load with multiple concurrent sessions.Troubleshooting the issue by changing the connection pool parameters did not seem to help.I ended up refactoring the application's data layer to use a NoSQL approach to work around the issue.I really like the idea of SQLx and appreciate the efforts of the SQLx developers, but I would advise caution if you plan to use SQLx with SQLite. parent thesuperbigfrog 1 year ago
The issues I saw seem to be related to these issues:
https://github.com/launchbadge/sqlx/issues/3080
https://github.com/launchbadge/sqlx/issues/2510
The problems did not manifest until the application was under load with multiple concurrent sessions.
Troubleshooting the issue by changing the connection pool parameters did not seem to help.
I ended up refactoring the application's data layer to use a NoSQL approach to work around the issue.
I really like the idea of SQLx and appreciate the efforts of the SQLx developers, but I would advise caution if you plan to use SQLx with SQLite.