local/remote database sync best practices

This is the place to post technical queries about SQL Yoga

Moderators: heatherlaine, Klaus, FourthWorld, robinmiller, trevordevore

Post Reply
trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 853
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

local/remote database sync best practices

Post by trevordevore » Fri Oct 11, 2013 1:59 pm

[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
Trevor DeVore
ScreenSteps - http://www.screensteps.com

Levure Application Framework: https://github.com/trevordevore/levure
LiveCode Resources for Developers: http://livecode.bluemangolearning.com

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 853
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: local/remote database sync best practices

Post by trevordevore » Fri Oct 11, 2013 2:00 pm

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 - http://www.screensteps.com

Levure Application Framework: https://github.com/trevordevore/levure
LiveCode Resources for Developers: http://livecode.bluemangolearning.com

Post Reply

Return to “SQL Yoga”