Re: [pgsql-www] Viewing Postgres website from China - Mailing list pgsql-www

From Magnus Hagander
Subject Re: [pgsql-www] Viewing Postgres website from China
Date
Msg-id CABUevEy=__JKnor1iHpV7yUY0mxNcgq34f3SD0tbA9Kzx+rccQ@mail.gmail.com
Whole thread Raw
In response to Re: [pgsql-www] Viewing Postgres website from China  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-www


On Fri, Oct 13, 2017 at 7:02 AM, Daniel Gustafsson <daniel@yesql.se> wrote:
> On 12 Oct 2017, at 20:12, Joshua D. Drake <jd@commandprompt.com> wrote:
>
> On 10/12/2017 06:11 PM, Bruce Momjian wrote:
>> As you might know, China blocks Google web addresses in their
>> country-wide firewall.  Unfortunately, our website hangs for me when
>> I access this PG URL from China:
>>      https://www.postgresql.org/list/
>> It hangs reading information from ajax.googleapis.com.  Eventually it
>> times out and displays the page, but it takes a few minutes.  Any use of
>> that page, like viewing search result detail, also delays.
>> This affects anyone in China without an external VPN trying to access
>> our email archives web page.  Any reasonable idea if this can be
>> improved?  Thanks.
>
> Yep,
>
> The problem is here:
>
> <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
>  <script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.9.1/jquery-ui.min.js"></script>
>
> This is arguably a bad idea in general and we should probably host these ourselves.

Well, I think calling commonly used CDNs a bad idea "in general" is stretching
it a bit thin.  That being said, not being available in China makes it a no-go
and we should host it ourselves as we already do on the commitfest app.

Much as it pains me to do so :P, I have to agree with JD on this one, it is a bad idea in general :) I know there are many arguments for it, but there are even more against it I think.

That said, not only do we already host it there in the commitfest page. We already host it there for www.postgresql.org. We just don't use it consistently, nor do we use consistent versions.

In pgweb: jquery 1.11, and jquery-ui 1.11. These are used for the admin sections of the website.
Featurematrix uses 1.11 downloaded from google.
*Forms* on the website uses jquery 1.8 downloaded from google.
List archives uses jquery 1.8 and jquery-ui 1.9 downloaded from google.

I'm going to see if I can clean that up a bit...

--

pgsql-www by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: [pgsql-www] Viewing Postgres website from China
Next
From: Magnus Hagander
Date:
Subject: Re: [pgsql-www] Custom sortation for file browser