Suppose there is currently a MySQL table article structure for
Id
Title Caption
Info content
Tags tag ID collection
Status State ( -1,0,1,2)
Atime Add Time
Utime Update Time
Ptime release Time
Requirements by (tags/status) Get articles sorted by (Add/update/Publish) time
How should the Redis table be designed at this time?
The current idea is
String type
Article:title:{id}
Article:info:{id}
Article:tags:{id}
Article:status:{id}
Article:atime:{id}
Article:utime:{id}
Article:ptime:{id}
Set type
All collections: Article:list
Store collections separately based on state: ARTICLE:STATUS:{-1/0/1/2}
Store collections separately according to tags article:tag:{tag_id}
Is it reasonable to use a sort article:tag:1 by article:atime:* for sorting?
There is also a question that when trying to do a search, use
Zrangebylex article:status:0 [F (G
Result error
ERR unknown command ' Zrangebylex '
What's the reason?
Reply content:
Suppose there is currently a MySQL table article structure for
Id
Title Caption
Info content
Tags tag ID collection
Status State ( -1,0,1,2)
Atime Add Time
Utime Update Time
Ptime release Time
Requirements by (tags/status) Get articles sorted by (Add/update/Publish) time
How should the Redis table be designed at this time?
The current idea is
String type
Article:title:{id}
Article:info:{id}
Article:tags:{id}
Article:status:{id}
Article:atime:{id}
Article:utime:{id}
Article:ptime:{id}
Set type
All collections: Article:list
Store collections separately based on state: ARTICLE:STATUS:{-1/0/1/2}
Store collections separately according to tags article:tag:{tag_id}
Is it reasonable to use a sort article:tag:1 by article:atime:* for sorting?
There is also a question that when trying to do a search, use
Zrangebylex article:status:0 [F (G
Result error
ERR unknown command ' Zrangebylex '
What's the reason?
Zrangebylex requires Redis >= 2.8.9
Sort Article:tag:1 by article:atime:* this sentence is to get the added time sort of tagged 1 article id sorted? This design is feasible
String type is not recommended, will cause too many keys