Step-by-step DB Sync client app implementation
This guide outlines the step-by-step implementation process for creating a DB Sync client
application, detailing key components and functionalities required for seamless data
syncing.
Import the DB Sync API modules Initialize the DB Sync API Declare the database schema dbsync_app.register_local_dbschema() function.Initialize the SQLite local database Register sync source parameters User authentication in direct mode User authenticating with GAS/SSO/GIP Declare application SQL tables Data changes: Row creation (INSERT) Data changes: Row change (UPDATE) dbsync_app.register_local_update() for complete row changes or dbsync_app.register_local_change() for field-specific updates to minimize conflicts. Compact the changes log with dbsync_app.compact_local_changes() to optimize synchronization and resolve potential conflicts.Data changes: Row removal (DELETE) Synchronizing with central database Cleanup the DB Sync API