Talk: How I used PostgreSQL® to find pictures of me at a party

Source and slides for the talk "How I used PostgreSQL® to find pictures of me at a party", given by Tibs:

1. At PyCon UK 2023. The video is available on YouTube.

2. At EuroPython 2024. The video will be linked when it is available.

A talk about using Python, OpenCV, OpenAI CLIP, PostgreSQL and pgvector to find pictures containing a given face, and why that might be a good thing to do.

This talk is based upon and inspired by the tutorial Image recognition with Python, OpenCV, OpenAI CLIP and pgvector. There's also a GitHub repository with a Jupyter notebook showing working code for that tutorial.

Note an early version of this talk was rehearsed at CamPUG on Tuesday 5th September 2023.

There are two directories here:

• slides contains the sources for the slides themselves, as well as a PDF of the slides.
• src contains the Python programs I used when following the tutorial.