I recently partnered with a lawyer to produce DocketMonitor.com, a website which will keep you up to date on certain court dockets. It currently supports all of the state level and federal level courts, including appellate courts, excluding bankruptcy courts. We are currently looking for lawyers interested in trying out the service for free. Please use the user registration form on http://docketmonitor.com to sign up and try it out.

Functions include automated checking of dockets, as well as email notifications.

I hope its a useful service that saves lots of time and effort.

Well, in school we talked so much about tuning, I even took a class that devoted part of it to MySQL tuning, but I had yet to see a need for it until today. We have a site that wanted an area to each video page that pulled in content like Amazon.com. We titled the area "People who viewed this also viewed" and we were pulling in content that was seen by other users and highly rated. So, here's the sql I came up with:

SELECT path, COUNT(path) as count FROM accesslog WHERE uid IN (SELECT uid FROM accesslog WHERE path='*****' AND uid !=0) GROUP BY path ORDER BY count

I am in Boston this week at a Drupal conference. I am attending tons of sessions and learning all sorts of awesome stuff, and blogging about it (sometimes just dumping my notes) at http://drupalcon.brettevanson.com

Please go comment if you are there or have questions.