Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gz19P-0006a6-SU for pgsql-www@arkaria.postgresql.org; Wed, 27 Feb 2019 15:29:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gz19O-0004e8-MX for pgsql-www@arkaria.postgresql.org; Wed, 27 Feb 2019 15:29:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gz19O-0004e1-8g for pgsql-www@lists.postgresql.org; Wed, 27 Feb 2019 15:29:38 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gz19L-0006Ju-9t for pgsql-www@postgresql.org; Wed, 27 Feb 2019 15:29:37 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Type:In-Reply-To:MIME-Version:Date: Message-ID:From:References:To:Subject:Sender:Reply-To:Cc: Content-Transfer-Encoding:Content-ID:Content-Description; bh=Gn5vr3YMVK7XXjp35jtRwe7JCbHUOVLgMOBg4UExOXo=; b=BEM1y0JWEkOzPuj7ptdrHtem7Y udqzL2eBGEm1289oEXjM/vaL1UClCD7vAAC6jCsMls+DJoTBn3fM+EMmcu0UK/6J0b4Cxc7/fyHWh T7gYnraxb5XbFOoAD88DxdisnS2vpyPySbPMZguxqvBtkrEIA9uy9A3Np+6Ft7ZFOO3xTRwh7YeWR /E8VBjzX9SwIw3d2VxzvIVBQkA9jtg3jBSjsR0i8o3KRGhRMKjEJmTT5gnv6mModA56yRb5svoRZ1 WMqDltqFC5i8/dv6EStVvbPmjfs5O4EZweRoO9N3P4VBw9Jj4crEXw2Da4BiFWfsROVbEE1Sa/Adn ahb+NBsA==; Received: from [63.118.15.50] (helo=Ph33r-Retina.local) by meldrar.postgresql.org with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gz19H-0000mN-RG; Wed, 27 Feb 2019 15:29:33 +0000 Subject: Re: apt.postgresql.org django app for www.postgresql.org To: Christoph Berg , PostgreSQL WWW , Adrian Vondendriesch References: <20190122140025.GA27301@msg.df7cb.de> <20190130154803.GF4383@msg.df7cb.de> <20190227150932.GE25213@msg.df7cb.de> From: "Jonathan S. Katz" Openpgp: preference=signencrypt Autocrypt: addr=jkatz@postgresql.org; keydata= mQINBFtShwABEAC7PNHDUOTYuifpUCk23KqfxdQQkn4nkoxOXRK0+rAj36FiwqGB4TJFuOVZ sDFAEiSlC8Jt4y5Cs7B5tetT8JNd2cs6zp/udMJJDz9d65O9PDpdlMgAmIiTzpLlSdx8FG56 DTksaDv1d8j3cTJPSE4/fWSxqzA7o3Y9UuL7atZPrzfImgpRKs0of7elIHwOa8GucjyhYqcR h60wFBJc2KXqQdDYRTZy43DSnY/0VNc0omiH355fustvpm+m5HjD3w7qZyfN3fpKJpnX1LCF f3MnPHaDGITIYGRCBXvf0UqUtD6OEVWPv2C2gyqWMIpWmZTOgDufltKyIByKBoS9x0PlFkij 04X3KODCngt+N8Ssc9OICc6QSxhjoP48PYPdmiTmkrGuf0LX084wj1xeo1NX7XxZK39F6dTJ DhsIiW0sNS0xMxQHLHG9VLbPjx3SANQBh6BuryPz5ZupW9/TIDmkvprtU/oXfKgtfYm3fxmk EctxbWrEPsFTFPyuMqQu6l+xyQv0s1VLZfjNWaua6H1/gGoIt6kRnn5qMXDVVpijuWkHbv7G ngaQMd258UrrOEHnnjzhQ7jxMWV9D+emxbAtlIxnYvCWlV4IwAQhEHfvudqYaIY3hNWrvQ6H GB2KXoTZYN9g5djm14/5nj1IU5zOcovkjJnKhoo9iStnpFF2cwARAQABtCdKb25hdGhhbiBT LiBLYXR6IDxqa2F0ekBwb3N0Z3Jlc3FsLm9yZz6JAlQEEwEIAD4CGwMFCQeGH4AFCwkIBwIG FQoJCAsCBBYCAwECHgECF4AWIQT6hLaVryv3miBkP/HxBJxynxxlJwUCW1KJJQAKCRDxBJxy nxxlJwjrD/kBgqsW4QpNpTFw7ifRokZV08CCX4huPBJQ91rrv+UEWlEcotFBHVkYyHnpzARl tcZxhJ9CbFxjniH9cOTty5T/O1yolbOHtZSW8Z8aWV6BVEbjMb+BFxSSLm7RnvJdzQbGCZq2 ZZvfVpB6z3EHYph4KDdVKvMFjoLskxmdS1DE0tE3zTxvoQsi24Q+HOS07kUjs6fsu/WICMfz mgO++AWG9Y0CvN0mm4TkujESzyKM9E5irD+leEMIcddl51Aa2c/VMfBXQbRmpHIgUFTmuHQD CnQih+9i3OJAksDg66SP8a7yiXv5mwvyDi1EfTGVKYR2j+pwyjwnC3oIbvDMmB3uTn2JIjnT iZKPVtAcAylXjubFltihQgNyuShdP4W+kBwZizhUFqUVL8Anx+KoytYmJPfMRFLGuK4obXKq a2ZS3k9KB+H+isOx2nFJOsc7V360Zp1DVaNmuiK10TT6QndShSPaqkJqFtCb6r92rZ9sZM/L 3vtCI4Rrl3Pt1MgtENXupS8gZpJnAYS0j5A1PAZ09r6ANoaeMHspF+5J5fOHeEvqphXr36mm a83Vl1t4orPb0+QmmijmlpseDU63M88Aw5p3c4qj7t8Qr2EZ5zrn7/sFn5wOfbs8Nymxafif QCnlV2vg9p0m7vSk/yLJ4PFZvs52FgqAGRCdRn0s2EC99bkCDQRbUocAARAAv8ho/toQ9DG3 j4f9h9n1aRHr2FlviN2Utpy6L8+dfDggO0geilmkGQOolZ2E60gGfye/kUtF9W3NByO4hxDR 9u6qbOXcdqnuA+cc68EfqlWFJrVtYFxt0h4ElWYOYnIezKthriWch/FY70FGrxs3z8UHOHq5 0wBW433eTvZm90WixBiXEt2v1DgW4Vr3ymfO7Aap/IYyPuE4JzgudAuAl0HKPyNEHWHG1dAb jX1RiCw9gknIDWQOF0B4UAaJctWGVcnZ3A2ULwNGMa1P9ZJlBWf1vcj01aiHMU0yQ7JjJiSp vfm9eM0uSLwRdDrJjyl5ZZqVumjdv2SMNQ8GvYRbEMys3GGDSt9zXgfCSUnPnJfYxjzBHRI6 x44Wfsx8S6hWxepOogCJJ/g67Bk9mY8YV4klWIXDJVOL5jnBC09DbsZG81JaE2QxB8Y7W36Z Mroi9XMxg3s805hQAQUvdG/poU8hN8BWdrnTm/+4eQQp7gDY1ePDmGM6bJC+OHOSnFtR/f+7 0zpKJ10cc7cBygGnl1yR3KjhFyAWUFvP4ZGziKCcpMwXZfe9PGuyA/YOubMphxIn3YsK2wrd faKZYX2GMZCZhMMcvx9IpQrxIJgU+VlwXu/O+Lk10VIPcxPJJwmpdI6HzcS8ZgG6IMcC444X XTuLaP8j2mgcMvYak3ScCykAEQEAAYkCPAQYAQgAJhYhBPqEtpWvK/eaIGQ/8fEEnHKfHGUn BQJbUocAAhsMBQkHhh+AAAoJEPEEnHKfHGUnReMP/RA2UhGQj+G4uBshkRLjpRysabdPqgQB dEBk6wYbio88Wg/2/hgY7UzmDDEwX3sZfQDcrI6+vIobI8uqstZID+WgAAa1JLfChMyVQnSy 0zfWMOABXscc5tGuvFRZvJklTissMFjXUwaREEKp4ZikTvJ/62MCjSdtrUhnPLvoTsHTKRKD ichE+b5A54alwsubTijw12O6N22r5IjZiiSZV0u7dsShyKw+7wCSax9fuBoE43NMYf+dnjMK nerAQYUcZWYMnk+EC8RaqYAxv6XZ2tKx1AkGGktwkQIBwrz9IlDSvJ3LWJ2UIIuLRTdngNgg GIL4zzuUa2F56FqskQIuYMaNETk6LYfalBDQ6TVLAcgCPQxp4k4i/PRsZ3lZ2ZhRHRYciOvm kp+I6EfHwllQpYrWs1thluBGqlJSVJgKl0IOFvKLsQ6KKfqzAwh6FxrO5qajp4viNIgtWoFw O5Bp0jgFTbH2OrMWIRfUdUCH1Djbuo65svhNj7FNsQVYzHDI+Nd1I/LOBoPc3UorRMF2M4JV kUR7skOHWUbPTSNUr7qc14NSMY3PKjGeVGAsBVHBPvmRx/Ss2tW/TpJWpxg4pmquFQSXuaYh Yf4FN8Sxy320pcr+FqN8AhZkYJcNY82OTtR5VEKRC/mYcyq61qXIKqngydn79bJjGxHipxyF FmEC Message-ID: <14f521d7-bfbc-7fb3-df26-3ccf9c1c79d5@postgresql.org> Date: Wed, 27 Feb 2019 10:29:25 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:60.0) Gecko/20100101 Thunderbird/60.5.1 MIME-Version: 1.0 In-Reply-To: <20190227150932.GE25213@msg.df7cb.de> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="tALbyJNMGKysg4AcsvK53mRTeghsGc5I0" X-Host-Lookup-Failed: Reverse DNS lookup failed for 63.118.15.50 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --tALbyJNMGKysg4AcsvK53mRTeghsGc5I0 Content-Type: multipart/mixed; boundary="OdlRXG4W9Ba1YkWjvENjzwwubn824r6Fi"; protected-headers="v1" From: "Jonathan S. Katz" To: Christoph Berg , PostgreSQL WWW , Adrian Vondendriesch Message-ID: <14f521d7-bfbc-7fb3-df26-3ccf9c1c79d5@postgresql.org> Subject: Re: apt.postgresql.org django app for www.postgresql.org References: <20190122140025.GA27301@msg.df7cb.de> <20190130154803.GF4383@msg.df7cb.de> <20190227150932.GE25213@msg.df7cb.de> In-Reply-To: <20190227150932.GE25213@msg.df7cb.de> --OdlRXG4W9Ba1YkWjvENjzwwubn824r6Fi Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 2/27/19 10:09 AM, 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}}. >=20 > Ping? tl;dr I do think having a repo browser on pgweb would be nice, but we need to solve a few fundamental questions first: 1. Will we make the same thing available for the yums? 2. What will be the manual overhead on the pgweb, pginfra, + release team= ? And the rest of it: This will take some involved review. I made a quick pass, and saw a few things. First, an off-list comment that Magnus had raised (amongst a few others): is this be set up to handle RPM/YUM, and if not, what will it take to get it there? (Will somewhat answer this below). There are a few things that are immediate nonstarters for me: 1. There is a bunch of DDL hanging out in SQL files that should be in the Django migration file (and in fact, I don't see a migration file) 2. There appear to be some hardcoded things specific to deb/apt (e.g. "all" =3D> "amd64") which would not work if we wanted to extend this to rpm/yum. The question becomes can we / do we want to build a one-size-fits-all system? Also: 1. This appears to introduce an extension from PGXN, "debversion" -- I don't believe we've added any pgxn extensions directly into pgweb (I may be wrong) but we would have to see what that means from an administration standpoint. 2. There seem to be some easy improvements to make in some of the logic: def search(request): if 'package' in request.GET and request.GET['package']: package =3D request.GET['package'] becomes: def search(request): if request.GET.get('package'): package =3D request.GET['package'] 3. For now, the "active" booleans scare me until I understand how much of this is automated and how much of this is manual. Adding more manual steps to each release terrifies me, mostly because we have more than our fair share at the moment :) Thanks, Jonathan --OdlRXG4W9Ba1YkWjvENjzwwubn824r6Fi-- --tALbyJNMGKysg4AcsvK53mRTeghsGc5I0 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAEBCAAdFiEE+oS2la8r95ogZD/x8QSccp8cZScFAlx2rNYACgkQ8QSccp8c ZSdDjQ/+N+B/n5vDzLoQYclXa/7RTfnz8YE6VgA7tQiNV+Ze2Nlqok1FB00b9BgN IMY7ljj0TpOUY4hUQBE9lk/bN1YRKsYc1XZ/xh8SEq8ZEZ7MSZXQLBmggH7Zb0et VubBwX8Kvb8ICpXBi2gP+KBWJ98pIzQPze1/lC4GGhsCaXraZmJCeZfgIU0oKMol waBjtf6XfkF/MKJN9adwQg637LJXStIizSR329IFqVc7ORDxLwdUmOS78K6Bbz7L KcW3ZqvWXQCQg49QR0SPWW02T98DXAG9P8lFl6ji3+G3qbzNEhDxnw7nnZML4bab Hj2zIRlJ+xTOOtXi5HMScc5gBXNWMRBrggMCmLnovSDeJegnYDgQ+tdTZ7KYQBWb 5370giz0tOtAmF8Io9g/P7cMXCKdpKjKyFcWdGIW5paSfkejbI1Yg4qEuWOS5i4m qnCb6WBloA4kyDJhYtbWA1KzPO9cyH1eiqFwbT/Q5VV1RSiC2F3YmPN4pe3T2tC3 zPLwkU+OnJ/BpKJNamz3/i1Nz2t5aRguVbPsvfqINLSiR4JwfdU0OECS3M+r/F3O S9OYPxAPHPiKiAHweLAcLdfIdLgu8saC+yM6G8G3hlwvCTv4Utky9ug8siB0vRh5 uKMaoEhQGXTdbltoTRRxnI5zdUXhgOaGR1IUz9G0fHb3gQ90Gzc= =JfbK -----END PGP SIGNATURE----- --tALbyJNMGKysg4AcsvK53mRTeghsGc5I0--