[sqlalchemy] DB sync on application level

2015-09-26 Thread Cornelinux K
Hello, I have an application that uses an SQL database with also many write access. Now I am thinking of high availability. One solution was to set up a mysql master master replication. But I was thinking, there might be some good aspects when doing the synchronization on the application

[sqlalchemy] ora-25408 can not safely replay call

2015-09-26 Thread Abhishek Sharma
Hi Team, We have integrated our Django project with sqlalchemy ORM. Django: 1.4.2 SQLALCHEMY-0.8 Recently we started getting the following error while making the service call and it leads to internal server error: *ora-25408 can not safely replay call* Is there any way in

Re: [sqlalchemy] ora-25408 can not safely replay call

2015-09-26 Thread Mike Bayer
On 9/26/15 10:28 AM, Abhishek Sharma wrote: Hi Team, We have integrated our Django project with sqlalchemy ORM. Django: 1.4.2 SQLALCHEMY-0.8 Recently we started getting the following error while making the service call and it leads to internal server error: *ora-25408 can not

Re: [sqlalchemy] DB sync on application level

2015-09-26 Thread Mike Bayer
On 9/26/15 6:35 AM, Cornelinux K wrote: Hello, I have an application that uses an SQL database with also many write access. Now I am thinking of high availability. One solution was to set up a mysql master master replication. that's a good solution. But I was thinking, there might be

Re: [sqlalchemy] funky session usage to add join conditions and where clauses

2015-09-26 Thread Mike Bayer
On 9/25/15 12:24 PM, Chris Withers wrote: On 25/09/2015 13:58, Mike Bayer wrote: session.query(A).filter(A.id>10).as_at(now)) you'd need to subclass Query and dig into Query.column_descriptions to get at the existing entities, then add all that criterion. remind me where the docs are for

Re: [sqlalchemy] views

2015-09-26 Thread Mike Bayer
On 9/25/15 9:00 AM, Mike Bayer wrote: On 9/25/15 3:13 AM, Chris Withers wrote: Hi All, Is this still the best way to hand views, or are there later and greater things in 1.0+? https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/Views How would I make a view behave like a normal