Zeilk Creative

  • Home
  • Apps
  • Blog
  • Portfolio

April 5, 2012 by Mike 2 Comments

Incorporating databases into our iOS apps

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/

Filed Under: Blog, News Tagged With: database, development, iOS, iPad, iPhone, JSON, SQLite

Comments

  1. Lucas says

    April 5, 2012 at 2:39 pm

    Out of curiosity, what are some differences, if any, between MySQL and SQLite?

    Log in to Reply
    • Mike says

      April 5, 2012 at 3:45 pm

      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.

      Log in to Reply

Leave a Reply Cancel reply

You must be logged in to post a comment.

Search for a Product or Article

COPYRIGHT © - Zeilk Creative