warning for postgres users: current contrib/pg8000 is old and causes weird postgres errors

[Mirek Zvolský]

As long the contrib/pg8000 version is old,

it is good idea to install the current version: pip install pg8000

Errors from old driver are like (at least pg 9.6, long running tasks): OperationalError, Broken Pipe,...

I have created issues:

https://github.com/web2py/web2py/issues/1742

https://github.com/web2py/pydal/issues/490

I don't know how to create pull request,

because with just replacing contrib/pg8000 with new content

the web2py (pydal?) will not find the driver.

Mirek

[Mirek Zvolský]

Other advantage (for me) is that the database access with the current version of pg8000 seems to be faster (- 30% ?).

However I should say following:

I was never interested about the used postgres driver.

Now I read about differences:

pg8000 is pure python, so probably runs everywhere,

psycopg2 uses standard C postgres client libraries (means: for some os it could be difficult to install)

Previous means psycopg2 is faster (2-4 times?) and more compatible.

So if it is no problem to install psycopg2, it should be used. Web2py uses psycopg2 if installed.

pip install psycopg2

Dne čtvrtek 17. srpna 2017 14:33:51 UTC+2 Mirek Zvolský napsal(a):

[Alex Glaros]

I have older version of w2p on pythonAnywhere.com

anyone know which to use for pythonAnywhere.com?

how to update on pythonAnywhere.com?

thanks

Alex Glaros

[Gualter Portella]

Alex,

You've got to upgrade your account to a paid one on the account tab.

When you customize your plan, choose the postgres server option.

The postgres option itself will cost you an extra charge of US$7 per month.

Hope this helps.

Gualter

[Alex Glaros]

Thanks Gualter. I do have the paid account but web2py versions are not automatically updated on pythonAnywhere, so was looking for any tips, if needed.

[Gualter Portella]

Hi Alex, 

What I did a month ago was to click on the update button and it worked.

Best,

Gualter

Enviado do meu iPhone

Em 22 de ago de 2017, às 13:33, Alex Glaros <alexg...@gmail.com> escreveu:

Thanks Gualter. I do have the paid account but web2py versions are not automatically updated on pythonAnywhere, so was looking for any tips, if needed.

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/YtUTRdcgXWM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Alex Glaros]

did it update pg8000 too?

thanks Gualter

Alex

[Gualter Portella]

To be honest I did not check, but you can check using the shell.

Best,

Gualter 

Enviado do meu iPhone

--