SQLite Forum

facing issue from sqlite3_step()
Login
Thank you Keith Medcalf.
In my current design, I do read from in-memory DB and write to in-memory and disk (Disk write is happening sequentially also I am not performing any Disk read operation. On system startup, I am restoring the data from Disk to in-memory).

I tried using shared cache mode for in-memory db and creating two connections to it. But the issue is if I try to read from a table from one thread, while I am writing into it from another thread, I get a sqlite busy error.

So, is there any way to handle this scenario with multiple connections to in-memory db?

Thank you