2 ms·

Joins and Transactions are a pretty big part of SQL. I'm no expert, but if my quick search results are right, both are lost in the separate file per table scena

• conradev 1y ago
  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).