[This post is an archive from old SQL Yoga forums]
Are there a set of best practices for syncing a local and remote database using SQLYoda?
The app has multiple users that need to share a common database.
The app runs on desktop (windows) and mobile (android).
The mobile users are often in areas with zero coverage and no connectivity for extended periods (hours to days).
Record sync arbitration based on "latest timestamp" is sufficient for this app.
What is the best method to maintain sync between the local mobile database instances and the remote, central database?
# of users: 20 to 30
Desktop: Windows 7
Mobile: Android 4.x
local/remote database sync best practices
Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore
-
- VIP Livecode Opensource Backer
- Posts: 1005
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
- Contact:
local/remote database sync best practices
Trevor DeVore
ScreenSteps - https://www.screensteps.com
LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder
ScreenSteps - https://www.screensteps.com
LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder
-
- VIP Livecode Opensource Backer
- Posts: 1005
- Joined: Sat Apr 08, 2006 3:06 pm
- Location: Overland Park, Kansas
- Contact:
Re: local/remote database sync best practices
Sorry, I missed this post originally and just saw it. Syncing content between devices is outside the scope of what SQL Yoga can do. It can actually be a very complex problem. While you can use SQL Yoga within a larger system that syncs data, the syncing system is separate from SQL Yoga.
Trevor DeVore
ScreenSteps - https://www.screensteps.com
LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder
ScreenSteps - https://www.screensteps.com
LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder