Re: [sqlalchemy] sqlite and max_overflow

2013-05-28 Thread jo
Thanks for the tip, Michael, I'm going to see how to manage with this keyword (because I'm not specify such parameter, but probable is turbogears who uses it by default). j Michael Bayer wrote: you can't use max_overflow with the default connection pool used by the SQLite engine, remove

Re: [sqlalchemy] sqlite and max_overflow

2013-05-28 Thread Simon King
I think turbogears is loading your sqlalchemy parameters from a config file (dev.cfg perhaps?). You should look for a line of the form sqlalchemy.max_overflow = X and delete it. Hope that helps, Simon On Tue, May 28, 2013 at 10:34 AM, jo jose.soa...@sferacarta.com wrote: Thanks for the tip,

Re: [sqlalchemy] implementing implicit scalar collections

2013-05-28 Thread Burak Arslan
Hi Mike, On 05/25/13 17:59, Michael Bayer wrote: Your primary key is far from useless. If your collection consists of unique values, then that's your primary key. If your collection consists of non-unique values, but are unique to their parent, then again, that's your primary key (a

Re: [sqlalchemy] sqlite and max_overflow

2013-05-28 Thread jo
Yes, you are right, Simon, I found it in app.cfg as: sqlalchemy.max_overflow=40 # Bumped up from 10 sqlalchemy.pool_size=10# default thanks a lot. j Simon King wrote: I think turbogears is loading your sqlalchemy parameters from a config file (dev.cfg perhaps?). You should look for a

[sqlalchemy] trouble with postgresql ANY

2013-05-28 Thread Jon Nelson
I'm having difficulty using PostgreSQL's ANY operator (for use with arrays). I've tried several variations of the syntax provided in the documentation, but all I ever get is: AttributeError: 'SQLCompiler' object has no attribute 'visit_any' What am I likely doing wrong? I've tried (using

Re: [sqlalchemy] trouble with postgresql ANY

2013-05-28 Thread Michael Bayer
printing a SQL construct invokes the default dialect which doesn't support Postgresql operators, use compile() for stringification: from sqlalchemy.dialects import postgresql dialect = postgresql.dialect() print stmt.compile(dialect=dialect) On May 28, 2013, at 10:23 AM, Jon Nelson

[sqlalchemy] storage in disk

2013-05-28 Thread lei zhang
hi all, why the storage of monetdb in the disk is 64-B-tree, is there some advantages using this method? -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To unsubscribe from this group and stop receiving emails from it, send an email to