On Thu, 15 Nov 2018 at 16:41, Mike Bayer wrote:
> >
> > But then you lose the benefits of the cache, and the Bakery is only
> useful if you use the same Querys over and over. Unless I've completely
> misunderstood how it works.
>
> well the "anonymous" bindparam() still has a name. you just use
On Thu, Nov 15, 2018 at 10:17 AM Martijn van Oosterhout
wrote:
>
>
>
> On Thu, 15 Nov 2018 at 14:55, Mike Bayer wrote:
>>
>> > And have all the query compilation cached. All the query stuff can be put
>> > near the model so your code isn't covered with fragments of SQLAlchemy. I
>> > have no id
On Thu, 15 Nov 2018 at 14:55, Mike Bayer wrote:
> > And have all the query compilation cached. All the query stuff can be
> put near the model so your code isn't covered with fragments of SQLAlchemy.
> I have no idea if this pattern is common, but it works well for us.
>
> filter_by_id and filter
On Thu, Nov 15, 2018 at 12:27 AM Martijn van Oosterhout
wrote:
>
> Hoi Mike,
>
> On Wednesday, November 14, 2018 at 11:30:18 PM UTC+1, Mike Bayer wrote:
>>
>> I have some big ideas for the baked concept which may or may not
>> impact this area as well. But they are only ideas for now, I have
>>
Hoi Mike,
On Wednesday, November 14, 2018 at 11:30:18 PM UTC+1, Mike Bayer wrote:
>
> I have some big ideas for the baked concept which may or may not
> impact this area as well. But they are only ideas for now, I have
> many explicit SQLAlchemy tasks that I have to get done before I can
> tr
I have some big ideas for the baked concept which may or may not
impact this area as well. But they are only ideas for now, I have
many explicit SQLAlchemy tasks that I have to get done before I can
try to explore that stuff.
On Wed, Nov 14, 2018 at 4:34 PM Martijn van Oosterhout
wrote:
>
> Ho
Hoi Mike,
You're right, we should probably measure it first. You state that the
simple joins and filters are probably cheap which I don't doubt. We also do
correlated subqueries and stuff. Actually, we also use the baking mechanism
to cache some of our own processing which goes into the constructi
On Tue, Nov 13, 2018 at 3:49 PM Martijn van Oosterhout
wrote:
>
> Hoi,
>
> We're starting to do some pretty complicated things with the SQLAlchemy
> bakery (because we have some pretty complicated queries) and I have something
> I'd like to verify.
>
> We have queries that are constructed like s
Hoi,
We're starting to do some pretty complicated things with the SQLAlchemy
bakery (because we have some pretty complicated queries) and I have
something I'd like to verify.
We have queries that are constructed like so (each letter is a step):
A B C .. M N0
A B C .. M N1
A B C .. M N2
A B C .