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

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.



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


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

Search: