O’Reilly: Inside RIA

In the last tutorial, I examined some additional techniques for querying an existing database. Today I want to explain how you create a database and create a table inside of that database.. If you are good with SQL and have followed along with this series, this concept will work as expected.

 

In the previous tutorial, I demonstrated how to return all of the rows of a database table and access the results within AIR. Many times you will not want to retrieve all of the rows in a table, so today I will examine some techniques for querying your tables. I will focus on two main areas: Strongly Typing Results and Parameterized Queries.

 

In the previous article, I examined the process for running a simple SELECT query on a pre-populated SQLite database in AIR. In today's example, I will actually execute a simple SELECT query and use the results to populate a data grid. I will also look at how to include a pre-populated database with an AIR application.

In the previous article, I gave an introduction to SQLite and its place inside or AIR. In this tutorial, I will be explaining the code needed to connect to and query a previously existing SQLite database. This will take two articles to accomplish this, so this article will focus on learning the basic classes and methods that you will need to know. The next tutorial will contain a sample application that implements these features.

One of the most powerful features in Adobe AIR is the native integration of SQLite that was introduced in Beta 2. Since Beta 2 it's integration has been improved, and it is now a viable local database capable of storing application data or syncing with a database server. The implementation provided with AIR is powerful and provides two distinctly different ways to access the database. There are nineteen different classes that can be used with this API, and in the next few articles I will dissect the ones that you need to know.