All News | Boards | Chips | Devices | Software | Archive | About | Contact | Subscribe
Follow LinuxGizmos:
Twitter Facebook Pinterest RSS feed
*   get email updates   *

Android DBMS adds bidirectional sync

Sep 30, 2014 — by Eric Brown 1,072 views

ITTIA has added bidirectional sync to ITTIA DB SQL for Android, enabling a back-end RDBMS to store device data and download sync’d updates for each device.

In March of last year, ITTIA announced the Android version of its Linux-compatible ITTIA DB SQL lightweight embedded relational database. Now, ITTIA has added bidirectional synchronization for Android apps to the Android version, in order to “bridge the gap of collecting big data on-the-go” in an era of “unprecedented influx of sensitive data that is managed and collected on mobile devices,” says the company.

Typically, synchronizing Android device data with a back-end server requires some tricky programming by app developers, says ITTIA. Apps must be able to identify local changes, open a communication channel to a back-end service, and transfer the data. You can use a sync adapter for scheduling in the background, but apps that store data in a SQLite database must still be able to track changes manually and define protocols for authentication and communication, says the company.

Sample phone book data sync app using ITTIA DB SQL for Android

The latest ITTIA DB SQL for Android is claimed to handle all this in the background as a “drop-in replacement for SQLite.” The new synchronization code automatically synchronizes local changes with a back-end database.


The ITTIA DB SQL for Android update also avoids the need to develop a custom network service to synchronize numerous Android devices, which is especially helpful when every device has a different subset of the available data, says ITTIA. The ITTIA software handles this task by communicating with ITTIA DB Sync, a bidirectional data synchronization service for Linux and Windows. It also lets you use a back-end RDBMS, such as Microsoft SQL Server or Oracle Database, to store device data in existing tables and download updates specific to each device.

To enable synchronization, Android developers create similar tables in an app’s local database, and then designate which tables should send or receive changes. The ITTIA DB SQL sync adapter runs in the background at scheduled times or whenever the device is online. For authenticated connections, the sync adapter automatically displays a customized login activity that the app developer can tailor, says ITTIA.

The bidirectional synchronization feature on ITTIA DB SQL for on Android automatically detects conflicts and provides multiple options for resolution, and divides tables across multiple devices with robust filters, says the company. It also offers concurrent shared access, optimizing multi-threaded apps with row-level locking. The program is said to offer a “small footprint,” and supports Android Froyo (2.2) and above, including KitKat (4.4).

ITTIA DB SQL bidirectional synchronization explained

Further information

Developers can now download an example phone book Android app to try the new synchronization features on ITTIA DB SQL for Android. A free evaluation copy of ITTIA DB SQL for Android is available at the ITTIA DB Evaluation Center.

(advertise here)

Print Friendly, PDF & Email

One response to “Android DBMS adds bidirectional sync”

  1. jelabarre says:

    The next thing to do is develop a local-sync backend that will let you sync *over USB* to files on your local computer, and avoid having to squirt your data all the way to some server in a dirt-floor shack in Bangalore and back. Then we could replace the sync functionality we *lost* at the demise of PalmOS.

Please comment here...