Redis Want the data in sorted manner based on their scores from sorted set.

ZADD add the data in sorted set with score and some value while fetching the data wanted the data to be sorted based on their scores. Tried with ZSCAN but didn't get desired result

Comment From: oranagra

i think you're looking for https://redis.io/commands/zrange

Comment From: rajneran-quot

i think you're looking for https://redis.io/commands/zrange

zrange gives the data in a given range but I want to get the data based on some regex that should give all the string which follow that regex with sorted score. For Example :

If you observe the result here the string is coming with their scores but that is not in sorted manner.

Comment From: oranagra

that's right, ZRANGE can give you the entire sorted set, but with no filtering. and ZSCAN doesn't do sorting. i suppose the only thing you can do is use ZRANGE inside a Lua script which will do the filtering for you. If you also want to scan it alliteratively rather than get the whole set in one go, that would also complicate things.

Comment From: rajneran-quot

that's right, ZRANGE can give you the entire sorted set, but with no filtering. and ZSCAN doesn't do sorting. i suppose the only thing you can do is use ZRANGE inside a Lua script which will do the filtering for you. If you also want to scan it alliteratively rather than get the whole set in one go, that would also complicate things.

Since wanted to implement autocompletion so fetching the data each time for different regex that would be highly costly task.

Comment From: oranagra

@rajneran-quot so your LUA script can fetch just the first n results, and even do incremental calls to LRANGE and abort the "scan" when enough results were collected.

i'm guessing there are better way, maybe involving a module. @itamarhaber might be able to point to something.

Comment From: rajneran7890

@itamarhaber can you check and let me know is there any better way ?

Comment From: itamarhaber

Hello @rajneran7890

As @oranagra said, I'd go with a Lua script to implement this using vanilla Redis. Alternatively, you can extend Redis with the RediSearch module and use its autocomplete feature (i.e SUGADD and SUGGET).

Comment From: rajneran-quot

@itamarhaber MODULE LOAD redisearch.so OPT1 OPT2 (error) ERR unknown command MODULE, with args beginning with: LOAD, redisearch.so, OPT1, OPT2,

getting this while loading the redissearch.so any idea why so ?

Comment From: itamarhaber

Redis modules were added to Redis v4 - which version are you using?

Comment From: rajneran-quot

redis_version:4.0.14

Comment From: itamarhaber

redis_version:4.0.14

This doesn't make sense... unless you're using a managed Redis service where this functionality has been turned off? Although if that's the case I'm not sure how you got the .so file there in the first place.