ValentinaDB incorporates a powerful Full‑Text Search (FTS) engine.

Full‑Text Search for ValentinaDB

FTS lets you index one or more String, VarChar, or Text fields and perform fast, relevance‑ranked searches using BM25 scoring. It integrates naturally with SQL through the new fts_search table‑valued procedure and the MATCH predicate.

Key Benefits

• Create FTS indexes over multiple text fields for high‑performance search results.
• Search using the fts_search procedure, which returns matching record IDs and BM25 relevance scores.
• Use the MATCH predicate directly in SQL WHERE clauses for natural query integration.
• Rich query language: terms, phrases, AND/OR/NOT, required/excluded clauses, boosts, field selectors, parentheses, prefix searches, and wildcards.
• Choose from five analyzers: ICU (default), simple, snowball, keyword, and ASCII.
• Automatic index maintenance on insert, update, and delete operations.
• Self‑healing behavior: dirty indexes are rebuilt automatically when needed.
• FTS participates in metadata inspection, diagnose, reindex, SQL/XML dump/restore, and clone operations.

FTS is included with Valentina Studio, Valentina Server, and the vcomponents.zip.

Enabling FTS in the ValentinaDB system in Database ADK

ADK apps can enable FTS by adding the valentina_fts extension matching the correct OS, architecture, and Valentina version.