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!
