{"repo":"zdk/pg-search-thai","free":true,"listed":false,"github":"https://github.com/zdk/pg-search-thai","clone":"git clone https://github.com/zdk/pg-search-thai.git","description":"Thai language full text search extension for PostgreSQL","language":"Python","stars":41,"topics":["full-text-search","thai","thai-language","nlp","postgresql","postgresql-extensions","postgresql-full-text-search","pgxn","postgresql-extension"],"license":null,"category":"machine-learning","readme_excerpt":"pg-search-thai ============================ pg-search-thai is full text search PostgreSQL extension for Thai Language. Its main purpose is: To enable PostgreSQL Full Text Search in Thai language (Due to Thai Language does not use spaces to separate words) Performance Benchmarked against Elasticsearch 8.15 with the built-in thai analyzer on 100,000 Thai Wikipedia articles, single Docker host, warm cache: Metric pg-search-thai ES (thai analyzer) --- --- --- Single-term query (p50 / p95) 1.4 ms / 4.3 ms 5.7 ms / 18.9 ms Boolean AND (p50 / p95) 1.6 ms / 5.8 ms 6.7 ms / 9.8 ms Boolean OR (p50 / p95) 2.6 ms / 3.2 ms 6.1 ms / 9.6 ms Index size 105 MB 427 MB Write → searchable lag 0 ms (transactional) 1 s (refresh interval) Full reproducible harness, methodology, and caveats: see bench/BENCHMARKS.md and bench/README.md . Installation Quick start with Docker Spins up Postgres 18 with thai parser pre-built and the extension auto-created: git clone https://github.com/zdk/pg-search-thai.git cd pg-search-thai docker compose up -d Connect with psql (password: testpass ): psql -h localhost -U testuser -d testdb \\ -c \"SELECT FROM ts parse('thai parser', 'ต้มยำกุ้ง');\" From source Install libthai and the Postgres build headers via your package manager: # Debian / Ubuntu sudo apt install -y build-essential libthai-dev postgresql-server-dev-all # macOS (Homebrew) brew install libthai libdatrie Then build and install the extension: git clone https://github.com/zdk/pg-search-thai.git cd pg-search","default_branch":null,"files":null,"tree":[],"storefront":"/r/zdk","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/zdk/pg-search-thai/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}