While we want to use RedisTimeSeries for storing IoT time series data, the different timeseries (what we call in manufacturing automation as ‘Tags’) are part of a hierarchical topology - a relational tree structure. We have realized that using RDBMS makes its storing, updating and access easy through SQL commands - from clients perspective. So we were looking for a solution where clients sees the store as SQL compatible DB and uses SQL commands, while the data is actually stored in Redis. That way we will avoid using two DBs - one RedisTS and the other some RDBMS. Is there any elegant solution out there?
Redis Labs doesn’t provide any SQL-based interfaces to RedisTimeSeries, unfortunately.