Re: Fixing inconsistencies in the list of books

Lists: pgsql-www
From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Fixing inconsistencies in the list of books
Date: 2022-11-10 12:11:35
Message-ID: 4EB58BFC-3BAA-46FA-B067-9B65864C879F@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

When I added a book to the list a while back I realized that the list is quite
inconsistent in how it lists and even spells authors (and in more minor
nitpicks, punctuation). The case at hand is "Hans-Juergen Schoenig" and
"Hans-Jürgen Schönig". The attached patch attempts to make it consistent in
how authors are spelled using HTML entities, and how we list multiple authors.

Longer term it might make sense to move this information to the database and
template the list, but that feels like a low-priority task (if one at all)
given the low churn of this list.

--
Daniel Gustafsson https://vmware.com/

Attachment Content-Type Size
0001-Ensure-book-list-has-consistent-syntax.patch application/octet-stream 13.9 KB

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Re: Fixing inconsistencies in the list of books
Date: 2022-11-10 12:40:32
Message-ID: CA+OCxowdvomE5gQXgeFBcF86TyKVsrhhYHfT42gey8aOjtKBnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

Hi

On Thu, 10 Nov 2022 at 12:11, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:

> When I added a book to the list a while back I realized that the list is
> quite
> inconsistent in how it lists and even spells authors (and in more minor
> nitpicks, punctuation). The case at hand is "Hans-Juergen Schoenig" and
> "Hans-Jürgen Schönig". The attached patch attempts to make it consistent
> in
> how authors are spelled using HTML entities, and how we list multiple
> authors.
>
> Longer term it might make sense to move this information to the database
> and
> template the list, but that feels like a low-priority task (if one at all)
> given the low churn of this list.
>

Looks good to me. The only correction I would offer is that "et al" should
only be preceded by a comma if there is more than one name listed. Eg.

Dave Page et al.
Dave Page, Daniel Gustafsson, et al.

--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com


From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Re: Fixing inconsistencies in the list of books
Date: 2022-11-10 13:13:13
Message-ID: 90CC6E41-B9A5-4F07-98EA-A30C5C310264@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

> On 10 Nov 2022, at 13:40, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> The only correction I would offer is that "et al" should only be preceded by a comma if there is more than one name listed.

Thanks, I'll fix that before committing.

--
Daniel Gustafsson https://vmware.com/


From: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Re: Fixing inconsistencies in the list of books
Date: 2022-11-10 13:28:51
Message-ID: FCFF5A3E-6FE1-47F7-AA1C-323CF3A91D0B@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

> On Nov 10, 2022, at 7:11 AM, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
>
> When I added a book to the list a while back I realized that the list is quite
> inconsistent in how it lists and even spells authors (and in more minor
> nitpicks, punctuation). The case at hand is "Hans-Juergen Schoenig" and
> "Hans-Jürgen Schönig". The attached patch attempts to make it consistent in
> how authors are spelled using HTML entities, and how we list multiple authors.

Many of these were user supplied and some a very long
time ago, so there’s no surprise there are inconsistencies.

> Longer term it might make sense to move this information to the database and
> template the list, but that feels like a low-priority task (if one at all)
> given the low churn of this list.

We’ve discussed this in the past and decided not to do it. Given
how we handle images, we would still need to have a commit
with a new book, so I don’t think we save much, and
some of
the consistency errors are not prevented by putting it into
a database.

Jonathan


From: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Re: Fixing inconsistencies in the list of books
Date: 2022-11-10 13:29:33
Message-ID: E69BE8CF-44BE-4552-8933-FA1B57B244D0@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www


> On Nov 10, 2022, at 8:13 AM, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
>
> 
>>
>>> On 10 Nov 2022, at 13:40, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>> The only correction I would offer is that "et al" should only be preceded by a comma if there is more than one name listed.
>
> Thanks, I'll fix that before committing.

Please wait until after the update release.

Thanks,

Jonathan


From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
Cc: Dave Page <dpage(at)pgadmin(dot)org>, pgsql-www(at)lists(dot)postgresql(dot)org
Subject: Re: Fixing inconsistencies in the list of books
Date: 2022-11-11 07:55:35
Message-ID: FC40D40E-A8CA-4999-9F14-D93868A35047@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-www

> On 10 Nov 2022, at 14:29, Jonathan S. Katz <jkatz(at)postgresql(dot)org> wrote:
>
>> On Nov 10, 2022, at 8:13 AM, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
>>
>>>> On 10 Nov 2022, at 13:40, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>
>>> The only correction I would offer is that "et al" should only be preceded by a comma if there is more than one name listed.
>>
>> Thanks, I'll fix that before committing.
>
> Please wait until after the update release.

With the releases done, I've applied this. Thanks for review!

--
Daniel Gustafsson https://vmware.com/