This very specific question is what I'm trying to understand. SQLite can be run in memory and as a temporary store.