Hacker News new | ask | show | jobs
by MushyRoom 1785 days ago
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 :)

2 comments

For small project and simple full text search requirement, try this generic parser: https://github.com/freewizard/pg_cjk_parser
Why support so many locales in a one man project?
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.

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.
To attract more visitors/customers I guess. I plan to extend to 10 languages too. 1 man project.