Hacker News new | past | comments | ask | show | jobs | submit login

The FAQ disagrees with you: https://www.sqlite.org/faq.html#q5



> But only one process can be making changes to the database at any moment in time


You can open the same SQLite DB from multiple processes and then issue UPDATEs and INSERTs "simultaneously", and SQLite enforces the single-write rule internally with locking - using shared-memory on the same PC or file-locking on NFS-alikes.




Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4

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

Search: