Beyond the SQLite Single-Writer Limitation with Concurrent Writes

Re:Beyond the SQLite Single-Writer Limitation with Concurren... by nextaccountic on Wednesday October 15, 2025 @12:51AM (#45588185)

> SQLite is built around a file that stores data for a single application

A single application can need multiple concurrent writes

[ Parent | on HN ]

Re:Beyond the SQLite Single-Writer Limitation with Concurren... by crazygringo on Wednesday October 15, 2025 @11:16AM (#45593891)

So that's what asking. When? Why? I've simply never encountered that, and can't imagine what a use case would be.

SQLite already supports lots of threads writing, they just all take turns. What application needs those writes to be concurrent?

[ Parent | on HN ]

Re:Beyond the SQLite Single-Writer Limitation with Concurren... by pod_krad on Saturday October 18, 2025 @07:32PM (#45631115)

I have such application. It scans hosts for gathering some information in several parallel threads. Then each thread stores part of this information in Sqlite database.

[ Parent | on HN ]