One Lock to Rule Them All
How to simplify migrations thanks to postgres advisory locks using rust and sqlx. Observing the locks with bpftrace.
tags
Postgres
Proving SQLx’s Statement Cache with bpftrace
SQLx prepares and caches every query you run, transparently, in an LRU that belongs to the connection rather than the pool. This post traces the Postgres wire protocol with bpftrace to watch what is happening under the hood.