Link: http://itp.nyu.edu/~yy600/DWD/port/
My mid-term is less a website and more just me figuring out how to orient everything I’m doing in a more modular way. I ended up doing a lot of reinventing the wheel (e.g. parsing tags, etc).
The long-term goal is to create a lightweight CMS for myself that will function as the back-end to a portfolio site that will hopefully afford more flexibility in design and be easier to maintain than say using wordpress.
DB Design
The basic unit of the CMS is a Project. Projects have a unique ID, Title, Year, Description, Images, Videos, Collaborators, Tags.
Collaborators and Tags simply have names and ids.
There are 2 linking tables to link Projects and Collaborators and Tags.
Images and Videos only ever belong to a single project.
Images have a filename and caption in addition to names and ids.
Videos have “embed code” and caption in addition to names and ids.
Where I’m At
Thus far, I have a DB in place and all project fields working except for images and videos. Obviously, the interface is also still bare-bones.