[web2py] Re: Using mysqldb instead of pymysql

2011-01-12 Thread Massimo Di Pierro
that should do it. but why? pymysql is faster and more portable. On Jan 12, 8:38 am, Luther Goh Lu Feng wrote: > I upgraded a project from 1.87.3 to 1.91.6. Pymysql is one of the new > features, replacing mysqldb. > > I would like to ask if it is possible to do an override and use > mysqldb inste

[web2py] Re: Using mysqldb instead of pymysql

2011-01-12 Thread Luther Goh Lu Feng
There are some concerns that pymysql might not be ready for production yet. Nothing specific. But mysqldb is definitely stable and tested. On Jan 12, 10:47 pm, Massimo Di Pierro wrote: > that should do it. but why? pymysql is faster and more portable. > > On Jan 12, 8:38 am, Luther Goh Lu Feng w

[web2py] Re: Using mysqldb instead of pymysql

2011-01-12 Thread Luther Goh Lu Feng
Anyway these are some of the open pymysql issues http://code.google.com/p/pymysql/issues/list On Jan 12, 11:02 pm, Luther Goh Lu Feng wrote: > There are some concerns that pymysql might not be ready for production > yet. Nothing specific. But mysqldb is definitely stable and tested. > > On Jan 1

[web2py] Re: Using mysqldb instead of pymysql

2011-01-12 Thread Luther Goh Lu Feng
Btw, is there a link I can read about pymysql being faster and more portable? On Jan 12, 10:47 pm, Massimo Di Pierro wrote: > that should do it. but why? pymysql is faster and more portable. > > On Jan 12, 8:38 am, Luther Goh Lu Feng wrote: > > > > > > > > > I upgraded a project from 1.87.3 to 1

[web2py] Re: Using mysqldb instead of pymysql

2011-01-12 Thread Massimo Di Pierro
It is more portable because it is pure python (mysqldb includes c libraries). About faster, I remember reading something about that but this everything I could find today: http://code.google.com/p/pymysql/wiki/Performance On Jan 12, 9:40 am, Luther Goh Lu Feng wrote: > Btw, is there a link

[web2py] Re: Using mysqldb instead of pymysql

2011-01-12 Thread drayco
I need that some of you guys check this, in my case, Pymysql have some issues with legacy databases (First, I think this issue is of new dal, but I'm not sure) However mysqldb, my application work well this is my report: http://groups.google.com/group/web2py/browse_thread/thread/72e91e281e0610d8/

[web2py] Re: Using mysqldb instead of pymysql

2011-01-14 Thread Luther Goh Lu Feng
To test if the issue is with pymysql, you could edit the dal file to use mysqldb http://code.google.com/p/web2py/source/diff?spec=svnfc75444ca55590835b4d0dc0e6c06a85e3f282a8&r=fc75444ca55590835b4d0dc0e6c06a85e3f282a8&format=side&path=/gluon/dal.py On Jan 13, 11:31 am, drayco wrote: > I need that

[web2py] Re: Using mysqldb instead of pymysql

2011-01-18 Thread drayco
Hi, I do this revert, thank's try: import MySQLdb drivers.append('MySQL') except ImportError: logger.debug('no MySQLdb driver') And self.pool_connection(lambda db=db, user=credential_decoder(user), password=credential_

[web2py] Re: Using mysqldb instead of pymysql

2011-01-18 Thread Massimo Di Pierro
I just included the latest pymysql in trunk. Does it make things better? On Jan 18, 6:05 pm, drayco wrote: > Hi, I do this revert, thank's > > try: >     import MySQLdb >     drivers.append('MySQL') > except ImportError: >     logger.debug('no MySQLdb driver') > > And > >         self.pool_connec

[web2py] Re: Using mysqldb instead of pymysql

2011-01-20 Thread drayco
Hi, I did my test with trunk version this is the issue Traceback (most recent call last): File "/home/drayco/web2py/gluon/restricted.py", line 188, in restricted exec ccode in environment File "/home/drayco/web2py/applications/iscada/models/cfedb.py", line 16, in migrate = False) F

Re: [web2py] Re: Using mysqldb instead of pymysql

2011-01-12 Thread Vasile Ermicioi
hi, Massimo, there is a new version of pymysql I think pymysql has a few advantages - being pure Python, PyMySQL is easily patched by gevent and the likes to make it cooperative http://code.google.com/p/pymysql/wiki/WhyPyMySQL I use it with web2py and works fine