Hacker News Reader

Yes, just not at the same time. If you can you want to enable WAL (that requires some shared memory primitives, so same machine generally), because otherwise writes block reads

https://www.sqlite.org/wal.html

View on HN

> Yes, just not at the same time.

Does this mean that my processes need some synchronization primitive of their own to not to concurrent writes?

Afaik SQLite in WAL mode takes your writes but still serializes the commits, so no SQLite-specific synchronization primitives needed. You might run into SQLITE_BUSY, in which case you can play with the timeout https://www.sqlite.org/c3ref/busy_timeout.html

Reply on news.ycombinator.com