Hacker News new | ask | show | jobs
by askmenot26 10 days ago
Interesting ! Quite often repl projects like this provide no or half baked support for schema change sync.. Does this handle schema changes seamlessly?
1 comments

Each write operation (DDL + DML) is transactionally captured by the synclite logger ( a wrapper over underlying embedded db) and logged into the log file. So, it handles all schema operations create, drop, alter ( add/drop/rename column), rename column/table, in addition to the dml operations insert/update/delete.
how does it handle changes done on destination database? Does it sync them back to local database ?
SyncLite currently supports unidirectional replication/consolidation from embedded database to destination database. Reverse path from destination to local db(with conflict resolution) is on the roadmap.