Has anyone made an attribution database? Any advice?

Has anyone made an attribution database? Any advice?

Death's Darling's picture

I've been looking for an efficient way to store attributions for my game; I want to be able to store what user contributed what and the associated licenses, so I can use script to export them into a complete credits page. I'm mostly using the LPC collection, so a lot of my things are CC-by-SA. It's also something of a building game, using procedural generated landscapes and lots of content in build menus, landscapes, ect.

Has anyone done this before? What tends to work most efficiently? Right now I'm looking at a SQLite database, but I'm drawing a blank on how to handle chains of changes by multiple authors, or that a lot of the LPC stuff is in mixed atlas packs.

Or... is it just easier to go through it all by hand and hope you don't miss anything? (Sorry if this has been discussed before; google wasn't showing me much on the subject.)