Wednesday, May 31
Future files - and eventually, past files as well - will appear here.
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.
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 bakfile=sys.argv outfile='header.dat' f=open(bakfile,'r') g=open(outfile,'w') while 1: t=f.readline() if t[0:20]=='-- Current Database:': db=t[22:-2] print db g=open(db+'.dat','w') g.write(t)Use: python dbsplit.py <filename>
Tuesday, May 30
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.
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.
Monday, May 29
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.
Do not trust the lolis.
They cheat at cards.
Hale is Charlie Brown.
Guu is Lucy.
Sunday, May 28
The first dozen AMVs are available now.
I've linked back to the creators' pages at animemusicvideos.org so that if you like a particular video you can find what other work they've done.
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.)
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.
Friday, May 26
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.
57 queries taking 0.4474 seconds, 348 records returned.
Powered by Minx 1.1.6c-pink.