Is there a way to update SQLITE database using deltas?

Viewed 2572

I would like to know if SQLite proposes a update mechanism based on some delta file, to be clear for example an Oracle database can be synchronized with sql redo logs or snapshot logs.

Does SQLite proposes an optimized mechanism to update itself.

My use case is the following, I have a local database which must be synchronized with some remote data, in ideal world I would like to build in an optimized format the changes and only them, not all the database, is there some native SQLite mechanism or must I implement a custom one ?

Thank you

4 Answers

Some of the other answers are out of date as of 2016. The "sessions" extension was added to SQLite3 in version 3.13.0 (in 2016) which provides something similar to diff and patch. I'm in no way an expert on this, I had the same question as the OP here, and eventually found this.

https://sqlite.org/sessionintro.html

Related