How we've migrated from globalize to hstore-translate

说明与用途

将 Rails 应用从 Globalize 迁移到 hstore-translate，合并翻译到单个 hstore 列，提升性能。

问题

The Rails application used Globalize for translations, but Globalize was slow and required a separate translations table, causing performance and maintenance issues.

结果

The migration reduced database joins, improved read performance, and simplified the schema by consolidating translations into a single hstore column per model.

工作流

• 1. Added hstore column to each model that required translations.
• 2. Migrated existing translation data from Globalize tables into the new hstore column using a rake task.
• 3. Updated model code to use hstore-translate methods instead of Globalize.
• 4. Removed Globalize gems and tables from the schema.
• 5. Tested application to ensure translations displayed correctly and performance improved.

证据

We replaced Globalize with hstore-translate and saw a noticeable performance improvement.