Translations and Symfony2 in the database

Question

File-based translation does not work for me because clients need to change the text.

So, I am thinking of implementing this interface to retrieve data from a database and cache the results in the APC cache. This is a good decision?

Answer 1

It may be what you are looking for

http://blog.elendev.com/development/php/symfony/use-a-database-as-translation-provider-in-symfony-2/

Answer 2

Take a look at the Translation Behavior Extension for Doctrine 2. The StofDoctrineExtensionsBundle integrates it with Symfony.

Answer 3

You might want to take a look at this Loader + Resource using a PDO connection: https://gist.github.com/3315472

Then you only need to make it cache accessible, for example, add memcache, apc, .. between them. If so, you can disable the file caching of Translator itself.