I was interested to read about database access in Corona with SQLite:
http://www.coronalabs.com/blog/2012/04/03/tutorial-database-access-in-corona/
What are some uses that a developer would use a database for in an app?
I’m interested in getting some database related development experience and am trying to think of a project to attempt with Corona. Let me know if anyone has any ideas! Thanks 
[import]uid: 105707 topic_id: 35158 reply_id: 335158[/import]
In general databases are great when you have many records of data but are only interested in a few at a time. In an adventure game, the database could hold a list of clues the player has picked up, or their inventory items (though both of those could be done with tables and saving the table out to a regular file).
I’ve used it to store information where I’m adding new information as I’m going along and need to delete information when I’m done with that. For instance in a multi-player guessing game, I kept track of the player’s previous guesses. They could have multiple games with multiple guesses. Since I only wanted the guesses for this game, using a database let me fetch just the records I wanted and if a game was deleted, it was easy to remove the records for that game only with a single database command.
If your data is a small amount, a table has less overhead to setup and use. If you have a lot of data and as I said are working with small amounts at a time, the database becomes a better tool for you. [import]uid: 199310 topic_id: 35158 reply_id: 139815[/import]
In general databases are great when you have many records of data but are only interested in a few at a time. In an adventure game, the database could hold a list of clues the player has picked up, or their inventory items (though both of those could be done with tables and saving the table out to a regular file).
I’ve used it to store information where I’m adding new information as I’m going along and need to delete information when I’m done with that. For instance in a multi-player guessing game, I kept track of the player’s previous guesses. They could have multiple games with multiple guesses. Since I only wanted the guesses for this game, using a database let me fetch just the records I wanted and if a game was deleted, it was easy to remove the records for that game only with a single database command.
If your data is a small amount, a table has less overhead to setup and use. If you have a lot of data and as I said are working with small amounts at a time, the database becomes a better tool for you. [import]uid: 199310 topic_id: 35158 reply_id: 139815[/import]