From: Christoph Berg <myon@debian.org>
To: Dave Page <dpage@pgadmin.org>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: Jonathan S. Katz <jkatz@postgresql.org>
Cc: Daniel Gustafsson <daniel@yesql.se>
Cc: pgsql-www@lists.postgresql.org, Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Melanie Plageman <melanieplageman@gmail.com>
Cc: PostgreSQL Contributors <contributors@lists.postgresql.org>
Subject: Re: Introduce contributor badges
Date: Fri, 16 Oct 2026 14:49:45 +0200
Message-ID: <atIdaaQxQRpBWERs@msg.df7cb.de> (raw)
In-Reply-To: <CA+OCxoxDqwvE7Bn=_EdMgVT6nucvuVJhidobTWb+5GM5m4-T_g@mail.gmail.com>
References: <aszgh1hJGT6bG7QU@msg.df7cb.de>
<329b5d0e-44ba-4c5f-8cc9-c9eb5424955b@postgresql.org>
<as_JRi3I0UCkFvBJ@msg.df7cb.de>
<AC76685F-1AE4-44F9-8108-03952D02493A@yesql.se>
<c8a36992-f9f7-4ef8-bd54-15ac711ce621@postgresql.org>
<CABUevEy6LfTWE9QaJuZKyUcBkggozTp_87OLmzDSBxyo2cV1iQ@mail.gmail.com>
<atHYqT5b0eFnHEZl@msg.df7cb.de>
<CA+OCxoz62dPkZwihHVz0zt1LoAYAG-bJsEmyfPDoMkV9QN5CqA@mail.gmail.com>
<atHniPzZPas6faP6@msg.df7cb.de>
<CA+OCxoxDqwvE7Bn=_EdMgVT6nucvuVJhidobTWb+5GM5m4-T_g@mail.gmail.com>
Re: Dave Page
> > What max input size would we accept? 2000x2000 (4 megapixels) should
> > be pretty much enough for everyone?
>
> These are images for badges - why on earth do they have to be that big? You
> pad them and then display them at 150x150 from what I can see. All of that
> seems like work that needn't be done by our servers - I would have the user
> upload at <= 256x256 or something (and adjust max_length to something more
> reasonable), and then pad and resize them in CSS. Which looks like it might
> be broken anyway - .badges-grid uses minmax(150px, 1fr) with img { width:
> 100% }, so on wide layouts a 150px image likely gets stretched beyond its
> real size.
That would be the max acceptable input size before server-side
rescaling. I proposed something insanely large that shouldn't get in
the way of anyone uploading while still limiting server memory.
What you are saying is that we shouldn't do server-side rescaling but
just take the user image-as is. That works for me.
I'll work on a patch to make that switch.
(The question might come back if we want to build a sprite image.)
Christoph
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-www@postgresql.org
Cc: myon@debian.org, dpage@pgadmin.org, magnus@hagander.net, jkatz@postgresql.org, daniel@yesql.se, x4mmm@yandex-team.ru, melanieplageman@gmail.com, contributors@lists.postgresql.org
Subject: Re: Introduce contributor badges
In-Reply-To: <atIdaaQxQRpBWERs@msg.df7cb.de>
References: <aszgh1hJGT6bG7QU@msg.df7cb.de> <329b5d0e-44ba-4c5f-8cc9-c9eb5424955b@postgresql.org> <as_JRi3I0UCkFvBJ@msg.df7cb.de> <AC76685F-1AE4-44F9-8108-03952D02493A@yesql.se> <c8a36992-f9f7-4ef8-bd54-15ac711ce621@postgresql.org> <CABUevEy6LfTWE9QaJuZKyUcBkggozTp_87OLmzDSBxyo2cV1iQ@mail.gmail.com> <atHYqT5b0eFnHEZl@msg.df7cb.de> <CA+OCxoz62dPkZwihHVz0zt1LoAYAG-bJsEmyfPDoMkV9QN5CqA@mail.gmail.com> <atHniPzZPas6faP6@msg.df7cb.de> <CA+OCxoxDqwvE7Bn=_EdMgVT6nucvuVJhidobTWb+5GM5m4-T_g@mail.gmail.com> <atIdaaQxQRpBWERs@msg.df7cb.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox