Skip to content

TheAnsIs42/postgres-chinese-textsearch

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

36 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

postgres with chinese textsearch support just for my miniflux compatibility

add zhparser and pg_jieba

build

git pull
Docker build -t name:tag .

migrate from exist database

  1. In postgresql.conf, set default_text_search_config to 'chinese'
  2. In psql, connect to database and run:
UPDATE entries SET document_vectors = setweight(to_tsvector(left(coalesce(title, ''), 500000)), 'A') || setweight(to_tsvector(left(coalesce(content, ''), 500000)), 'B');

(This comes from miniflux. But also split the link in content to words, looking for better way.)

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Dockerfile 94.5%
  • Shell 5.5%