News for hackers. Stuff that matters.
Re: by alongub on Tuesday January 09, 2024 @10:12AM (#38927064)
There's a really neat pattern for building stateful apps on Postgres that can handle millions of entities concurrently.

Traditionally you'd need Kafka / RabbitMQ / other external components. But FOR UPDATE SKIP LOCKED basically make these redundant for some types of applications.

I found it particularly useful for building LLM-based agents that can transition between different states.

I created a short video to demonstrate the concept: https://youtu.be/VvDHi-H0Jck?si=WuUhUyIOuZ6jj8BO

Hope you find it useful!

There are no comments on this comment yet.