In this project, you'll work with data that could have come from a real-world web application, with fields representing information that a web server would record, such as HTTP status codes and URL paths. The web server and the reporting tool both connect to the same database, allowing information to flow from the web server into the report.

• Python2
• Vagrant
• VirtualBox

1. Install Vagrant and VirtualBox
2. Download or Clone fullstack-nanodegree-vm repository.
3. Download the data from here.
4. Unzip this file after downloading it. The file inside is called newsdata.sql.
5. Copy the newsdata.sql file and content of this current repository, by either downloading or cloning it from Here

1. Launch the Vagrant VM inside Vagrant sub-directory in the downloaded fullstack-nanodegree-vm repository using command:

  $ vagrant up

2. Then Log into this using command:

  $ vagrant ssh

3. Change directory to /vagrant and look around with ls.

1. Load the data in local database using the command:

  psql -d news -f newsdata.sql

The database includes three tables:

• The authors table includes information about the authors of articles.
• The articles table includes the articles themselves.
• The log table includes one entry for each time a user has accessed the site.

2. Open Postresql by typing psql.

3. Use \c news to connect to database.

4. Now exit Postresql by hitting Ctrl + 'D' on your keyboard.

1. From the vagrant directory inside the virtual machine,run logs.py using:

  $ python3 log.py