Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jtA13-0001ZJ-1Q for pgsql-www@arkaria.postgresql.org; Wed, 08 Jul 2020 13:21:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jtA0W-0004BT-8w for pgsql-www@arkaria.postgresql.org; Wed, 08 Jul 2020 13:21:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jtA0W-0004BM-1z for pgsql-www@lists.postgresql.org; Wed, 08 Jul 2020 13:21:04 +0000 Received: from mail-ed1-x544.google.com ([2a00:1450:4864:20::544]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jtA0S-000831-Dg for pgsql-www@postgresql.org; Wed, 08 Jul 2020 13:21:03 +0000 Received: by mail-ed1-x544.google.com with SMTP id g20so41591014edm.4 for ; Wed, 08 Jul 2020 06:21:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin.org; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=4KUiEs29yT+qtjCXOe99YUpwrfiVgNI/q9Hrl6Ngn34=; b=NZyj+nKc2FCS/ffbwVqeWa6IzKxbpFx22NSsELbJIx4OeGLIn8QCpVSEw4WRUaWide HSruYs04nqRYV8apV47kR+dhGtQFsygyr0DOyUJWYXCq+QOON1TzfxCuI7pSLvQxdFjP GbHIULd5svcrb+J7j7SkaVEIkyr1TRMYu4BENXGYcgOtlCyPB/nZzo5jUqWHW0Vn/K7X DTLHKW0tT0+nVKfdV9dkTS0YOUd7x7FkgdXaNE9Xw18p1EIxe10+1TOY6ySaYu+6LvBT qbE+7poaHqlJiRZpXUM+roApTi2SjSZBFmVsYTxMFo+ac0J/3X4Uy6Xe1sQW5o8EFFmj ieQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=4KUiEs29yT+qtjCXOe99YUpwrfiVgNI/q9Hrl6Ngn34=; b=ZzZ5WDRY1pouHx3TRE5bLFbdnMsI+vKEREBc9u33EuhgITInnbbeV68JB+cx7W3Zpo bS8M4Ui1Tz0S1WUROny9gZ1NMsFcsOuV9tP0mJr/CUN+gdXXx1XXIDqtTciPkyAtPq1r tNi787HVPPGVL0DdBgv7nlZfKJTq91jUhbI8Fyg3rWGls3giM7Vkv/iZ8vrq0wcL/7ge iGasBWcmHeVZstRvqNzvdERl9DsoRJO/O7cz9H8fr5hRwXDQ2QnzEaKG21UHnKebxQgr 8GsWMiztUq0U3EIX7Oi+ue94WDOz/EkHqmPPdTGCtqDgtGiUHiymXVc9QcJpGiCtw/+g vhUw== X-Gm-Message-State: AOAM533g3VwGa3nDk5jZEXMtkfErO/IU1k/8FZd0qyk6vBfefstrrh4y sokT/hXuG+JDxSZn56tZjiKJdBCkckAKPGnmN0IYyz3yRsY= X-Google-Smtp-Source: ABdhPJz/iVpqjTWQEoGlh9SckTwXLHFSyBPvF3O1yN5g5Kca2e5eD61m2OA/0MVba3r2SsW5OsUfIUWp5ajdRQLfPTQ= X-Received: by 2002:a50:f418:: with SMTP id r24mr60835104edm.382.1594214459599; Wed, 08 Jul 2020 06:20:59 -0700 (PDT) MIME-Version: 1.0 References: <20190122140025.GA27301@msg.df7cb.de> <20190130154803.GF4383@msg.df7cb.de> <20190227150932.GE25213@msg.df7cb.de> In-Reply-To: From: Dave Page Date: Wed, 8 Jul 2020 14:20:48 +0100 Message-ID: Subject: Re: apt.postgresql.org django app for www.postgresql.org To: Christoph Berg , PostgreSQL WWW , Adrian Vondendriesch Content-Type: multipart/alternative; boundary="0000000000008f918d05a9edfaaa" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000008f918d05a9edfaaa Content-Type: text/plain; charset="UTF-8" On Wed, Jul 8, 2020 at 2:08 PM Dave Page wrote: > Hi > > On Wed, Feb 27, 2019 at 3:09 PM Christoph Berg wrote: > >> Re: To PostgreSQL WWW 2019-01-30 <20190130154803.GF4383@msg.df7cb.de> >> > Updated for python3. I had to fix several places where {{package}} was >> > rendered as "Package Object". The new syntax is {{package.package}}. >> >> Ping? >> > > I spent a bunch of time playing with this, as I intend to get repo > browsing for both Yum and Apt onto the website. > > There was quite a bit of work to do to get it working with modern versions > of Django and Python 3. Once I got through enough of that to start looking > at the actual functionality what I found was *really* comprehensive. > Unfortunately I think there's actually far more there than we should put on > the main website. > > - I think the QA section is clearly something that's aimed at you as > maintainers of the apt repos. This definitely doesn't belong on the main > website in my opinion. > > - The madison interface is also interesting (academically), but I think is > of little use to the vast majority of our users; I'm not even sure that the > majority of Debian/Ubuntu users would know about rmadison. > > - Similarly, I think the binary and source package pages are far more > comprehensive than most of our users need or would care about. > > One of the biggest barriers of adoption to PostgreSQL is the perceived > complexity, including that of getting it up and running. That's why I'm > spending a lot of time at the moment trying to simplify and clarify the > download and installation processes. I think what we have in this patch > will simply be information overload for most of our users. > > My suggestion is that we incorporate a relatively simple browser into the > main website, which allows users to easily browse the available packages > and see the details of them. I already have the repo scanning part of that > done for both apt and yum, generating JSON output in a way that can be > integrated with our download server sync process, which can load that into > the website database. > > I would support a separate site (probably under apt.enterprisedb.com) > that supports the level of functionality you have in your patch; and I > think much, if not all of the code you currently have could be used for > that. This could of course be linked from the main website. > Obviously that should be apt.postgresql.org :-) -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com --0000000000008f918d05a9edfaaa Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Wed, Jul 8, 2020 at 2:08 PM Dave P= age <dpage@pgadmin.org> wrot= e:
Hi

