Re: [sqlalchemy] relationships, potentially large collections and eagerloading/bad dbs.

2016-03-30 Thread Jonathan Vanasco
Thanks a ton. This was really quick to implement and solved a bunch of issues! -- 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

Re: [sqlalchemy] relationships, potentially large collections and eagerloading/bad dbs.

2016-03-30 Thread Mike Bayer
On 03/30/2016 11:56 AM, Jonathan Vanasco wrote: On Wednesday, March 30, 2016 at 12:46:01 AM UTC-4, Mike Bayer wrote: why can't you build a relationship() which has its primaryjoin set up to do this? You can do it w/ a correlated subquery. Can you reference an example ? from

Re: [sqlalchemy] relationships, potentially large collections and eagerloading/bad dbs.

2016-03-30 Thread Jonathan Vanasco
On Wednesday, March 30, 2016 at 12:46:01 AM UTC-4, Mike Bayer wrote: why can't you build a relationship() which has its primaryjoin set up to > do this? You can do it w/ a correlated subquery. > Can you reference an example ? > That is, unless you want this relationship() to load

Re: [sqlalchemy] relationships, potentially large collections and eagerloading/bad dbs.

2016-03-29 Thread Mike Bayer
On 03/29/2016 06:32 PM, Jonathan Vanasco wrote: I'm in the processes of open-sourcing a mini-project and need to support sqlite -- so I'd like to be a bit easier on DB operations. The following use-case is puzzling me: I want to view a record on TableA, which will show the last 5 related

[sqlalchemy] relationships, potentially large collections and eagerloading/bad dbs.

2016-03-29 Thread Jonathan Vanasco
I'm in the processes of open-sourcing a mini-project and need to support sqlite -- so I'd like to be a bit easier on DB operations. The following use-case is puzzling me: I want to view a record on TableA, which will show the last 5 related objects in TableB and a 'see all' link. It's