Search the Community

I was wondering if anyone has successfully tried to use 2 (or more) sqlite dbs simultaneously with the sqlite UDF. There are many scenarios where this could be desirable. For instance, suppose you have a memory db that stores and manipulates temporary data that is only required at run time, and you want to store only a subset of that data in a file db, say, when the user presses a save button, or something of the sort. Or maybe you want to verify if the permanent database already contains the data, for example: select * from temp.table1 as t inner join perm.table1 as p on p.pk = t.pk where t.col=match_condition; I can't quite figure out how the handle to temp can be passed to query perm, or the other way around. You can certainly use sqlite udf to attach the dbs using sqlite3.exe and generate a script that runs your query, but I'd rather not walk through that alley if a superior solution already exists Any thoughts anyone? As always, any help or advice will be greatly appreciated. Regards, Ivan.