Now? You want to do this now?
I have a right to know! I'm getting married in four hundred and thirty years!

Wednesday, May 31


Bulletin Bulletin Bulletin

Future files - and eventually, past files as well - will appear here.

Posted by: Pixy Misa at 08:26 AM | Comments (2) | Add Comment | Trackbacks (Suck)
Post contains 19 words, total size 1 kb.



I uploaded a couple more videos, and Broadcast Machine lost the plot completely. So I've (a) switched it back to flat file mode, and (b) given up on it entirely.

I'll just do it as a Movable Type blog, I think.

Posted by: Pixy Misa at 07:37 AM | No Comments | Add Comment | Trackbacks (Suck)
Post contains 43 words, total size 1 kb.



Let's say you have a MySQL backup made using mysqldump -A, which dumps all the databases on the system into a single file. But you only want to restore one of the databases, which consists of about 300KB in the middle of a 1.7GB SQL dump. And you're not sure if you want today's file or yesterday's or the day before's. How do you find the right one? How do you restore it easily?


import sys
while 1:
  if t[0:20]=='-- Current Database:':
    print db
Use: python <filename>

Posted by: Pixy Misa at 12:38 AM | No Comments | Add Comment | Trackbacks (Suck)
Post contains 100 words, total size 1 kb.

Tuesday, May 30


Daily Dose

Up now in the clips library: the opening and closing credits of Tweeny Witches (DVD version; edited down slightly from the original versions I posted), and the opening credits for Cutey Honey, Cutey Honey Flash, the Cutey Honey live action movie, and Re:Cutie Honey (spelling variable; since the creators aren't consistent I don't see why I have to be).

I'd like to add the credits for New Cutey Honey, but I only have it on VHS. If anyone out there has it on DVD, particularly if it comes with a textless version of the credits, please leave a comment.

Update: FNORD!!

Broadcast Machine seemed to be a bit slow doing updates of late, and even when displaying the galleries. It's supports MySQL, but you can use it without - after all, a simple text file should be fine if you're only going to have a few dozen items, right?

Well, evidently not, because when I reconfigured it to use MySQL just now it suddenly got much, much faster. How anyone could screw up the performance on such a small dataset so badly is beyond me, but they did. Well, that would all be of little import; just tell everyone to use MySQL. Except that if you switch to MySQL at a later date it randomises the sequence of all your files.

Fnord. Fnordling fnordy fnordness.

Update: Tried hacking the code. The database code in Broadcast Machine is mind-boggling bad. As bad as Movable Type. Possibly worse.

This is a common feature of open-source web apps. The people who write these apps don't have a clue how to cleanly interface with a SQL database. Of course, they're programming in PHP or Perl, so it's something of a case of "you can't get there from here", but the ways they find to make a bad situation worse can be entertaining. If you don't have to fix it, that is. And I do.

So far I've managed to break the channel display; none of my other changes have made the slightest difference. Why? Who knows. There are two different interfaces to MySQL, both of which replace the standard flat file storage system, which is in turn utterly broken.


Update: You know what the really great thing about Broadcast Machine is? When you try to upgrade or reconfigure it, and it infallibly goes wacko , you can downgrade it by reversing whatever you did - and get it back in a working state.

Update: Ye gods and little fishes! It takes THIRTY SECONDS for Broadcast Machine to pull 47 entries from a text file, sort them, and display the page. I originally thought it was my browser waiting for images to download or something, but no, it's taking THIRTY SECONDS OF CPU TIME. On a 2.8GHz Pentium D. It shouldn't be taking so much as thirty milliseconds.

Update: Back to MySQL. Enjoy your high-speed randomness. I'm going to bed.

Update: Apart from the fact that it doesn't work, it has this cute little trick: Every time you look at a listing of any of the channels, it sucks the entire database into an array. Oy.

Posted by: Pixy Misa at 07:57 AM | Comments (3) | Add Comment | Trackbacks (Suck)
Post contains 526 words, total size 3 kb.

Monday, May 29


Work In Progress

Via The Commissar, Ambient Irony as a graph:


The Java applet that generates this is still chugging away, so I'll let it run overnight and see what it looks like in the morning.

Posted by: Pixy Misa at 09:14 AM | Comments (3) | Add Comment | Trackbacks (Suck)
Post contains 39 words, total size 1 kb.


A Relatively Uninteresting Case of Dismemberment

Do not trust the lolis.

They cheat at cards.

Higurashi no Naku Koro ni.

Posted by: Pixy Misa at 08:07 AM | No Comments | Add Comment | Trackbacks (Suck)
Post contains 26 words, total size 1 kb.



Hale is Charlie Brown.
Guu is Lucy.

Posted by: Pixy Misa at 05:06 AM | Comments (4) | Add Comment | Trackbacks (Suck)
Post contains 9 words, total size 1 kb.

Sunday, May 28



The first dozen AMVs are available now.

I've linked back to the creators' pages at so that if you like a particular video you can find what other work they've done.

Posted by: Pixy Misa at 08:54 PM | Comments (13) | Add Comment | Trackbacks (Suck)
Post contains 34 words, total size 1 kb.


More Clips

Uploaded today: The high quality, un-subtitled (but not textless) versions of the Haruhi opening and closing, and all versions of the opening and closing credits for Galaxy Angel. (Some of these were available previously in the Clips and Clips2 collections.)

All available here.

I'm going to make all the clips available for individual http download, but that will take a little while, as there are now 155 of them. I also have about twenty AMVs to upload. None of them are my work; they're just ones I've particularly enjoyed.

Posted by: Pixy Misa at 06:32 AM | Comments (4) | Add Comment | Trackbacks (Suck)
Post contains 93 words, total size 1 kb.

Friday, May 26


Tin Toy

New goodies up in my anime clips collection: Opening credits for Sasami - Mahou Shoujo Club, opening and closing credits (and closing credits and closing credits) for Renkin San-kyuu Magical? Pokaan, and opening and closing credits for The Melancholy of Haruhi Suzumiya.

Most of the closing credits for MagiPoka are Matroska files, .mkv, rather than the usual avis I provide. There is a reason for this, but you will need a Matroska aware player to discover what it is. You should be able to get Windows Media Player to do the job; my current preferred alternative (since BSPlayer went crapware) is The Core Media Player. It's not pretty, but it works well enough.


Oh yes: BitTorrent trackering is currently rather messed up, so they're enabled for direct download. Try not to devour all my bandwidth.

Posted by: Pixy Misa at 08:24 AM | Comments (7) | Add Comment | Trackbacks (Suck)
Post contains 140 words, total size 1 kb.

<< Page 1 of 5 >>
78kb generated in CPU 0.0593, elapsed 0.3206 seconds.
57 queries taking 0.2749 seconds, 394 records returned.
Powered by Minx 1.1.6c-pink.
Using http / / 392