>seankerr.dev

These are my experiences in life and the past 2 decades of software development.

May 31, 2023

Released postgresql-lock

by Sean Kerr

I developed this software specifically for CartHero’s requirements, but wanted to release it to the public since we found it a critical when working at high scale.

The use-case was simple, we are firing hundreds and sometimes thousands of events per second and need to prevent conflicts when writing new records and updating existing ones. There are redis libraries available, but I’m strictly talking about PostgreSQL records. And keeping my locking mechanism as close to the database and with a guaranteed unlock on database connection exit was absolutely critical to our scenario.

If you’re using Python & PostgreSQL and our use-case sounds similar, consider giving postgresql-lock a try.