Comment by conradev

SQLite has an experimental change, "BEGIN CONCURRENT", which uses optimistic locking to allow concurrent non-overlapping writes: https://www.sqlite.org/src/doc/begin-concurrent/doc/begin_co...

So the "rebase" could be the exact same pages (no compute) if none of the writes overlap. If they do, you'd likely need to replay the transaction and make new pages (some compute).