@mcc a sqlite connection pointer can be safely moved between threads, but it does not perform internal synchronization and so can not be used by more than one thread at the same time. you can open more connections and distribute connections among threads to get concurrency. in wal mode the concurrency can be parallel for reads, but at most only one writer will proceed at a time.
undefined
James Tucker
@raggi@don.rag.pub