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

问题描述

我想知道SQLite是否基于某种增量文件提出了一种更新机制，例如，Oracle数据库可以与sql重做日志或快照日志同步.

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.

SQLite是否提出了一种优化的机制来进行自我更新.

Does SQLite proposes an optimized mechanism to update itself.

以下是我的用例，我有一个本地数据库，该数据库必须与一些远程数据同步，在理想情况下，我想以一种优化的格式来构建更改，并且只有它们，而不是所有数据库，是否存在一些更改本机SQLite机制还是我必须实现自定义的一种?

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 ?

谢谢

推荐答案

我们有完全相同的要求，我们通过编写插入/更新/删除语句满足了这一要求，当对SQLLite数据库执行该语句时，它会对其进行更新.

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.

我们有一个中央SQLLite数据库，该数据库已从某些来源进行了更新.然后需要将更新传播到其他SQLLite数据库.我们要做的是生成SQL脚本，并针对需要更新的数据库执行它们.

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屋！