preloader
軟體工程 Make Postgres support full text search in Mandarin/Chinese for Rails 讓Postgres 開始支援中文全文檢索
By Howard Lee 11 January 2016

I use the gem pg_search in rails as a light-weight tool for full-text searching task of Postgres, but Postgres doesn’t support the function well in Mandarin/Chinese. After finding solutions, I take the combination of tools for full-text search in Postgres, which are pg_search gem, SCWS and zhparser. Doing it yourself according content in following links, you will setup successfully too. Remark at 20160131: This tutorial requires postgresql-server-devel-{VERSION} at Ubuntu and

read more

About

Howard Lee is a Staff Software Engineer based in Taipei, specializing in frontend architecture, CI/CD, and production-quality engineering for enterprise web applications. With 13+ years of software development experience, Howard has worked across B2B SaaS, IoT energy-management platforms, online travel marketplaces, and Android applications. His work focuses on modernizing large frontend systems, improving delivery quality, and building reliable product workflows with automated testing, observability, and practical cloud/platform integration. Core Expertise Frontend architecture: Angular 5 to 19 modernization, TypeScript, JavaScript, React, Next.

Know More

Category

Tag

Social