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.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s