Re: Viewing Postgres website from China

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:

/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.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +

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:
>
> /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.

JD

>

--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.us
***** Unless otherwise stated, opinions are my own. *****

> On 12 Oct 2017, at 20:12, Joshua D. Drake <jd(at)commandprompt(dot)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:
>> /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.

cheers ./daniel

On Fri, Oct 13, 2017 at 7:02 AM, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:

> > On 12 Oct 2017, at 20:12, Joshua D. Drake <jd(at)commandprompt(dot)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:
> >> /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...

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>