efficient way to process data

Chris Angelico rosuav at gmail.com
Sun Jan 12 17:18:42 EST 2014


On Mon, Jan 13, 2014 at 6:53 AM, Petite Abeille
<petite.abeille at gmail.com> wrote:
> On Jan 12, 2014, at 8:23 PM, Larry Martell <larry.martell at gmail.com> wrote:
>
>> AFAIK, there is no way to do this in SQL.
>
> Sounds like a job for window functions (aka analytic functions) [1][2].

That's my thought too. I don't think MySQL has them, though, so it's
either going to have to be done in Python, or the database back-end
will need to change. Hard to say which would be harder.

ChrisA



More information about the Python-list mailing list