Accessing SQLite from AIR

Earlier in this chapter, it was noted that SQLite databases are stored as files on the user’s file system and that there is no practical limit to the number of databases that can be created. AIR does not enforce any particular pattern for using these databases, meaning every application you create could share a single database or each could define its own. All users of any particular application could also share a single database, or each user could have their own. These decisions are left up to you as the developer.

To work with a SQLite database from AIR, you must first open it, then issue commands to create tables, insert or query data, and finally close it. AIR provides an API to work with the SQLite database using patterns already familiar to ActionScript and JavaScript developers.