Someone else has noticed a one year lifespan for a modern XP hard drive

I have two corporate XP machines, and between then I have to replace a drive every six months. My home XP and OS X drives last for years.

So I now have two completely unrelated corporate backup systems that run nightly.

I haven't seen anyone else comment on the lifespans of corporate hard drives, so I liked this post (emphasis mine)...

DadHacker » Blog Archive » Thoughts while rebooting

On the IT-ridden machines I regularly have to swab out twenty megabyte log files, logs from things that I didn’t even know were running on the machine, and when I find something like “ArScnr38″ running I have no idea if it’s spyware or something that an IT monkey stuck on my laptop to scan my Excel spreadsheets.

It’s hilarious when four different scanners are fighting for disk access. No wonder our drives are dying after like a year in service. I don’t work late, so I can only imagine what the buildings sound like at 3AM when Windows Update goes into its happy dance and reboots every single workstation.

“Shhhh… wait for it.”

“What, Dad? I’m sleepy.”

“Any second now…”

clikclickClickClikCLIKCLICKCCLLIICCKK-CLICK-***KA-CHUNGGGKGKGKG!!!!!***

“Wow! Do the lights flicker like that in every time zone?”

“That was nothing. Wait until they all ask the DHCP servers for an address!”

...The IT philosophy of bloat appears to be: “Screw the user, we own the machines, and if they can’t get work done with them then they can’t do any damage. More scanners! And loggers! And Java-based enterprisey things with *****up XML configuration schemas! If there’s CPU or disk space left we’re not doing our jobs; we have to pay for that call center expansion somehow!”

That's what I see. Between my heavy duty database work, the antivirus scanner, the corporate HP monitoring systems, Windows Search indexing, and the two nightly backups the hard drivers are being worked to death.

I really need to switch to an in-office NAS with a hot-swappable RAID array -- so I can rotate out bad drives without the hassle of a restore.

Aperture's SQLite Database

I'm going to fire-up the SQLite Database browser and follow these directions: The Deep Dark Depths of the Database (and some fingerprinting) - Inside Aperture. I wonder what iPhoto is doing these days -- be interesting to look for SQLite files in other Apple applications.

I recall that SQLite was thought to have threading issues with 10.4. I wonder if that's better with 10.5.

A last lesson from our Samsung i500

I like my iPod. I liked the Palm Vx. I even mostly like my MacBook.

So I ain't impossible to please. Just not easy.

So it was hard so say the long good-bye to our Samsung i500s and all their accesories!

They were great tech for their day and today. Palm Classic goodness -- fast, super reliable, elegant. Graffiti One. Compact clamshells with good sound quality and an excellent form factor. Line 'em up against the iPhone and they do pretty well. Sure -- no mobile web. On the other hand, way more reliable and they have tasks too!

Alas, they gradually died. When my wife's failed we switched to AT&T for her BlackBerry and to line-up for my iPhone.

There was one major flaw of the i500 though -- and one related lesson. All the connectors were proprietary - and transient. No USB goodness (BlackBerry, Nokia 6555), and no evil-but-ubiquitous connector like the iPod -- just another one off from Samsung.

So, when a "free for anyone" listing on Craigslist got no hits, I had to toss everything out. Connectors, chargers, accessory cables, -- the whole bit.

That's the last lesson, though most of us have figured it out by now. Don't buy devices that use proprietary connectors -- unless they've made it to evil-but-universal status.

It's a great way to narrow your purchasing options ...

Introduction to the relational database

ATPM 14.04 - FileMaking: Getting Relational turns out to be a fairly comprehensive and quite readable introduction to relational database design. I didn't see anything that's FileMaker specific, it applies equally well to MySQL, Microsoft Access, Oracle, etc. (The promised f/u articles will be FileMaker specific.)

It's a handy reference to keep around for colleagues, students, etc.

Charles Ross covers a range of topics typically taught over the course of several lectures, so don't be surprised if it takes a while to get through the entire article. If you need to understand the topic, this is worth printing out and studying.

More iPhoto humiliation: the vanishing edited video

iMovie '08 is so abominable that it makes iPhoto look good ... by comparison.

Still, it's not hard to humiliate iPhoto, even if we forget that after 8 releases it still can't import a Library.

We know that iPhoto has a nasty video export bug that can result in total data loss. That's bad, but this is at least comparable:

