Awesome
sqlite3-base64
Add base-64 encoding & decoding functions to SQLite3:
BASE64
BLOBFROMBASE64
LICENSE: UNLICENSE (public domain) ref: http://unlicense.org/
External dependencies
cencode.h
,cencode.c
,cdecode.h
,cdecode.c
from https://github.com/gorb314/libb64 or a fork such as https://github.com/brodybits/libb64-core (public domain)sqlite3.h
NOTE: cencode.h
and cdecode.h
must be in the build path.
Sample usage
After opening sqlite3 database:
sqlite3_base64_init(db);
Then the following SQL:
SELECT BASE64(X'010203')
returns the following value ending with a newline (\n
):
AQID
And the following SQL:
SELECT HEX(BLOBFROMBASE64('AQID'))
returns the following value: 010203