If you don't have to preserve any existing client data, then you could simply rip and replace the existing db file. Your Air application could drop the file, back it up or whatever and then replace it with another copy downloaded from a server.
If you need to preserve some of the data then your problem becomes much more daunting. First you need to determine the rules by which an update is to occur. Is it at application start or part of some predefined schedule? What happens if one user leaves their client up for days/weeks/months and another restarts hourly? If you base on application start, how will you insure that you cover both use cases? How will you insure that client A and client B don't have different data? I would suggest adding timestamps to every server synchronized row allowing you to implement some concept of knowing what data might be stale. K From: [email protected] [mailto:[email protected]] On Behalf Of bonny_us Sent: Tuesday, January 13, 2009 7:02 PM To: [email protected] Subject: [flexcoders] Re: AIR and SQLLite Hi Kevin, i want to do synchronize all client sqlite db's from a common back-end db? Thanks, Bonny --- In [email protected] <mailto:flexcoders%40yahoogroups.com> , "Kevin Benz" <kb...@...> wrote: > > What are you asking? > > > > Are you wanting to synchronize all client sqlite db's from a common > back-end db? > > Are you wanting to replicate the client data on the server? > > > > Air doesn't provide any facilities to help with either although both > could be accomplished with a non-trivial development effort. I know > there is some discussion on the web of tools to help although you need > to be aware of the fact that Adobe extended SQLite with support for AS > datatypes (like Date for example) so beware of tools that may not be > aware of your whole schema. > > > > K > > > > From: [email protected] <mailto:flexcoders%40yahoogroups.com> [mailto:[email protected] <mailto:flexcoders%40yahoogroups.com> ] On > Behalf Of bonny_us > Sent: Monday, January 12, 2009 7:57 PM > To: [email protected] <mailto:flexcoders%40yahoogroups.com> > Subject: [flexcoders] AIR and SQLLite > > > > Hi All, > > Any one have idea of SQLLite and AIR Synchronization. I want to create > one POC using SQLLite. If any one have any example regarding this then > please let me know. it will be very helpful to me. > > Thanks, > Bonny >
<<image001.jpg>>
<<image002.jpg>>
