Deep inside Aperture

I'm assuming everyone woke up today wondering, "golly, what's in that internal database used by Aperture?" Of course. As if by divine inspiration, Fazal Majid (who used to use NeXT computers) has your answer. If there's one thing to take away from this it's the fact that Apple is being very smart. Yes, you knew this. In fact, the database inside Aperture uses SQLite3. SQLite is an open source relational database engine that's quite reliable and easily embedded. In this case, it's Aperture using it, although SQLite is found in the Core Data framework too. Another example of Apple's use of open source engineering, while hiding the details of such geekery from the masses. Not that I consider Aperture a mass-market product... Anyway, Fazal has a little data dump on what's inside that there database, for what it's worth.