PostgreSQL
7 articles tagged with PostgreSQL.
GDPR data export and account erasure in an ASP.NET Core SaaS
Learn how to implement a GDPR data export and a real account erasure in a modular ASP.NET Core application, without breaking domain boundaries or other people's history.
7 min read
A migration runner instead of Database.Migrate() at startup
Learn how to move EF Core migrations out of your services and into a small worker that runs once, exits, and gates everything else.
7 min read
Idempotent message handlers in .NET: deterministic IDs from the message ID
Learn how to make a .NET message handler idempotent by deriving the ids of the rows it writes from the id of the message it consumes.
7 min read
Optimistic concurrency with PostgreSQL xmin in EF Core
Learn how to let exactly one of several writers win the same row, without locks, using PostgreSQL's xmin column as an EF Core concurrency token, plus a claim and a lease.
7 min read
Testing EF Core repositories on a real PostgreSQL with Testcontainers
Learn how to test EF Core repositories against a real PostgreSQL started by Testcontainers, with the real migrations and one DbContext each to arrange, act and assert.
7 min read
Domain events vs integration events in .NET, and the transactional outbox
Learn the difference between domain events and integration events in .NET, and how a transactional outbox on EF Core and PostgreSQL makes an event exist if and only if the change committed.
7 min read
Strongly typed IDs in C# with EF Core and PostgreSQL
Learn how to replace primitive int keys with strongly typed IDs in C#, and wire them into EF Core, HiLo sequences on PostgreSQL and your API controllers.
7 min read