it's a python program that answer some questions about database from analyzing data. the 3 questions the program answer is:
- 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?
To run this program you have to install:
- Vagrant
- Python
- Python3
When you run vagrant with vagrant ssh and connect the database using psql dbname
you should create those views :
create view terrors as select date(time), count(*) as errors from log where status != '200 OK' group by date(time) order by date(time);
create view errors_prcentage as select to_char(tresponses.date, 'FMMon FMDD, YYYY'), ((errors*10000)/responses)*0.01 as percentage
from tresponses join terrors on tresponses.date=terrors.date order by percentage desc ```