litecli icon indicating copy to clipboard operation
litecli copied to clipboard

writefile function with fileio

Open roblabla opened this issue 2 years ago • 0 comments

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.

roblabla avatar Sep 19 '21 16:09 roblabla