RU203: Querying, Indexing, and Full-text Search with Redis

Introduction

This repository contains example data and setup instructions for the Redis University course RU203: Querying, Indexing, and Full-Text Search with Redis.

To take this course, you'll first need do the following:

1. Clone this git repository
2. Get RediSearch and load the sample data
3. Build the RediSearch indexes by running the index creation commands

Need help getting started? Stop by the Redis University Discord server.

To get RediSearch, we recommend either launching it from Docker (for beginners) or building it from source and running Redis locally (more advanced).

Option 1: Run RediSearch locally with Docker (Best option for beginners)

First, make sure you have Docker installed.

1. Start Redis

Next, run the following command from your terminal:

docker-compose up -d

This will launch a Redis instance with RediSearch installed. The instance will be listening on localhost port 6379.

When you're done with this container, stop it like so:

docker-compose down

2. Load the sample data

The commands that load the sample data are in the file commands.redis, which is part of this git repository. To load this data, run the following command:

docker exec -i redis-search redis-cli < commands.redis > output.txt

Check the "output" file for "Invalid" responses.

grep Invalid output.txt

If you have any "Invalid" responses, you might not have RediSearch installed properly. If you have any problems, find us on our Discord channel.

3. Create the indexes

To create the indexes, first start the Redis CLI:

docker exec -it redis-search redis-cli

Then paste in the index creation commands (see the next section for details).

Option 2: Build RediSearch from source

1. Build RediSearch and launch Redis

First, follow the instructions for building and running RediSearch from source.

2. Load the sample data

The commands that load the sample data are in the file commands.redis, which is part of this git repository. To load this data, run the following command from your terminal:

redis-cli < commands.redis > output.txt

This assumes that you have redis-cli in your path.

Check the "output" file for "Invalid" responses.

grep Invalid output.txt

If you have any "Invalid" responses, you might not have RediSearch installed properly. If you have any problems, find us on our Discord channel.

3. Create the indexes

To create the indexes, first start the Redis CLI:

redis-cli

Then paste in the index creation commands (see the next section for details).

Building indexes

This data ships without RediSearch indexes, so you need to create them yourself.

We're going to give you all the commands you need to create these indexes, but before you run these index commands, make sure you're in the redis CLI:

$ redis-cli

Then run the following commands:

FT.CREATE books-idx ON HASH PREFIX 1 ru203:book:details: SCHEMA isbn TAG SORTABLE title TEXT WEIGHT 2.0 SORTABLE subtitle TEXT SORTABLE thumbnail TAG NOINDEX description TEXT SORTABLE published_year NUMERIC SORTABLE average_rating NUMERIC SORTABLE authors TEXT SORTABLE categories TAG SEPARATOR ";" author_ids TAG SEPARATOR ";"

FT.CREATE users-idx ON HASH PREFIX 1 ru203:user:details: SCHEMA first_name TEXT SORTABLE last_name TEXT SORTABLE email TAG SORTABLE escaped_email TEXT NOSTEM SORTABLE user_id TAG SORTABLE last_login NUMERIC SORTABLE

FT.CREATE authors-idx ON HASH PREFIX 1 ru203:author:details: SCHEMA name TEXT SORTABLE author_id TAG SORTABLE

FT.CREATE authors-books-idx ON HASH PREFIX 1 ru203:author:books: SCHEMA book_isbn TAG SORTABLE author_id TAG SORTABLE

FT.CREATE checkouts-idx ON HASH PREFIX 1 ru203:book:checkout: SCHEMA user_id TAG SORTABLE book_isbn TAG SORTABLE checkout_date NUMERIC SORTABLE return_date NUMERIC SORTABLE checkout_period_days NUMERIC SORTABLE geopoint GEO

Now try a sample search query to find the authors of a book titled "You Can Draw Star Wars":

FT.SEARCH books-idx "@title:You Can Draw Star Wars" return 1 authors

RediSearch should find one book, with "Bonnie Burton" as the author:

1) (integer) 1
2) "ru203:book:details:9780756623432"
3) 1) "authors"
   2) "Bonnie Burton"

You're Ready!

Now, you're ready to take the course.

If you aren't signed up yet, visit the course signup page to register!

Appendix: The Data Model

The queries in this repository rely on a data model composed of Redis hashes. The entities in this data model include books, authors, library checkouts, and users. The following diagram represents this data model:

    Authors
+--------------+
|  name        |               Author-Books
|              |            +----------------+
|  author_id   +------------+  author_id     |
|              |            |                |
+--------------+        +---+  book_isbn     |
                        |   |                |
    Users               |   +----------------+
+--------------+        |
|  first_name  |        |
|              |        |
|  last_name   |        |       Checkouts
|              |        |  +------------------------+
|  email       |   +----|--+  user_id               |
|              |   |    |  |                        |
|  user_id     +---+    +--+  book_isbn             |
|              |        |  |                        |
|  last_login  |        |  |  checkout_date         |
|              |        |  |                        |
+--------------+        |  |  checkout_length_days  |
                        |  |                        |
    Books               |  |  geopoint              |
+--------------+        |  |                        |
|  isbn        +--------+  +------------------------+
|              |
|  title       |
|              |
|  subtitle    |
|              |
|  thumbnail   |
|              |
|  description |
|              |
|  categories  |
|              |
|  authors     |
|              |
|  author_ids  |
|              |
+--------------+

Subscribe to our YouTube Channel / Follow us on Twitch

We'd love for you to check out our YouTube channel, and subscribe if you want to see more Redis videos! We also stream regularly on our Twitch.tv channel - follow us to be notified when we're live.