Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Question: Anyway to open encrypted DB with DB Browser SQLite (SQLCipher)? #43

Open
almas opened this issue Jun 22, 2021 · 4 comments
Open

Comments

@almas
Copy link

almas commented Jun 22, 2021

Is there anyway to open SQLeet encrypted DB with "DB Browser SQLite (SQLCipher)" (https://sqlitebrowser.org/) directly?

@m4heshd
Copy link

m4heshd commented Jul 18, 2021

I'm pretty sure this question doesn't belong here and there's already an issue (sqlitebrowser/sqlitebrowser#1646) being tracked there regarding this.

@utelle
Copy link
Contributor

utelle commented Jul 18, 2021

Currently DB Browser for SQLite supports only SQLCipher encryption. The DB Browser issue mentioned by @m4heshd is a long-standing one - no idea if and when additional encryption options will be added.

If you are looking for a database management tool with which you can administrate sqleet encrypted databases you may consider to use SQLiteStudio.

@Nailik
Copy link

Nailik commented Jun 14, 2022

Doesn't work for me.
When i create a database and execute PRAGMA key='swordfish'; or when i use the c function and then try to open it in SQLiteStudio (3.3.3)
with WxSQLite3 and Cipher sqleet and the correct Password it just shows me that it couldn't add the database.

@utelle
Copy link
Contributor

utelle commented Jun 14, 2022

When i create a database and execute PRAGMA key='swordfish'; or when i use the c function and then try to open it in SQLiteStudio (3.3.3) with WxSQLite3 and Cipher sqleet and the correct Password it just shows me that it couldn't add the database.

SQLiteStudio offers to enter optional cipher configuration parameters on adding a database. Try to add the following command as the cipher configuration:

PRAGMA legacy=1;

That should do the trick.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants