This is an internal reporting tool that uses information from the database to discover what kind of articles the site's readers like.
The given database contains newspaper articles, as well as the web server log for the site.
This program was built in Python3 and PostgreSQL and it runs from command line. There is no user's input. The program connects to the database, uses SQL queries to analyze the log data, and print out the answers to questions:
- What are the most popular three articles of all time?
- Who are the most popular article authors of all time?
- On which days did more than 1% of requests lead to errors?
This is a project submission for Udacity Full Stack Web Developer Nanodegree Program.
In order to run and make changes to this project, you'll need:
Projects files and Modules:
- Download the data sample for this project
- Download or clone this project repository
- Install the psycopg2 module:
pip3 install psycopg2
Make sure to save the data sample file newsdata.sql inside project directory.
Build the database
- Load the data to a local news database:
psql -d news -f newsdata.sql - Create the VIEWS into the database:'
psql -d news -f sql_views.sql - Connect to the local database:
psql -d news
Run the program
python3 reporting_tool.py
Understanding the files:
reporting_tool.py The program.
results.jpg The program results screen.
sql_views.sql The file to create the VIEWS.