One day at a time

Here is a posting about how FriendFeed uses MySQL to store the Json object. Then it creates separate table for each meta field to store the meta data. I use similar method to store all the static data (for example, order payment and transaction information). This method is good for data which is relatively stable.

http://bret.appspot.com/entry/how-friendfeed-uses-mysql