12-21-2013 12:41 AM
How do I make a database for an app. Can I create it outside somewhere in my computer and then copy it into the assets folder? or is there any standard way?
Solved! Go to Solution.
12-21-2013 04:02 AM
Yes you can make it externally if you wish, two programs I have used are SQLite Browser and sqlitestudio both do the job but sqlitestudio has more functionality and is the one I now use exclusively.
There are many others however, just search for sqlite application in google.
12-22-2013 12:21 AM
Be aware that any database you access from your assets folder is read-only unless you copy it to your app's data directory and open it from there. You cannot write anything to your assets path at runtime in a signed app (it works during development due to relaxed permissions but you are in for a nasty surprise when you deploy it.)
If your database stucture is relatively simple you can just create a zero length file in you data path, open it as a database, and then use DDL commands to define the structure.