Log Analysis of a newpaper website

This is an exercise to make PostgreSQL queries on a database using python as a web server. Queries are done on a log database of a news paper server.

Built with

Python 3.6.4, PostgreSQL 9.5.11, Ubuntu 16.04.3 LTS VM on Vagrant

Extract newdata.sql from newsdata.zip file, which is a PostgreSQL database dump.
Connect it to a PostgreSQL database named news with psql -d news -f newsdata.sql.
- If you wish to name your database with a different name, then it has to be updated in the python code logAnalysis.py where the get function tries to connect to the database.
Run the logAnalysis.py using python 3.
Open localhost:8000 or 127.0.0.1:8000 in any browser.
Wait for a while for the queries to run and load the results.

Python code logAnalysis.py runs a simple python server (for ever) on localhost:8000 address.
As soon as it gets a HTTP GET request, it connects to the news database and sends three queries (PostgreSQL) for the three questions from the exercise description.
Results are sent back as plain text with a 200 status code.

Note: News database was setup initially on a Linux VM (Vagrant).