tag:robotlegs.tenderapp.com,2009-10-18:/discussions/robotlegs-2/7969-not-exactly-a-robotlegs-question-database-on-adobe-airRobotlegs: Discussion 2013-12-23T09:23:45Ztag:robotlegs.tenderapp.com,2009-10-18:Comment/299002292013-11-13T10:51:20Z2013-11-13T10:53:36ZNot exactly a robotlegs question :) database on adobe air<div><p>Hello,</p>
<p>Indeed, this is not a robotlegs question:)<br>
It's not even just an AIR problem.<br>
Database synchronization is a really complicated matter.<br>
I suggest you ask your question on stackoverflow [<a href=
"http://stackoverflow.com/">http://stackoverflow.com/</a>]<br>
But, firstly you'd better narrow down your question and describe
your specific use case.</p>
<p>Some of the questions, I think, you'd need to ask yourself:</p>
<ul>
<li>what do you want to synchronize? row-based sync, field-based
sync?</li>
<li>is the online database residing on a central server?<br></li>
<li>is the client db a subset of the central db or is it a 1 to 1
copy?</li>
<li>do you need a db replication mechanism ?</li>
<li>is the sync process one-way ( server to client, or client to
server) or both ways?</li>
<li>how often do you need to synchronize the DBs?</li>
<li>are you using GUIDs, composite keys or a key pool server?</li>
<li>can you afford using a commercial middle-ware for conflict
detection and resolution, kind of a sync server?</li>
<li>is security important?</li>
</ul>
<p>For Air, as an inspiration:<br>
<a href=
"http://flex.sys-con.com/node/834097">http://flex.sys-con.com/node/834097</a></p>
<p><a href=
"http://www.cleartoolkit.com/dokuwiki/doku.php?id=clearwiki:20.cleardatabuilder:07.architecture:data_synchronization">
http://www.cleartoolkit.com/dokuwiki/doku.php?id=clearwiki:20.clear...</a></p>
<p>Ondina</p></div>Ondina D.F.