« Antennae 1.2.0 Released | Main | Priorities »

User experience considerations with SQLite operations

An article I wrote for the Adobe Developer Connection entitled "User experience considerations with SQLite operations" has been published. Its focus is on issues Allurent uncovered while working with a SQLite database on the Allurent Desktop Connection application for Anthropologie that was demoed at Adobe MAX 2007 in Chicago.

Tags: adc air article flex

Comments

What are your thoughts about two different connections to the same database, one sync and one async? Would this not be recommended?

Mark:

Having a sync and async, in my opinion doesn't get you that much. The primary issue is that reads and writes can't be happening simultaneously so if reads are on the async, before trying to do a sync write you need to make sure that no async will happen. If you are doing reads on both, I find having to deal with two different programming models to be a distraction.