Logs Analysis

Logs analysis is a basic python code connected to database acts as a reporting tool that will use information from the database to discover what kind of articles the site's readers like. -- this is project is part of the full stack web developer nano degree by Udacity --

Prerequisities

• python 3.6
• postgreSQL database
• psycopg2

Installation

• download the data here
• run psql -d news -f newsdata.sql.
• run the logs_analysis.py file.
• open localhost:8000 in your browser

output

Database views definitions

we created one view called popular_articles for making queries simpler

create view popular_articles as
            select articles.title, count(*) as views
            from articles, log
            where log.path like concat('%', articles.slug )
            group by articles.title
            order by views desc ;

Authors

• Karim Tawfik