Rails: store translations in database

by

i18n has built-in support for using the database as a translation backend.

Create a table using this code in a migration:

   create_table :translations do |t|
     t.string :locale
     t.string :key
     t.text   :value
     t.text   :interpolations
     t.boolean :is_proc, :default => false
   end

Then add an initializer in config/initializers/i18n.rb with contents:

   I18n.backend = I18n::Backend::ActiveRecord.new

And last… put translations in the table. Something like:

locale key      value
en     Cool     Cool
es     Cool     Frio
en     nav.Home home
es     nav.Home casa
...

As of i18n 0.5.0 I believe they moved this code out into it’s own gem… I forget what that gem is called.

More Related Contents:

  1. Difference between rake db:migrate db:reset and db:schema:load
  2. Rails :include vs. :joins
  3. Using Rails, how can I set my primary key to not be an integer-typed column?
  4. PG::ConnectionBad – could not connect to server: Connection refused
  5. Why can you not have a foreign key in a polymorphic association?
  6. Postgres could not connect to server
  7. Composite primary keys versus unique object ID field
  8. PG undefinedtable error relation users does not exist
  9. Alias for column names in Rails
  10. Change from SQLite to PostgreSQL in a fresh Rails project
  11. Multiple databases in Rails
  12. What is the best way to seed a database in Rails?
  13. Connecting to multiple databases in ruby on rails
  14. Cannot add a NOT NULL column with default value NULL in Sqlite3
  15. A migration to add unique constraint to a combination of columns
  16. Using Rails Migration on different database than standard “production” or “development”
  17. How do I set up the database.yml file in Rails?
  18. delete_all vs destroy_all?
  19. How to implement Active Record inheritance in Ruby on Rails?
  20. Passing variables inside rails internationalization yml file
  21. Fall back to default language if translation missing
  22. How to use the I18n fallback features in Rails 3
  23. Changing the default date and time format in Rails 4
  24. How do I avoid a race condition in my Rails app?
  25. rails i18n – translating text with links inside
  26. Ruby on Rails Server options [closed]
  27. Rails – Strong Parameters – Nested Objects
  28. how to solve “ruby installation is missing psych” error?
  29. What does do in rails erb?
  30. has_and_belongs_to_many, avoiding dupes in the join table

Leave a Comment