libsql icon indicating copy to clipboard operation
libsql copied to clipboard

Sync prevents concurrent reads?

Open penberg opened this issue 1 year ago • 1 comments

Airyland on Discord reports that:

Appears that the embedded replica's .sync function is blocking SQL queries. Is there a way to allow queries to execute concurrently with the sync process?

SQLite itself should be able to serve reads while we're syncing and applying changes to the WAL. Perhaps there is a serializing lock somewhere that prevents this?

penberg avatar Feb 02 '24 08:02 penberg

What is the status of this? We are considering using Turso, and want to do sync to keep data fresh on more than one edge locations, but if sync locks reads, it would be issue.

amitu avatar Oct 05 '24 06:10 amitu