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
FFmpeg is a set of highly-capable video processing libraries and tools available for free on Windows, Mac and Linux. I had used FFmpeg occasionally in the past for various one-off video operations and was delighted to find that it could also be used to convert time lapse image files into a video. [Continue reading...] Making Time Lapse Videos From JPGs
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
While RAW files provide much more information to work with, you may find support for different manufacturers RAW format lacking in tools and libraries that you may have used in the past. This post briefly covers extracting Exif metadata from most RAW file formats with python. [Continue reading...] Extracting RAW Photo Exif Data With Python
Google provides a REST API for Search Console along with several language libraries that simplify interacting with it. There are quickstart guides for python and Java, however I found the Java examples somewhat lacking and as a result decided to put together this post to help augment the documentation Google provides. [Continue reading...] Google Search Console API - Java Example
