I am no expert, but SQLite does have in memory store? At least for tables that need it..ofc sync of the writes to this store may need more work.