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?
[ Parent
| on HN ]
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.