CODEWITHSUNDEEP
mysqlpostgresqldictionarystemminglemmatization
Jimmix
Jimmix

Reputation: 6536

Create a custom Lemma or Stem Dictionary for the Fulltext search in RDBMS: MySQL, PostgreSQL, MariaDb

I have my own non English dictionary with words in CSV format where every line represents a word. A single line starts with the word's base form followed by all its inflected forms.

I would like to use that file to create my own dictionary that sould be used by the FULLTEXT search.

I prefer to use MySQL with that FULLTEXT search but if it is not possible to use MySQL with a custom dictionary then I can switch my project to PostgreSQL or MariaDB.

How to make MySQL or other RDBMS use custom dictionary for FULLTEXT search? It would be nice to have a solution that works also with SQLite so it could be deployed to mobile apps as well.

So far I found related links that unlucky don't say how to do that:

MySQL Stemming for full-text Status: Un-Assigned

PostgreSQL Dictionaries

If using a Lemma dictionary for FULLTEXT search is not possible with any of these RDBMS I think It should be possible to create at least a Stemming dictionary for the PostgreSQL as its extension but I haven't done any extension for PostgreSQL and don't know where to start especially in the context of creating your own dictionary for the FULLTEXT search.

Upvotes: 0

Views: 568

Answers (1)

user2560539
user2560539

Reputation:

If you curently use MySQL then you could use the ngram plugin as specified in ngram Full-Text Parser (you may also want to see this article also).

Regarding the PostgreSQL link that you provided I don't think that you actually have any questions on that, it is straight forward how to configure it.

Upvotes: 0

Related Questions