[guardian-dev] Storing blobs over 1MB in SQLite?
Hans-Christoph Steiner
hans at guardianproject.info
Tue Feb 23 12:46:46 EST 2016
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
--
PGP fingerprint: EE66 20C7 136B 0D2C 456C 0A4D E9E2 8DEA 00AA 5556
https://pgp.mit.edu/pks/lookup?op=vindex&search=0xE9E28DEA00AA5556
More information about the guardian-dev
mailing list