Building an Apple II games database


Filed under Game trail;
Comments Off on Building an Apple II games database

Whenever I’ve blogged about Brian Picchi, it’s been in the context of the games he’s made, such as Retro Fever or Deadly Orbs. But his latest undertaking is more meta and Sisyphean: a database of every 8-bit Apple II game.

The list, most recently updated on August 12, 2014, currently indexes the title, publisher, developer(s), year of publication, and media for 2,160 titles. The data are culled from such sources as MobyGames, GameFAQs, YouTube, and wikis

"It started both as a project Alex Lee and I were talking about, and because I was just curious as to how many Apple II games there are," said Picchi in an email to Apple II Bits. "Every site I had seen had under 1,000 games listed, despite claims of several thousand by other sources, including Apple."

But the database’s value is in more than just verifying or setting records. "I also thought it might be helpful because I hear lots of people asking questions like ‘What was that game from my childhood I can’t remember, I know it was in an issue of Microzine?’ or ‘How many games supported Mockingboard?’ or ‘How many games did Sierra release for the Apple II?’" continued Picchi. "The list is available to anyone who wants to use it for any purpose." Anyone who wants to contribute to the database may do so via Google Docs.

As a metadata junkie, I’m excited to see so much information being compiling and to consider how much more can be added. Data such as game genre, additional assets such as box art, and links to related resources, such as Virtual Apple II or the Internet Archive’s Console Living Room implementation of JSMESS. Picchi agrees: "I’d love to see it built into something like http://www.c64.com/ where you search for the game, can view screenshots, download it directly, etc."
Games databaseCollecting so much information is only half of this vast undertaking, with organizing and presenting it being another. The database is currently implemented using TablePress, one of my all-time favorite WordPress plugins. It’s a powerful tool, but one that is ultimately limited in how much data it can associate and present with a single software title. The database may be better served by creating a Content Post Type, which would allow the definition of fields and attachments unique to this database.

The end result would be exactly why I was briefly enrolled in a Master’s of Library and Information Science (MLIS) program: I love collecting and organizing information but lack the programming skills necessary to structure and host such vast quantities of data in a useful, meaningful way. But one thing I’ve learned about Picchi from reading his Juiced.GS article is that he’s constantly expanding his boundaries, mastering new languages and platforms. Could WordPress be next? If so, it will be to the benefit of Apple II gamers the world over!