Databases
StackOverflow2013
Postsdbo
POWhere to store translations in cloud applications?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhere to store translations in cloud applications?
    primarykey
    data
    text
    <p>I am currently building an application for an architecture running in the amazon cloud (some webservers w/ php5.3, load balancing, PostgreSQL).</p> <p>A key feature of my (PHP5) application is, that everything (on the frontend) has to be translatable into various languages, so there will be lots of strings, which are represented by a "token", that have to be translated.</p> <p><strong>My Question ist: Where would you store these translations?</strong></p> <ul> <li>Store the translations in files on the local (webserver) disks?</li> <li>Store the translations in files on a central storage?</li> <li>Store the translations in the database?</li> <li>Elsewhere?</li> </ul> <p>Additional info: No matter where the translations will be stored - there will be some caching (Redis, + template cache), so the files / DB will not be queried on every rendered page.</p> <p>Each of the above solutions has pros and cons, and after lots of discussion in my team, we did not find a solution that we all were happy with.</p> <p>Some of our thoughts:</p> <ul> <li>Files are easier to maintain (update translations via overwriting files)</li> <li>DB-Tables are more flexible (build a nice translation interface around the translation data)</li> <li>DB-Tables are only stored once; so this is cheaper than lots of files in the cloud, i think (we pay for storage and data transfer)</li> <li>Central storage for the files could be a bottleneck</li> </ul> <p><strong>So what is your oppinion?</strong></p> <p>Greetings, Robert</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USS38
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhere to store translations in cloud applications?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhere to store translations in cloud applications?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhere to store translations in cloud applications?
      1. USRudie
      1. VTFavorite
    1. COYou could always build an interface that updates to files. Is there any cost involved in storing the files on the webservers (and not on EBS)? It could perhaps have a mechanism similar to code deployment.
      singulars
      1. POWhere to store translations in cloud applications?
      1. USSukumar
    2. COIt would be helpful to know where and how your application stores the untranslated texts. Are they dynmic content in a database (then it seems sensible to store the translations there, too), or is it static content stored in (source-)files, or is it something completely different?
      singulars
      1. POWhere to store translations in cloud applications?
      1. USBurninLeo
    3. COThe untranslated text is stored both in db and files. DB for table-translations, files for templates. So we could store our translations in db, or files, or both - a never ending discussion in our team...
      singulars
      1. POWhere to store translations in cloud applications?
      1. USS38
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload