Joins and Transactions are a pretty big part of SQL. I'm no expert, but if my qu... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		kgwxd 4 months ago \| parent \| context \| favorite \| on: Beyond the SQLite single-writer limitation with co... 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 scenario.

conradev 4 months ago [–]

They work just fine!

Joins: https://simonwillison.net/2021/Feb/21/cross-database-queries...

Transactions: https://www.sqlite.org/atomiccommit.html#_multi_file_commit

thayne 4 months ago | | [–]

But then you need the write lock for all the databases (assuming your transaction involves writes).

mchristen 4 months ago | | [–]

Unfortunately if you use WAL mode the transactions are only isolated per database file.

https://www.sqlite.org/lang_attach.html

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact