1. Good point on that. I was also thinking that perhaps materialized views could help, but I’m not clueful enough to design for that.
2. As noted, I’m not yet thinking too much about performance. There are a few techniques I am keeping in mind for that. The baked query idea looks good. 3. I am indeed pretty close to thinking about this as a PL/pgsql function, especially if I can make it fit in well with a column type and into the rest of querying, to keep it feeling natural. —Paul > On Oct 21, 2015, at 10:20 PM, Jonathan Vanasco <[email protected]> wrote: > > This looks painful to me for a few reasons: > > 1. Hitting the db on everything is pricey. Building this with the foresight > that a read-through cache will eventually be needed might be a good idea. > 2. Some of the SqlAlchemy generation looks to be likely expensive (within > Python). It would probably make sense to do this in a way that takes > advantage of the newer 'baked' queries. > (http://docs.sqlalchemy.org/en/latest/orm/extensions/baked.html) > 3. If you're locking down to Postgres for the JSONB support... you might as > well develop this as postgres function and python code to interact with it. > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at http://groups.google.com/group/pylons-discuss > <http://groups.google.com/group/pylons-discuss>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/pylons-discuss. For more options, visit https://groups.google.com/d/optout.
