2 ms·
It works for the data itself just fine. Hopefully schema changes aren't terribly frequent.
by regularfry 5y ago
It works for the data itself just fine. Hopefully schema changes aren't terribly frequent.
- lostmsu 5y agoWhat do you mean "works fine"? AFAIK to read consistent data you need to be reading from a database snapshot. So with every data update on the server you need to make a new snapshot (to include new data), and publish it under new version (otherwise clients might be in the middle of some query reading data from the old snapshot, and combine metadata from the old snapshot with data from the new one).
- regularfry 5y agoSQLite already supports multiple-readers/single-writer. You don't need a new snapshot to add data.
- lostmsu 5y agoOne of us does not understand how that works. According to me you need to acquire read/write locks in order to ensure consistency in presence of a writer. You can't do that by reading ranges of a static file with independent read requests.