Re: Introduce contributor badges: image versioning?

From: Christoph Berg <myon(at)debian(dot)org>
To: Dave Page <dpage(at)pgadmin(dot)org>, Magnus Hagander <magnus(at)hagander(dot)net>
Cc: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, Daniel Gustafsson <daniel(at)yesql(dot)se>, pgsql-www(at)lists(dot)postgresql(dot)org, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, PostgreSQL Contributors <contributors(at)lists(dot)postgresql(dot)org>
Subject: Re: Introduce contributor badges: image versioning?
Date: 2026-10-16 16:00:25
Message-ID: atJKGa00GdsUheY0@msg.df7cb.de
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-www

Re: Dave Page
> That's fair, but items 1 to 3 still stand; the VCL limits how long the
> stale pages last, though:

Ack, I'll address these separately.

Re: Magnus Hagander
> Agreed, no need for URL versioning.

Thanks.

> > > - `badge_image` fetches the image and computes its MD5 before it checks
> > > `If-None-Match`; storing the hash would avoid both.
> >
> > badge_image is only reached on a Varnish miss, and on a miss we're
> > almost always about to serve the image anyway. Storing the hash only
> > helps the narrow (?) "Django itself receives a conditional request"
> > case.
>
> No, on the vast majority of misses we'd be serving a 304 Found with no
> content. Every time an image expires in any of the caches it would send a
> conditional request.

Is that enough to warrant storing the MD5 in a separate column? The PG
xx Contributor images I have here are all between 20 and 40kB in size.
(I.e. is that the fix we want?)

> (I have not looked at the rest, so I reserve the right to further review)

There will be patches coming for the other points soon.

Christoph

In response to

Browse pgsql-www by date

  From Date Subject
Next Message Christoph Berg 2026-10-16 17:21:33 Re: Introduce contributor badges - v14
Previous Message Magnus Hagander 2026-10-16 15:22:53 Re: Introduce contributor badges