writefile function with fileio

[roblabla]

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.

[kracekumar]

@roblabla we added a new sqlean dependency that would help you achieve simlar functionality. Would you happy to try this out? It may not be one to one match, but provides close enough functionality.

Steps to try

1. Pull the latest main branch
2. then run uv run litecli ::memory. Please install uv if you haven't

uv run litecli ::memory
   Built litecli @ file:///Users/kracekumar/code/litecli
Uninstalled 1 package in 0.79ms
Installed 1 package in 1ms
LiteCli: 1.15.1.dev14+g76fb4c5 (SQLite: 3.47.0)
GitHub: https://github.com/dbcli/litecli
::memory> .tables
Time: 0.000s
::memory> create table TEST(ID int);
Query OK
Time: 0.001s
::memory> insert into `TEST` values(1);
Query OK, 1 row affected
Time: 0.000s
::memory> SELECT fileio_append('test.gz', printf('%d',id)) FROM TEST;
+-------------------------------------------+
| fileio_append('test.gz', printf('%d',id)) |
+-------------------------------------------+
| 1                                         |
+-------------------------------------------+
1 row in set
Time: 0.002s
::memory>

3. contents of the file

cat test.gz
1⏎

You can find list of supported sqlean supported functions

[roblabla]

It looks like you need to run with uv run --extra sqlean litecli ::memory for it to work (since sqlean is an optional dep), but then it works pretty well, and should be enough for my use-cases! Thanks.

[kracekumar]

Thanks for the response. Glad it works for you. I will close the issue!

Thank you for the feature request.