We have an application that showed different messages to the user depending upon her state of application use. These messages were stored in a MySQL database. That must have been an obvious place to store text initially. However with time I have felt plain text files could have worked as well, if not better. –
- Text lookup does not require a connect followed by a query or perhaps less of it.
- Text changes don’t require database upgrades and the corresponding times.
- Text can be compared easily with prior versions. With a database that could require restoring from a backup, exporting data and then comparing it.
- Development tools provide extensive infrastructure for managing translations in text files. This has to be retrofitted, if at all used, when text is inside a database.