Month: May 2006

i saw saws

You have got to see these folks! The Singing Saw Shadow Show were amazing the other night; wild raucous lo-fi that had me on the edge of my seat. I must get the old saw out and rosin the bow.

The support were interesting. Pyramid Culture, while better than Better Than Everyone, are okay if you want to learn about the perils of artificial sweeteners, face transplants and parasitic foetal twins. Faun Fables produced their art-rock pantomime The Transit Rider; fun, and with a fab rendition of The House Carpenter, too.

But go and see this Singing Saw Shadow Show if and when you can. They will blow you away.

the commitments

When I was testing BlackBerry typed-alike words (dactonyms?) I found that sqlite was averaging about 1 insert per second. This is by no means good.

It turns out that, under Perl, sqlite auto-commits after every write. This slows things down terribly. Here’s how to fix this:

When opening the database handle, turn AutoCommit off:

my $dbh =
DBI->connect( “dbi:SQLite:bberry2.sqlite”, “”, “”, { AutoCommit => 0 } )
or die “$!”;

Then, only commit occasionally — say every thousand writes:

while ( … ) {

…$id++;
$dbh->commit unless ( $id % 1000 );
…

}
$dbh->commit;

It works out about 1000 times quicker this way.

best beat neat nest

Beware, nerdiness follows: I generally like my BlackBerry 7130e, but its multiple letters per key can sometimes give the wrong result. Using word frequency lists from the British National Corpus, sqlite, and way too much programming time, I determined that the key sequence with the most possible word results (81?2) produces best, beat, neat or nest. The device itself suggests also brat and bray, so I should try a longer word list — in my copious free time, of course.
The longest (common words in the corpus) that have the same key sequence are employers and employees, which might briefly cause hilarity in an HR or legal context.

Energy Saving Tips for Canadians, #1: a name thing

Canadians are remarkably profligate in their energy use, and I think I know why. It’s not to do with the oft-cited scale of the country, the size of our houses, our cold winters or our hot summers, it’s something simpler than that; it’s what we call our electricity.

Power here is generally known as hydro, and with it comes images of tree-lined rivers with bears happily fishing for salmon. Local electricity companies tend to have that watery thing in their name: Toronto Hydro, Hamilton Hydro, London Hydro (Crieff Hydro is something quite different, though). Some happy green images, eh?

I propose that we stop using the term hydro, and replace it with the snappier smog belching, nuke leaking, only fractionally hydro. It’d certainly make yer average Kathy or Doug drop their double-double (or donut, or dumaurier) when they got their smog belching, nuke leaking, only fractionally hydro bill in. Energy use would plummet, and at no cost to anyone!