Re: [sqlite] locking problem (on insert inside callback)

[Rachel Willmer]

> Solution 1 is to use a TEMP table:
>
>   CREATE TEMP TABLE diffs AS
>      SELECT * FROM table1 LEFT JOIN table2 ....;
>   SELECT * FROM diffs; -- Insert into table1 in the callback;
>   DROP TABLE diffs;

that sounds like the answer for me
thanks
Rachel