Re: [Sqlalchemy-users] Problems with connection

Mysql has a idle timeout on connection. If you leave a connection idle for a long time (hours) then mysql will drop the connection. This is controlled by wait_timeout system variable. To find out more Google mysql wait_timeout William K. Volkman wrote: > On Sun, 2006-07-30 at 17:28 +0300, Joona

Re: [Sqlalchemy-users] SQLAlchemy and Firebird SQL

Hello, Jonathan Ellis said the following on 29.07.2006 4:31: > users_table.create() > i = users_table.insert() > print i > - > > And it gives me this: > AttributeError: 'NoneType' object has no attribute

Re: [Sqlalchemy-users] SQLAlchemy and Firebird SQL

Hello, Michael Bayer said the following on 29.07.2006 6:47: > firebird support is not regularly maintained. though its not very hard, > assuming one has firebird installed (i dont, doesnt seem to have an OSX > version that is up to date). There are OSX versions of most recent 1.5.3 release,

[Sqlalchemy-users] SQL design pattern and Activemapper

Hi, I've encountered a couple of instances of a specific SQL design pattern, aimed at mimicking a linked list (of comments and sub- comments to blog entries) and I'd just like to check that the pattern is known not to be supported in ActiveMapper. Michael Bayer describes the pattern as "hand

Re: [Sqlalchemy-users] Problems with connection

On Sun, 2006-07-30 at 17:28 +0300, Joona Kulmala wrote: > I'm having some problems with ActiveMapper and MySQL connection. I'm > using SQLAlchemy on top of Twisted webserver. Everything works > wmoothly when the site is used, but if the connection is unused for > some time, the whole webserve

[Sqlalchemy-users] Problems with connection

I'm having some problems with ActiveMapper and MySQL connection. I'm using SQLAlchemy on top of Twisted webserver. Everything works wmoothly when the site is used, but if the connection is unused for some time, the whole webserver frozes on page load and finally after some minutes it throws

Re: [Sqlalchemy-users] delimited identifiers with postgresql

Michael Bayer wrote: > ticket #155. theres some patches there that are very close to how it > should be done. i didnt like the "quote_string" function being called so > often but there might not be any way around that (i.e. maybe the > quote=True flag not really worth it). > > what this patch wo

[Sqlalchemy-users] NOWAIT

Hello, I implemented NOWAIT clause for select statement. I updated files sqlalchemy/sql.py and sqlalchemy/ansisql.py near occurences of for_update clause. I hope that is enough to properly support NOWAIT. See attached file for diff againist latest svn. -- Best regards, Vasily