2 ms·
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
by nerdponx 3y ago
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.
- slondr 3y agoSQLite itself doesn’t support concurrent users.
- abbeyj 3y agoThe FAQ disagrees with you: https://www.sqlite.org/faq.html#q5 https://www.sqlite.org/faq.html#q5
- lostdog 3y ago> But only one process can be making changes to the database at any moment in time
- mappu 3y agoYou 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.