AnswerDotAI / AnswerDotAI/apswutils

Explore the use of multi-db connections to isolate reads from writes

Open
#15 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
3
Forks
3
PR merge metrics
No merged PRs in 30d

Description

Rails uses its multi-db feature to accelerate sqlite by having two connections, 1 for writes and 1 for reads. To test this out we will need:

1. Load tests that combine read/writes. This is already underway.
2. Addition of a secondary db connection when `database()` is called via `apsw.Database.attach` called something like "read_DBNAME"
3. Modify read methods to access the `read_DBNAME` connection

Note: I put this in apswutils rather than fastlite, as a lot of devs access apswutils read methods directly.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.