Hacker News Reader

Does the SQLite format support concurrent users? Or would it need better conflict resolution support in the application?

Checking the XML data into text-based version control is a really interesting idea. you could probably do something similar with the SQLite data, using a tool like Dolt.

View on HN

SQLite itself doesn’t support concurrent users.

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.

Reply on news.ycombinator.com