Thanks for providing this great library.
I have v3.20.1 built with GCC using C++ and encrypting my SQLite databases properly. I’ve spent some time reading the docs and analyzing the codebase, so I think I know the answer to my question, but I wanted to at least ask it here for clarity.
I am currently using the PRAGMA method of setting my raw key (with salt) for database encryption. My raw key is stored as a chunk of binary data from an external source, Using this approach, I have to do extra processing to convert it to a string of hex for the PRAGMA statement, which takes up extra time and also creates extra security risks from literal strings/string processing.
sqlite3_key() looked like it provided me a way to send they binary key data directly (and avoid using any sql execs/statements), but after testing and reading, it appears this is not the case.
Question 1: is it possible to pass binary data directly into sqlite3_key()? In my case, an array of char data with the raw/salted key.
Question 2: If #1 is not possible, is it possible to pass a full/raw key (with salt) as a string of hex to sqlite3_key()? Similar to the PRAGMA approach, except the sqlite3_key() call would save me from adding string literals for the PRAGMA/sqlite3_exec call.
Thanks for your time.