[sqlalchemy] Re: [RFC] Connecting SqlAlchemy to NoSQL DBs

2016-09-27 Thread Ashfaque Siddiqui
Hey Olemis, Did you ever find anything in response to this request? I have a similar question, we are able to use SQLAlchemy for our SQL based dbs, but looking for an abstraction layer for NoSQL - the issue is that these NoSQL dbs are also conceptually quite different but maybe for

[sqlalchemy] concerns over generating a bitwise comparison in postgres - (or "can columns be explicit in a text filter?"

2016-09-27 Thread Jonathan Vanasco
Let's say that I have a table such as this: CREATE TABLE foo ( id SERIAL PRIMARY KEY, attribute_toggles INT DEFAULT NULL ); CREATE INDEX idx_attribute_toggles ON foo(CAST(attribute_toggles AS BIT(32))) WHERE attribute_toggles <> 0; represented by such a

Re: [sqlalchemy] Dialects supporting autocommit in the current session

2016-09-27 Thread Mark Sandan
Thanks! I'll check it out. I wanted to write an application that made sure to autocommit for various database backends or else if those backends already support it, then don't autocommit. I will check out the set_isolation_level() method. On Tuesday, September 27, 2016 at 7:34:29 AM UTC-7,

Re: [sqlalchemy] Dialects supporting autocommit in the current session

2016-09-27 Thread Mike Bayer
On 09/26/2016 09:25 PM, Mark Sandan wrote: Hi, I was wondering if there exists a dialect-wide way to query whether the underlying database is in a transaction mode that requires an autocommit or not. In Teradata, there is this notion of a transaction mode. When a session in Teradata is in a