有没有办法使用增量更新 SQLITE 数据库? [英] Is there a way to update SQLITE database using deltas?

问题描述

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

解决方案

We have this exact same requirement and we have met this by writing insert/update/delete statements which when executed against a SQLLite database updates it.

We have a central SQLLite database which is updated from some source. The updates then are required to be propagated to other SQLLite databases. What we do is we generate SQL Scripts and execute them against the databases which needs to be updated.

Something similar will help achieve what you are looking for

这篇关于有没有办法使用增量更新 SQLITE 数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！