tags

Sqlx

One Lock to Rule Them All

How to simplify migrations thanks to postgres advisory locks using rust and sqlx. Observing the locks with bpftrace.

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.