Brandon Savage has a new post that looks at planning databases for your applications, specifically in the context of picking the right data types for what you're going to store.

When I started writing this blog post, I had titled it "Tips for Designing Databases" and I planned to talk about various database design techniques. However, as I did more and more research, it dawned on me that one of the most crucial, and most overlooked, components of database development, is the selection of data types for columns.

He touches on a few different topics like how disk I/O can play a part in the storage type, what kind of numeric type might be best for the data, text storage recommendations and some of the data storage types he thinks you should avoid.