SQLite has Encryption Extension that could protect database. Though it's not free so I don't think AIR have/will have this feature (maybe commercial AIR version?)
http://www.hwaci.com/sw/sqlite/prosupport.html#crypto George nathanpdaniel wrote: > > > > 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? > > That's affirmative. They just have to download the tool from > sqlite.org . It's what I used to build/test databases for my AIR > projects in the past. They can also change the file extension to .txt > and open it that way - albeit you'd have to know what to look for when > doing that because it's kind of "jumbly". But for your question - yes > and it's not hard. > > -Nathan D. > > --- In [email protected] <mailto:flexcoders%40yahoogroups.com>, > "LazerWonder" <[EMAIL PROTECTED]> wrote: > > > > 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] > <mailto:flexcoders%40yahoogroups.com>, Maciek Sakrejda <msakrejda@> > > 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 <http://www.truviso.com> > > > > > > -----Original Message----- > > > From: LazerWonder <jacq98@> > > > Reply-To: [email protected] > <mailto:flexcoders%40yahoogroups.com> > > > To: [email protected] <mailto:flexcoders%40yahoogroups.com> > > > 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! > > > > > > >
