I just have a question for you experts out there! I have an idea for an app that I need a user to be able to store data, probably a paragraph of data that the user could input (paragraph of 50 words or less)? I’m wondering how you would store the data? would you use mysql? just a file? just curious how others would approach this?
Thanks for your help!
Brandon [import]uid: 18460 topic_id: 27611 reply_id: 327611[/import]
Do you need to access the data off of the device or is it data that only the app will use? in other words is there value in saving it online somewhere (other than backups)
Do you need to search through the data to find things or will you be happy presenting a list of paragraphs and letting the user edit/view them individually?
Let’s talk about the first question. MySQL is an internet server based database. Corona SDK comes with SQLite as it’s database to use. They are different beasts. If you don’t need your files on some Internet server then you won’t need MySQL.
Now to the second topic. Now that we have LFS (Lua File System), a simple note app like this could be done with a series of flat files stored in the system.DocumentsDirectory using simple file open/read/write/close operations and would have much less overhead than having to include the SQLite engine. A simple TableView based app could be easily built around simple files to do what you wont.
SQLite, brings more overhead to your app (both in size, memory consumption, and programming overhead), but it has the feature of being able to return your data in various orders and being able to only return data that matches some search criteria. [import]uid: 19626 topic_id: 27611 reply_id: 112109[/import]
Thank-you for your reply!
To answer you questions I do not need to store or access the data online anywhere. The data will only be stored on the device. I appreciate your comments and using a file system like the LFS would be adequate for this application. I believe that is the direction that I will take in building this app!
I wanted to see how other would approach this, again thanks for your input!
Brandon [import]uid: 18460 topic_id: 27611 reply_id: 112163[/import]