Category: FTS

FTS: ElasticSearch Alternative with BM25, 2-gram/3-gram Fuzzy Search, Zhparser & Hunspell Segregation Dicts, etc…

FTS category has 15 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
pg_search pg_search PIGSTY 0.11.1 FTS AGPLv3 pg_search: Full text search for PostgreSQL using BM25
pg_bigm pg_bigm PGDG 1.2 FTS PostgreSQL create 2-gram (bigram) index for faster full text search.
zhparser zhparser PIGSTY 2.2 FTS PostgreSQL a parser for full-text search of Chinese
hunspell_cs_cz hunspell_cs_cz PIGSTY 1.0 FTS PostgreSQL Czech Hunspell Dictionary
hunspell_de_de hunspell_de_de PIGSTY 1.0 FTS PostgreSQL German Hunspell Dictionary
hunspell_en_us hunspell_en_us PIGSTY 1.0 FTS PostgreSQL en_US Hunspell Dictionary
hunspell_fr hunspell_fr PIGSTY 1.0 FTS PostgreSQL French Hunspell Dictionary
hunspell_ne_np hunspell_ne_np PIGSTY 1.0 FTS PostgreSQL Nepali Hunspell Dictionary
hunspell_nl_nl hunspell_nl_nl PIGSTY 1.0 FTS PostgreSQL Dutch Hunspell Dictionary
hunspell_nn_no hunspell_nn_no PIGSTY 1.0 FTS PostgreSQL Norwegian (norsk) Hunspell Dictionary
hunspell_pt_pt hunspell_pt_pt PIGSTY 1.0 FTS PostgreSQL Portuguese Hunspell Dictionary
hunspell_ru_ru hunspell_ru_ru PIGSTY 1.0 FTS PostgreSQL Russian Hunspell Dictionary
hunspell_ru_ru_aot hunspell_ru_ru_aot PIGSTY 1.0 FTS PostgreSQL Russian Hunspell Dictionary (from AOT.ru group)
fuzzystrmatch fuzzystrmatch CONTRIB 1.2 FTS PostgreSQL determine similarities and distance between strings
pg_trgm pg_trgm CONTRIB 1.6 FTS PostgreSQL text similarity measurement and index searching based on trigrams

pg_search

pg_search: Full text search for PostgreSQL using BM25

pg_bigm

create 2-gram (bigram) index for faster full text search.

zhparser

a parser for full-text search of Chinese

hunspell_cs_cz

Czech Hunspell Dictionary

hunspell_de_de

German Hunspell Dictionary

hunspell_en_us

en_US Hunspell Dictionary

hunspell_fr

French Hunspell Dictionary

hunspell_ne_np

Nepali Hunspell Dictionary

hunspell_nl_nl

Dutch Hunspell Dictionary

hunspell_nn_no

Norwegian (norsk) Hunspell Dictionary

hunspell_pt_pt

Portuguese Hunspell Dictionary

hunspell_ru_ru

Russian Hunspell Dictionary

hunspell_ru_ru_aot

Russian Hunspell Dictionary (from AOT.ru group)

fuzzystrmatch

determine similarities and distance between strings

pg_trgm

text similarity measurement and index searching based on trigrams


Last modified 2024-10-28: update docker params (a2bba6e7)