Groonga is a fast and accurate full text search engine based on an inverted index. Newly registered document instantly appears in search results, and updates are allowed without read locks. These characteristics result in superior performance for real-time applications. It is also a column-oriented database management system (DBMS). Compared with well-known row-oriented systems, such as MySQL and PostgreSQL, column-oriented systems are more suited for aggregate queries.
Release Notes: This release added support for the snippet_html() function, which extracts keyword and surrounding text, nested index search among related tables by column index, and range search by using an index and calculations across the meridian, equator, and date line using the geo_distance() function.