I have very limited experience using Adobe AIR but it seems really cool since I'm plenty familiar with jQuery and other web technologies. We have a client interested in creating a desktop application that would rely on the local database feature of AIR. I have some questions though before I begin development.
Here's some other non-DB related questions:
Thanks for all your help!!
note: I'm not expert
yes, AIR uses SQLite (3.6.*.? now one exactly knows as it is undocumented and sqlite_version() native function will throw runtime error to be handled)
it depends for what purpose it will be used and how, yes? e.g.:
(User experience considerations with SQLite operations)
there is an option now to create native installer for platform which could be send off-line. It asks user to overwrite content if application is already installed, etc
please define "interact" with USB? as disk or interface to talk with some device? Air itself cannot talk to low level ports but could start native process (NativeProcess) to some application/tool/process that could act as middle-tier between your application and usb: