That's reassuring to know that I won't have to worry about limits there. The local db is just a copy of the remote - but if the remote connection is down, the user can use the local copy until connection is reastablished.
Do you know if a user can view the DB outside of the AIR application? Like, can they find mydb.db and open up the file to see the data? Thanks. --- In [email protected], Maciek Sakrejda <[EMAIL PROTECTED]> wrote: > > SQLite scales to a couple of terabytes, so you shouldn't be hitting > limits there, but I'm not sure how you plan to set up the rest of the > architecture (that is, if the local db is not just a copy of the remote, > what's in it?). Also, I'm not sure how well AIR deals with massive > SQLite databases (that is, even if SQLite itself has no issues, AIR > might not like that much data for whatever silly reason--you should > probably try this out with dummy data before deciding on architecture). > > -- > Maciek Sakrejda > Truviso, Inc. > http://www.truviso.com > > -----Original Message----- > From: LazerWonder <[EMAIL PROTECTED]> > Reply-To: [email protected] > To: [email protected] > Subject: [flexcoders] SQLite and AIR > Date: Tue, 17 Jun 2008 16:40:52 -0000 > > Hi everyone, > > I know this group is about flex development, but I have a question > abuot AIR and SQLite and I don't know which group to post this in (I > can't seem to find another yahoo group specifically for AIR. So, I > apologize if there is one and I'm too blind to see it.) > > Anyways, I need to convert a current Flex-app into an AIR app > that's "occasionally online" capable. That is, when the AIR app > knows that there's connectivity, it would work with the remote > database. However, if connectivity is lost, then the app would > seamlessly switch over to "offline" mode and use the local DB, and > when the Internet is restored, the local DB would sync with the > remote DB. > > I hope that's clear. Now, my question is: How would I go about > implementing this? I know that AIR has an implementation of SQLite. > How "lite" is lite? The remote DB is just under 1G and will only > grow over the years. Will SQLite be able to handle? Will AS3 be > able to handle that amount of data? The alternate solution is to > create a small client-db-server architecture right on the user's > machine. This would take up a lot more resources, I believe, but it > would be easier to implement since it would be a matter of switching > from "remote" server to "local" server. > > If anyone has any ideas, please let me know. Thank you! >
