dallbit Prompt & Skill

Database Full-text Search (FTS) Implementation

#IT & Development#Data & Analysis#Code & ReviewPROMPT

About

Implements FTS indexes and queries to efficiently search text data within a database.

Prompt Template

The more specific your inputs, the higher the quality of the output.

{{database_type}}
{{table_schema}}
{{target_columns}}
{{search_requirements}}

You are a Search Engine Engineer. Implement a Full-text Search (FTS) feature for the following table using PostgreSQL / MySQL / Elasticsearch. ### Search Configuration - Table Schema: Articles(id, title, content, author) - Target Columns: title, content - Specific Requirements: Support Korean language and rank by relevance score. ### Tasks 1. **Index Creation**: Write FTS index scripts suited for language traits (e.g., morphological analyzers, N-grams). 2. **Search Query**: Provide SQL that includes weight assignments and similarity scoring. 3. **Optimization**: Suggest tuning tips to reduce latency during massive text searches.