| 00:00.25 | *** join/#storm _mup_ (~mup@li37-90.members.linode.com) |
| 00:19.51 | *** join/#storm rrerolle_ (~rrerolle@neonex.fr) |
| 00:23.36 | *** join/#storm jamesh (~james@canonical/launchpad/jamesh) |
| 02:21.33 | *** join/#storm gggirl (~gggirl@212-198-248-35.rev.numericable.fr) |
| 03:03.26 | *** join/#storm lakin (~lakin@S010600265af23ae6.cg.shawcable.net) |
| 04:29.52 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 05:10.28 | *** join/#storm m4v (~znc@unaffiliated/m4v) |
| 06:02.39 | *** join/#storm stub (~stub@125.24.143.153.adsl.dynamic.totbb.net) |
| 06:02.39 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 06:53.27 | *** join/#storm danilo_ (~danilo@static-213-198-236-193.adsl.eunet.rs) |
| 07:19.54 | *** join/#storm danilos (~danilo@canonical/launchpad/danilos) |
| 07:20.04 | *** join/#storm danilo_ (~danilo@cable-178-148-38-107.dynamic.sbb.rs) |
| 08:00.35 | *** join/#storm bigjools (~quassel@canonical/launchpad/bigjools) |
| 08:26.59 | *** join/#storm esteve (~quassel@cli-5b7ee9bd.bcn.adamo.es) |
| 08:57.40 | *** join/#storm stub (~stub@125.24.143.153.adsl.dynamic.totbb.net) |
| 08:57.40 | *** join/#storm stub (~stub@canonical/launchpad/stub) |
| 11:05.42 | *** join/#storm danilos (~danilo@static-213-198-236-193.adsl.eunet.rs) |
| 11:05.42 | *** join/#storm danilos (~danilo@canonical/launchpad/danilos) |
| 11:17.34 | *** join/#storm zmijunkie (~sascha@46.115.10.228) |
| 11:44.31 | *** join/#storm esteve (~quassel@cli-5b7ee9bd.bcn.adamo.es) |
| 11:57.59 | *** join/#storm niemeyer (~niemeyer@200-102-220-163.pltce701.dsl.brasiltelecom.net.br) |
| 13:33.34 | *** join/#storm jdobrien (~john@rrcs-24-73-235-170.se.biz.rr.com) |
| 14:18.47 | *** join/#storm jdobrien (~john@rrcs-24-73-235-170.se.biz.rr.com) |
| 14:50.22 | *** join/#storm lakin (~lakin@S010600265af23ae6.cg.shawcable.net) |
| 14:54.57 | *** part/#storm stub (~stub@canonical/launchpad/stub) |
| 16:09.19 | *** join/#storm magmatt (~Matt@63-235-131-194.dia.static.qwest.net) |
| 16:14.57 | *** join/#storm jdobrien (~john@rrcs-24-73-235-170.se.biz.rr.com) |
| 16:51.17 | *** join/#storm maxb (~maxb@jabberwock.vm.bytemark.co.uk) |
| 18:39.22 | magmatt | How do you guys handle complex report queries (sums and counts and stuff) |
| 18:39.43 | magmatt | That was one failing of sqlalchemy last time I tried it -- working with objects is great... but reports are a pain |
| 18:44.49 | jkakar | magmatt: You can use expressions to build up such queries. |
| 18:45.29 | magmatt | jkakar: yeah.... at that point I always feel like I'm writing SQL anyway, so why bother with the python? |
| 18:45.38 | magmatt | Let me come up with a specific problem |
| 18:45.48 | jkakar | magmatt: Yeah, it might not be worth the trouble. |
| 18:46.07 | jkakar | magmatt: If you don't need to build objects, or do fancy things with ResultSet.values, then using Store.execute with raw SQL is fine. |
| 18:47.07 | jkakar | But you can also do things like, result = store.find((Count(), User.birthday)); result.group_by(User.birthday), to run something like: SELECT COUNT(*) FROM user GROUP BY birthday |
| 18:47.39 | jkakar | The raw SQL is arguably easier to read. The benefit of being able to do it with expressions is when you have code that can generate a variety of expression trees, depending on some inputs. |
| 18:47.40 | magmatt | jkakar: I'm joining on 3 tables and only taking the top row of one of them |
| 18:48.01 | magmatt | jkakar: yes, I like being able to put different expressions together |
| 18:49.21 | jkakar | magmatt: Yeah, I prefer to use expressions compared to raw SQL... I'm not sure it buys me much. |
| 18:49.47 | jkakar | magmatt: The reason I prefer expressions is because I think code is a less error prone way, in some weird way, to express the logic than strings... strings suck. :) |
| 18:50.23 | magmatt | jkakar: you also get cross-database benefits. When I write SQL, I usually end up using some postgres or sqlite-specific thing |
| 18:50.36 | jkakar | magmatt: Yeah, me too. |
| 18:53.18 | magmatt | jkakar: I also would prefer storm to SQL because Storm wraps up some bad column names into good ones |
| 18:53.37 | jkakar | magmatt: Ah, yeah, that's a good point. |
| 18:54.02 | jkakar | magmatt: Also, you won't accidentally open yourself to an injection attack if you use %s instead of ? by mistake. |
| 18:54.15 | jkakar | magmatt: I'm stepping away for awhile, have a good one! |
| 18:54.22 | magmatt | thanks |
| 19:00.30 | *** join/#storm jdobrien (~john@50-88-19-25.res.bhn.net) |
| 20:22.43 | *** join/#storm lakin (~lakin@S010600265af23ae6.cg.shawcable.net) |