by Charlie Key
Learning how to work with SQLite, AIR's built-in, self-contained database engine, is a must for any developer wanting to integrate the web with the desktop in an AIR application. In this article, Charlie Key explains the concept of synchronous vs. asynchronous queries, covers different database queries in AIR (Create, Retrieve, Update and Delete), and then takes us through the building of a simple task application, complete with code, to illustrate the use of synchronous SQLite queries.
Download the code for Synchronous SQlite Database Queries in AIR
by Theo E. Rushin, Jr.
When you're developing an application that works on the desktop and the web, part of the challenge is in knowing the status of the user's connection to the internet. With the tools that Adobe built into AIR, you can both keep your users informed of their own network connectivity (building trust) and build more robust applications that react to network changes appropriately. Theo E. Rushin, Jr. explores AIR's network detection capabilities and provides code that you can use in your own applications.
Download the code for To Be or Not To Be... Online, that is
by Leif Wells, Flex Authority Reporter
If you've never heard of the Merapi project, you're missing out on something potentially very useful and important. The Merapi project is a framework developed by Adam Flater and Dave Meeker that enables communication between a Flex AIR application and a Java application. Leif Wells interviews the creators of Merapi, exploring what this framework can do, why you'd want to use it, and much more.
by Johnny Boursiquot
Embedding PDFs into your AIR application isn't difficult at all. Johnny Boursiquot explains how to do it, and possible pitfalls to be aware of before you start coding.
Download the code for Quickly Integrating PDFs into Your AIR Applications
by Giorgio Natili
When you update an AIR application, how do you notify users that a new update is ready? Should you update automatically? AIR gives you the ability to update your AIR gives you the ability to update your application in whole or in part, in modules or plug-ins... The challenge lies in architecting your application so that these updates are easy and painless for your users, and not intrusive. In this article, Giorgio Natili walks you through the means of updating, the problems you might run into, and the many possibilities you should consider.