1. Import 3ivx MPEG 4 encoded video with AVI wrapper into iPhoto.
2. Right click on the Edit button and open in QuickTime Pro.
3. Trim the video and save. QT Pro offers to save in .MOV format. Choose that.
4. Return to iPhoto. The video you see is the previous version.

Basically the "Edit" option in iPhoto doesn't work for Video. It should be "grayed out" and unavailable for selection.

I bet QA found this one in early testing of iPhoto '08, but product management decided it wasn't worth fixing.

They should be ashamed.

Firefox 3 beta: they didn't tackle the tab UI problem

I've been using Firefox 3 beta 5 with OS X. I've noticed a few problems -- windows initially appeared almost off screen, one window would abruptly close, but overall it looks like a good incremental improvement. It hasn't pegged my CPU yet, so that's encouraging. (Firefox 2 would do that without any help from Flash.)

Alas, they didn't do anything to tackle the multi-window tab UI problem. I was looking for a view that would render windows and tabs in a browseable outline view with tab names and mouse-over window views, but there's no sign of this.

Lesson from FLIP Video: your video is doomed

Petabyte-equivalents of home video have vanished over the past 40 years. Odd sized films, film degraded and glued together, beta tapes, odd VHS variants, digital tapes, digital disks, abandoned digital file formats ... there are many routes to the graveyard.

Things are not about get get better. I don't have any data, but I'm blogging -- I don't need any friggin' data.I'm guessing most video now is coming from cell phones, digital cameras, and new packagings like FLIP Video. So how well will this video do over the next 40 years.

Digital cameras commonly use "Motion JPEG" [1]. Mobile phones use all kinds of formats, but they're converging on a wrapper called "3GP", behind that wrapper are all kinds of semi-standard data formats. The FLIP Video camera the kids and I are using on our Wisconsin Dells holiday uses 3ivx, of which I recently wrote:

Gordon's Tech: FLIP Video Ultra camcorder: iMovie HD works, iMovie '08 doesn't

...Videos are in "AVI" format -- that's a metadata wrapper around a codec. In this case coded is 3ivx MPEG-4... 3ivx Technologies is hoping you'll buy the full version from them...

I ended up writing an extended post with lots of updates; I learned quite a bit about iMovie '08 (disgraceful, Apple shipped at least one year too soon [3]), QuickTime and QuickTime Pro, MPEG Streamclip, video formats, video codecs, editing software, etc.

I haven't quite figured out the optimal strategy for editing and storing FLIP Video 3ivx encoded video, but I think there's a very good chance the 3ivx files will be completely unreadable within 15 years. It's a completely proprietary format, with no particular reason to expect it to become a lasting "standard".

So what will last? Well, I'm betting reasonably compliant still image JPEG will be readable a hundred years from now [2], so I think Motion-JPEG video might persist. Motion-JPEG's simplicity makes it easy to edit too, assuming one doesn't try to convert from the highly JPEG compressed images to any lossy format. I'm not so sure about the sound formats though. DVD-Video without copy-protection might also be expected to last, but that simple name hides a lot of complexity and variation with sound and video compression standards and metadata wrappers.

So called DV-stream is one name given the streamed version of 'digital video' standard (actually is a standard), but a casual glance at Wikipedia reveals lots of room for incompatible variations on digital media. It does lend itself well to editing (no intra-frame compression) but it makes for huge data files. It's dying off as MPEG-4 and HDV "standards" take over.

Hmm. Sounds like a real mess. I've read lots of discussions about archival image formats, so I'm sure this Google archival video search will yield lots of great advice.

Well, as of April 2008, not so much great advice. Basically, no advice at all.

Those petabytes of lost home 8mm home film recording are about to joined by peta-giga-tera bytes of every conceivable unreadable combination of video, audio and metadata formats.

Don't get to attached to those precious video moments ....

-- Footnotes --

[1] I'm still figuring out what this corresponds to in QuickTime Pro's export menu. I think it's the JPEG export option that shows up in the video export list, but I've reason to suspect things are even more confusing than they appear.

[2] Assuming our non-human inheritors are curious about their precursors. JPEG is what I store my photos in, I assume the original RAW files will be absolutely unreadable within 10 years.

[3] Seriously. The more I play with it the worse it gets. For example: even the one or two video formats it can import aren't recognized when the same files are stored in an iPhoto repository. If anyone ever has the delusion that Apple has some special magical interest in their customers, they need to review the iMovie '08 story. I use a lot of Apple products, but they're not marvelous. They're only better than the alternatives.