ZRANGEBYLEX for lexicographic queries in Redis - Mini Project: Build & Apply

Using ZRANGEBYLEX for Lexicographic Queries in Redis

📖 Scenario: You are managing an online bookstore's Redis database. You want to query book titles stored in a sorted set by their alphabetical order.

🎯 Goal: Build a Redis query using ZRANGEBYLEX to retrieve book titles within a specific lexicographic range.

📋 What You'll Learn

Create a sorted set called books with specific book titles as members and the same score for all.

Define a lexicographic range using Redis range syntax with [ and (.

Use ZRANGEBYLEX to get book titles between two lexicographic boundaries.

Limit the number of results returned by ZRANGEBYLEX using the LIMIT option.

💡 Why This Matters

🌍 Real World

Lexicographic queries in Redis sorted sets are useful for autocomplete features, alphabetical listings, and filtering data by string ranges.

💼 Career

Understanding ZRANGEBYLEX helps in building efficient search and filtering features in applications using Redis as a fast in-memory database.

1

DATA SETUP: Create the sorted set books with book titles

Create a Redis sorted set called books and add these members with score 0: 'A Tale of Two Cities', 'Brave New World', 'Crime and Punishment', 'Don Quixote', 'Emma'.

Redis

# Add the specified book titles to the sorted set 'books' with score 0
# Your code here

Need a hint?

Use ZADD with score 0 for all members to create the sorted set books.

2

CONFIGURATION: Define the lexicographic range boundaries

Define two variables: min_lex as [Brave New World and max_lex as [Emma to set the lexicographic range for the query.

Redis

ZADD books 0 "A Tale of Two Cities" 0 "Brave New World" 0 "Crime and Punishment" 0 "Don Quixote" 0 "Emma"

# Define min_lex and max_lex for lexicographic range
# Your code here

Need a hint?

Use Redis lexicographic range syntax with [ to include the boundary.

3

CORE LOGIC: Use ZRANGEBYLEX to query book titles in the lexicographic range

Write a Redis command using ZRANGEBYLEX on books with min_lex and max_lex to get all book titles between these boundaries.

Redis

ZADD books 0 "A Tale of Two Cities" 0 "Brave New World" 0 "Crime and Punishment" 0 "Don Quixote" 0 "Emma"

min_lex = "[Brave New World"
max_lex = "[Emma"

# Use ZRANGEBYLEX with min_lex and max_lex to get book titles
# Your code here

Need a hint?

Use the variables min_lex and max_lex directly in the ZRANGEBYLEX command.

4

COMPLETION: Add a LIMIT clause to restrict results to 2 items

Extend the ZRANGEBYLEX command to include LIMIT 0 2 to return only the first two book titles in the lexicographic range.

Redis

ZADD books 0 "A Tale of Two Cities" 0 "Brave New World" 0 "Crime and Punishment" 0 "Don Quixote" 0 "Emma"

min_lex = "[Brave New World"
max_lex = "[Emma"

ZRANGEBYLEX books [Brave\ New\ World [Emma

# Add LIMIT 0 2 to the ZRANGEBYLEX command
# Your code here

Need a hint?

Use LIMIT 0 2 after the range arguments to limit results.