Name: How I used PostgreSQL® to find pictures of me at a party
Start: 2023-09-05T19:00:00+01:00
End: 2023-09-05T21:00:00+01:00

Our next meeting will start at 19:00 (7 pm) on Tuesday 5th September on Zoom.

**Tibs (Tony Ibbs) will give a talk**:

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

**Find out how to search for faces using Python, OpenCV, OpenAI and, yes, PostgreSQL®: at an event, a photographer can take many photos - which ones do you appear in**?

Nowadays, if you attend an event you're bound to end up with a catalogue of photographs to look at. Formal events are likely to have a professional photographer, and modern smartphones mean that it's easy to make a photographic record of just about any gathering. It can be fun to look through the pictures, to find yourself or your friends and family, but it can also be tedious.

At our company get-together earlier in the year, the photographers did indeed take a lot of pictures. Afterwards the best of them were put up on our internal network - and like many people, I combed through them looking for those in which I appeared (yes, for vanity, but also with some amusement).

In this talk, I'll explain how to automate finding the photographs I'm in (or at least, mostly so). I'll walk through Python code that extracts faces using OpenCV, calculates vector embeddings using imgbeddings and OpenAI, and stores them in PostgreSQL® using pgvector. Given all of that, I can then make an SQL query to find which pictures I'm in.

Python is a good fit for data pipelines like this, as it has good bindings to machine learning packages, and excellent support for talking to PostgreSQL.

You may be wondering why that sequence ends with PostgreSQL (and SQL) rather than something more machine learning specific. I'll talk about that as well, and in particular about how PostgreSQL allows us to cope when the amount of data gets too large to be handled locally, and how useful it is to be able to relate the similarity calculations to other columns in the database - in our case, perhaps including the image metadata.

**Zoom link provided on the day via email ([enable email notifications for Meetup](https://help.meetup.com/hc/en-us/articles/360002879591-Editing-my-email-settings)) and Zoom link added to Meetup 1 hour before the meeting starts on event page.**

Zoom is configured to start muted and with video off - so feel free not to share video if you prefer not to. There's no fixed time for stopping - we'll see how it goes.

Remember that everything we do must follow our [code of conduct](https://github.com/campug/organisational/blob/master/CodeOfConduct.rst). Basically, be considerate to each other.

And lastly, feel free to [join our slack group](https://join.slack.com/t/campug/shared_invite/enQtMzM2NjcwMzM2ODM2LTQyMmQ5MmVlZGMxMzBhOGQ0MTQ1ZGMyMTkzYjc1MWQzM2M2ZDViZDc5NDEyYmViY2QyNWJlMjg2ZTkwNzc3NjM) for general discussion before and after the meeting.

Hue Holleran (&DEV)

Cambridge Python User Group (CamPUG)

Technology

Python

Agile and Scrum

Software Development

Programming Languages

Computer Programming

Python Web Development

Linux

Open Source Python

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

Online event

Share

Cambridge Python User Group (CamPUG)

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

Cambridge Python User Group (CamPUG)

Details

Members are also interested in