News for hackers. Stuff that matters.
Re:Postgres Full-Text Search: A search engine in a database by MushyRoom on Tuesday July 27, 2021 @12:02PM (#27974008)
I was hyped when I found out about it a while ago. Then I wasn't anymore.

When you have 12 locales (kr/ru/cn/jp/..) it's not that fun anymore. Especially on a one man project :)

Re:Postgres Full-Text Search: A search engine in a database by freewizard on Tuesday July 27, 2021 @05:06PM (#27977665)
For small project and simple full text search requirement, try this generic parser: https://github.com/freewizard/pg_cjk_parser
Re:Postgres Full-Text Search: A search engine in a database by oauea on Tuesday July 27, 2021 @12:10PM (#27974114)
Why support so many locales in a one man project?
Re:Postgres Full-Text Search: A search engine in a database by MushyRoom on Tuesday July 27, 2021 @01:59PM (#27975467)
It's just a project to learn all the things that are web. It's mainly a database for a game now with most of the information sourced from the game (including its localization files).

I'm slowly transitioning from MariaDB to Postgres - again as a learning experience. There is cool stuff and there is annoying stuff to reproduce things like case-insensitive + ignore accents (utf8_general_ci) in Postgres.

I've looked into FTS and searching for missing dictionaries to support all the locales but Chinese is one of the harder ones.

Re:Postgres Full-Text Search: A search engine in a database by blacktriangle on Tuesday July 27, 2021 @02:07PM (#27975559)
One (dev) project here, we're up to 5 locales at a surprisingly small number of customers. Problem is when your customers are global, all of a sudden a single customer can bring along multiple locales. I very much regret not taking localization far more seriously early in development but we were blindsided by the interest outside the Angleosphere.
Re:Postgres Full-Text Search: A search engine in a database by habibur on Tuesday July 27, 2021 @01:45PM (#27975306)
To attract more visitors/customers I guess. I plan to extend to 10 languages too. 1 man project.