Eric have been working with the new SQL API for Adobe AIR which is available as of Flex 3 beta.
The new SQL capabilities provide numerous possibilities when developing online / offline desktop applications in Adobe AIR which require data to be persisted locally when not connected.
The SQLConnection and SQLStatement classes provide everything you need for working with a SQLite database. The SQLEvent and SQLResult classes provide an API into asynchronous statement executions from which query result and faults can be handled.
To view full article and source code go here.
Brgds,
CP
October 25th, 2007 at 5:56 pm
and how about flash cs3 (AS3) and AIR operating SQL stuff? i cant find it anyway, only flex3 flex 3 flex3 and i dont want flex
October 1st, 2008 at 2:14 am
I have developed a new framework which exemplifies some of the various advocated best practices for working with Adobe AIR. This framework has no dependencies on the Flex framework. To learn more visit:
http://www.ericfeminella.com/blog/2008/09/29/air-sql-framework/