News for hackers. Stuff that matters.
Re:How FriendFeed uses MySQL to store schema-less data by SingAlong on Thursday October 29, 2009 @08:59PM (#911291)
I tried this method for my app. But it turned out that I needed a lot of fields to be in their own columns since i would have to use them with queries in the WHERE clause or ORDER clause.

So be careful while choosing the columns you would like to serialize or json-ify and dump.

Just my 2c.

Re:How FriendFeed uses MySQL to store schema-less data by technoweenie on Thursday October 29, 2009 @10:00PM (#911369)
Part of this article talks about the index tables they use. The rationale for having separate index tables is they can create or drop them without locking tables or anything like that. It takes a little more manual work to keep things updated though.

I too use a hybrid approach on my site. Only columns that aren't specifically referenced in indexes aren't kept in the serialized attribute hash.