hotrungnhan/postgres repository overview

Make Vietnamese Great Again !!!

⁠Vietnamese Full Text Search Dictionary for Postgres

Due to lack of FTS support for vietnamese in postgres. I've make this project to archive it with by collect all the dictionary in the internet, prebuild it for fastest usage.

For more this image is base on postgres image⁠. As an consequence, fts-image will share the same config and enviroment with postgres, as well.

⁠Getting Started

⁠Installation

Docker image will share the same environment with postgres

docker run hotrungnhan/postgres:alpine

Install full text search dictionary via run sql in database

-- add dictionary
CREATE TEXT SEARCH DICTIONARY vietnamese_hunspell (
    TEMPLATE = ispell,
    DictFile = "vietnamese",
    AffFile = "vietnamese",
    Stopwords = "vietnamese"
  );
-- add configuration
CREATE TEXT SEARCH CONFIGURATION vietnamese(
    COPY = english
);
-- alter parser mapping
ALTER TEXT SEARCH CONFIGURATION vietnamese
ALTER MAPPING FOR asciiword, asciihword, hword_asciipart, word, hword, hword_part
WITH vietnamese_hunspell;

----------------------------------------

⁠For builder

⁠Login docker

docker login

⁠Build

And

./run.sh

⁠Reference

⁠Stop Word

• https://github.com/stopwords/vietnamese-stopwords/blob/master/vietnamese-stopwords.txt⁠

⁠AFF Word

• https://github.com/wooorm/dictionaries/blob/main/dictionaries/vi/index.aff⁠

⁠Dict

• https://github.com/wooorm/dictionaries/blob/main/dictionaries/vi/index.dic⁠
• https://github.com/undertheseanlp/dictionary⁠

⁠Installation

• https://stackoverflow.com/questions/30365611/add-new-language-to-postgresql-full-text-search⁠ https://www.postgresql.org/docs/current/textsearch-dictionaries.html#TEXTSEARCH-SYNONYM-DICTIONARY⁠

⁠Lisence

MIT⁠

Copyright (c) 2022-present, Ho Trung Nhan