Hi all
I am looking at being able to encrypt/decrypt or password protect a sqlite database. The asset sits in streaming assets and ideally i need this to be protected on builds/releases but accessible to a viewer during development (for quick debugging and referencing).
I have tried a few plugins but they all appear to have to have the database created through the plugin as encrypted (which can then not be decrypted and i would have to build the database from scratch). These options then appear to not allow you to modify the password after it has been created, there for i would need to rebuild the whole database every time the password is needed to change (with is looking to be weekly).
Doing some research there appears to be a databaseconnection.ChangePassword() function in the sqlite .dll but it does not appear to be accessible when trying to use it (or the plugins i have that expose this then throw errors when calling it)
any ideas/help here would be greatly appreciated, currently my only plan i can think is to use the normal database during development and then before building create a new database with one of the plugins i have found and then add modifiers to all the code to determine if its editor/build and act accordingly (efficiently doubling my code for database calls) or purchasing an online solution for the database (again not ideal as then requires online access to use, which i would like to avoid)
Potentially is it possible to encrypt the whole file similar to how you would a string, this could be an additional option
Thanks in advance for any help