Opened 10 years ago

Closed 8 years ago

#758 closed enhancement (worksforme)

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

Reported by: arthurmaciel Owned by: Jim Ursetto
Priority: minor Milestone:
Component: extensions Version: 4.7.x
Keywords: sql-de-lite sqlcipher encryption Cc:
Estimated difficulty:

Description

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

Attachments (2)

sqlite3-api.h.patch (121 bytes) - added by arthurmaciel 10 years ago.
sqlite3-api.scm.patch (430 bytes) - added by arthurmaciel 10 years ago.

Download all attachments as: .zip

Change History (4)

Changed 10 years ago by arthurmaciel

Attachment: sqlite3-api.h.patch added

Changed 10 years ago by arthurmaciel

Attachment: sqlite3-api.scm.patch added

comment:1 Changed 10 years ago by Jim Ursetto

Milestone: 4.8.0

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.

comment:2 Changed 8 years ago by Jim Ursetto

Resolution: worksforme
Status: newclosed

Closing due to nonresponse. Suggested workaround should work fine.

Note: See TracTickets for help on using tickets.