Re: [sqlalchemy] Best way to set up sqlite_pragma for all applications

2014-05-07 Thread Bao Niu
That helps a lot! Every time it is so enjoyable reading your reply, it's so clear and cogent. Thank you very much Simon! TWO THUMBS UP!! On Tue, May 6, 2014 at 3:00 AM, Simon King si...@simonking.org.uk wrote: On Tue, May 6, 2014 at 10:14 AM, Bao Niu niuba...@gmail.com wrote: I am seeking

[sqlalchemy] Best way to set up sqlite_pragma for all applications

2014-05-06 Thread Bao Niu
I am seeking some advice on best practice regarding setting up sqlite_pragma across applications. I have the following code which I currently put in each and every module across my applications, wherever such module uses SQLAlchemy. @sqlalchemy.event.listens_for(sqlalchemy.engine.Engine,

Re: [sqlalchemy] Best way to set up sqlite_pragma for all applications

2014-05-06 Thread Simon King
On Tue, May 6, 2014 at 10:14 AM, Bao Niu niuba...@gmail.com wrote: I am seeking some advice on best practice regarding setting up sqlite_pragma across applications. I have the following code which I currently put in each and every module across my applications, wherever such module uses