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 […]

25 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 […]

227 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 […]

63 commentsContinue Reading

Salesbuilder Beta 3 (AIR file + Flex Source Code)

A number of you asked me for the beta 3 version of Salesbuilder. So here it is. I also took the opportunity to clean up the code, and improve a few things. The application is now using synchronous access to the local SQLite database (as opposed to the asynchronous data access strategy of the previous […]

31 commentsContinue Reading

New AIR SQLite Administration App (with Source Code)

UPDATE: This version is now obsolete. A new version is available here. Here is an updated/rewritten version of my AIR SQLite Admin application. 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 […]

63 commentsContinue Reading

css.php