Posts tagged "databases"

A concrete schema and concurrency model for mapping external IDs to internal entities without duplicates, cross-tenant collisions, or unsafe retries.

Two requests read the same row, both change it, and the second save quietly erases the first. A version number turns that silent bug into a conflict you can catch. Here is how optimistic locking works.

When you really delete a row, other systems can never learn that it is gone. A tombstone is a delete you can see. Here is why it matters and how to use one.

Offset pagination is easy to write and breaks in two ways: it gets slow, and it skips or repeats rows when the data changes. Cursor pagination fixes both. Here is the difference.

A tutor-style walkthrough of what a distributed database control plane actually is, why metadata is the crown jewel, where Raft fits in, and how to follow one request end-to-end to remember the whole design.