local database for adobe air for JSON on Android

Question

I am building an app that will have local database. I plan to implement local database that will be used for offline work, and when app connects with internet it should sync with the server data.

What is currently the best way to do it?

I prefer JSON type databases over SQL databases so I would like to use MongoDB for web, but then for local database there is only one solution that is not yet available for android. https://github.com/thejustinwalsh/airejdb

How do you do it? Do you save key:value inside of SQLite database, do you use plain text saved somewhere or do you have some other implementation of mongoDB for local Adobe Air?

Thankx

If you are targeting mongodb, why not to have your local db in [JSON](http://help.adobe.com/en_US/FlashPlatform/reference/actionscript/3/JSON.html)? — Salvador Dali, Nov 10 '13 at 10:28
are you suggesting to just save plainText in local app directory? — ThanksBro, Nov 10 '13 at 10:41
From what I have read there is a JSON support, so in my opinion it will not be a plainText — Salvador Dali, Nov 10 '13 at 11:03

score 1 · Accepted Answer · answered Nov 10 '13 at 16:13

Depends on project, if I have sensitive data then putting it in encrypted SQLite might be necessary, also if JSON data is not so small it might be good idea to just compress it as a string and put as a byteArray->BLOB in SQLite, can save lot of space which in case of mobile project might be useful, otherwise you can do same with some text file without using SQLite at all, just save and load data, IMHO impelementing something like MongoDB is much more harder work then given examples.

local database for adobe air for JSON on Android

1 Answers1