Elasticsearch

Highly Scalable Solution: Elasticsearch has been consistently praised by users for its highly scalable nature. It is able to handle storing and retrieving large numbers of documents, offering redundancy and distributed storage across multiple hosts with minimal configuration required.

Extensive Search Capabilities: Users highly praise Elasticsearch for its extensive search capabilities, especially in terms of full-text search. They find it easy to search and filter through millions of documents efficiently, even on large datasets, thanks to its fast search speeds.

Valuable Aggregations and Facets: Elasticsearch's support for aggregations and facets is highlighted as a valuable feature by users. They appreciate the ability to progressively add search criteria to refine their searches and uncover trends in their data.

Configuration Process: Users have encountered difficulties when implementing custom functions and have found the configuration process to be lacking. Some reviewers have mentioned challenges in integrating different elements of the program, incomplete documentation, and misleading forums.

Query Editor Limitations: Users have experienced issues with the query editor and noted that certain queries are not supported in the IntelliSense feature. Several users expressed frustration with inadequate documentation, hard-to-debug problems, and the complexities involved in tuning for ingress performance.

Learning Curve: Users have found the learning curve to be challenging, particularly for those with a background in SQL. Many reviewers mentioned a steep learning curve, extensive documentation requirements, and complexities related to mapping and data type conversion.