Database Native Search

Description

Database Native Search uses MariaDB's full-text search.

It is a fast, simple search method. Unlike Meilisearch, it does not support typo tolerance or advanced filters, but it's reliable for exact matches and controlled queries (like user uploads).

This is the default method when the user profile search setting is set to database native search.

Usage

1. Open the basic search bar.
2. Enter your exact keywords.
3. Submit to view results.

Query Behaviour

• ✅ Exact matches.
• ✅ Some wildcard support (*, +).
• ❌ No typo tolerance.
• ❌ No filters (categories are supported if specified).
• ✅ Supports sorting

Characteristics

Feature	Details
Match Type	Exact match only
Typo Tolerance	No
Filters & Tags	Not supported (except category)
Wildcards	Some support (+, *)
Speed	Fast
Best Use Case	Simple, precise queries, or user uploads mode

Notes

• Wildcard Usage:
  • word → optional term
  • +word → required term
  • -word → excluded term
  • * → partial matching (to an extent, not like Meilisearch)

When should I use this method?
Use for:

• Simple, fast searches.
• When exact keyword matching is expected.