Postgres

There are multiple timeouts to work with when using Postgres and CockroachDB. These can help prevent single statements from running too long, stop transactions that are idle or taking too long, and release locks.

There are times when it is necessary to use handwritten SQL with Entity Framework Core. In this post I should how to do that, and to mix it with the usual fluent statements.

With CockroachDB and Postgres, combining the SELECT FOR UPDATE and SKIP LOCKED statements can help you handle concurrent access to the same table.

It’s not a problem to use Postgres C# and .NET. You can also use Entity Framework.

A simple example of running Postgres in Docker with a password set, and a port exposed.