On Wed, Feb 27, 2019 at 3:09 PM Christoph Berg <myon@debian.org> wrote:
<= /div>
Re: To PostgreSQL WW= W 2019-01-30 <20190130154803.GF4383@msg.df7cb.de>
> Updated for python3. I had to fix several places where {{package}} was=
> rendered as "Package Object". The new syntax is {{package.pa= ckage}}.

Ping?

=C2=A0I spent a bunch of time pla= ying with this, as I intend to get repo browsing for both Yum and Apt onto = the website.

There was quite a bit of work to do t= o get it working with modern versions of Django and Python 3. Once I got th= rough enough of that to start looking at the actual functionality what I fo= und was *really* comprehensive. Unfortunately I think there's actually = far more there than we should put on the main website.

=
- I think the QA section is clearly something that's aimed at you = as maintainers of the apt repos. This definitely doesn't belong on the = main website in my opinion.

- The madison=C2=A0int= erface is also interesting (academically), but I think is of little use to = the vast majority of our users; I'm not even sure that the majority of = Debian/Ubuntu users would know about rmadison.

- S= imilarly, I think the binary and source package pages are far more comprehe= nsive than most of our users need or would care about.

=
One of the biggest barriers of adoption to PostgreSQL is the perceived= complexity, including that of getting it up and running. That's why I&= #39;m spending a lot of time at the moment trying to simplify and clarify t= he download and installation processes. I think what we have in this patch = will simply be information overload for most of our users.

My suggestion is that we incorporate a relatively simple browser i= nto the main website, which allows users to easily browse the available pac= kages and see the details of them. I already have the repo scanning part of= that done for both apt and yum, generating JSON output in a way that can b= e integrated with our download server sync process, which can load that int= o the website database.

I would support a separate= site (probably under apt.enterprisedb.com) that supports the level of functionality you= =C2=A0have in your patch; and I think much, if not all of the code you curr= ently have could be used for that. This could of course be linked from the = main website.

Obviously t= hat should be apt.postgresql.org = :-)
=C2=A0
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsn= ake

EDB: h= ttp://www.enterprisedb.com

--0000000000008f918d05a9edfaaa--