Document Oriented DB for AIR?

Question

Today I just learned that Adobe Air has a local SQL database, which is great; however, we had been creating xml/json files to handle mostly everything. Rather than re-architect to gain a few new features it would seem useful to simply have some document oriented DB index our files. So the question is: documented oriented DB for air?

Answer 1

Try using the DB as a key/value store. Then, if you need to index a field, add a corresponding field in your key/value table and store a (very denormalized) copy of the data in there.

I think the local DB that Air uses is SQLite -- if so, you can install triggers to keep your denormalized indexed fields synchronized.

I've done the key/value thing before to store serialized JSON trees. Not nearly as good as using CouchDB, but it works.