# Redis & Trino - Real-time indexed SQL queries (new connector)

DevFeed: [Redis & Trino - Real-time indexed SQL queries (new connector)](<https://devfeed.tech/articles/redis-trino-real-time-indexed-sql-queries-new-connector-8725.md>)

Original publisher: [Read original article](<https://trino.io/blog/2023/07/10/trino-fest-2023-redis.html>)

Author: Allen Terleto, Julien Ruaux, Ryan Duan

Published: 2023-07-10T00:00:00Z

Content type: article

Language: en

Sources: [Trino Blog](<https://devfeed.tech/sources/trino-blog.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [data](<https://devfeed.tech/topics/data.md>), [AI search](<https://devfeed.tech/topics/ai-search.md>)

Tags: [cache](<https://devfeed.tech/tags/cache.md>), [database](<https://devfeed.tech/tags/database.md>), [integration](<https://devfeed.tech/tags/integration.md>), [json](<https://devfeed.tech/tags/json.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [performance](<https://devfeed.tech/tags/performance.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [redis](<https://devfeed.tech/tags/redis.md>), [search](<https://devfeed.tech/tags/search.md>), [sql](<https://devfeed.tech/tags/sql.md>), [vector](<https://devfeed.tech/tags/vector.md>)

## AI overview

The article presents a new Redis connector for Trino that pushes down advanced queries and aggregations using Redis secondary indexes. It describes Redis Search, JSON document support, and the connector's intended performance and integration benefits.

## Source excerpt

Ever since the pandemic, it has become clear that the need for a digital first economy is becoming more and more necessary. As Redis' Field CTO Allen Terleto said during their talk from Trino Fest 2023, "In a digital first economy, data is the lifeblood of the organization, which makes the databases the heart of enterprise architectures". Redis, a popular open source project, is a distributed in-memory key-value database. It includes a cache, message broker, and optional durability. In his talk, Allen demonstrates Redis' new connector for Trino. It can push down advanced queries and aggregations while leveraging Redis' unique in-memory secondary indexing. As a result, performance with the new connector is much higher.