How to create data sync: LiveCode app <-> server with MySQL?

Anything beyond the basics in using the LiveCode language. Share your handlers, functions and magic here.

Moderators: heatherlaine, Klaus, FourthWorld, robinmiller, kevinmiller

Post Reply
greg falda
Posts: 77
Joined: Thu Jan 15, 2015 6:51 pm
Location: Warsaw

How to create data sync: LiveCode app <-> server with MySQL?

Post by greg falda » Wed May 24, 2017 11:21 am

Dear all

I have a mobile SQLite database of my LiveCode app (Android, iOS). On the LiveCode server, I have a MySQL database.
Both databases have (logically) the same tables with the same data.

The data may be updated in any of the databases. On the mobile - by my LiveCode app, on the server - by a Web application.

My goal is to provide a sync between the databases - through a WebService, I guess. The goal of the sync is to keep the data (logically) the same.

I am able to define a (logical) policy of how to keep the data in sync (put timestamp on updated records and synchronize only those records, remember which records were deleted and so on), but I'm still unaware of how to implement the sync from the technical point of view.

1) What are the best technologies/libraries to accomplish the task? I believe a WebService would be proper, but could you provide some details, suggest any technical solutions or a roadmap?

2) Do you know about any documentation/courses/tutorials/links (from LiveCode or other parties) which would help me accomplishing this task?

3) In fact, any informations and ideas of how to create such a sync are welcome.

Thanks in advance
best
greg falda

AndyP
Posts: 368
Joined: Wed Aug 27, 2008 12:57 pm
Location: Seeheim, Germany (ex UK)
Contact:

Re: How to create data sync: LiveCode app <-> server with My

Post by AndyP » Wed May 24, 2017 2:21 pm

You may find this post interesting?
http://forums.livecode.com/viewtopic.ph ... nc#p145623
Andy Piddock

http://2108.co.uk/tinyide/ - TinyIDE gives you more space to develop your ideas

http://2108.co.uk/script-editor-themer/ Script Editor Themer - Your code has never looked so good

My software never has bugs. It just develops random features

Post Reply

Return to “Talking LiveCode”