encode

Package encode adds encode(data, format) and decode(text, format) scalar functions covering the common binary-to-text codecs SQLite lacks (only hex/quote are built in):

SELECT encode('hello', 'base64');   -- 'aGVsbG8='
SELECT decode('aGVsbG8=', 'base64'); -- x'68656c6c6f' (the blob "hello")

Supported formats: base64, base64url, base32, base32hex, base16 / hex, ascii85 / base85, and url (percent-encoding). This is the codec half of the sqlean crypto surface; the digest half is covered by ext/hash.

Full API: pkg.go.dev/gosqlite.org/ext/encode