PMTiles is absurdly great software.
My only gripe is that the tile metadata is stored as JSON, which I get is for compatibility reasons with existing software, but for e.g. a simple C program to implement the full spec you need to ship a JSON parser on top of the PMTiles parser itself.
I know right! I'd never heard of HTTP Range requests until PMTiles - but gee it's an elegant solution.