[Dbix-class] Re: Running Parallel queries

I'm poking on this just to see if anyone can provide some ideas on approaches to consider. The use case is a sharded infrastructure where, for example, a user table would be on every shard. So, you might want to ask "which database shards have user rows with a given email address?" And then ass

[Dbix-class] Support for inline where (left join with extra condition)

Hi, Anyone know of native support queries like: SELECT * FROM artist a LEFT JOIN cd c *ON a.name = c.artist AND c.year = 2000* Note the complex on clause. This is basically a four year bump of this thread: http://dbix-class.35028.n2.nabble.com/Left-join-with-an-extra-condition-td3880896.htm

[Dbix-class] Re: Support for inline where (left join with extra condition)

brew writes: > Hi, > > Anyone know of native support queries like: > > SELECT * FROM artist a LEFT JOIN cd c *ON a.name = c.artist AND c.year = > 2000* > > Note the complex on clause. Yes, this is now supported by custom join conditions, which give you the full power of SQLA to build your ON cla

Re: [Dbix-class] Re: Support for inline where (left join with extra condition)

Yes that is a good improvement, thanks. For my case I would need the year to be a bind variable which doesn't look like it is possible, so I will use two queries or subselect. Thanks On 13/03/13 22:38, Dagfinn Ilmari Mannsåker wrote: brew writes: Hi, Anyone know of native support querie