Splitting a sql file containing a whole database into per-table files is quite easy:

1. Grep the .sql for any occurence of DROP TABLE.
2. Generate the file name from the table name that is included in the DROP TABLE statement.
3. Echo the output to a file.

Here is a little script that expects a .sql file as input:

#!/bin/bash

file=$1 # the input file
directory="$file-splitted" # the output directory
output="$directory/header" # the first file containing the header
GREP="DROP TABLE" # what we are looking for

mkdir $directory # create the output directory

while read line
do
   # if the current line contains the wanted statement
   if [ $(echo "$line" | grep -c "$GREP") == "1" ]
   then
      # extract the file name
      myfile=$(echo $line | awk '{print $5}' | sed -e 's/`//g' -e 's/;//g')
      # set the new file name
      output="$directory/$myfile"
   fi
       echo "$line" >> $output # write to file
done < $file

Here you can download the script if you don’t want to copy & paste. More here.

This is a kind of brain dump. I'm going to add to this over time. I spend a lot of time in templating code with jsp taglibs and velocity markup. CSS is a recurring pain so I keep my eyes open for new tools.

Editor Tools

DownloadSquad posted on the Zen Coding project offers a new fast tag completion for writing html and css quickly. It has support for a number of text editors, but not Vim.

Zen Coding v0.5 from Sergey Chikuyonok on Vimeo.

On Slashdot somebody pointed to http://mattn.github.com/zencoding-vim/ which offers a similar functionality to Zen Coding.

These are both keyBoard Shortcut style scripting environments, I was impressed with the speed of them, and they of course mean less typing, but I'm not sure that I still produce enough html these days to make the extra learning pay off. My usual Vim plugins make html pretty painless anyway.

From the Ruby World

On the other hand another slashdotter pointed to Haml and Sass. these are terse /abbreviated markup styles that get compiled into normal html / css by the Ruby compiler.

Haml

Haml, offers an indentation based shorthand for generating html. I got the feeling though that once the html got more complicated, the shorthand notation wasn't much less complicated than the html, and perhaps less legibl

Sass

Sass on the other hand has some really great features adding some basic programmatic elements to css with variables and mixins, promoting good DRY concepts in CSS:

Variables

this:

// Sass

!blue = #3bbfce
!margin = 16px

.content_navigation
  border-color = !blue
  color = !blue - #111

.border
  padding = !margin / 2
  margin = !margin / 2
  border-color = !blue

becomes:

/* CSS */

.content_navigation {
  border-color: #3bbfce;
  color: #2aaebd;
}

.border {
  padding: 8px;
  margin: 8px;
  border-color: #3bbfce;
}

Mixins

this:

// Sass

=table-scaffolding
  th
    text-align: center
    font-weight: bold
  td, th
    padding: 2px

=left(!dist)
  float: left
  margin-left = !dist

#data
  +left(10px)
  +table-scaffolding

becomes:

/* CSS */

#data {
  float: left;
  margin-left: 10px;
}
#data th {
  text-align: center;
  font-weight: bold;
}
#data td, #data th {
  padding: 2px;
}

Now this would be great if I could get this in Java. perhaps some kind of maven plugin would be what I need. I'll have to research a little further here....

Curtain up for Figaro!
A website built with Figaro channels the voices of many and integrates their feeds and media from popular social networks into one harmonic orchestra.

Curious? Download the Figaro-Manual.pdf here!

  read more.

When you deploy a piece of software it's easy to get something wrong. The server may not be set up to specification, or you may have a typo in your configuration. For simple applications these errors are easy to identify and standard test procedures should weed out the most obvious culprits. However more complex functionality is harder to test, and errors may be harder to identify. First I'll talk about a typical error, then I'll discuss a solution.

  read more.

Flightlab is the online equivalent to the Red Bull Flugtag; a global event taking place in 23 different countries around the world where people build homemade, man-powered flying machines and pilot them off a 30-foot high ramp.

The online platform includes a fun-to-use workshop where people can build and paint their own flying machines. Physical qualities - material, size and shape - all influence the flight behaviour, giving each plane unique characteristics.

Pilots can store their planes on their personal homepage, a hangar, and continue working on them later on.

The goal of the game is to cover as much distance as possible. To achieve this, users may experiment with acrobatic maneuvers, collect cans of Red Bull to refuel and employ the thermal updrafts.

Points are given after each flight for distance covered and piloting style. Loops, drifts, rolls, low-level flight and other maneuvers are rewarded. In addition, the other users rate the plane's design. A total score is calculated which, if it's good enough, may be included on a high score table.

Awards

The project has won numerous international awards, 2 Webby Awards, Gold at the BIMA awards, 2 x Gold at the Davey Awards, Silver at the W3 Awards, Bronze at The One Show Interactive and the Cannes Cyber Lions, a FAB and a FABulous Award, Gold at the Clios, Winner/3D and Best In Show at Flash in the Can, and it won FWA Site of the Day and Site of the Month, amongst others.

The hugely successful game nearly doubled the traffic on Red Bull's corporate website. Flight Lab's spiritual successor, the Red Bull Soapbox Racer was launched one year later, and an update of Flight Lab is in the works.
 

