[sqlalchemy] Splitting a table ?

2015-12-02 Thread Jonathan Vanasco
I recently had to "split" or partition another table into 2 -- one of high write and low write access. The new table is just the high-write columns fkey'd onto the original table, and handled with a relationship. I was wondering if there was any "shortcut" in sqlalchemy to automatically

Re: [sqlalchemy] Splitting a table ?

2015-12-02 Thread Jeff Widman
I've also been dealing with a similar problem of managing a parent/child table that is the result of splitting an original table, and also curious to hear suggested solutions. Solutions I've thought about so far: a) using a hybrid property or column_property to map the columns back onto the

Re: [sqlalchemy] Splitting a table ?

2015-12-02 Thread Mike Bayer
On 12/02/2015 10:18 AM, Jonathan Vanasco wrote: > > I recently had to "split" or partition another table into 2 -- one of high > write and low write access. The new table is just the high-write columns > fkey'd onto the original table, and handled with a relationship. > > I was wondering if