Dotnet(Blazor) + Postgres: Stream table CRUD notifications using NOTIFY/LISTEN
This post is inspired by this other post with a couple of performance improvements: we will use DB Context Factory instead of Npgsql, and bundle notifications to prevent backpressure condition. First, let’s look at this query we need to run. It creates a trigger function that will dispatch our notification whenever a new row is…
Read more