I need to store locales of Rails app in DB. And give access for admin to edit locales from admin area of app (activeadmin).
This is idea what I have.
Create file with locales named, e.g. en.yml.lock.
Write translations in this file (duplicate to en.yml in development).
Create table for translations (json or hstore).
Create Capistrano task and load file to DB.
After deploy generate en.yml on server with values from DB.
After editing translations in DB click some button "Regenerate" or use some callback and rewrite en.yml on server.
Reboot application.
What are you think about it? May you have more pretty solution?
And one more question. I think storing this with JSON is easier, but how can I generate form for translation in which user can edit only values, not keys?