Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xH3gM-00000002nmb-1H3H for pgsql-www@arkaria.postgresql.org; Wed, 14 Oct 2026 18:26:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xH3gL-00000004woD-0Dk6 for pgsql-www@arkaria.postgresql.org; Wed, 14 Oct 2026 18:26:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xH3gK-00000004wo2-2RAY; Wed, 14 Oct 2026 18:26:28 +0000 Received: from stravinsky.debian.org ([2001:41b8:202:deb::311:108]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xH3gG-000000021Of-2CVW; Wed, 14 Oct 2026 18:26:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=debian.org; s=smtpauto.stravinsky; h=X-Debian-User:In-Reply-To:Content-Transfer-Encoding: Content-Type:MIME-Version:References:Message-ID:Subject:Cc:To:From:Date: Reply-To:Content-ID:Content-Description; bh=j3SOqYBJmPbbthKDQCFK0jHMAn+b64q1NhjQzrDRAys=; b=vo+G4Hs7+RhlGtm/JLQG10of/M 8Gmhq21Mp66rb0qQmlhWRkS+B9OUar+18NctqJNXDjywfAff9IRZohzueR/P8/49EmA6FmepZmeaj sp4tsZYkgtcRiIwj0wXUvb8YmGVw+PTYGwITeOjYTSLI+fF5gpGYfZEQW+zZDA04ZT4ZU/0/ePz9/ wyP+69cmVZFk/2EHKn4coL7RAbL/RwfIUsdvT/SxER3HKA7hQooH+0miDQ2FU/L5wDDp5aCRDLsrm G6O1uXY9rGQUh8biYAnVnP0vGPGP51yxJJD4Ug9XXXA+tcRtL/wVz0IO2EaG+gKzKWpt/ABCkWC0r wB2ZpMOQ==; Received: from authenticated-user by stravinsky.debian.org with esmtpsa (TLS1.3:ECDHE_SECP256R1__RSA_PSS_RSAE_SHA256__AES_256_GCM:256) (Exim 4.96) (envelope-from ) id 1xH3g8-004bik-2K; Wed, 14 Oct 2026 18:26:17 +0000 Date: Wed, 14 Oct 2026 20:26:14 +0200 From: Christoph Berg To: "Jonathan S. Katz" Cc: Daniel Gustafsson , Magnus Hagander , pgsql-www@lists.postgresql.org, Andrey Borodin , Melanie Plageman , PostgreSQL Contributors Subject: Re: Introduce contributor badges Message-ID: References: <329b5d0e-44ba-4c5f-8cc9-c9eb5424955b@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="U4qa6dZj49sCywz8" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <329b5d0e-44ba-4c5f-8cc9-c9eb5424955b@postgresql.org> X-Debian-User: myon List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --U4qa6dZj49sCywz8 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Re: Jonathan S. Katz > Thanks for working on this. I can provide some review on the current > patches. Thanks! > While looking at the text edits, I saw that we're storing the badge binary > in the database. This would be a first for .org; typically we store these in > the repo, so we can leverage whatever cache/CDN mechanisms we have. While > the code is pretty neat, IMV it'd be better to store it in our standard > image directory. > > If there's a reason for this to be in the database, please let me know. I > also know this is one of those things that we can ultimately change. I've had file/repo storage in the first version because it was simpler, but Magnus said we should use the pgeu image-in-database code. I tend to agree that database is better, this is content that is added frequently ("PGconf Wherever 20xx Speaker"), so automating the process as much as possible makes sense. The images themselves don't change (much), so varnish caching should just work. One point that Magnus raised is if there are many images on a page, some web browsers will open 80 concurrent connections and run into some rate limit. If we reach that point, we need to create sprites and serve the badges grid as one big image. (This is a UX issue, not a bandwidth one.) But there is still time until that happens, and for that, we can take the images from the database as well. > The rest of this looks OK. > > > v12-0001-Make-contributor-badges-discoverable.patch - what will > > actually put the badges live > > I guess I missed why we're separating out Contributors + People, but if it's > agreed upon I don't have too strong of an opinion. Otherwise just looking at > it, I'm confused at the difference :) We can definitely revisit the split after some time. > Maybe we have to also retitle > "Contributors" to "Recognized Contributors", i.e. > > - {'title': 'Contributors', 'link': '/community/contributors/'}, > + {'title': 'Recognized Contributors', 'link': > '/community/contributors/'}, I had tried that, but rejected it because it got wrapped over two lines in the sidebar, and none of the other menus have multi-line entries. But maybe that's not a problem and we should just do it. Done in the attached v13-0002. > The rest LGTM. > > > v12-0001-Extend-badge-title-to-64-chars.patch - future database fix > > I don't think we need to be stingy on the characters here; I think the > "default" we've used is 255; let's just be safe. (I'm also OK if we don't > use TextField given these will typically be short). Ack, will bump it in the staged DB commit v13-0003. > > Assuming v12-0001-Contributor-copy-editing.patch is ok, would you > > think that we can proceed with adding some badges now? My hope would > > be to have at least "PostgreSQL 18 Contributor" live for Valencia. > > > > Timeline: > > after ack: apply v12-0001-Contributor-copy-editing.patch > > this week: create initial badges, add holders > > have badges approved in moderation (they are still not visible) > > shortly before the conference: apply v12-0001-Make-contributor-badges-discoverable.patch > > later: apply v12-0001-Extend-badge-title-to-64-chars.patch > Thanks, > > Jonathan Given that we now have the review from Daniel and this what I read as review-and-ack from Jonathan, I think we can proceed to add actual badges. Tomorrow is 19rc1 release day, so I'd say Friday. Christoph --U4qa6dZj49sCywz8 Content-Type: text/x-diff; charset=iso-8859-1 Content-Disposition: attachment; filename=v13-0001-Contributor-copy-editing.patch Content-Transfer-Encoding: 8bit From fc08c159e2c0d570da307029cbc43660c86da1f5 Mon Sep 17 00:00:00 2001 From: Christoph Berg Date: Mon, 12 Oct 2026 15:14:39 +0200 Subject: [PATCH v13 1/3] Contributor copy-editing Apply finding from Daniel's review: * retired badge holders have a CSS class * contribution field description is "Describe your involvement in the PostgreSQL community" * The logo is the PostgreSQL logo * Badge images have an alt title * "Create contributor profile" checkbox has a proper id and label --- media/css/main.css | 3 +++ pgweb/contributors/migrations/0001_initial.py | 2 +- ...er_contributor_ctype_alter_contributor_email_and_more.py | 2 +- pgweb/contributors/models.py | 4 ++-- templates/account/userprofileform.html | 4 ++-- templates/contributors/badge.html | 6 +++--- templates/contributors/people.html | 2 +- templates/contributors/profile.html | 4 ++-- 8 files changed, 15 insertions(+), 12 deletions(-) diff --git a/media/css/main.css b/media/css/main.css index 9c4e24d8..a41632d2 100644 --- a/media/css/main.css +++ b/media/css/main.css @@ -1758,6 +1758,9 @@ table.contributor-table thead tr th { text-align: center; padding: 4px; } +.badgeholder-retired { + font-style: italic; +} /* News archive */ #pgContentWrap span.newstag { diff --git a/pgweb/contributors/migrations/0001_initial.py b/pgweb/contributors/migrations/0001_initial.py index 244e2e49..e2121892 100644 --- a/pgweb/contributors/migrations/0001_initial.py +++ b/pgweb/contributors/migrations/0001_initial.py @@ -22,7 +22,7 @@ class Migration(migrations.Migration): ('company', models.CharField(max_length=100, null=True, blank=True)), ('companyurl', models.URLField(max_length=100, null=True, verbose_name='Company URL', blank=True)), ('location', models.CharField(max_length=100, null=True, blank=True)), - ('contribution', models.TextField(null=True, blank=True, help_text='Describe what you did in the PostgreSQL community')), + ('contribution', models.TextField(null=True, blank=True, help_text='Describe your involvement in the PostgreSQL community')), ], options={ 'ordering': ('lastname', 'firstname'), diff --git a/pgweb/contributors/migrations/0005_alter_contributor_ctype_alter_contributor_email_and_more.py b/pgweb/contributors/migrations/0005_alter_contributor_ctype_alter_contributor_email_and_more.py index 75b002aa..87627ccb 100644 --- a/pgweb/contributors/migrations/0005_alter_contributor_ctype_alter_contributor_email_and_more.py +++ b/pgweb/contributors/migrations/0005_alter_contributor_ctype_alter_contributor_email_and_more.py @@ -82,7 +82,7 @@ class Migration(migrations.Migration): "imagedata", pgweb.util.fields.ImageBinaryField( blank=True, - help_text="Square image, will be auto-scaled to 150×150. JPEG or PNG, up to 1 MB. When left blank, the Slony logo will be used.", + help_text="Square image, will be auto-scaled to 150×150. JPEG or PNG, up to 1 MB. When left blank, the PostgreSQL logo will be used.", max_length=1000000, null=True, verbose_name="Image", diff --git a/pgweb/contributors/models.py b/pgweb/contributors/models.py index 7ffc0881..7d55a0dc 100644 --- a/pgweb/contributors/models.py +++ b/pgweb/contributors/models.py @@ -53,7 +53,7 @@ class Contributor(models.Model): companyurl = models.URLField(max_length=100, null=True, blank=True, verbose_name='Company URL') location = models.CharField(max_length=100, null=True, blank=True) contribution = models.TextField(null=True, blank=True, - help_text='Describe what you did in the PostgreSQL community') + help_text='Describe your involvement in the PostgreSQL community') user = models.OneToOneField(User, null=True, blank=True, on_delete=models.CASCADE) send_notification = True @@ -102,7 +102,7 @@ class Badge(TwostateModerateModel): slug = models.SlugField(max_length=64, null=False, blank=False, unique=True, help_text='URL-friendly identifier for the badge page. Generated from the title when the badge is created, and kept fixed after that.') description = models.TextField(null=True, blank=True, help_text='What did the people do who contributed here?') url = models.URLField(max_length=100, null=True, blank=True, verbose_name='Contribution URL', help_text='URL for this contribution, e.g. the conference homepage. (Leave blank when there is no URL.)') - imagedata = ImageBinaryField(max_length=1000000, resolution=(150, 150), auto_scale=True, blank=True, null=True, verbose_name="Image", help_text="Square image, will be auto-scaled to 150×150. JPEG or PNG, up to 1 MB. When left blank, the Slony logo will be used.") + imagedata = ImageBinaryField(max_length=1000000, resolution=(150, 150), auto_scale=True, blank=True, null=True, verbose_name="Image", help_text="Square image, will be auto-scaled to 150×150. JPEG or PNG, up to 1 MB. When left blank, the PostgreSQL logo will be used.") contact = models.CharField(max_length=100, null=True, blank=True, verbose_name='Contact address', help_text='Contact address (email, URL, other) for people who want to be added as badge holder') holders = models.ManyToManyField(User, through="Badgeholder", through_fields=("badge", "user"), blank=True) diff --git a/templates/account/userprofileform.html b/templates/account/userprofileform.html index bac04651..01fba575 100644 --- a/templates/account/userprofileform.html +++ b/templates/account/userprofileform.html @@ -100,7 +100,7 @@ {%for b in badges %}
- + {{b}}
{{b}}
@@ -134,7 +134,7 @@

Create contributor profile

You have been awarded contributor badges. To have your name included in the public people and badge holder lists, you can create a publicly visible profile page.

- Create publicly visible profile page +
{% endif %} diff --git a/templates/contributors/badge.html b/templates/contributors/badge.html index 1da8f84b..7ea0f1fd 100644 --- a/templates/contributors/badge.html +++ b/templates/contributors/badge.html @@ -3,7 +3,7 @@ {%block title%}{{badge}} - Contribution{%endblock%} {%block contents%}

Badge: {{badge}}

-

+

{{badge}}

{% if badge.description or badge.url %}

Contribution

@@ -19,12 +19,12 @@

Badge Holders

{%if holders|length > 50%} {%for u in holders.all %} - {%if u.date_retired%}{%endif%}{{u.user.contributor.firstname}} {{u.user.contributor.lastname}}{%if u.date_retired%}{%endif%} {%if not forloop.last%}·{%endif%} + {{u.user.contributor.firstname}} {{u.user.contributor.lastname}} {%if not forloop.last%}·{%endif%} {%endfor%} {%else%} {%endif%} diff --git a/templates/contributors/people.html b/templates/contributors/people.html index 67de9b9d..37211902 100644 --- a/templates/contributors/people.html +++ b/templates/contributors/people.html @@ -26,7 +26,7 @@ {%for b in badges %}
- + {{b}}
{{b}}
diff --git a/templates/contributors/profile.html b/templates/contributors/profile.html index f4d1afdc..e47bf455 100644 --- a/templates/contributors/profile.html +++ b/templates/contributors/profile.html @@ -12,8 +12,8 @@ {%for b in badges %}
- -
{{b.badge}}{%if b.date_retired%}
(retired){%endif%}
+ {{b.badge}} + {{b.badge}}{%if b.date_retired%}
(retired){%endif%}
{%endfor%} -- 2.53.0 --U4qa6dZj49sCywz8 Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename=v13-0002-Make-contributor-badges-discoverable.patch From 80251b121dbabef84fdc6c753c87c9b3ab8759af Mon Sep 17 00:00:00 2001 From: Christoph Berg Date: Fri, 25 Sep 2026 17:29:36 +0200 Subject: [PATCH v13 2/3] Make contributor badges discoverable Add the People entry to the community menu and the Contributor Badges entry to the account's submitted-data menu, and link the recognized contributors list to the new people and profile pages. These are the incoming links from existing pages; the badges system is fully functional without them, so this can be pushed separately after testing. Author: Melanie Plageman Author: Christoph Berg --- pgweb/util/contexts.py | 4 +++- templates/contributors/list.html | 29 ++++++++++++++++------------- 2 files changed, 19 insertions(+), 14 deletions(-) diff --git a/pgweb/util/contexts.py b/pgweb/util/contexts.py index ca493714..6fdd3969 100644 --- a/pgweb/util/contexts.py +++ b/pgweb/util/contexts.py @@ -46,7 +46,8 @@ sitenav = { ], 'community': [ {'title': 'Community', 'link': '/community/'}, - {'title': 'Contributors', 'link': '/community/contributors/'}, + {'title': 'Recognized Contributors', 'link': '/community/contributors/'}, + {'title': 'People', 'link': '/community/people/'}, {'title': 'Mailing Lists', 'link': '/list/'}, {'title': 'IRC', 'link': '/community/irc/'}, # {'title': 'Slack', 'link': 'https://join.slack.com/t/postgresteam/shared_invite/zt-1qj14i9sj-E9WqIFlvcOiHsEk2yFEMjA'}, @@ -86,6 +87,7 @@ sitenav = { {'title': 'Events', 'link': '/account/edit/events/'}, {'title': 'Products', 'link': '/account/edit/products/'}, {'title': 'Professional Services', 'link': '/account/edit/services/'}, + {'title': 'Contributor Badges', 'link': '/account/edit/badges/'}, {'title': 'Organisations', 'link': '/account/edit/organisations/'}, ]}, {'title': 'Change password', 'link': '/account/changepwd/'}, diff --git a/templates/contributors/list.html b/templates/contributors/list.html index 068fc949..8377a8e7 100644 --- a/templates/contributors/list.html +++ b/templates/contributors/list.html @@ -1,18 +1,18 @@ {%extends "base/page.html"%} {%load pgfilters%} -{%block title%}Contributor Profiles{%endblock%} +{%block title%}Recognized Contributors{%endblock%} {%block contents%} -

PostgreSQL Contributor Profiles

- -

These are the fine people that make PostgreSQL what it is today!

+

PostgreSQL Recognized Contributors

- For a list of all code contributions to a specific release, see the - Release Notes for released versions of PostgreSQL. + These are the fine people who make PostgreSQL what it is today! + Contributors listed here have provided a sustained stream of notable contributions in recent years.

+

- Existing contributors can update their information in their - user profile. + A separate page lists all + people who have made contributions to PostgreSQL + over the years.

{%for t in contributortypes%} @@ -32,7 +32,7 @@ {%for c in t.contributor_set.all %} {%if t.detailed%} - {{c.firstname}} {{c.lastname}} {%if t.showemail and c.email%}({{c.email|hidemail}}){%endif%} + {% if c.user %}{{c.firstname}} {{c.lastname}}{% else %}{{c.firstname}} {{c.lastname}}{% endif %} {%if t.showemail and c.email%}({{c.email|hidemail}}){%endif%} {%if c.company %}
{% if c.companyurl %} @@ -41,21 +41,23 @@ {{c.company}} {% endif %} {% endif %} -
- {{c.location}} + {%if c.location %} +
+ {{c.location}} + {% endif %} {{c.contribution}} {%else%} {%if forloop.counter0|divisibleby:"2" %} - {{c.firstname}} {{c.lastname}}{%if t.showemail and c.email%} ({{c.email|hidemail}}){%endif%} + {% if c.user %}{{c.firstname}} {{c.lastname}}{% else %}{{c.firstname}} {{c.lastname}}{% endif %}{%if t.showemail and c.email%} ({{c.email|hidemail}}){%endif%} {%if forloop.last%} {%endif%} {%else%} - {{c.firstname}} {{c.lastname}}{%if t.showemail and c.email%} ({{c.email|hidemail}}){%endif%} + {% if c.user %}{{c.firstname}} {{c.lastname}}{% else %}{{c.firstname}} {{c.lastname}}{% endif %}{%if t.showemail and c.email%} ({{c.email|hidemail}}){%endif%} {%endif%} {%endif%} @@ -65,6 +67,7 @@ {%endfor%}

All contributors are listed in alphabetical order. + Existing contributors can update their information in their user profile. To suggest additions or corrections to this list, please email the Contributors Committee at contributors@postgresql.org. -- 2.53.0 --U4qa6dZj49sCywz8 Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename=v13-0003-Extend-badge-title-to-255-chars.patch From 6c3d38ff0ac743008830c4cf5d3cc98de868fd7d Mon Sep 17 00:00:00 2001 From: Christoph Berg Date: Mon, 12 Oct 2026 14:17:58 +0200 Subject: [PATCH v13 3/3] Extend badge title to 255 chars Daniel pointed out that a reasonable badge title like "Nordic PGDay 2026 Program Committee" is already longer than the 32 chars we catered for (it's 35). Extend it, we still have moderation to reject overly long names. --- .../migrations/0006_alter_badge_badge.py | 25 +++++++++++++++++++ pgweb/contributors/models.py | 2 +- 2 files changed, 26 insertions(+), 1 deletion(-) create mode 100644 pgweb/contributors/migrations/0006_alter_badge_badge.py diff --git a/pgweb/contributors/migrations/0006_alter_badge_badge.py b/pgweb/contributors/migrations/0006_alter_badge_badge.py new file mode 100644 index 00000000..f69c47f3 --- /dev/null +++ b/pgweb/contributors/migrations/0006_alter_badge_badge.py @@ -0,0 +1,25 @@ +# Generated by Django 5.2.17 on 2026-10-12 12:17 + +from django.db import migrations, models + + +class Migration(migrations.Migration): + + dependencies = [ + ( + "contributors", + "0005_alter_contributor_ctype_alter_contributor_email_and_more", + ), + ] + + operations = [ + migrations.AlterField( + model_name="badge", + name="badge", + field=models.CharField( + help_text='Title of this badge, e.g. "PGConf.EU 2025 Speaker".', + max_length=255, + unique=True, + ), + ), + ] diff --git a/pgweb/contributors/models.py b/pgweb/contributors/models.py index 7d55a0dc..e5efab79 100644 --- a/pgweb/contributors/models.py +++ b/pgweb/contributors/models.py @@ -98,7 +98,7 @@ class BadgeManager(models.Manager): class Badge(TwostateModerateModel): org = models.ForeignKey(Organisation, null=False, blank=False, verbose_name="Organisation", help_text=ORGANISATION_HINT_TEXT, on_delete=models.CASCADE) - badge = models.CharField(max_length=32, null=False, blank=False, unique=True, help_text='Title of this badge, e.g. "PGConf.EU 2025 Speaker".') + badge = models.CharField(max_length=255, null=False, blank=False, unique=True, help_text='Title of this badge, e.g. "PGConf.EU 2025 Speaker".') slug = models.SlugField(max_length=64, null=False, blank=False, unique=True, help_text='URL-friendly identifier for the badge page. Generated from the title when the badge is created, and kept fixed after that.') description = models.TextField(null=True, blank=True, help_text='What did the people do who contributed here?') url = models.URLField(max_length=100, null=True, blank=True, verbose_name='Contribution URL', help_text='URL for this contribution, e.g. the conference homepage. (Leave blank when there is no URL.)') -- 2.53.0 --U4qa6dZj49sCywz8--