Simon Willison’s Weblog


Friday, 27th February 2009

How FriendFeed uses MySQL to store schema-less data. The pain of altering/ adding indexes to tables with 250 million rows was killing their ability to try out new features, so they’ve moved to storing pickled Python objects and manually creating the indexes they need as denormalised two column tables. These can be created and dropped much more easily, and are continually populated by an off-line index building process.

# 2:33 pm / brettaylor, databases, friendfeed, mysql, python, scaling, sharding

Magic properties make Firefox synchronously load the Java plugin. Even defining a function called sun() (or several other symbols) will trigger the Java VM to be loaded, dramatically hurting the performance of your page.

# 4:03 pm / firefox, java, javascript, mark-pilgrim, performance

jQuery Sparklines. Delightful Sparklines implementation, using canvas or VML in IE. A neat nod towards unobtrusiveness as well: you can specify your data as comma separated values inside a span, then use a single jQuery method call to convert the span in to a sparkline image.

# 8:43 pm / canvas, gareth-watts, graphs, javascript, jquery, sparklines, vml

2009 » February