News for hackers. Stuff that matters.
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.