Opening Sqlite DB encrypted using SQLite Encryption Extension with DB Browser with SqlCipher

Question

I have a database I encrypted using SQLite Encryption Extension being used with MobileServiceSQLiteStore.

Is there anyway to use DB Browser with SqlCipher to view the database. I have the key that was used to decrypt the database.

Stephen Lombardo · Accepted Answer · 2022-12-22 13:10:15Z

0

No, SQLCipher is not compatible with the SQLite Encryption Extension. You may be able to use a command line shell compiled with SQLite Encryption Extension support to open the database.

answered Dec 22, 2022 at 13:10

Stephen Lombardo

1,5238 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

plato522 Over a year ago

Yeah seems to match what I am finding. It looks like SqlCipher just encrypts the pages while SEE encrypts the while file.

Stephen Lombardo Over a year ago

They actually work in a similar way. The whole file is encrypted with both systems. Both encrypt on a per-page level, because SQLite databases are structured that way. However, the key derivation and encryption algorithms used differ.

Collectives™ on Stack Overflow

Opening Sqlite DB encrypted using SQLite Encryption Extension with DB Browser with SqlCipher

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related