Adobe AIR SQLite ORM

by Alexis Hope, 21 Jan 2011

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).

Wanting a better approaching to persistent data in AIR I started writing my own DataObject to handle saving and retrieving data. While writing it I thought surly someone had implemented something like this, and sure enough they have.

Mark Moloney has written FlexORM which creates SQLite tables via meta data left in the application

There is a great run down here

And there is also a ColdFusion 9 and AIR ORM which I haven’t played with, it also supports syncing local DB’s with servers! Very nice I thought.