CockroachDB

CockroachDB and Postgres let you lock a row with a select if you intend to update it, but what if the transaction gets stuck and the row remains locked? The idle_in_transaction_session_timeout setting can help with this.

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

In a previous post I showed how to run CockroachDB locally using Docker, but there is an even easier way - run the executable for your operating system.

Using CockroachDb with Entity Framework is easy, here is a simple post showing how.

This post shows how to use a Dockerfile to start CockroachDB in single user mode.

Simple post on how to start CockroachDB in single user mode on Docker.