基于文件探测的SQLite数据实时远程增量同步的实现

Implementation of SQLite Data Real-Time Remote Incremental Synchronization Based on File Detection

随着移动互联网、物联网的发展,基于SQLite数据库的应用越来越多,SQLite数据库简单、自包含、零配置等特点方便了应用的开发,但是在数据集成、远程同步等方面还没有通用、完善的解决方案。基于文件探测的思路提出了以采集程序、消息传输通道、服务端程序为核心的SQLite数据实时远程增量同步的解决方案,通过监控SQLite数据库文件的改变来触发增量数据的获取、传输、解析与入库,整个过程通过数据库文件改变这一事件进行驱动,实现了SQLite数据同步的实时性。

With the development of the mobile Internet and the Internet of Things,there are more and more applications based on the SQLite database.The features of the SQLite database are simple,self-contained,and zeroconfiguration,which facilitates the development of applications.But there is no universal and perfect sdution in data integration and remote synchronization.Based on the idea of file detection,a solution for real-time remote incremental synchronization of SQLite data is proposed,which is centered on the acquisition program,message transmission channel,and server program.The acquisition,transmission,and analysis of incremental data are triggered by monitoring the changes of SQLite database files.With warehousing,the whole process is driven by the event of database file change,which realizes the real-time synchronization of SQLite data.