Re: [flexcoders] Flex 3: AIR Local Database

2009-11-25 Thread Tim Romano
The answer to your question about large scale is yes, AIR + SQLite can handle large datasets but with some caveats. I have a SQLite database that is several hundred megabytes. The main tables contain 4 million rows, 275000 rows, and 3500 rows. Queries that join these tables, when the query

[flexcoders] Flex 3: AIR Local Database

2009-10-22 Thread jwc_wensan
In all the articles I have read and some examples, it only talks about using SQLite as the database on the users' PC/Mac. Is that the only database that can be used locally? Can that database handle a large-scale commercial AIR app with tens of thousands of records? Also, since the AIR app

Re: [flexcoders] Flex 3: AIR Local Database

2009-10-22 Thread Jake Churchill
I've had many thousand records before and SQLite performed just fine. The only limitation I found was with datatypes which is easily overcome in most cases. I can't comment about the rest. On Thu, Oct 22, 2009 at 5:28 PM, jwc_wensan jwcaldw...@zingit.com wrote: In all the articles I have

Re: [flexcoders] Flex 3: AIR Local Database

2009-10-22 Thread Sam Lai
2009/10/23 jwc_wensan jwcaldw...@zingit.com: In all the articles I have read and some examples, it only talks about using SQLite as the database on the users' PC/Mac.  Is that the only database that can be used locally? Because AIR has support for sockets, there are ongoing projects to give

RE: [flexcoders] Flex 3: AIR Local Database

2009-10-22 Thread Jack @ WenSan
To: flexcoders@yahoogroups.com Subject: Re: [flexcoders] Flex 3: AIR Local Database 2009/10/23 jwc_wensan jwcaldw...@zingit.com mailto:jwcaldwell%40zingit.com : In all the articles I have read and some examples, it only talks about using SQLite as the database on the users' PC/Mac. Is that the only