Live data from Hacker News

SQLCipher – Full Database Encryption for SQLite

zetetic.net

21–23 of 23 posts

Re: SQLCipher – Full Database Encryption for SQLite

#21

Earlier quoted context omitted.

We have done some work on a branch in SQLCipher that allows for adaptive key derivation length based on the device it runs on. The iteration length will be computed per device where time is the constraint. We presented our initial findings last year at PasswordsCon 14.

Isn't that the standard? We always time the iterations for a specific time delay on the specific device and use that, and that's what, for example, LastPass (IIRC) does. That still does nothing for the fact that a GPU will be thousands of times faster than a mobile.

>Isn't that the standard?

SQLCipher uses PBKDF2 as a standard mechanism to compute a key, however by default it uses a static iteration length, currently 64,000.

The problem is often that the device spread varies greatly and often a given application will target more than one device. You can watch our presentation covering the details here:

https://www.youtube.com/watch?v=b8TNHZ7fWzg&list=PLdIqs92nsI...

Re: SQLCipher – Full Database Encryption for SQLite

#22
post #6

The SQLite Encryption Extension is another encryption library for SQLite (under a commercial license): http://www.hwaci.com/sw/sqlite/see.html It's created by the authors of SQLite, so purchasing it helps support the public domain SQLite project.

Does it authenticate encrypted data?

CCM mode is an option, and is an authenticated mode. Not a great choice per se, but nothing outright wrong with it either. CCFB and GCM would be preferred alternatives.

Re: SQLCipher – Full Database Encryption for SQLite

#23
post #22
post #6

Earlier quoted context omitted.

Does it authenticate encrypted data?

CCM mode is an option, and is an authenticated mode. Not a great choice per se, but nothing outright wrong with it either. CCFB and GCM would be preferred alternatives.

Thank you, I somehow missed that they list CCM as one of the modes.
Post reply on HN