> 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 flexcoders@yahoogroups.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 flexcoders@yahoogroups.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
> >
> > -----Original Message-----
> > From: LazerWonder <jacq98@>
> > Reply-To: flexcoders@yahoogroups.com
> > To: flexcoders@yahoogroups.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!
> >
>
