PGDay UK2026

Getting your amateur radio license opens up all sorts of fun. One interesting example is Active Packet Reporting System (APRS), basically sending your location information out over the airwaves. The data is gathered up and available on a web site, APRS.fi. However, you only get limited reporting from the data there. In order to have more fun with that data, I've built a Lambda Function on AWS to pull data into an Aurora PostgreSQL database that has the postGIS extension. With all that in place, I can then use my APRS data in much more interesting ways to display all sorts of exciting reports thanks to the functionality offered through postGIS. This session will be focused on showing you how all the processes are brought together in order to demonstrate just how much you can do with PostgreSQL and postGIS. Putting PostgreSQL to work doesn't have to be hard, especially on fun projects.