February 2, 2011 8:56 PM Subscribe
I need some advice on how to build a database-driven site around an archive of ephemera (mostly flyers). Essentially, I want to build an online archive of scanned rave flyers from the Toronto-London-Detroit rave scenes (plus some Midwest US flyers). Here's what I have:
Here are my resources so far:
- a dusty file folder full of about 10 lbs worth of flyers, pamphlets, and mini-zines from the rave era from 1995 to the early 2000s.
- through a university library, access to a scanner where I can get full-color images
- an undergraduate minor in comp sci, which gave me some basic project-development workflows plus an intimate knowledge of C++, Java, and Perl.
- Some experience coding HTML and CSS, particularly through Dreamweaver (which also does PHP)
- Some self-taught proficiency with MySQL and PHP
- An installation of MySQL on my home computer for testing
- space on a server with MySQL and PHP activated.
So, I want to be able to scan a pile of these flyers, attach metadata of various sorts to them (location, date, headliners, description of event, etc), and present them as a searchable, web-accessible archive. Any advice? re: platforms, data structures, useful utilities and tutorials, examples to work from, etc…
I'm a bit of a bedroom coder and actually get a kick out of coding things by hand from the ground up, so I'm not looking for solutions that involve plugging one online app into another and putting a glossy skin over it.