A–C
D–H
I–Z
Developer services
Project centers
Community resources
- Adobe Cookbooks (share code)
- CSS Advisor (browser bug fixes)
- Exchanges (share components)
- Adobe Labs
- Adobe Open Source
- Forums
- RSS feeds
- Bug base
- User groups
- Adobe Community Professional
- Developer events
Integration
Product documentation
Downloads
Samples
Training and books
- Online training
- Classroom training
- Certification
- Adobe Developer Library
- Adobe Press
- Safari Books Online
Newsletters
Blogs
Archives
ADC program
Additional resources
Daniel Rinehart
Software architect
Allurent
Table of Contents
User experience considerations with SQLite operations
Adobe AIR's SQLite support brings powerful relational database support to the desktop in a standardized cross-platform environment. Manipulating information in a SQLite database is made easy with the rich APIs provided by the AIR runtime.
One of the first steps in using a local database is deciding whether a connection will operate in a synchronous or asynchronous execution mode. An application using a synchronous connection waits for a database operation to complete before continuing, whereas an application using an asynchronous connection is informed when a database operation completes. This article explores what those two execution modes mean, discusses why to choose one over the other, and provides an example of how Allurent Desktop Connection leverages a SQLite database to produce the rich interactive shopping experience demoed at Adobe MAX 2007 in Chicago.
Requirements
In order to make the most of this article, you need the following software and files:
Adobe AIR
Adobe AIR SDK
Adobe Flex Builder 3 (optional)
Sample files:
- Download SQLite_operations.zip (ZIP, 28K)
Prerequisite knowledge
Experience building web applications with Flex and an interest in building apps on Adobe AIR.
About the author
Daniel Rinehart is a software architect at Allurent, where he is helping to build a new generation of innovative online shopping experiences using Flex. He has worked in the field of software development as an engineer and architect for the past eight years. Prior to joining Allurent, Daniel worked at Ruckus Network, Towers Perrin, and BiT Group. While at BiT Group he worked for clients, including Cisco and Dell Financial Services, among others. He can be reached online at http://danielr.neophi.com/.
