ShowStash

ShowStash is a full-stack web application that tracks a user’s concert history. It allows users to search, add and view past concerts that they have attended.

http://showstash.herokuapp.com/

Technologies Used

• PostgreSQL
• Express
• AngularJS
• Node.js
• Bulma
• Angular Toastr
• Font-Awesome
• FileStack
• setlist.fm and last.fm APIs

Getting Started

Instructions to get ShowStash up and running on your local machine for development and testing purposes.

Prerequisites

• Node.js
• PostgreSQL

Installing

Steps to get the development environment running.

CREATE TABLE users
( 
    id SERIAL PRIMARY KEY,
    username VARCHAR(80) NOT NULL UNIQUE,
    password VARCHAR(80) NOT NULL,
    first_name VARCHAR(80) NOT NULL,
    last_name VARCHAR(80) NOT NULL
);
CREATE TABLE users_shows
(
    id SERIAL PRIMARY KEY,
    version_id VARCHAR(80),
    artist VARCHAR(80) NOT NULL,
    mbid VARCHAR(80),
    show_date DATE NOT NULL,
    show_date INT,
    venue VARCHAR(120) NOT NULL,
    city VARCHAR(80) NOT NULL,
    state VARCHAR(10),
    notes VARCHAR(256),
    setlist TEXT[],
    image VARCHAR(256),
    user_id INT REFERENCES users
);
CREATE TABLE friends
(
    id SERIAL PRIMARY KEY,
    first_name VARCHAR(80) NOT NULL,
    last_name VARCHAR(80) NOT NULL,
    user_show INT REFERENCES users_shows
);

App Screen Shots

Documentation

Scope Document

Completed Features

• Year-by-year listing of concerts attended
• Concert details including artist, date, venue, city, friends attended the concert with, show notes, and setlist if available
• Manually add new shows to the list of concerts attended
• Search past concerts to quickly add new shows to your concert history. Search powered by data from setlist.fm and last.fm
• Upload your own artist avatar to enhance the visual aesthetics of your concert history
• Timestamp added for login via Google or Facebook oAuth

Todos

• Cleanup pagination to not show everys page of results
• Pagination moved to bottom of search results. Top have a page x out of x
• Upload your concert photos to a concert specific photo gallery. Explore alternative to filestack
• Fetch new setlist information if available for a show
• Do not allow duplicate shows to be added
• Edit artist image by clicking on current image
• Auto suggest in the search shows feature

Authors

• Sam Fortin