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.


In order to make the most of this article, you need the following software and files:

Adobe AIR


Adobe Flex Builder 3 (optional)

Sample files:

~ by mjcprasad2000 on April 3, 2009.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: