CODEWITHSUNDEEP
databaseairembedded-databasekey-value-storedocument-oriented-db
Parris
Parris

Reputation: 18408

Document Oriented DB for AIR?

Today I just learned that Adobe Air has a local SQL database, which is great; however, we had been creating XML and JSON files to handle mostly everything. Rather than re-architect our application to gain a few new features, it would seem useful to simply index our existing data files, using an embedded document-oriented DB.

So the question is: what’s the easiest way to get an embedded documented-oriented DB running in the Adobe Air runtime?

Upvotes: 1

Views: 154

Answers (2)

a friend
a friend

Reputation: 31

guess what there is finally a document oriented database for adobe air through native extensions

Upvotes: 3

fish2000
fish2000

Reputation: 4435

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.

Upvotes: 1

Related Questions