dbcli / litecli

CLI for SQLite Databases with auto-completion and syntax highlighting
https://litecli.com
BSD 3-Clause "New" or "Revised" License
2.09k stars 68 forks source link

writefile function with fileio #119

Open roblabla opened 2 years ago

roblabla commented 2 years ago

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.