Hi all,
My questions are related to data storage. In general, what’s the best solution to store simple data (1000+ entries)? sql lite, or simply put it with json into a text file? Any experiences regarding performance?
SQLLite… are joins available?
Thanks a lot for your inputs! [import]uid: 90610 topic_id: 23348 reply_id: 323348[/import]
For that many entries i would go with SQLite. Its easy to learn and i find it great for storing all sorts of information.
I don’t know how it compares to a JSON text file with 1000 entries though as i’ve never tried. But i would presume its faster and easier to get certain bits of information from a SQLite database than the text file.
By joins do you mean appending information onto another table or combining tables? If so, then yes they are available. You can do pretty much anything with SQLite, thats why i find it great for storing information 
[import]uid: 69826 topic_id: 23348 reply_id: 93527[/import]
thanks for your reply!
since i have strong mssql and mysql background, I will probably go for that.
I only need to join some tables, maybe i can even do it without a single join. so I assume the speed is ok, since the db is stored locally… [import]uid: 90610 topic_id: 23348 reply_id: 93528[/import]
if your app download files to documents or cache directory and you dont use “do not back up” attribute your app will be rejected on the app store #coronafail. [import]uid: 7372 topic_id: 23348 reply_id: 93596[/import]