Really good article, I’ve experimented with this kind of workloads in SQLite a few times and found it insightful. One note though, using: pragma temp_store =

Really good article, I’ve experimented with this kind of workloads in SQLite a few times and found it insightful. One note though, using: pragma temp_store = memory; only affects temporary tables and indices, not the main database itself[0] [0] https://sqlite.org/pragma.html#pragma_temp_store https://sqlite.org/pragma.html#pragma_temp_store