hi,
is there an easy framework or routine to easily 1 way sync many local db with one central master db using sqlite?
the master will only hold a centralised copy of the many local dbs, for viewing by manager. manager wouldn't change anything in master.
however, if local db amends/deletes rows, then this would also need to be updated to master.
i know sqlite local apps can read concurrently from the centralised master db.
only 1 local app can write to central master db at a time, but if locked, would just want this to retry after a minute.
the syncing should happen in background maybe with idle timer, so shouldn't affect user. syncing doesn't have to be to the second. every 5 min should be fine and before closing.
I chose sqlite as I don't need server yet, only local embedded db app. was considering firebird, but that doesn't allow concurrent access by many local apps to one centralised db, in embedded mode - have to use server.
later, i may want 2 way syncing but not yet.