Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Open a password protected sqlite database

Tags:

sqlite

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.

like image 741
Boardy Avatar asked Apr 21 '12 23:04

Boardy


People also ask

How do I open a SQLite database file?

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.

Can I put password on SQLite database?

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.

How do I view the contents of a SQLite file?

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.


2 Answers

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 :-)

like image 74
andyhasit Avatar answered Oct 03 '22 07:10

andyhasit


You can open and create a password protected sqlite database with SQLiteStudio:

see open image

see create image

like image 22
Anas Avatar answered Oct 03 '22 09:10

Anas