Re: [sqlalchemy] custom __init__ methods not being invoked

2013-02-13 Thread Ryan McKillen
Thanks for the details. Makes sense. Still not consistent with what I'm experiencing. Although consistent with what I'm seeing when I put a simple example/test together. I'll keep digging... — RM On Feb 12, 2013, at 4:51 PM, Michael Bayer wrote: > its called in all SQL loading scenarios inclu

Re: [sqlalchemy] storing a large file into a LargeBinary question

2013-02-13 Thread Andre Charbonneau
Thanks for the feedback Michael. Lots of good information in there. I will read up on buffer() and memoryview() and also on custom SQLAlchemy types. Thanks again, Andre On 13-02-12 04:33 PM, Michael Bayer wrote: > On Feb 12, 2013, at 3:22 PM, Andre Charbonneau > wrote: > >> Greetings everyon

Re: [sqlalchemy] Low performance when reflecting tables via pyodbc+mssql

2013-02-13 Thread shaung
On Tuesday, February 12, 2013 9:13:48 PM UTC+9, betelgeuse wrote: > I had a smilar problem. > I had a ms sql database that another application created and I need to > select data from it. There was lots of tables so I tried reflection but > it was slow so I decided to use sa declarative method.

Re: [sqlalchemy] Low performance when reflecting tables via pyodbc+mssql

2013-02-13 Thread 耿 爽
On Tue, Feb 12, 2013 at 9:37 PM, Simon King wrote: > > Caching the metadata should be fairly easy if you are happy with that > > approach. I think MetaData instances are picklable: > > > > > http://stackoverflow.com/questions/11785457/sqlalchemy-autoloaded-orm-persistence > Just pickled all the