Mroonga User-Defined Functions

Extend Mroonga's functionality in MariaDB Server with user-defined functions. Learn how to create custom functions to enhance full-text search and data processing capabilities.

Creating Mroonga User-Defined Functions

Instructions on how to manually create Mroonga's UDFs if they were not automatically installed, ensuring full functionality.

last_insert_grn_id

This UDF returns the unique ID assigned by Groonga for the last inserted record, useful for tracking internal record identifiers.

mroonga_command

Execute raw Groonga commands directly from MariaDB using this UDF, allowing for advanced administration and inspection of the Groonga database.

mroonga_escape

This function escapes special characters in a string to make it safe for use in Mroonga full-text search queries.

mroonga_highlight_html

Highlight keywords within a text string using HTML tags, making it easy to display search results with matched terms emphasized.

mroonga_normalize

This UDF normalizes a given string using Groonga's normalizers, ensuring consistent text processing for accurate indexing and searching.

mroonga_snippet

This function extracts a snippet of text surrounding a keyword from a document, providing necessary context for search result displays.

mroonga_snippet_html

Similar to mroonga_snippet, this function generates HTML-formatted snippets, automatically wrapping matched keywords in tags for web display.