I am trying SQLite Studio to try and open a simple encrypted database. As an example I created a simple table with a few rows of data and created the encrypted SQLite database and saved the file as PasswordEncrypted.sqlite. The password for this test is: MyPassword, and I attempted to open it with aes-128-ofb, and below is a screen grab.
The reason I am asking is that there are many versions of encryption, types, iterations, and page sizes available, and I can’t seem to find anything on the Xojo website. The good news is that I can open the encrypted database with Xojo, but I am unable to open the database with any other editor, I have tried 5 so far.
I don’t believe that Xojo attempted to make a proprietary encryption type, so I am trying to figure out:
- How to open a Xojo encrypted SQLite database in a third party SQLite editor
- or create Xojo programming to create an encrypted database that is compatible with other programs, so that Xojo is not perceived to have proprietary encryption. Proprietary encryption is not welcomed by businesses.
The attached screen grab attempted AES-128-OFB, and no joy.
Thanks for your comment 