Exporting working Database

[maggi1417]

I'm trying to include a Database Editor for my players. My goal is that players (or myself) can make edits to the Database within the game and later choose this edited version of the database as the default database the next time they start the game. I also want my players to be able to share their edited database files with each other.

So what I'm looking for is a way to export the working database file and a way to import that file back into the game a the embedded database.

 

[echo17]

SimpleSQL actually works from a persistent data path outside of your project, so it is not embedded. The file in your project is a template that SimpleSQL copies to the working directory. This allows you to make changes to the database and they will persistent until the next time the game is run. Please see these FAQs for more information:

link
link

If you need to select among several different databases in your persistent data path (other than the one you are pointing to in your project), please see this FAQ:

link

The file in the persistent data path is just a normal sqlite file, so at that point you can do whatever you want with it as far as sharing. Sharing is outside of the scope of SimpleSQL, so you will need to find some way to get the files to your other players, like email, Dropbox, a custom server script, or other file sharing means.

[maggi1417]

Thank you for your reply. I think I get it so far, but that's not the problem. I already played around a bit and found out that changes I made in-game to the database where committed to the copy in the working directory, not to the original one (which is the way it's meant to be, right?). So far, so good. However, I kinda feel bad to make my players dig around in their AppData Folder for that file. Is there a way to store this working copy in another, more accessible directory?

[echo17]

Please see this FAQ:

link