Not long after I arrived in Japan, I was introduced to an older gentleman, who shared a keen interests in some European authors and was altogether a pleasure to converse with. That man spoke extremely little English, but was practically fluent in both German and French, while I was, on my end, doing my best to start conveying meaningful sentences through the 15 words of Japanese I had mastered at the time.

I have been in the past ironically referring to “my Japanese lawyer“, and people naturally always assumed I was joking… Well, he is a lawyer. While he should probably have hit retirement a few years ago now, he seems well intent on pleading cases until the very last day. He has, on rare occasions, given me some pro bono advices, repaid in old whiskey and binded european books, which, I suppose, makes him my Japanese lawyer after all.

We once had a conversation about his youth: growing up in Japan during and immediately after the war. The bombing over Tokyo, where his parents lived, got extremely intensive during the last two years. Most of his childhood neighbourhood burnt down before the end of the war. He and his older sister had therefore been sent to some relatives’ house in the country, near a smaller city that had been so far spared from most of the bombings.

Continue reading

A pretty bad week for databases.

After nearly killing a client’s DB yesterday (and spending most of my night restoring every bits and pieces semi-manually), I felt it wise to secure my own DB here. The one that stores this blog. Guess what happened then?

Yea, I blew the DB too. Or to be more precise: mySQL blew the part of the DB encoded in Japanese.

Here again I just spent half my night recovering everything that could be. Unfortunately all Japanese content for entries posted in June and early July is lost for good: not like it had much literary value, but still a bummer. And in case you are wondering about backups: believe me, I have backups, hundred of them… It just turns out that this piece of crap SQL isn’t even able to properly back up an exact binary copy of your tables that won’t screw up when it encounters encodings it can’t handle properly. So every single backup I have, is identically screwed.

My last personal piece of advice to any mySQL user out there, is to stay away from mysqldump do a freaking binary copy of the db files directly.

And for once: geeky news of interest to the non-geeky crowd…

For the past few days, I have been spending every available minute on a brand new pet project. I was finally able to release a first prototype yesterday (well, this morning really, but that was before going to sleep, round 5am).

bCal is, to be short, an “event aggregator”: it collects event announcements scattered across blog entries into a calendar where they can be subscribed to (from a desktop application, like Apple iCal) or viewed online (through a PHPiCalendar interface) by anybody.

A few features of bCal:

Continue reading