Few code samples are shown here: https://github.com/syncliteio/SyncLite and https://github.com/syncliteio/SyncLite/tree/main/synclite-co...
A jsp-servlet sample web app is here: https://github.com/syncliteio/synclite-sample-web-app
SyncLite logger transactionally captures the exact sql statements (DDLs and DMls) as executed on the underlying embedded databases, into sqllog files.
The log files for each device (i.e. database) are shipped to a configured staging storage(Local FS/SFTP/S3/MinIO/Kafka etc).
SyncLite consolidator continuously looks for new devices and new logs for each devices.
The received raw sql logs are not directly applicable on final destination as they are logical statements, may involve complex dependencies/joins e.g. insert into select <cols> from t1 JOIN t2 ...
Consolidator applies the incoming sql logs transactionally to a native embedded database (SQLite) and in the process generates record level CDC logs by identifying exact changed records and tables
The CDC logs are record-level INSERT, UPDATE, DELETE statements, DDL statements : CREATE TABLE, ALTER TABLE, DROP TABLE, RENAME TABLE.
The CDC log files as generated are applied to final destination databases.
A summary of this is here : https://www.synclite.io/synclite/sync-ready-apps
Thank you for the feedback and we are improving the documentation.