Redis Alternative at Apache Software Foundation Now Supports RediSearch and SQL

A new query engine called KQIR has been introduced for Apache Kvrocks, supporting both SQL and RediSearch queries. Kvrocks, a Redis-compatible database, persists data on disk for enhanced storage capabilities. The need for SQL features in NoSQL databases has led to the emergence of NewSQL databases, aiming to combine performance with transaction guarantees and complex query support. RediSearch, a Redis module, enhances Redis with structured schemas and unique query syntax. KQIR utilizes an intermediate language (IR) to handle SQL and RediSearch queries consistently. The architecture includes an IR optimizer with multiple passes for query optimization. Currently available on the unstable branch, KQIR supports commands like FT.CREATE and FT.SEARCHSQL. Future plans include expanding support for field types, enhancing transaction guarantees, and integrating runtime statistics for optimization. Developers are encouraged to engage with the Apache Kvrocks community to contribute and stay updated on the project's progress.