search

davidmartos96 / sqflite_sqlcipher

SQLite flutter plugin
BSD 2-Clause "Simplified" License
102 stars 46 forks source link

page size? #9

Closed ramsestom closed 4 years ago

ramsestom commented 4 years ago

what is the default page size used by the cypher? I tried to open one of my encrypted database created from a flutter app using this lib (so as the example_pass_1234.db from the example folder) with DB browser for SQLite but couldn't find the correct page size (tested with a value of 4096, 2048, 1024, 512, 256, 128 but none of these worked)

davidmartos96 commented 4 years ago

That database is created with SqlCipher 4 and its default pass parameters. From my understanding you need to have sqlite browser compiled with version 4 of SqlCipher in order to open it. I can open that sample db fine with my sqlite browser.

davidmartos96 commented 4 years ago

@ramsestom These are the encryption settings for that sample asset database with password "1234" image If your db was created within the app you should be able to open it with the defaults.

ramsestom commented 4 years ago

Thanks. updated my version of DB browser for SQLite to the latest and it worked (don't know why the previous version, from just 4 to 6 months ago, failed to open the database with the correct parametters...)