Oh and PS to optimise your SQLite DB performance, have a look here: github.com/nikspyratos/toybox… All of those are pulled from this and other articles: kerkour.com/sqlite-for-servers
The long and short of the multi-db usage as well is that there's separate databases for Queue, Cache, and Pulse (performance monitoring) functionality, because each of those can become very write-heavy and affect users as app traffic scales up.
Oh and PS to optimise your SQLite DB performance, have a look here:
github.com/nikspyratos/toybox…
All of those are pulled from this and other articles:
kerkour.com/sqlite-for-servers
The long and short of the multi-db usage as well is that there's separate databases for Queue, Cache, and Pulse (performance monitoring) functionality, because each of those can become very write-heavy and affect users as app traffic scales up.