Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-20 Thread Kevin S
Ah ok, I did not know you could use FreeTDS with pyodbc. It was a bit more complicated to set up, but I finally got pyodbc installed and working. I reran my thread tests, and they seem to be working. They don't have the locking issue anymore. However, I have one small (hopefully small) issue

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-20 Thread Michael Bayer
On Jun 20, 2013, at 12:54 PM, Kevin S kevinrst...@gmail.com wrote: Ah ok, I did not know you could use FreeTDS with pyodbc. It was a bit more complicated to set up, but I finally got pyodbc installed and working. I reran my thread tests, and they seem to be working. They don't have the

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-19 Thread Kevin S
Unfortunately, we cannot switch off of Sybase. It is a future project, but we cannot go there right now (I would love to). I also have not been able to find any other sybase dbapis that work with sqlalchemy and are free. I did set up some tests against pysybase directly, omitting the

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-19 Thread Michael Bayer
On Jun 19, 2013, at 3:07 PM, Kevin S kevinrst...@gmail.com wrote: Unfortunately, we cannot switch off of Sybase. It is a future project, but we cannot go there right now (I would love to). I also have not been able to find any other sybase dbapis that work with sqlalchemy and are free.

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-17 Thread Ladislav Lenart
Hello. This will probably be completely off-topic, but we have recently solved a similar issue. In our case it was cherrypy's fault, because it uses 'implicit' 'sesssions.locking' by default. It acquires web session's lock at the beginning of a web request processing and releases it at the end of

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-16 Thread Kevin S
I can try to get another dbapi installed later this week and see if that works. However, I had to jump through some hoops just to get pysybase working in the first place, so I'm not terribly looking forward to trying to tackle another one. I don't know much about how sessions are managed (I

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-16 Thread Michael Bayer
On Jun 16, 2013, at 12:55 PM, Kevin S kevinrst...@gmail.com wrote: I can try to get another dbapi installed later this week and see if that works. However, I had to jump through some hoops just to get pysybase working in the first place, so I'm not terribly looking forward to trying to

Re: [sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-15 Thread Michael Bayer
On Jun 14, 2013, at 3:18 PM, Kevin S kevinrst...@gmail.com wrote: I am running into a problem while developing a flask application using flask-sqlalchemy. Now, I'm not even 100% sure my problem is sqlalchemy related, but I don't know how to debug this particular issue. To start, I have a

[sqlalchemy] flask-sqlalchemy pysybase connections

2013-06-14 Thread Kevin S
I am running into a problem while developing a flask application using flask-sqlalchemy. Now, I'm not even 100% sure my problem is sqlalchemy related, but I don't know how to debug this particular issue. To start, I have a sybase database that I want to see if I can build a report generating