Warm tip: This article is reproduced from serverfault.com, please click
RediSql (for redis): Get column names as well as data type?
发布于 2020-12-01 09:20:27
I am using the excellent RediSql, a module for Redis, to get a powerful caching solution.
When sending a command to Redis, that interacts with the SqLite db in the background, like this:
REDISQL.EXEC db "SELECT * FROM jobcache"
I get a result like this:
I get a type for the integer column, but not for the string, and no column names are provided.
Is there a way to get column name and defined data type always? I would need this, as I need to convert the results back to a more standard sql result format.
Questioner
Ted
Viewed
0
Siscia, you also mentioned that v 2 of RediSql might give the option to get column names back, right? =)
Update: Siscia has resolved this issue and in newer versions, column names are returned to make parsing, and life in general, easier. Good stuff!