I have been looking all over in this forum and other places online to find a good method of using an Encrypted SQLite Database with ExeOutput for PHP…
I have not been able to come up with a good solution. Does anyone have a good working solution that they can help me with.
I was playing around with using something like this example:
Where I would encrypt the decrypt the database to a temp folder when my app starts up then rewrite and update the encrypted data as any changes were made to the temp database, but this would open a security hole as once someone found out where the temp database was, they could modify it before it was written back to the encrypted version.
What about decrypting the Database to Memory/Ram then writing encrypted changes as needed. Again a Memory Dump may compromise the data.
I have seen a few projects and commercial plugins that look like they may work like these:
…but no sample code to test or look at, and no way of knowing if they would even work with exe php, as they mostly require custom builds of the SQLite engine. This is the last stage of my development with exe output for php then my app is done. Any help with this from anyone would really help!