Selecting row number in MySQL

Michael Yakobi sent us this clever use of MySQL’s user defined variable syntax to return row numbers in a result set: Occasionally, one wants to execute a query and have the rows in the results set numbered. This could be done using a variable. For example: SELECT @row := @row + 1 as row, t.* […]

Continue Reading

Fuzzlab uber effects box

Beavis Audio Research brings us the Fuzzlab, an fusion of 4 classic DIY guitar distortion circuits into one hefty tweakable unit. The construction was a very long and educational process – Now that all is said and done, I learned a great many things from this project. I made a large number of mistakes and […]

Continue Reading

CNC tree

My internet friend, David Erwin, had a crisis on his hands; the Christmas tree was a “brown, shedding, fire hazard and it ended up in the front yard on the 23rd.” Well, being a ShopBot owner (as well as the owner of the best darned mid-century modern door company out there, Crestview Doors) he did […]

Continue Reading