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!
