ITTIA announces DB Sync database software for Android apps

To synchronize data, an Android app must identify local changes, open a communication channel to a back-end service, and transfer the data. While a sync adapter can be used to schedule synchronization in the background, apps that store data in an SQLite database must track changes manually and define protocols for authentication and communication. For any non-trival data model, this represents a significant development effort. ITTIA DB SQL is a drop-in replacement for SQLite that automatically synchronizes local changes with a back-end database quickly and efficiently.

Likewise, developing a custom network service to synchronize with numerous Android devices is no simple task, especially when every device has a different subset of the available data. Instead, ITTIA DB SQL communicates with ITTIA DB Sync, a bidirectional data synchronization service for Windows and Linux. ITTIA DB Sync uses 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, an Android app simply creates similar tables in its local database and designates which tables should send and/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 can tailor to match its own look and brand.