Questions about SQLite and directories

Solar2D General Questions/Discussion
#1

If I have a SQLite3 database “data.db” in system.ResourceDirectory, am I allowed to open it and do SELECT statements on it? The documentation has some very strong words about using files in this area.

Also, I have a Windows 7 machine and running Corona Simulator. Where is it storing the .db file for system.DocumentsDirectory??? I know it exists somewhere, because data is persisting… but I can’t find it. A start menu search on my computer for “data.db” comes up with nothing. Hmm. [import]uid: 70391 topic_id: 13544 reply_id: 313544[/import]

#2

u can access project sandbox from corona simulator menu. [import]uid: 71210 topic_id: 13544 reply_id: 49766[/import]

#3

system.resourceDirectory is your App Bundle and if you change anything, the checksums are not going to add up and you risk having your app not work.

But as long as you’re doing READ ONLY operations, I would think you can read a sql DB in the resource folder. [import]uid: 19626 topic_id: 13544 reply_id: 49775[/import]

#4

to find out where the file is - aka system.DocumentsDirectory

local filePath = system.pathForFile( “data.db”, system.DocumentsDirectory )

print( filePath )
look at the debugger window and it should be printed there.

good luck

LArry [import]uid: 11860 topic_id: 13544 reply_id: 50341[/import]