Data Sync: SQLite on Android + MySQL on Linux

Question:

There is an Android tablet app that stores user data in SQLite. And there is a remote MySQL database that stores the data of many users. It is necessary to periodically synchronize or asynchronously synchronize data (mainly from a mobile client to a remote server).

What's the best out-of-the-box solution?

Answer:

In general, there is no generally accepted remedy. Known:

  • Oracle Database Mobile Server + Oracle Database
  • Microsoft Sync Framework (SQL Server, SQLite)
  • Sybase SQL Anywhere Studio + UltraLite

Of the little-known:

Mobile frameworks like Sencha and RhoMobile also include modules for data synchronization.

Scroll to Top