Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support concurrency with connection pool #864

Open
jacobg opened this issue May 3, 2019 · 0 comments
Open

Support concurrency with connection pool #864

jacobg opened this issue May 3, 2019 · 0 comments

Comments

@jacobg
Copy link

jacobg commented May 3, 2019

Currently, this plugin only supports one connection per database, whereas sqlite does support multiple connections. Check out this article for info on that:
http://charlesleifer.com/blog/sqlite-small-fast-reliable-choose-any-three-/

And because there is only one connection, contention can occur between simultaneous requests that can causes errors and even possible corruption.

The plugin should expose sqlite's support for concurrency by allowing for multiple connections, ideally even a way to manage a connection pool.

And in the meantime, perhaps the plugin should add a request queue to enforce that requests are processed one at a time, and prevent interference.

Some related issues are:

@brodybits

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant