2 个仓库
SQL layers that allow retrieval and filtering of non-relational search indices using standard query syntax.
Distinct from SQL Query Engines: None of the candidates capture the specific identity of an SQL interface targeting a search index (Elasticsearch).
Explore 2 awesome GitHub repositories matching data & databases · Search-Oriented SQL Interfaces. Refine with filters or upvote what's useful.
This project provides a SQL interface for Elasticsearch, serving as a translator and database layer that allows users to retrieve, filter, and manipulate indices using structured query language. It functions by converting standard SQL statements into the native JSON query language used by the search engine. The system includes a geospatial SQL engine for executing location-based searches and distance calculations. It also features a query debugger used to visualize the translation process from SQL to search engine request bodies to verify the logic and accuracy of data retrieval. The capabil
Provides a standard SQL syntax to retrieve and filter data from Elasticsearch indices.
Zombodb 是一个将 PostgreSQL 与 Elasticsearch 集成的数据库扩展和关系数据索引器。它提供了一个 SQL 搜索接口,允许用户使用标准 SQL 函数和语法(而非原生 JSON API)执行复杂的搜索查询和聚合。该项目将关系数据从 PostgreSQL 同步到远程搜索引擎,以实现高性能的全文本搜索和分析。 该系统通过将关系结构与搜索引擎能力桥接而脱颖而出,特别是通过针对几何和地理类型的地理空间搜索集成。它实现了一个 SQL 转 JSON 的查询映射层,支持在关系环境中直接进行高级文本分析,包括模糊匹配、邻近搜索和相关性评分。 该项目涵盖了广泛的能力领域,包括索引生命周期管理、自动化关系数据同步和复杂的分析聚合。它支持用于基于位置查询的空间索引、自定义文本分析管道,以及用于审计索引统计和集群健康的监控工具。安全性通过使用 TLS 在数据库和搜索引擎之间进行加密连接来处理。
Provides an SQL interface allowing advanced search engine queries and aggregations to be executed using standard SQL syntax.