One of the key elements we will need to learn about, as developers, is the proper use of databases. Databases are used to store user information, settings, etc.
Corona SDK allows us to interact with two very different database frameworks, JSON and SQLite. The Corona team has put together a great article/tutorial about this, be sure to check it out:
http://blog.anscamobile.com/2012/04/tutorial-database-access-in-corona/
Out of curiosity, what are some differences, if any, between MySQL and SQLite?
Basically SQLite is a “lite” version of an SQL database. It’s like a mini database packaged up in a single local file. Mobile apps use this approach a lot for storing local data. The other option after that is to have the application take the information in that SQLite DB and send it to the cloud for backup. For instance, let’s say we enable bookmarks in our books, we would provide the user with an option to backup their settings and progress to the cloud (like SteamCloud), then they could restore it if they switch to a new device or re-install the app.