[guardian-dev] Storing blobs over 1MB in SQLite?

Dominik Schuermann dominik at dominikschuermann.de
Wed Feb 24 15:23:45 EST 2016


Hey,

Thanks for detailed explanations of IOCipher internals. I appreciate that!

- Dominik

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:
>>> https://github.com/open-keychain/open-keychain/issues/1714
>>>
>>> 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:
>> https://github.com/guardianproject/libsqlfs
>> that was originally built for Palm OS.
>>
>> IOCipher = SQLCipher + Libsqlfs + a java.io.File-style API.
>>
>> +n
> 
> 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.
> 
> .hc
> 
> 

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mayfirst.org/pipermail/guardian-dev/attachments/20160224/7edff0f5/attachment.sig>


More information about the guardian-dev mailing list