Actions on 2 sqlite dbs

[ivan]

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.

[jchd]

It's brain dead easy to open several databases simultaneously using the standard UDF, but doing so doesn't allow you to perform queries like you show. Leave the command-line tool (sqlite3.exe) alone, it's not needed.

Fortunately you can ATTACH one or more database to an already open one. From then, you can indeed construct queries using tables from all attached DBs. Look at the SQL documentation on the SQLite site.

[ivan]

Thanks for the advice.