Tool Open source
sqlite-multiwriter is a VFS extension for SQLite that allows multiple threads or processes to write to the same database concurrently without changing SQLite, the SQL, the schema, or the ordinary SQLite database format. Each writer uses a private write-ahead log and a snapshot; at commit, the engine validates the pages read and written, orders the commits, publishes them through a commit log, and compacts the results into the database file. Writers that conflict on the same page can receive SQLITE_BUSY_SNAPSHOT and must retry the whole transaction; the optional rebase mode can replay supported row-level INSERT, UPDATE, and DELETE operations that lost only because they shared pages. It supports extension loading or static linking, thread and multi-process modes, and platform packages for Linux, macOS, iOS, Android, and Windows. It requires WAL mode and a local filesystem, and is distributed under the Apache License 2.0; the vendored SQLite code is public domain.
1 use taken from transcripts — each links to the moment in the video.
A VFS extension layer letting many threads or processes write to one SQLite database concurrently without modifying SQLite, using per-writer write-ahead logs while keeping a normal SQLite file.
1 in the library.