Summary

sql-de-lite procedures to key and rekey a sqlcipher-ed db

Metadata

• Id: 6e1ad0ba78b7f4ac97255a50e81ef316a2e25e2f
• Trac id: 758
• Type: enhancement
• Reporter: arthurmaciel
• Owner: zbigniew
• Cc:
• Status: closed
• Component: extensions
• Estimated difficulty:
• Resolution: worksforme
• Priority: minor
• Milestone:
• Version: 4.7.x
• Changetime: 2013-07-19 21:55:40 UTC
• Created: 2011-12-17 19:33:24 UTC
• Keywords: sql-de-lite sqlcipher encryption

Attachments

• 6e1ad0ba78b7f4ac97255a50e81ef316a2e25e2f/attachments/sqlite3-api.scm.patch
• 6e1ad0ba78b7f4ac97255a50e81ef316a2e25e2f/attachments/sqlite3-api.h.patch

Description

Implementation of sqlite3_key and sqlite3_rekey procedures to work with sql-de-lite using an external sqlcipher-ed sqlite3 database.

Changes and comments

[2011-12-17 19:34:48 UTC] arthurmaciel attached sqlite3-api.h.patch (description=#f)

[2011-12-17 19:34:58 UTC] arthurmaciel attached sqlite3-api.scm.patch (description=#f)

[2011-12-17 20:54:02 UTC] zbigniew removed milestone 4.8.0

[2011-12-17 20:54:02 UTC] zbigniew wrote:

sqlcipher is not a standard sqlite extension and this patch will not compile if the extension is not present. Therefore it would need some kind of feature detection or manual override.

I suggest instead you do as the docs for both sqlcipher and sqlite's own SEE recommend: simply use 'PRAGMA key =' and 'PRAGMA rekey ='; in this case it's not necessary to extend the wrapper.

If this solution works for you, please close the ticket.

[2013-07-19 21:55:40 UTC] zbigniew changed status from new to closed

[2013-07-19 21:55:40 UTC] zbigniew set resolution to worksforme

[2013-07-19 21:55:40 UTC] zbigniew wrote:

Closing due to nonresponse. Suggested workaround should work fine.