Recovering a lost Aperture 3 library

The battery on my 2008 15″ MacBook Pro is dying an ugly death. Last night the battery level dropped precipitously as I imported pictures from an SD card into Aperture 3. When the battery level reached about 75%, the MacBook shut off in mid-import.

I plugged the computer in and rebooted, expecting to complete the import. Not so. Aperture 3 quit unexpectedly every time I tried to launch it. I ran (or tried to run) the built-in diagnotic trio of Repair Permissions, Repair Database and Rebuild Database  by holding down the Cmd-Option combo while starting Aperture. Aperture happily repaired permissions, but quit while trying to repair or rebuild the DB.

I was able to start Aperture with a fresh library, so I determined that it wasn’t the Aperture prefs or executable that were causing the problem.

But how could I get my 64 GB of photos back in some coherent form? Any attempt to import the contents of the corrupt Aperture Library into a new empty library resulted in “The Crash.”

I right-clicked on the Aperture Library and used “Show Package Contents” to navigate to the folder containing all of the masters (original JPEGS and RAW files). I decided to import the contents of the Masters folder into a new Library.

This procedure worked, but my Projects and Albums were all still toast, as were my Faces and Places data.

Faced with the prospect of having to restructure my photo library from scratch, I cast about on the Internet and found this little gem, which I want to share:
Aperture 3 rebuild library – SQLITE MISUSE
The procedure outlined in this post basically involves deleting the SQLite database files that make up the Aperture Library and then forcing the Library to rebuild from scratch. I can only surmise that I couldn’t do this before, because Aperture was choking on the original, corrupted database files while trying to rebuild.

A word to the wise: Always backup your computer.


I use to keep track of new updates for the software
that I use. Some software programs seem to be updated on an almost
daily basis. I can help but wonder if this is a case of
“versionjacking”; issuing incremental updates so as to always be in
the list of updated software.

My impressions of Mac OS X 10.5 (Leopard)

I tend to be an early adopter of new technology (when I can afford to be!). When the ship date for the version 10.5 of Mac OS X a.k.a. “Leopard” was announced earlier this month, I placed my order right away.I received the DVD on Friday, October 26th, the day of the official release and proceeded to install it on my MacBook Pro as well as my older G5 tower.

My first impressions are emphatically positive. As far as overall system upgrades go, this is more an upgrade of “tweaks” and enhancements then a paradigm shift for the operating system. Not only are many welcome new features both major and minor added, there are are also a plethora of “fixes” that add to the overall consistency of the OS. The upgrade performs well on both the Intel-based MacBook Pro as well as the older PPC G5 (a dual 2.3 GHz processor). Finder performance seems zippier than previous iterations of the Mac OS.

Here’s a short list of what I like (in no particular order):

  • Consistent views in every app, modeled after the iTune look and feel. The graphite color scheme has infected every part of the OS, and though it may be an acquired taste for some, it is consistent and easy to get a handy on what to look for in every program.
  • iChat adds some eye candy in the form of funky effects and backgrounds, but the real power comes in the form of iChat Theatre, which allows users to share screens, media files and images in the chat window. Also new in Leopard is the ability to be logged into multiple .Mac/AIM accounts simultaneously. The look of the chat window can also be customized to fit various screen sizes.
  • Spotlight now has real boolean search capabilities, and many of the performance issues of Tiger’s version of Spotlight seem to have been resolved.
  • Mail is much more of a full-featured program, incorporating task lists and notes into the mix.
  • Time Machine: backups without thinking!
  • Safari’s web clips feature allows you to save a page or a portion of a page as a Dashboard widget (great for RSS content).
  • Networking in Leopard is much simpler. Most connections can be made aith a minimum of fuss and managing networked printers has been a snap so far.
  • System preferences make a lot more sense, and many of the options have been simplified (and the geeky stuff hidden behind an “Advanced…” button.

Of course, there are always some rough edges or annoyances to any OS, especially a new one. Here’s my list of beefs:

  • The new dock makes for attractive eye candy, but it is sometimes hard to tell which apps are running with a quick glance.
  • It would be great to be able to change the size of the font in a Finder Window’s sidebar.
  • The downloads icon in the Dock assumes the icon of the last thing you downloaded, so it’s always in flux and it screams to your colleagues that you use Bittorrent!
  • It’s great that we can have so many connections open in iChat, but why do they all have to be in their own window? I much prefer Adium’s integration of all my Buddy lists into a single window.

I am sure that I will find more stuff to love and to dislike as I get deeper into using this OS on a regular basis, but so far, the impression is good.

NECC – June 26, 2007 in Review

The final full day at NECC was a full one. The day began with a bus tour of the Atlanta area. Did you know that Elton John lives for part of the year in Atlanta? We toured through the downtown area of Atlanta and drove through one of the more upscale neighbourhoods, admiring stately homes.

The bus stopped at the Atlanta Cyclorama, which is a huge panoramic painting depicting one of the key battles of the American Civil War. Afterwards, the tour continued on to Dr. Martin Luther King Jr.’s birth house, as well as the church where he was a minister. Both of this sites are now historical monuments.

The afternoon was devoted to presenting LEARN’s Virtual School project at an afternoon poster session entitled “Learning Environments.” We spoke to interesting people from all over the place. There was a woman from Perth, Australia who expressed some interest in what we were doing. We spent quite a bit of time speaking with a colleague from New Brunswick about their Virtual High School project. It will be interesting to follow up with them and compare notes as we move forward.

The evening was spent attending a reception at CNN Center hosted by Apple Canada. After some lively conversation with Canadian colleagues and Apple representatives, we enjoyed a fascinating tour of the CNN facilities.