Posts

CockroachDB has an internal table that shows all locked rows. With a simple query, you can find out a lot about what is locked, and maybe the cause.

With CockroachDB, you can lock rows or whole tables using SELECT FOR UPDATE. This post explains how it works, and how to avoid locking too much data.

Just for the sheer joy of it, here is a simple C# program that encodes Morse code messages and plays them on Windows and Linux.

Chromium based browsers like Chrome, Edge, and Brave make it very difficult to clear cookies for specific sites. Here is the easy way to do it.

This is an update to an earlier post on caching Tasks and only executing them when first accessed. This version uses Lazy<Task> to hold the Task.

Did you know you can define parameters up front in a lambda, and satisfy a Func or Action with a method that doesn’t match the definition of the Func/Action?

Here’s a simple example of using a lock in a Web API action method. But you probably shouldn’t.

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.

I’ve been using CockroachDB for a while, generally accessing via the command line or from C# applications. When I tried to use via DataGrip, the connection properties were not immediately obvious.

InfluxDB is a time-series database that is great for storing and querying time-based data. This post shows how to set it up with Docker and access it from a C# application.