Cache Store for storing db tables with indexes

• Redis

  320 64,893 9.7 C

  Redis is an in-memory database that persists on disk. The data model is key-value, but many different kind of values are supported: Strings, Lists, Sets, Sorted Sets, Hashes, Streams, HyperLogLogs, Bitmaps.

  

Simple key-value stores like redis or memcached come to mind. You could then store every sql result there, using the query as key (or a md5 hash of it). If you want to make sure the first latency per day doesn't hit the end user at all you might need to implement a cache-warmup script though.

• Memcached

  56 13,208 8.4 C

  memcached development tree

  

Simple key-value stores like redis or memcached come to mind. You could then store every sql result there, using the query as key (or a md5 hash of it). If you want to make sure the first latency per day doesn't hit the end user at all you might need to implement a cache-warmup script though.

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• redis-sql-trino

  1 33 6.4 Java

  Real-time Indexed SQL Queries for Redis

  

Seems to come close to what you’re looking for, and you could bolt on this project to get closer to SQL https://github.com/redis-field-engineering/redis-sql

Suggest a related project