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 with your central database.
I have been getting a number of questions related to this feature, so I decided to build a sample application that demonstrates how it works.
Read more
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 a database (sqladmincache.db) to keep track of the databases you opened and the statements you executed. This is useful if you want to quickly re-open a recently accessed database, or re-execute a recently executed statement.
The UI is still simple, but uses some new AIR and Flex 3 features such as the AdvancedDataGrid and Native Windows.
Click here to download the source code.
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 the embedded SQLite database, data synchronization, native drag-and-drop, and other features such as direct chart manipulation.
Additional Resources:
- Click here to install the application.
- Click here to download the source code.
- Follow this script for a guide tour of the application.
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 version). I also introduced a simple Data Access Object (DAO) abstraction (see the BaseDAO.as class) to make the DAOs a lot easier to write, read, and maintain. This is a nice improvement compared to the very verbose DAOs used in the previous version. I might move to the annotation-based ORM approach introduced here in a future version. Finally, the “lazy loading” strategy has been improved as well and does a better job at retrieving data as needed by the application.
Salesbuilder is a Sales Force Automation application written in Flex and deployed on the AIR runtime. It demonstrates local persistence using the embedded SQLite database, data synchronization, native drag-and-drop, and other features such as direct chart manipulation.
The links:
- Click here to install the application.
- Click here to download the source code.
- Follow this script for a guide tour of the application.
Offline Synchronization using AIR and LiveCycle Data Services
As part of my MAX talks in Chicago and Barcelona, I used a simple Contact Manager application to demonstrate offline synchonization using AIR and LiveCycle Data Services (LCDS). Many people have asked me to share the code, so here it is… This is actually an update of an application I posted a few months ago (but that didn’t include the offline synchronization part at the time).
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 this new version is that the application itself uses a database (sqladmincache.db) to keep track of the databases you opened and the statements you executed. This is useful if you want to quickly re-open a recently accessed database, or re-execute a recently executed statement.
This new version uses synchronous database operations (AIR beta 1 only supported asynchronous database access), and uses the schema API (also new in beta 2) to show you the list of tables and columns available in your database.
The UI is still simple, but uses some new AIR and Flex 3 features such as the AdvancedDataGrid and Native Windows.
Click here to install the application.
Click here to download the source code.
Salesbuilder for Flex 3 / AIR Beta 2 (AIR file + source code)
I migrated the Salesbuilder application for Flex 3 / AIR beta 2.
Click here to install the application.
Click here to download the source code.
Follow this script for a guide tour of the application.
