PicShare is a social photo-sharing website using Ruby on Rails and SQLite.  It has features like photo-tagging, photo-uploading, commenting, logging in, friending, etc.  It was part of the final project for CS142.