Howdy, everyone! Don't you hate it when one of your favorite Pivots blogs a non-official, non-blabs article about tea and you didn't even know about it? It's just too much effort to subscribe to everyone's blog individually.

Fret no more! Now you can read and subscribe to every blog post with one easy URL: the All Pivots Blog. Just navigate to http://pivots.pivotallabs.com /everyone. You'll see all Official, Blabs, and individual posts in chronological order.

A couple of points:

• Exposing the All Pivots Blog reinforces the fact that all posts are public.
• There are no links directly to the All Pivots Blog -- you "just have to know". We still want to drive traffic to the Official Blog and Pivotal Blabs; the All Pivots Blog is mostly for us Pivots, which is why I have not put a working link in this post.

Interesting Things

• IE Fun: when building a DOM tree by hand (such as in Javascript), don't forget to add <tbody> tags in your tables! These are required in Internet Explorer 6 and 7. The tables will not appear without them.
• Pivot Erik wrote a post about firing mouse events in tests using Yahoo's YUI Javascript library. Check it out!

Interesting Things

• As a follow-up to yesterday's "As for Help" regarding geo-spatial algorithms, one developer implemented MySQL's geo-spatial code with great success. One caveat: the table must be an MyISAM rather than InnoDB in order to get the indexes, and thus speed benefits. Wes suggested this helpful link.

Interesting Things

• Rails tweaking: test startup times can be very slow due to Fixture loading, especially for HABTM. We monkey-patched the Fixture-loading code that handles HABTM, resulting in a test suite performance increase of 300% for one project! We'll submit the patch to Rails core and keep you posted.

Ask for Help

• "Does anyone know an efficient algorithm for detecting overlapping rectangles made of up latitudes/longitudes... in SQL?"
  Or, in other words, detecting if two selections on a map overlap. The latitudes and longitudes are stored in a MySQL database. MySQL has some GIS features that we'll explore.