mysql string replacements

code :: quick and dirty sql example

sometimes you find the need to do mass string replacements in your mysql/maria databases. here's how i do it:

UPDATE your_table
SET your_field = REPLACE(your_field, 'old_value', 'new_value')
WHERE your_field LIKE '%old_value%'

BLiSS Sim for ipad

lab :: my first itunes release

BLiSS Sim

the Bioregenerative Life Support System Simulator, BLiSS Sim, is an ipad app, built with titanium studio, based on investigations conducted by NASA scientists and engineers to explore how plants can be grown to provide air, water, and food for astronauts at a lunar base.

BLiSS uses a game format to engage youth and adults in the challenges of supporting humans in space or extreme environments on earth.

The app is free and available for download from the iTunes Store.
Visit the promotional website at: http://bliss-sim.cet.edu/

stencil graffiti

art :: paintings for my friends

stencil graffiti - fight club

this year i decided to make xmas gifts for all my friends. part of me wanted to make something special for everyone, part of me just wanted to paint. i chose stencils as the medium for a few reasons. one, i have little experience with them. most of my graffiti has been hand drawn on the fly. some people in the 'graff scene' seem to think that stencils are cheating. but i don't see it that way. it's just another method in the same medium...

Read: stencil graffiti »

double cooked tofu

notes :: steamed and fried goodness

tofu - double-cooked

one day i walked into an unfamiliar chinese restaurant and ordered szechuan tofu. the nice lady behind the counter asked me if i wanted it steamed, fried... or both. at that moment my mind was blown. and the idea of double cooked tofu was born. it’s a simple recipe for anyone new to cooking tofu. this article is meant to teach you how to cook tofu, not flavor it. tofu is known for taking on the tastes of whatever it’s cooked with. after cooking the tofu in this method you can coat or sauté it in a sauce of your choice, or eat it plain.

Read: double cooked tofu »

LSDj keyboard tutorial

lab :: DIY gameboy piano interface

LSDj keyboard

so, making music for LSDj is fun. but after a while you start to wish you could “play" the gameboy software as a musical instrument as opposed to composing music in its tracker style interface. that's where the LSDj keyboard comes in. the idea is, the keyboard sends messages though the gameboy linkport to LSDj. the commands that can be sent vary from playing/stopping notes or chains or tables, un/muting channels, in/decreasing octaves, switching instruments, navigating screens, and more. 
here's what the LSDj wiki says about the keyboard...

Read: LSDj keyboard tutorial »

SQL select into statement

code :: copy and swap database tables in MSSQL

have you ever had a database table that you needed to clone? you can use any number of convoluted methods such as: manually coping and pasting rows in the database manager, running lots of queries/stored procedures, or writing a script to cycle though each row copying data from one table to the next. all of these methods are inferior and far more complex then the method i'm going to show you.

introducing the select into query...
this method should be used if the table you want to clone exists, but the new table douse not. the select into query will create the new table for you, copying all the column names, properties, and data. if you want to make an exact clone of the table you can select * into the new table. but if you only want a few specific columns, you can declare only the ones you want. the syntax is elegantly simple...

SELECT *
INTO [new-table]
FROM [old-table]

Read: SQL select into statement »

R4-DS

entertainment :: the nintendo DS homebrew revolution

R4-DS the homebrew revolution

the nintendo ds is an awesome portable gaming system. i have the ds lite, its thin, weights under a pound, has two super bright backlit screens, pretty sweet integrated speakers, the classic nintendo plus d-pad, four front buttons, and two shoulder buttons. the bottom screen is touch sensitive, which makes for some awesome gameplay. the touch screen is sick, but a lot of people can be put off by it. so tons of games let your switch between the touch motion and d-pad motion.

the nintendo DS

Read: R4-DS »