Where's the sqlite database stored? And how to make it persistent?

___

I added some code to interact with a sqlite3 database in my game.

I added some code like

get("score") -- returns 0, the default set("score", 1) get("score") -- returns 1

When I re run it, the data is gone.

get("score") -- returns 0

How to make this persistent? I tried creating a db with the same file name in the root directory of my project, but that didn't work.

Also, where is the database of the instance that is run by the Gideros Player stored? I'd like to edit/test some things manually.

I could find any related tutorials either.

___

Found a way to make it persistent (hopefully it works on the device too) from this page.

Still looking for a way to interact with those file locally.

___

May I bump this?

atilim

your database file should be in documents directory (means it should have a filename like "|D|score.db")

___

@atilim, on my computer?

ar2rsawseen

@___ internal reference inside Gideros SDK is always in your case |D|score.db in any device, PC, Mac, phones.

The real path however, where you can find these files physically, outside Gideros SDK are different.

on Windows XP: C:\Documents and Settings\[YOUR USER NAME]\Local Settings\Temp\gideros\[YOUR APP NAME]
on Windows Vista and Windows 7: C:\Users\[YOUR USER NAME]\AppData\Local\Temp\gideros\[YOUR APP NAME]
on Mac OS X: $TMPDIR/gideros/[YOUR APP NAME]

Here's some reading material:
http://www.giderosmobile.com/forum/discussion/136/save-files

___

@ar2rsawseen

Thank you! I was waiting for an answer to this for days!

ar2rsawseen

Sorry I somehow missed this thread

___

See? That's why we need a QA system. It shows Answered/Unanswered questions separately.

talis

I agree about Q/A system. My inbox is in chaos now because of bookmarked conversations:D
I can not imagine other users who is more active than me (

gorkem

@talis if you want, you can opt-out from receiving emails for bookmarks.