Problems with creating tables for beginners in redis
Assume that there is currently a mysql table article structure of
id
title title
info content
tags tag id collection
status status (-1, 0, 1, 2)
atime addition time
utime update time
ptime release time
demand press (Tag/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 according to status: article:status:{-1/0/1/2}
store separately according to tags Collection article:tag:{tag_id}
Use something like sort article:tag:1 by article:atime:* to get sorting. Is this design reasonable?
There is another question. When trying to search, use
zrangebylex article:status:0 [f (g
The result is an error
ERR unknown command 'zrangebylex'
What is the reason?
Reply content:
Assume that there is currently a mysql table article structure of
id
title title
info content
tags tag id collection
status status (-1, 0, 1, 2)
atime addition time
utime update time
ptime release time
demand press (Tag/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 according to status: article:status:{-1/0/1/2}
store separately according to tags Collection article:tag:{tag_id}
Use something like sort article:tag:1 by article:atime:* to get sorting. Is this design reasonable?
There is another question. When trying to search, use
zrangebylex article:status:0 [f (g
The result is an error
ERR unknown command 'zrangebylex'
What is the reason?
zrangebylex requires redis >= 2.8.9
sort article:tag:1 by article:atime:* This sentence is to get the sorting of article ids with tag 1 by adding time, right? This design works
String type is not recommended as it will cause too many keys

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP is mainly procedural programming, but also supports object-oriented programming (OOP); Python supports a variety of paradigms, including OOP, functional and procedural programming. PHP is suitable for web development, and Python is suitable for a variety of applications such as data analysis and machine learning.

The process of starting MySQL in Docker consists of the following steps: Pull the MySQL image to create and start the container, set the root user password, and map the port verification connection Create the database and the user grants all permissions to the database

The core benefits of PHP include ease of learning, strong web development support, rich libraries and frameworks, high performance and scalability, cross-platform compatibility, and cost-effectiveness. 1) Easy to learn and use, suitable for beginners; 2) Good integration with web servers and supports multiple databases; 3) Have powerful frameworks such as Laravel; 4) High performance can be achieved through optimization; 5) Support multiple operating systems; 6) Open source to reduce development costs.

The main role of MySQL in web applications is to store and manage data. 1.MySQL efficiently processes user information, product catalogs, transaction records and other data. 2. Through SQL query, developers can extract information from the database to generate dynamic content. 3.MySQL works based on the client-server model to ensure acceptable query speed.

PHP is suitable for web development and content management systems, and Python is suitable for data science, machine learning and automation scripts. 1.PHP performs well in building fast and scalable websites and applications and is commonly used in CMS such as WordPress. 2. Python has performed outstandingly in the fields of data science and machine learning, with rich libraries such as NumPy and TensorFlow.

PHP is suitable for web development and rapid prototyping, and Python is suitable for data science and machine learning. 1.PHP is used for dynamic web development, with simple syntax and suitable for rapid development. 2. Python has concise syntax, is suitable for multiple fields, and has a strong library ecosystem.

PHP is a server-side scripting language used for dynamic web development and server-side applications. 1.PHP is an interpreted language that does not require compilation and is suitable for rapid development. 2. PHP code is embedded in HTML, making it easy to develop web pages. 3. PHP processes server-side logic, generates HTML output, and supports user interaction and data processing. 4. PHP can interact with the database, process form submission, and execute server-side tasks.

Laravel is a PHP framework for easy building of web applications. It provides a range of powerful features including: Installation: Install the Laravel CLI globally with Composer and create applications in the project directory. Routing: Define the relationship between the URL and the handler in routes/web.php. View: Create a view in resources/views to render the application's interface. Database Integration: Provides out-of-the-box integration with databases such as MySQL and uses migration to create and modify tables. Model and Controller: The model represents the database entity and the controller processes HTTP requests.
