how can i use rediSQL to save a picture to redis

[mengpengfei]

i am very exited for your work，and i have read all the document of rediSQL。
but i have three questions。
how can i use rediSQL to save a picture to redis?
do the full text search of rediSQL support chinese?
what is the Tokenizer of the full text search of rediSQL？
please help me

[siscia]

Hello!

Thanks for being so interested in the project, unfortunately this week I am out of office so I won't be able to help much.

RediSQL is based on SQLite!

For pictures. While SQLite supports binary blobs, this is not true for the Redis protocol mechanism. Your safest choice is to serialised the image as base64 and save it as a string. It is not perfect but will work up to a very reasonable number of queries.

For Chinese. I don't know! Both fts3 and fts5 are supported.

I will suggest to look into the official SQLite documentation.

In particular this link here: https://www.sqlite.org/fts5.html

I also look into this link that unfortunately does not seems promising:
https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg112010.html

Cheers

[mengpengfei]

thank you very much
i have some other questions,can you help me?
#83 (comment)

[mengpengfei]

when is the cache query results expired？

[siscia]

Hi there,

still working through a backlog from vacation! Sorry for late reply.

when is the cache query results expired？

What you mean? What cache?

[mengpengfei]

RediSQL can store results of queries into a Redis Streams.
do the results of queries in redis have expire time?

[siscia]

No, it just push them into a redis stream.

Then how you use the stream is up to you.

You can keep it there, you can delete them after you read it.

RediSQL just push them!

Does this model works for you?