I have a MQ that uses SQLite. There's a flush routine that runs every 100ms. I just recently found a rare bug because the file isn't locked when flushing the queue table. Will adding a lock fuck up the write/read flow?

I dont recall ever having been so bored in my entire life as i have been with my gf this weekend, and im old as fuck