I have created a password protected sqlite database. I want to be able to view the database so that I can check that things are being inserted correctly during the development of my project. I have downloaded the sqlite database browser but this doesn't seem to let you open an encrypted database.
Is there a way that I can open the database file.
Thanks for any help you can provide.
Open a command prompt (cmd.exe) and 'cd' to the folder location of the SQL_SAFI. sqlite database file. run the command 'sqlite3' This should open the SQLite shell and present a screen similar to that below.
The base SQLite engine doesn't have any password/encryption options. You have to either use the paid SEE option for encryption, or some third party solution.
Click the File menu near the top right corner of the SQLite Database Browser window that opens and select Open Database. Browse to the location of the SQLite file you wish to read and click the file. Click the "Open" button. The SQLite file contents will display.
The free SQLite2009 Pro browser will let you open SQLite databases which were encrypted with System.Data.SQLite.
When you open the file you get a warning saying that the file is encrypted or not a database, and are then prompted to select an encryption type, select "RSA".
Edit:
You may find SQLite2009 Pro is not as reliable as sqliteadmin (which does not open databases encrypted with System.Data.SQLite). I just found it crashed upon trying to open a database which had a problem with one of the views.
I ended up removing the encryption, and opening it with sqliteadmin, which did not crash but instead put a little red cross over the view which had a problem. What a nice touch :-)
You can open and create a password protected sqlite database with SQLiteStudio:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With