Storing Message Strings in a Relational Database or Not

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.