[sqlalchemy] Re: One Class Mapping Multiple Tables

FWIW, instead of creating one big table you may be able to partition the data on the database level. I know postgres does this, not sure about others. If you're unfamiliar with it, you would create 1 master table that has an id field for the stock. Then you create a partition for each stock.

Re: [sqlalchemy] SAWarning shows not immediately, but after some time of app execution

On Fri, Jul 22, 2016 at 3:25 PM, TomS. wrote: > On 07/19/2016 06:41 PM, Mike Bayer wrote: > > > > On 07/19/2016 11:51 AM, TomS. wrote: > > Hi, > > We have Flask app which uses SQLAlchemy. Weird error started to happen > recently. The difficulty is that we can't reproduce the

Re: [sqlalchemy] SAWarning shows not immediately, but after some time of app execution

On 07/19/2016 06:41 PM, Mike Bayer wrote: On 07/19/2016 11:51 AM, TomS. wrote: Hi, We have Flask app which uses SQLAlchemy. Weird error started to happen recently. The difficulty is that we can't reproduce the error (/figure out conditions causing issue) - maybe someone could help. Any

Re: [sqlalchemy] Is there a way to create custom classes that inherit from sqlalchemy models in external library?

the first error is because declarative isn't smart enough to figure out this many __abstract__ flags, and I'd support efforts to improve this. But if you pass __abstract__ = False in a few places that gives it the clues it needs to get to the second case (as well as removing the __abstract__ =

Re: [sqlalchemy] One Class Mapping Multiple Tables

On 07/21/2016 07:06 PM, John Robson wrote: Hi everyone, I want to store the minute price of all 500 stocks from S 500. This means more than 500 million of rows + almost 200K updates per day + (sometimes) past values must be updated (to adjust ex-dividend, splits). Instead of creating a BIG

[sqlalchemy] Re: connecet to database file

On Friday, July 22, 2016 at 10:56:17 AM UTC+5:30, Honey Khangura wrote: > > > Hello guys, I am running a bot on bitfinex.com and creating ticker's > Database(file_name.db) I am using sqlalchemy API and sqlite Database >

Re: [sqlalchemy] Re: explicitly add objects to identity map

Thanks for the link :) Le jeudi 21 juillet 2016 20:18:05 UTC+2, Mike Bayer a écrit : > > > > On 07/21/2016 01:44 PM, Simon King wrote: > > On Thu, Jul 21, 2016 at 5:58 PM, Jonathan Vanasco > wrote: > >> > >> > >> On Thursday, July 21, 2016 at 12:15:40 PM UTC-4, Simon