Awesome GitHub RepositoriesSearch-Oriented SQL Engines

Manticoresearch is a high-performance search engine and database designed for indexing and retrieving large datasets. It functions as a full-text search engine, a vector search database, and a SQL-based search database, providing a distributed search cluster architecture. The system provides an alternative to the Elasticsearch stack, offering a compatible API for indexing and searching structured and unstructured data. It distinguishes itself by supporting multiple retrieval methods, including vector matching for similarity search, geospatial queries, and traditional full-text ranking. The p

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

Zombodb 是一个将 PostgreSQL 与 Elasticsearch 集成的数据库扩展和关系数据索引器。它提供了一个 SQL 搜索接口，允许用户使用标准 SQL 函数和语法（而非原生 JSON API）执行复杂的搜索查询和聚合。该项目将关系数据从 PostgreSQL 同步到远程搜索引擎，以实现高性能的全文本搜索和分析。 该系统通过将关系结构与搜索引擎能力桥接而脱颖而出，特别是通过针对几何和地理类型的地理空间搜索集成。它实现了一个 SQL 转 JSON 的查询映射层，支持在关系环境中直接进行高级文本分析，包括模糊匹配、邻近搜索和相关性评分。 该项目涵盖了广泛的能力领域，包括索引生命周期管理、自动化关系数据同步和复杂的分析聚合。它支持用于基于位置查询的空间索引、自定义文本分析管道，以及用于审计索引统计和集群健康的监控工具。安全性通过使用 TLS 在数据库和搜索引擎之间进行加密连接来处理。