3 ms·

They work just fine! Joins: https://simonwillison.net/2021/Feb/21/cross-database-queries/ https://simonwillison.net/2021/Feb/21/cross-database-queries... Tran

They work just fine! Joins: https://simonwillison.net/2021/Feb/21/cross-database-queries/ https://simonwillison.net/2021/Feb/21/cross-database-queries... Transactions: https://www.sqlite.org/atomiccommit.html#_multi_file_commit https://www.sqlite.org/atomiccommit.html#_multi_file_commit

mchristen 1y ago
Unfortunately if you use WAL mode the transactions are only isolated per database file. https://www.sqlite.org/lang_attach.html https://www.sqlite.org/lang_attach.html
thayne 1y ago
But then you need the write lock for all the databases (assuming your transaction involves writes).