song for a future generation
The Red Book standard defined how audio was to be encoded on a CD, and it was great for 1980, but it, well, kinda sucks now.
1. The error correction is too minimal to withstand real-world abuse (cars, friends, etc.).
2. Tracking is pretty loose, and a lot of players have trouble seeking to the exact beginning [...]
Really cool technology with video.
Given a column of polar directions in degrees, this is a single SQL expression to compute their average, for use in a GROUP BY query. Some functions may be MySQL-specific.
IF(DEGREES(ATAN2(
-AVG(SIN(RADIANS(direction_deg)))
,-AVG(COS(RADIANS(direction_deg))))
) < 180
[...]
You are currently browsing the mrclay.org weblog archives for August, 2007.
