[sqlalchemy] real time plotting

2015-02-14 Thread lunatek78
hi everyone , I want the record data continually form a sensor in the datebase and then i can use it to plot a real time chart on my web page . I use sqlachemy and pygal for plotting . My question is how can i access and clean dynamilcy data from my databse . thank you -- You received thi

Re: [sqlalchemy] idle in transaction

2015-02-14 Thread Ed Rahn
On 02/13/2015 11:30 PM, Michael Bayer wrote: Ed Rahn wrote: I have several programs that are Multi Process and long running, they open up 30 or so connections and do selects periodically. For a select query, the default behaviour is to begin a transaction if not currently in one, but not com

Re: [sqlalchemy] Problem unpickling metadata for Postgres custom datatype

2015-02-14 Thread S P
Mike, OK, thanks for the quick reply. Many thanks too for SQLAlchemy! Steve -- 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 sqlalchemy+unsubscr...@googlegroup

Re: [sqlalchemy] Problem unpickling metadata for Postgres custom datatype

2015-02-14 Thread Michael Bayer
S P wrote: > I am using SQLAlchemy version 0.9.7. I have ~ 400 tables that I > automatically reflect from the database. I would like to cPickle the > metadata after reflection and store this, then subsequently unpickle the > metadata and use it (for speedup) rather than use reflection agai

[sqlalchemy] Problem unpickling metadata for Postgres custom datatype

2015-02-14 Thread S P
I am using SQLAlchemy version 0.9.7. I have ~ 400 tables that I automatically reflect from the database. I would like to cPickle the metadata after reflection and store this, then subsequently unpickle the metadata and use it (for speedup) rather than use reflection again. The pickle goes fi

Re: [sqlalchemy] Use multiple database for read and write operations

2015-02-14 Thread Michael Bayer
ahmadjaved...@gmail.com wrote: > Hi, > > I am working on a web site using Python Django and SQLAlchemy ORM. I want to > do all read operations in separate database and write operations in separate > database. > So I tried Mike Bayer's solution > (http://techspot.zzzeek.org/2012/01/11/django

[sqlalchemy] Use multiple database for read and write operations

2015-02-14 Thread ahmadjaved . se
Hi, I am working on a web site using Python Django and SQLAlchemy ORM. I want to do all read operations in separate database and write operations in separate database. So I tried *Mike Bayer*'s solution ( http://techspot.zzzeek.org/2012/01/11/django-style-database-routers-in-sqlalchemy/) but

[sqlalchemy] Re: idle in transaction

2015-02-14 Thread Jonathan Vanasco
Just to add to Michael's reply -- keep in mind that how you handle the session (commit/rollback/close) will impact the state of any objects the session loaded if you're using the ORM and that can have implications in your app. The default behavior of sessions is to have `expire_on_commit=True`