Обсуждение: [pgsql-www] 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: 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. -- Bruce Momjian <bruce@momjian.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 + -- Sent via pgsql-www mailing list (pgsql-www@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-www
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. 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. ***** -- Sent via pgsql-www mailing list (pgsql-www@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-www
> 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. cheers ./daniel -- Sent via pgsql-www mailing list (pgsql-www@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-www
On Fri, Oct 13, 2017 at 7:02 AM, Daniel Gustafsson <daniel@yesql.se> wrote:
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.
> 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...