I have some cases where sometimes I want to store a vector of floats along with a data item. I usually don't need to match against the column, just store it.

I have some cases where sometimes I want to store a vector of floats along with a data item. I usually don't need to match against the column, just store it. I know I could use BLOB but often I just use JSON for this kind of thing so that I don't have to deal with data types and conversion. It's wasteful and imprecise though due to the string conversion. Is JSONB a good middle ground option for these cases? Edit: Sorry, just saw the comment below by o11c, > Sqlite's JSONB keeps numbers as strings which means the answer to my question is basically "no".