Chipotle Social Media Site It has been a while since I wrote one of these, but a lot of progress has been made on the site since the last post! I finally got the PostgreSQL database set up and got a connection through code using Node/ExpressJS. I then proceeded to test adding reviews to the database and seeing what information would be necessary to store in order to pass information back to the website for viewing.

Chipotle Social Media Site Tough tough day today. I started the day by formatting the basic layout of the modal for the review page. This included sections for ratings 0-5 stars on food quality, quantity, staff quality, additional notes, and time taken to recieve food. This part went quite well and I was able to get example submissions working as well as resetting the values of the submission after closing/submitting a forum.

Chipotle Social Media Site Soooooo, I got side tracked a bit today. I noticed that for some of locations the address and name matched exactly. So, I did some digging and found that there are cross streets listed for each location that I could use as a stand-in for the name. However, I soon found out, that not all of the locations had these cross streets. I then thought “well, if there is only one Chipotle in a given city, then I can just use the city name as the name of the Chipotle.

Chipotle Social Media Site As I mentioned at the tail end of yesterdays blog, today was mainly to start work on moving the data to a database and figure out the API stuff However, when I started working today I found that I could just use Node.js to create the API server, and use a library to port the csv into json that could be used by the Javascript in index.

Chipotle Social Media Site Did some preliminary research yesterday and found that something very similar to what I want to do has already been done. The site has a map as the default background with pins for locations of Chipotle’s that you can click and see the rating and other information for. I would like to do something similar to this, but instead of just ratings and a few comments, I want to have a live feed, similar to Instagram, where you can see pictures and ratings of food that was just prepared at the location!