[guardian-dev] Storing blobs over 1MB in SQLite?
dominik at dominikschuermann.de
Wed Feb 24 15:23:45 EST 2016
Thanks for detailed explanations of IOCipher internals. I appreciate that!
On 02/23/2016 06:46 PM, Hans-Christoph Steiner wrote:
> Nathan of Guardian:
>> On Tue, Feb 23, 2016, at 10:14 AM, Dominik Schuermann wrote:
>>> Is there a way in general to store blobs over 1MB inside Android's
>>> default SQLite? At OpenKeychain we reached that limit, and I don't like
>>> to redesign everything just because of this corner case:
>>> I am open for suggestions :) Maybe you guys have an idea, how is this
>>> done in IOCipher?
>> IOCipher does this automatically. It was the reason we developed it - to
>> securely store large media files for apps like CameraV and Courier. It
>> works well enough that you can stream into it, which we do for recording
>> or playing back video and audio.
>> Hans made the brilliant discovery of Libsqlfs:
>> that was originally built for Palm OS.
>> IOCipher = SQLCipher + Libsqlfs + a java.io.File-style API.
> sqlfs works like many filesystems and stores files in blocks. In
> IOCipher, an 8192 byte block size is used. So SQLite only ever sees
> 8192 byte binary blobs.
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 473 bytes
Desc: OpenPGP digital signature
More information about the guardian-dev