SQLite Forum

temp storage within triggers
It should be safe, even with multiple connections, because a trigger is always used in the context of an implicit or explicit transaction.

In all journal modes, there is always only one writer. 
Triggers launch for insert, update, or delete, which are all writers.

So, the normal table you use as 'tempstore' will only be accessed by one connection at any time.

Kees Nuyt