I want to store passwords in a database in a Worklight application. What is the difference of JSONStore and SQLite as both can be used to store data?
JSONStore provides encryption for all the data stored inside, just use usePassword before calling initCollection. Make sure the password used to decrypt/access the contents of JSONStore is not hardcoded. Ideally just prompt the user for a password and if they fail to login a couple of times destroy the contents of JSONStore with destroy. SQLite out of the box won't allow you to encrypt all the data stored, JSONStore will.