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.
I wound Broadcast Machine back to version 20. I also whined pathetically over on their forums.
Anyway, I'll put some more goodies up tonight.
Thursday, May 25
What's the lifespan of a notebook battery these days?
I got my notebook last September, and at the time I could watch 3 hours of anime on a battery charge. I was editing the subtitles for Dirty Pair episode 4 on my way home yesterday, and the battery was dead by the time I got to Waitara; that's about 40 minutes. And that's less intensive than just watching anime, because I keep pausing the video while I edit the script.
Also, the power meter went from 10% to 3% in two seconds, which seems to be just a tiny bit abrupt.
I'm doing a test right now: 100% CPU, screen on, no disk activity; so far it's gone from 98% (which is where it is once you've booted from standby on battery) to 57% in 14 minutes. The 3% per minute seems to be pretty steady. Also crappy. Particularly since the last 10% is basically gone anyway.
16 minutes: 51%
20 minutes: 40%
22 minutes: 33%
24 minutes: 27%
26 minutes: 22%
28 minutes: 16%
30 minutes: 9%
32 minutes: 3%
34 minutes: 0%
36 minutes: 0%
38 minutes: 0%
40 minutes: 0%
41 minutes: URK
10 minutes: 72%
22 minutes: 38%
30 minutes: 14%
32 minutes: 9%
34 minutes: 1%
36 minutes: 0%
38 minutes: 0%
40 minutes: 0%
41 minutes: URK
Well, the full discharge and recharge didn't help a whole lot.
Went to upload some new files to Broadcast Machine. It informed me that a new version was out and that I should upgrade immediately. I did so, and it utterly ceased to function.
Installed the new version to a clean directory... twice... and it's working again, or at least not giving any errors. Of course, there are no files there either, but that's a relatively minor detail.
It also comes with some new themes, which while being prettier, use a different size for the images, so all the old images get rescaled in the browser and end up looking like crap. It still has the old theme, only it has changed too, so it ends up looking like crap anyway.
I'll post the new videos, or some of them, since I've spent the hour I'd planned on using to upload the new files beating my head against a wall instead. Then I'll upload the old files. Then I'll upload some more new files. Or something.
Update: Or not. This new release looks like a major downgrade. Bah. And bah again.
Update: One of the things that is particularly broken about the new version of Broadcast Machine is that instead of showing my lovingly handcrafted images on the individual torrent pages, it embeds the file. Yes, it takes your avi file - or your mp3 or zip or whatever it might be, but it assumes it's an avi - and sticks it right there on the web page. Of course, that only works in Internet Explorer 6; other browsers have quite an entertaining variety of ways of not working when they encounter this particular... trick.
Unfortunately, but unsurprisingly, their web site seems to have crashed, so I can't visit their forums to ask what drugs they were on when they decided that this was a good idea.
I was disappointed with one of the episodes of Dirty Pair I subtitled last month because there were some lines of dialogue that weren't translated. There were just gaps; no subtitles at all. Only a few, but still not the sort of quality I want for a MuNu Fansub. I thought the problem lay with the original translations, which were produced back in the early nineties when the fansubbing community was much smaller.
Because I never considered the possibility that a popular subtitle editing program would have a major bug relating to one of the most common subtitle file formats that could lead to the deletion of words or entire lines of dialogue without any warning.
I am now editing the subtitles for episode 4 in Wordpad.
Bruce Bawer talks about his book:
I was also shocked to hear people refer to immigrantsâ€™ European-born children as â€œsecond-generation immigrants.â€ And their children were â€œthird-generation immigrants.â€ This summed up an incredibly dramatic difference in the ways Americans and Europeans thought about immigrants. My fatherâ€™s parents were Polish, but never in my life had it occurred to me to think of myself as a third-generation immigrant or of my father as a second-generation immigrant. The idea was ludicrous. We were Americans, period.My father's parents were Polish. My father was born in England, but lived most of his life in Australia. I'm Australian, period.
Read the whole thing, depressing though it may be.
(Via Roger L. Simon)
62 queries taking 0.3641 seconds, 290 records returned.
Powered by Minx 1.1.6c-pink.