Parsing Apache Logs Into A SQL Database

Parsing Apache HTTPD access logs into a database structure allows you to easily run queries and reports against it to better understand web traffic and detect issues. By using the pip installable apache_log_parser package and the sqlite3 python module that comes as part of the standard python library, we can quickly parse these access logs and insert entries into a sqlite3 database. [Continue reading...] Parsing Apache Logs Into A SQL Database

Photo Slideshows Using Raspberry Pi And feh

At a family event just shy of a year ago I wanted to set up a slideshow (two in fact) to run continuously. The event was outdoors and leaving two laptops exposed to the elements for an extended period of time was obviously not very appealing. Instead a couple of Raspberry Pis together with the feh image viewer proved to be the perfect fit. [Continue reading...] Photo Slideshows Using Raspberry Pi And feh