4 things that you should never put in the database

Read this article by Frank Wiles,

TL;DR version

  • Images, files and binary data.  Solution: Use file system.
  • Ephemeral data: Usage statistics, metrics, GPS location, session data or anything that is only useful for a short period of time.  Solution: Use redis, statsdgraphite, Riak
  • Logs. Solution: Use Splunk, Loggly
  • Plain text passwords. Solution: Encryption

Last but not least,
But wait, you're a unique snowflake and your problem is SO different that it's ok for you to do one of these three. No you aren't and no it really isn't. Trust me. - Frank Wiles

No comments:

Post a Comment