litecli
litecli copied to clipboard
writefile function with fileio
The official sqlite CLI is compiled with the fileio extension, allowing functions like writefile
to be used, e.g.:
SELECT writefile('object0.gz', MyBlob) FROM MyTable WHERE id = 1
Unfortunately, litecli appears to be missing this extension: When I run the above query, I get the following error: no such function: writefile
.