ClePy September Meetup - Logging, Postgres, and Python

We will be hosted at Happy Dog, in the Underdog (basement).

Meetup Agenda
6:00-6:30pm Social and Setup, Announcements.
6:30-7:30pm Presentations (see below)
7:30-8:00pm Social and Clean-up

When Logs Become Data: Building a PostgreSQL Logging Handler in Python
by Matt Wilson
Normally we write logs to stdout and stderr. But what if your logs could be queried alongside the rest of your application data? This talk uses logtopg as a case study for extending Python’s logging system with a custom handler that stores log records in PostgreSQL. We'll start with a crash course on logging in Python. Then we will explore the integration, database schema and indexing choices, logger hierarchies with PostgreSQL’s `ltree` extension, and the tradeoffs regarding failures and logging performance. This presentation is a practical look at making application logs searchable with SQL and deciding when database-backed logging is the right tool.

---
If you decide to not come to the meetup but initially RSVP yes, please change your response so we have a proper headcount and folks who are on the waitlist can attend.

Want to present a talk? Let us know on meetup or the #clepy channel on Cleveland Tech Slack.

Join the Cleveland Tech Slack group here: https://cleveland-tech.vercel.app/