Redbull SoapBox Racer

Red Bull Soapbox - kids of all ages in self-made cars, racing down a steep hill. An extremely popular event, held throughout the year across the globe. The cars are powered by gravity only, no engines allowed but all dreams and colors.

And now it’s online! All of it, the cars, the race, the place to meet and challenge your friends. We call it Red Bull Soapbox Racer and racing you will.

Race first, think later

One single click on “Race now” and you find yourself on top of a steep road, pointing downhill. While the countdown is running, please be reminded that the game is based on a realistic physics simulation and you should not not not smash into one of those nice obstacles. Do collect cans for an extra speed boost and don’t forget the spanners.With ultra speed comes maybe damage.

A Selection of Tracks

If you didn’t win instantly the first time, maybe it was the wrong track. We have tracks for everybody, Wildwest, Night Ride, Turkish Riviera, Waterland, Alpenglück - many more will be added. Or was there a problem with the car?

Another car, another race

Red Bull Soapbox Racer lets you build your own car in 3D. Just draw the outline with your mouse. It’s really that simple and everything you draw will have an effect later in the game. The rounder the wheels the better, reconsider materials, use more stickers, paint, use colors, use more colors than your opponents, use every tool you have at least once. And winning races will get you even more of those. (THERE IS A NAILGUN!)

SoapBox Builder

Give it some love, cars will be rated by who-knows-what so make sure there is no doubt. You may also browse through all existing cars for some inspiration.

The Challenge

After tinkering and test driving for a while there comes a point in time where you are quite sure to have the best car ever built on this planet. Challenge your friends! Invite them by E-Mail or simply click on the name of your long-time-rival in the so-called friends list.

A challenge works like this: Start the challenge and you have three attempts to race your best time. After that your opponent will be notified and offered three rounds to beat your time.

And after that, there is the high score list for everyone to see.

Steeper, faster, harder

It’s even better to challenge somebody on your own surprise track.Give it a try, it’s simpler than building cars. Draw with your mouse where the street should go, done. Then, if you like, adjust the downward slope with some gusto and remember the guideline: The steeper the faster. Place obstacles and power-ups as you see fit, some recommend at least one can of Red Bull.

Track Editor

Red Bull Soapbox Racer is the latest addition to our creative online communities. Make yourrace times heard, we sure will try to beat you. See you on the circuit!

The built in Image Editor with CKEditor is really great and the documentation sure did a great job of explaining how to switch on 'upload' feature. In a matter of minutes I was successfully uploading images onto our server, and seeing the results sent from the server.

However I had no way of knowing what response it expected from the server. Simply returning the image url, or an image tag didn't work. After hours googling, reading forum posts, and finally the source code form a couple of open source projects I finally got the thing working.

  read more.

I'm really excited to be typing the first post on our wysiwyg editor - CKEditor, the next generation of the popular FCKEditor. This is the third rich text editor we've tried and I have to say I'm really impressed.

  read more.

Why have we chosen to call our new Blog Product Figaro? When discussing what the Figaro is and how it should work I had one of those high-low cultural inspiration moments. 

I kept thinking of a line from Peter Shaffer's Amadeus film of 1984. there was a scene where the young mozart is trying to justify to Emperor Joseph that he is writing an opera out of Beaumarchais' Play 'the Marrriage of figaro'

  read more.

We've chosen Slimbox to provide a javascript lightbox effect. it's clean simple and very lightweight. It provides not only features for viewing an enlarged version, but has a slideshow feature which works nicely.

It's based on our favourite javascript Library MooTools and at about 4kb it's very lightweight, with a code-design that makes it very simple to implement. There are a great many Lightbox clones out there, but I found this very simple to use, and they've made the effort to upgrade to Mootools 1.2, so I had no extra compatabilty headaches.

More details can be found on the SlimBox website

Torsten has built a sharp new looking video player.

The inevitable cheesipuffs movie

It can easily be embedded into blog post. you simply have to upload one of the supported formats, in same way as picture. We show many videos post with no problem

The Blog Administration recognises it video, and builds that render player when visitors look at blog. 

Currently formats are:

• Quicktime (mov)
• Flash (flv, f4v,m4v)
• Mpeg4 (mp4)

ECO2 is a concept for a desktop software, that automatically measures your computing habits, e.g. how many servers you connect to, which online worlds you explore, or how many print-outs you make. It then calculates your electronic CO2 footprint.

Your footprint is visualised directly on your desktop as a slowly greying and finally decaying landscape. Linked to a donation system, you can offset your electronic CO2 footprint and turn your desktop back into a bright, clean environment, while simultaneously trees in the real world are planted.

Desktop Widget / Air Application

CO2-calculator

The desktop application can be minimised to widget form; or extended into a full CO2-calculator to offset all your household's CO2-emissions.

ECO2 was developed as a self-initiated project. It won first place at the "IID Green Day", a competition in Tokyo around "green ideas". Our presentation was based on the idea that virtual avatars produce very real CO2-emissions, too.