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:
- Load tests that combine read/writes. This is already underway.
- Addition of a secondary db connection when
database() is called via apsw.Database.attach called something like "read_DBNAME"
- 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.