I am creating a biographical database of historical photographers. I am not a programmer, alas, and am learning drupal (thru WebMatrix) for my first adventures in building a website. Hello world!
I don't yet have my info in SQl, so I'm getting a bit ahead of myself, but I'd like to toss this issue out. I have ~85,000 entries in a spreadsheet. Each entry contains the following:
Name (comprised of Title, First, Family, and Suffix fields)
Nationality
Date (either life dates, or dates of activity)
Public repositories who report owning samples of the photographer's work (I have indexed about 20 large museum/library collections)
Bibliographic sources such as other academic databases or websites, or published books or journals with information on the photographer.
Biography (a free text field for further development once I can nail down some core facts!)
Places active (also not currently much used, but will be important going forward.)
I will have questions and will need advice from the community on each of these in the future (so thanks in advance to all for any insights, sincerely!)