Hivemind: Creating the ultimate Rolodex
This is more of a discussion prompt than a specific question. Maybe there's already an off-the-shelf software solution for this, or maybe it's something I'll have to build for myself. I want to create a private searchable, database that will allow me to index all of my contacts, call records, notes, and recordings, and supporting documents. For example, when I get a new source, I want to be able to assign that person an identifying number and key in his or her name, telephone number, job title, and other contact information. I also want to be able to key in the date of first contact, the name of the person who introduced us, the dates and times of each subsequent communication, and links to any notes or audio generated in that communication. I'd like to be able to tag various records by story as well. So, let's say that I talked to Jane, Sam, and Bob for the XYZ story. I'd like to be able to search for "XZY story" and see all the sources I talked to, the days on which I talked to them, and links to the notes and audio from each call. Is there any existing software that will enable me to do this efficiently? I'd like to stay away from giant Excel files, if at all possible.
Update: I run OSX.