Analyzing iMessage, PerlMagick PDF pages, and GeoIP database

Mon 18 Apr 2022

Analyzing iMessage with SQL

Message is one of the most popular messaging platforms today, largely because it is built into iOS and Mac devices. Since its release, it has evolved significantly. But, at its core, it is simply an instant messaging platform. iMessage uses SQLite in the background to store relational data about messages, conversations, and their participants.

Source: Analyzing iMessage with SQL, an article by Daniel Lifflander.

sqlite

PerlMagick PDF pages

It’s easy to get individual pages from a PDF with PerlMagick.

Source: PerlMagick PDF pages, an article by Flavio Poletti.

perl

GeoIP database from MaxMind

I’ve hit slightly less than 1.2 k banned IPs in a Fail2ban instance and I was curious about it, so I needed to translate a list of IP addresses into country names.

Luckily, IP::Geolocation::MMDB and a free DB by MaxMind made the translation possible and fun.

Source: GeoIP database from MaxMind, an article by Flavio Poletti.

perl