Archive | SQLite

Using the SQLite Database Access API in AIR… Part 2: Using the DAO Pattern

The first version of our contact management application introduced us to the database access API in AIR. However, the lack of “application partitioning” or “separation of concerns” in that first implementation represented a poor architecture with no potential for reusability. In this second version, we use the Data Access Object pattern to improve the overall […]

7 commentsContinue Reading

Using the SQLite Database Access API in AIR… Part 1

In my MAX session called “Liberate your Data with AIR”, I presented different approaches to access local data using the SQLite database access API in AIR. The list of approaches included: “SQL in View” Data Access Object (DAO) pattern Using an Object Relational Mapping (ORM) framework I demonstrated a version of inSync (a simple contact […]

8 commentsContinue Reading

InSync: Automatic Offline Data Synchronization in AIR using LCDS 2.6

LCDS 2.6 allows you to build AIR applications with automatic offline data synchronization. This feature leverages the SQLite relational database system embedded in the AIR runtime, but the advantage is that the data synchronization process is entirely automatic: you don’t have to write SQL statements or synchronization logic to keep your local database in sync […]

77 commentsContinue Reading

SQLite Admin for AIR 1.0

Here is a new version of my AIR-based SQLite Admin application updated for AIR 1.0. You can use this application to examine the structure of a database, create a new database or open an existing one, execute any type of SQL statement, etc. An interesting aspect of this version is that the application itself uses […]

226 commentsContinue Reading

Salesbuilder for AIR 1.0

Now that Flex 3 and AIR 1.0 are generally available, it’s time to upgrade some of the sample applications I have been building during the beta program. So, here is Salesbuilder for AIR 1.0. Salesbuilder is a Sales Force Automation application written in Flex and deployed on the AIR runtime. It demonstrates local persistence using […]

62 commentsContinue Reading

css.php