Quick update and interesting note. I've been blogging about AIR and SQLite databases, and recently I've had to put together an analytics tracking library for AIR (currently Google Analytics only supports Flex apps, it needs the DOM to function).
Interesting quirk about SQLite table PRIMARY KEY's. I've been using ID as my table KEY name, a habbit adobted from MySQL. And in recent SQLite development I've been using
OK leading on from the previous post, here's a solution for the INSERT or UPDATE if row exists which seems like a very common question in forums.