I’m building a quiz game in Corona. I have made the sqlite database beforehand and it will be packaged along with the apk file. This quiz game is intended for Android platform. From your experience which directory would you recommend for accessing the database: system.ResourceDirectory OR system.DocumentsDirectory? The reason i’m asking this is that on this page at the bottom it is mentioned that Android does not have a system.ResourceDirectory: https://docs.coronalabs.com/guide/data/readWriteFiles/index.html
So what i tried is in my main.lua, i wrote code to copy the sqlite db from system.ResourceDirectory to System.Documents directory. I am able to access the db fine on the simulator but on an android device i get a “table table_name does not exist” error. So i change code and then try to access the database from the system.ResourceDirectory and now i’m able to access the database and its contents both on the simulator and the android device. So i’m a little confused about which directory i should be using for working with databases?
I thank you for taking out the time and your reply in advance!