The AIR runtime includes the SQLite database engine, so if you want to use a database as part of your application that is the easiest way to do so. The documentation about the built-in database functionality is here:
In theory an AIR application can also communicate with any other type of database, assuming you find or write the code to perform that communication. For example, there is an open-source ActionScript library to directly access MySQL. However, as you point out, to use any server-based database you would need to have an instance of the database server running where the computer can access it.
Aside from SQLite, the only other file-based database system that I'm familiar with is Microsoft Access. (I'm sure there are others, but I just don't know their names.) I don't know of any existing projects to work with Access database files from AIR, but again I could have just missed something.
Thanks to your reply.
I have another question...
With sqllite can the DB be local with the air application or it must be placed on a server?
Thanks a lot
SQLite is a file-based database system. Each database is a single file on the filesystem. You tell the runtime where the database file is on the filesystem, and the runtime handles all the work that would normally be done by a database server (running sql queries, translating the data file into db results, etc.) So the data file must be somewhere where the application can access it, and the rest of what would normally be done by a db server is handled by AIR.
ok thanks for that explanation!I now understand how sqllite runs with AIR
did you ever programed any game runing in AIR?