| 00:19.17 | *** join/#uphpu redroy (~Adium@c-174-52-210-81.hsd1.ut.comcast.net) |
| 00:25.22 | mgeary | fungus: i know you're gone, but when i enable the same log file for ~400 sites, i get "Too many open files: could not open transfer log file" errors |
| 00:26.31 | *** part/#uphpu mgeary (~mgeary@50.8.70.19) |
| 00:27.10 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-129-181.DNVR.QWEST.NET) |
| 00:36.51 | mindjuju | anybody around? |
| 01:05.46 | *** join/#uphpu dharmatech (~hayduke@166-70-57-177.ip.xmission.com) |
| 01:08.27 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-129-181.DNVR.QWEST.NET) |
| 01:12.05 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-129-181.DNVR.QWEST.NET) |
| 02:09.52 | *** join/#uphpu macnewbold (~Adium@c-67-166-115-242.hsd1.ut.comcast.net) |
| 02:09.52 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 02:10.46 | *** join/#uphpu mgeary (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 02:10.46 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 02:28.24 | mindjuju | mgeary, go home |
| 02:28.54 | mgeary | mindjuju: i am home |
| 02:28.59 | mindjuju | ah dag |
| 02:29.05 | mindjuju | i'm leaving in about 5 minutes for home |
| 02:29.08 | mindjuju | ...long day... |
| 02:32.29 | *** join/#uphpu josephscott (~josephsco@208.95.152.44) |
| 02:32.29 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 02:41.40 | mgeary | no kidding |
| 02:44.49 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 03:30.05 | *** join/#uphpu wps (~wps@208.53.57.58) |
| 03:30.05 | *** mode/#UPHPU [+o wps] by ChanServ |
| 03:40.37 | mgeary | anyone here done work with geocoding? i need to be able to turn a lat/long into a city/state |
| 03:55.29 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-129-181.DNVR.QWEST.NET) |
| 03:55.56 | ninnypants | mgeary: I know someone in #utos has |
| 03:56.17 | ninnypants | can't remember his name right now, but it starts with an e |
| 03:58.25 | ninnypants | said he used somthing like the Tiger dataset or something like that http://www.esri.com/data/download/census2000-tigerline/index.html http://www.census.gov/geo/www/tiger/tgrshp2008/tgrshp2008.html |
| 04:01.38 | josephscott | google maps? |
| 04:02.39 | ninnypants | depends on whether you want to display a map or not |
| 04:03.10 | ninnypants | if I remember correctly in the terms of service you can't geocode things unless you show it on a map on your site |
| 04:14.49 | ninnypants | $chuck-fact |
| 04:14.50 | raifbot | Chuck Norris doesn't read books. He stares them down until he gets the information he wants. |
| 04:15.40 | DexterTheDragon | https://code.google.com/apis/maps/documentation/geocoding/ |
| 04:17.11 | ninnypants | oh nice I haven't seen that |
| 04:32.58 | josephscott | no strtotime() in python? |
| 04:35.54 | josephscott | hmmm guess time.strptime will do, but not the same :-( |
| 05:06.14 | *** join/#uphpu redroy (~Adium@c-174-52-210-81.hsd1.ut.comcast.net) |
| 05:10.12 | *** join/#uphpu ninnypants1 (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 05:23.26 | mgeary | ah, what he wants is parsedatetime |
| 05:23.32 | mgeary | ah well |
| 05:24.17 | mgeary | and yes, DexterTheDragon that's where i landed as well, thanks |
| 13:44.49 | *** join/#uphpu Utah_Dave (~boucha@72-166-51-162.dia.static.qwest.net) |
| 13:44.49 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 13:53.57 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 13:58.03 | influx | morning |
| 14:05.15 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 14:05.30 | *** join/#uphpu josephscott (~josephsco@208.95.152.44) |
| 14:05.30 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 14:07.01 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-129-181.DNVR.QWEST.NET) |
| 14:08.01 | *** join/#uphpu mahelious (~mahelious@64.0.29.254.ptr.us.xo.net) |
| 14:15.18 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-129-181.DNVR.QWEST.NET) |
| 14:35.46 | *** join/#uphpu skinner (~dskinner@64.0.29.254.ptr.us.xo.net) |
| 14:38.41 | *** join/#uphpu beandog (~sdibb@173-165-130-129-utah.hfc.comcastbusiness.net) |
| 14:38.41 | *** join/#uphpu beandog (~sdibb@gentoo/developer/beandog) |
| 14:38.41 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 14:41.52 | *** join/#uphpu itimber (~Adium@74.51.216.34) |
| 14:41.52 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 14:55.14 | *** join/#uphpu macnewbold (~Adium@66.60.115.30) |
| 14:55.14 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 15:02.58 | *** join/#uphpu wps (~wps@76.8.223.101) |
| 15:02.58 | *** mode/#UPHPU [+o wps] by ChanServ |
| 15:03.19 | *** join/#uphpu fungus (~olsonl@bromine.sosstaffing.com) |
| 15:03.19 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 15:04.11 | *** join/#uphpu Monnok (~monnok@205.204.33.82) |
| 15:14.14 | *** join/#uphpu cycokilr (~cycokilr@199.58.58.6) |
| 15:14.31 | jsmith | Too quiet in here |
| 15:14.51 | *** join/#uphpu mgeary (~mgeary@50.8.70.19) |
| 15:14.51 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:15.13 | skinner | Anyone know a decent moving company I could rent a 26' truck from? |
| 15:15.16 | skinner | (Not Uhaul) |
| 15:15.29 | skinner | ^ No trucks available when I need it... :( |
| 15:16.19 | josephscott | $lart jsmith |
| 15:16.19 | raifbot | strangles jsmith with a 9-pole serial cable. |
| 15:16.30 | josephscott | 9-pole? |
| 15:16.42 | jsmith | Yeah -- old school! |
| 15:17.09 | josephscott | don't think I ever called it 9-pole |
| 15:17.45 | josephscott | always thought of them as 9-pin |
| 15:18.20 | jsmith | Is pin/pole like male/female? |
| 15:21.38 | *** join/#uphpu jtsnow (~jtsnow@74-95-52-198-Utah.hfc.comcastbusiness.net) |
| 15:28.56 | *** join/#uphpu mastergunns (~mastergun@216.49.181.128) |
| 15:29.06 | *** join/#uphpu itimber (~Adium@74.51.216.34) |
| 15:29.06 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 15:32.39 | *** join/#uphpu carmony (~justin@ip70-181-214-176.sd.sd.cox.net) |
| 15:32.39 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 15:40.45 | mgeary | josephscott: did you see my note from last night? About parsedatetime? |
| 15:40.57 | josephscott | no, missed that |
| 15:41.08 | mgeary | it's the closest python equivalent (that i've found) to strtotime |
| 15:41.21 | josephscott | nice - http://code.google.com/p/parsedatetime/ |
| 15:41.27 | mgeary | yep |
| 15:41.53 | josephscott | strtotime is so absurdly handy I can't imagine any language not using it, in core date/time functions |
| 15:42.08 | mgeary | i hear ya |
| 15:52.32 | *** join/#uphpu dharmatech (~hayduke@utriders.dsl.xmission.com) |
| 16:00.01 | Utah_Dave | I love strtotime |
| 16:01.52 | mindjuju | ~lart utah_dave and his popeye eating ways |
| 16:01.52 | ibot | wallops utah_dave and his popeye eating ways with a main rotation server that needs rehubbing. It won't take long |
| 16:01.59 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 16:02.08 | josephscott | ~say $rlart |
| 16:02.08 | ibot | $rlart |
| 16:02.08 | raifbot | nukes dharmatech with a single large nuke. |
| 16:02.27 | influx | ~lart influx |
| 16:02.27 | ibot | eats influx and falls over dead |
| 16:02.28 | Utah_Dave | :) I'll just take that and smile, remembering that delicious popeyes I was eating a few days ago |
| 16:03.28 | utahcon | morning all |
| 16:07.35 | macnewbold | morning utahcon |
| 16:07.56 | macnewbold | i totally thought you were joking when you said you were marrying herlo - but i got the lowdown from ags and now i'm a believer |
| 16:08.28 | mindjuju | :) |
| 16:08.37 | macnewbold | that's pretty cool beans |
| 16:08.39 | mindjuju | he was there, he married them, i saw it |
| 16:10.31 | utahcon | lol |
| 16:10.36 | utahcon | yeah it was a great play on words |
| 16:10.50 | utahcon | fun wedding ceremony too |
| 16:10.53 | utahcon | if I do say so |
| 16:11.29 | utahcon | I don't think having to register for a site is "Free" anymore |
| 16:11.36 | utahcon | it costs me time and money to deal with your spam |
| 16:13.52 | mindjuju | that's why you should use dodgit.com, utahcon |
| 16:14.04 | mindjuju | it allows you to make a temporary email addy to get what you want, and leave the spam |
| 16:15.07 | mindjuju | the way it works is, you think of some crazy name for an email addy, like oh, utahcon@dodgit.com, you DON'T register it with dodgit.com, you just go to where they've got the freebie, use utahcon@dodgit.com as your email addy, dodgit is setup so it accepts all emails for any crazy name |
| 16:15.32 | mindjuju | it catches the email, you look in box utahcon, get the email validation code, validate, get your freebie and you're on your way |
| 16:17.13 | utahcon | mindjuju: I just use my own domain |
| 16:17.18 | utahcon | whatever@utahcon.com |
| 16:17.31 | mindjuju | i like dodgit better |
| 16:17.37 | utahcon | when I get spam I send a nastygram to whomever got it first and then set a delete filter |
| 16:17.49 | utahcon | that way I get anything important |
| 16:17.51 | mindjuju | too much overhead and processing time |
| 16:17.52 | utahcon | and I get to yell at them |
| 16:17.56 | utahcon | and I get to ignore it |
| 16:17.57 | mindjuju | why bother |
| 16:18.25 | utahcon | idk |
| 16:18.26 | mindjuju | why block a punch when you can dodge? |
| 16:18.31 | mindjuju | jk |
| 16:18.34 | utahcon | lol |
| 16:18.45 | mindjuju | so i've got this philosophical question |
| 16:18.47 | utahcon | cause I know who to bash on blog posts and things |
| 16:18.57 | utahcon | philosicate away |
| 16:19.35 | mindjuju | there is a guy, and he's scraping my site from turkey... and i think, what a putz, what is he doing? i should block him out right! , but then i think, if i block he'll move somewhere else, and i'll chase him here and there |
| 16:20.03 | mindjuju | now on sunday, he was scraping aggreseively, now he's much more slow about it |
| 16:20.32 | utahcon | mindjuju: peronsal site or business site? |
| 16:20.42 | mindjuju | business |
| 16:21.13 | utahcon | what is he doing with your site? |
| 16:21.19 | utahcon | with what he scrapes |
| 16:23.08 | mindjuju | who knows |
| 16:23.10 | mindjuju | he's in turkey |
| 16:23.13 | mgeary | what kind of content is it? |
| 16:23.19 | mindjuju | but the question is, can i stop it |
| 16:23.21 | mindjuju | and the answer is no |
| 16:23.23 | josephscott | mindjuju: redirect all his requests to image that says "what are you doing?" ;-) |
| 16:23.33 | mindjuju | he'll just keep switching IPs and keep going |
| 16:23.48 | josephscott | perhaps |
| 16:24.04 | mgeary | mostly for government-supplied data, so don't get your panties in a wedge |
| 16:24.04 | DexterTheDragon | mindjuju: it was mgeary! |
| 16:24.29 | mindjuju | see, thats my point |
| 16:24.32 | mgeary | there is a service that claims to be able to block scapers. They seem to market largely to airlines |
| 16:24.43 | mgeary | but i'd be curious about how they do it |
| 16:24.52 | mindjuju | it does provide a load balance test |
| 16:25.38 | mgeary | but there are a number of things i've done to avoid being blocked. right now i'm working on code that will spawn an EC2 instance, with a randomly-assigned(?) IP address for every scrape occurrence |
| 16:25.52 | josephscott | there are a few different approaches, I won't imagine they'd be 100%, but for folks like airlines they'd probably be ok with that |
| 16:26.12 | mgeary | however, i also try to be respectful of the server. Don't slam it too hard, take time between requests, etc |
| 16:26.26 | josephscott | request threshold would be an obvious one |
| 16:26.36 | mgeary | yep |
| 16:26.45 | josephscott | like, how likely is it that a single IP really needs to make 500 r/s? |
| 16:27.22 | mgeary | if you really want to work, you can even look at the pattern of requests, since a scrape would normally make them in a predictable fashion (though i've randomized request lists before) |
| 16:29.03 | josephscott | from the scraping point of view throwing in a sleep( mt_rand( 3, 15 ) ); between requests would not be har |
| 16:29.04 | josephscott | hard |
| 16:29.12 | mgeary | yep |
| 16:29.42 | mgeary | and of course, there's the basic things, like using a browser-esque User Agent signature |
| 16:29.42 | josephscott | I suspect for many sites they'd be ok with being over tough if they were fighting scrapers |
| 16:29.51 | josephscott | because you could turn around and white list IPs or access keys |
| 16:30.15 | mgeary | mindjuju: if you use cookies on your site, that will make it harder for the scraper |
| 16:30.19 | skinner | redirect them to this image: |
| 16:30.19 | skinner | http://www.alysion.org/iqtest/bsod1024.jpg |
| 16:30.24 | josephscott | oh yeah, if you aren't using a real UA to start with a scraper then you deserve to be blocked :-) |
| 16:30.46 | josephscott | +1 for bsod1024.jpg redirect |
| 16:33.36 | *** part/#uphpu Utah_Dave (~boucha@72-166-51-162.dia.static.qwest.net) |
| 16:34.01 | *** join/#uphpu Utah_Dave (~boucha@72-166-51-162.dia.static.qwest.net) |
| 16:34.01 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:35.16 | *** join/#uphpu cro (~cro@50.8.86.230) |
| 16:38.49 | *** join/#uphpu jkr801 (~jkr801@dsl093-228-008.slc1.dsl.speakeasy.net) |
| 16:39.13 | *** join/#uphpu xtrementl (~xtrementl@neutroninteractive-xmission.xmission.com) |
| 16:39.28 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 16:44.23 | josephscott | $weather 84092 |
| 16:44.23 | raifbot | 3josephscott - 0,2current weather for 84092 - Cloudy 42f / 6c Humidity: 88% Wind: W at 11 mph |
| 16:46.31 | utahcon | $weather 32111 |
| 16:46.31 | raifbot | 3utahcon - 0,2current weather for 32111 - Mostly Cloudy 74f / 23c Humidity: 49% Wind: W at 13 mph |
| 16:46.50 | utahcon | that's where I grew up :D |
| 16:48.24 | beandog | in the cloud? |
| 16:55.38 | carmony | $weather cloud |
| 16:55.38 | raifbot | carmony - sorry, I couldn't get weather data for cloud |
| 16:55.49 | carmony | $weather the clouse |
| 16:55.49 | raifbot | carmony - sorry, I couldn't get weather data for the clouse |
| 16:55.52 | josephscott | $weather the cloud |
| 16:55.52 | raifbot | josephscott - sorry, I couldn't get weather data for the cloud |
| 16:56.12 | josephscott | $weather my front yard |
| 16:56.12 | raifbot | josephscott - sorry, I couldn't get weather data for my front yard |
| 16:56.19 | skinner | $weather the interwebs |
| 16:56.20 | raifbot | skinner - sorry, I couldn't get weather data for the interwebs |
| 16:56.24 | carmony | josephscott: got some pretty cool redis stuff going on now :P |
| 16:56.38 | josephscott | carmony: yeah? nice. what's new? |
| 16:56.52 | carmony | finally making progress on the new score system |
| 16:57.38 | mindjuju | wow, dumb and dumber -- how about treat watermelons with additives to help them grow, but in the process, misuse it and cause them to grow so fast, that they actually burst. and at the loss of income, just feed the overdosed watermelons to hogs and fish - http://news.yahoo.com/s/ap/20110517/ap_on_fe_st/as_china_exploding_watermelons |
| 16:58.11 | mindjuju | gee, i sure hope nobody actually eats the pigs that ate the overdosed watermelons! |
| 17:00.12 | beandog | so basically, we're all going to die except fungus. |
| 17:00.50 | mindjuju | pretty much |
| 17:01.01 | mindjuju | but who knows what they did to the tofu |
| 17:01.07 | beandog | well that saves me the step of adding him to my will |
| 17:05.51 | carmony | josephscott: so right now I have 4 redis instances running on a server managing millions of scores :P |
| 17:06.06 | josephscott | nice |
| 17:06.20 | josephscott | has the disk persistence been an issue at all? |
| 17:11.30 | *** join/#uphpu jkr801_ (~jkr801@dsl093-228-008.slc1.dsl.speakeasy.net) |
| 17:22.03 | carmony | josephscott: not yet |
| 17:22.09 | carmony | but our scores data is okay if we lose some |
| 17:22.47 | josephscott | are you running for instances just to leverage multiple CPUs/cores? |
| 17:32.29 | *** join/#uphpu jkr801 (~jkr801@dsl093-228-008.slc1.dsl.speakeasy.net) |
| 17:32.37 | *** join/#uphpu SunSparc (~jonathan@24-104-129.146.hfc.mediarain.com) |
| 17:32.37 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 17:33.04 | SunSparc | ~cat |
| 17:33.05 | ibot | well, cat is officially used to concatenate files. cat is also used to display the contents of a file on screen. Syntax: cat (file1) (file2) ...(fileN) Where file1 through fileN are the files to display. Example: cat letters/from-mdw displays the file letters/from-mdw. or a clawed walking stomach that meows, or http://www.linux-on-line.net/downloads/fun/humorous-plus/beware_of_dogs.jpg |
| 17:33.45 | SunSparc | ~meow |
| 17:33.46 | ibot | jbot: woem |
| 17:36.40 | beandog | How do you see who on your network is sucking up all the bandwidth |
| 17:42.17 | mgeary | beandog: look in a mirror |
| 17:46.03 | skinner | beandog: You'll hear it first...like the sound of a giant waterfall, they say... |
| 17:50.02 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 17:53.50 | josephscott | ug, why is it snowing at my house? |
| 17:55.40 | skinner | ~weather josephscott's house |
| 17:56.37 | josephscott | $weather at my house |
| 17:56.37 | raifbot | josephscott - sorry, I couldn't get weather data for at my house |
| 17:56.46 | josephscott | $weather 84092 |
| 17:56.47 | raifbot | 3josephscott - 0,2current weather for 84092 - Showers 43f / 6c Humidity: 83% Wind: W at 14 mph |
| 18:00.56 | SunSparc | beandog: log into your router, it may have stats. |
| 18:01.21 | *** join/#uphpu mahelious (~mahelious@64.0.29.254.ptr.us.xo.net) |
| 18:02.55 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 18:15.53 | ninnypants | $chuck-fact |
| 18:15.53 | raifbot | Chuck Norris does not hunt because the word hunting infers the probability of failure. Chuck Norris goes killing. |
| 18:20.40 | influx | ayayaaaaa |
| 18:24.36 | ninnypants | hey influx |
| 18:26.27 | influx | ahlo! |
| 18:26.54 | *** join/#uphpu PoeticIntensity (~jason@76.8.222.23) |
| 18:26.54 | *** mode/#UPHPU [+v PoeticIntensity] by ChanServ |
| 18:31.49 | influx | ninnypants: What's up? |
| 18:32.10 | ninnypants | nota whole lot just workin |
| 18:36.26 | influx | :) |
| 18:39.51 | ninnypants | influx: how bout you? |
| 18:40.54 | influx | same. Heh. |
| 18:41.24 | influx | Almost ready to call this sales thing 1.0 |
| 18:42.30 | *** join/#uphpu cro (~cro@caffedbolla.xwi.xmission.com) |
| 18:47.07 | ninnypants | influx: sweet so you got the paypal stuff working then? |
| 18:49.10 | influx | Not just yet. I'm working on the part which retains old information even after products are deleted or prices are changed. |
| 18:49.22 | influx | Specifically the query. |
| 18:55.24 | SunSparc | beandog: did you ever fix your story site? |
| 18:58.53 | carmony | $weather san diego |
| 18:58.53 | raifbot | 3carmony - 0,2current weather for san diego - Showers 57f / 14c Humidity: 88% Wind: S at 19 mph |
| 18:59.11 | carmony | thanks raifbot, the room I'm in has no windows |
| 18:59.12 | carmony | :P |
| 19:00.44 | mgeary | ~box carmony |
| 19:06.02 | *** join/#uphpu xtrementl (~xtrementl@neutroninteractive-xmission.xmission.com) |
| 19:07.16 | carmony | omg... |
| 19:07.23 | carmony | http://bellard.org/jslinux/ -- wow |
| 19:07.31 | carmony | chrome 11 or ff4 required |
| 19:14.49 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 19:19.10 | *** join/#uphpu redroy (~Adium@c-174-52-210-81.hsd1.ut.comcast.net) |
| 19:34.13 | *** join/#uphpu Utah_Dave (~boucha@72-166-51-162.dia.static.qwest.net) |
| 19:34.13 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 19:38.53 | influx | Problem: For each row in a result I'm trying attach column value 1 to column value 2 based on whether the value of column 1 is older or newer than the value of a third column. |
| 19:39.49 | influx | column value 2 has an associated value which is of the same type (datetime) as the third column. |
| 19:40.48 | influx | Hmm. |
| 19:41.50 | unum | what you mean by attach? |
| 19:42.17 | macnewbold | influx: a conditional like if() is probably what you want |
| 19:42.28 | influx | join |
| 19:42.47 | influx | macnewbold: Is it possible to use an if() recursively in MySQL? |
| 19:43.45 | influx | The first column is the quantity of a product sold, the second column is the datetime of the purchase, and the third column is a price which is in its own table with a column that has the datetime on which the price was set (multiple entries for that particular product can exist, with different datetimes), |
| 19:45.54 | influx | I'd like to maintain a history of products sold with the correct prices joined to each product, basically. |
| 19:46.15 | unum | in situations like that I'm afraid I've used a non-normalized solution |
| 19:46.26 | unum | atleast I don't think it is normalized |
| 19:46.39 | unum | or I do a seperate query |
| 19:47.41 | unum | but I have an almost identical problem, so I'm interested in seeing if anyone has a better solution |
| 19:49.26 | influx | I may have to do a separate query as well. :< |
| 20:02.07 | macnewbold | if you condition t hem all off the same condition, you can do multiple if statements, if i'm understanding what you are asking |
| 20:02.58 | macnewbold | but this may just be a matter of doing a join |
| 20:03.21 | macnewbold | in tableA you have qty sold and datetime of purchase, |
| 20:03.46 | macnewbold | and in tableB a list of pricepoints and the time they were effective |
| 20:04.44 | influx | yes. |
| 20:04.53 | macnewbold | so you want to join each purchase in tableA with the price in tableB based on grabbing the price from tableB that has the date that is the highest date less than the date of purchase |
| 20:05.20 | unum | yes |
| 20:05.23 | unum | :) |
| 20:05.42 | influx | yes |
| 20:05.47 | macnewbold | it might take two joins to tableB I think, cause you can find the _time_ of the price change that you care about using max() |
| 20:06.02 | macnewbold | but then you need to make sure you just pull that one row when you look for the price |
| 20:06.18 | macnewbold | max(time) and max(price) don't give you the right answer |
| 20:06.19 | unum | that's what I've done in simliar situations in the past |
| 20:06.33 | unum | it just soooooooo messy |
| 20:06.41 | unum | seems like there ought to be a better way |
| 20:06.57 | macnewbold | you might consider making a view or subquery that has two timestamps - the start of that price, and the end of that price |
| 20:07.29 | macnewbold | but right now you only have the start time for the price, so you have to examine two rows to find what the price was on a given date |
| 20:11.07 | mindjuju | DtD, you around? |
| 20:11.09 | influx | AYe. |
| 20:11.31 | DexterTheDragon | mindjuju: I'm sitting here |
| 20:11.53 | unum | actually I think I ended up undoing it after I did it, the query was taking too long and it was MUCH faster to do it as a seperate query |
| 20:11.55 | influx | macnewbold: Having a start date and end date for the price would allow for use of BETWEEN, I take it. |
| 20:12.03 | eggyknap | Your best bet is prolly to store the effective dates of a price in teh price table ... e.g. price, start date, end date |
| 20:12.10 | influx | Sounds like it. |
| 20:12.15 | mindjuju | have you tried the portal 2 sdk thing |
| 20:12.25 | eggyknap | Alternatively, you could do it with window queries, given a sufficiently capable SQL engine |
| 20:13.58 | DexterTheDragon | mindjuju: nope |
| 20:14.11 | mindjuju | i wish there was a garry's mod for portal 2 |
| 20:14.24 | mindjuju | where you could dump lasers and reflectors anywhere you wanted |
| 20:14.32 | mindjuju | would be cool |
| 20:16.08 | unum | hmmmmmm maybe I need to remind someone about my birthday present |
| 20:16.21 | mindjuju | is it your bday today unum? |
| 20:16.34 | unum | next monday, but I was expecting to get portal 2 by now |
| 20:16.48 | unum | for my birthday |
| 20:16.51 | mindjuju | portal 2 es goot game |
| 20:17.13 | mindjuju | Corban and I have been having too much fun playing co-op |
| 20:17.18 | unum | I'm glad to hear it |
| 20:18.04 | mindjuju | so unum, where do we need to send hints to? |
| 20:18.53 | unum | it ends in valve.com :) |
| 20:18.56 | influx | portal 2 ftw |
| 20:19.17 | influx | macnewbold & eggyknap : Thanks guys. |
| 20:19.27 | unum | a good friend of mine often buys me video games for my birthday, he also happened to have designed many of the levels on portal 2 |
| 20:19.38 | unum | so I thought this years present was a no brainer :) |
| 20:19.48 | mindjuju | ah |
| 20:22.09 | utahcon | all multiplayer |
| 20:23.57 | influx | I have yet to play multiplayer. |
| 20:24.14 | skinner | I have yet to be a player |
| 20:24.16 | influx | I haven't touched it, actually. |
| 20:24.25 | influx | skinner: Get it. :) |
| 20:24.29 | macnewbold | i've done the portal demos, haven't broken down to buy either one yet |
| 20:24.42 | skinner | I have the first one |
| 20:24.44 | macnewbold | but now the portal+portal2 pack is a better deal - adds $5 for portal i think |
| 20:24.50 | skinner | just haven't gotten the second yet |
| 20:24.53 | influx | macnewbold: Do you play games on Windows or XBox? |
| 20:26.57 | macnewbold | neither :) |
| 20:27.08 | macnewbold | i had an xbox but it died and i haven't replaced |
| 20:27.15 | macnewbold | and i'm on a Mac with OS X |
| 20:28.20 | mindjuju | portal actually had a free weekend about 2 months ago |
| 20:28.28 | mindjuju | where all you had to do was click download, and it was yours |
| 20:28.33 | mindjuju | that's how i got it for corban |
| 20:29.02 | macnewbold | yeah, i missed it :( |
| 20:29.17 | macnewbold | somehow my friends who knew about it didn't seem to let me know⦠|
| 20:29.30 | mindjuju | srry, i sux |
| 20:29.51 | skinner | Oh....do you play the suxophone? |
| 20:29.59 | skinner | I know someone who did once.... |
| 20:30.05 | mindjuju | :) |
| 20:33.13 | macnewbold | j/k yall |
| 20:33.14 | unum | sorry |
| 20:33.20 | unum | I told my nephew.... |
| 20:33.24 | macnewbold | probably assumed i had it, cause i shoulda |
| 20:33.43 | mindjuju | hey, no worries, i dropped the ball, i admit it |
| 20:33.49 | mindjuju | :) |
| 20:33.53 | macnewbold | what little gametime i have lately (besides games on a phone) has been starcraft2 |
| 20:34.19 | mindjuju | will i be lynched if i admit that i haven't so much as 1 minute logged on starcraft2? |
| 20:34.20 | macnewbold | i probably just wasn't paying enough attention in here |
| 20:34.49 | macnewbold | its fun, but i get an hour or two about once every month or two |
| 20:35.01 | macnewbold | i got it for christmas from a very nice bro-in-law who is also into computers :) |
| 20:46.43 | mindjuju | DtD - my new fav song - A-FREAKIN-MAZING - http://www.youtube.com/watch?v=-mRYaEmxRck |
| 20:47.07 | mindjuju | i'm going to have to check to see if the whole album is this stuff |
| 20:48.42 | mindjuju | that song is from this mix - http://soundcloud.com/j4yj4y/of-soot-and-cinder |
| 20:48.53 | mindjuju | which i loved the first 20 min of |
| 20:50.40 | macnewbold | ooh, cool: http://www.xmission.com/jobs/ - director of data center operations at xmission |
| 20:51.39 | skinner | mindjuju: That's an awesome song! |
| 20:51.52 | mindjuju | :) crazy good, huh? |
| 20:51.58 | skinner | ya |
| 20:52.01 | mindjuju | i'm checking the rest of their stuff out, it's similar |
| 20:56.00 | mindjuju | good luck! |
| 20:56.07 | skinner | ty :) |
| 21:13.27 | *** part/#uphpu Utah_Dave (~boucha@72-166-51-162.dia.static.qwest.net) |
| 21:14.02 | *** join/#uphpu Utah_Dave (~boucha@72-166-51-162.dia.static.qwest.net) |
| 21:14.04 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 21:16.58 | beandog | SunSparc: no |
| 21:59.42 | carmony | mindjuju: cool mix |
| 21:59.48 | mindjuju | word |
| 22:00.56 | mindjuju | anybody have an apple nano touch 8gb 4g or better for sale? |
| 22:03.08 | mindjuju | swanky! google spreadsheets now does pivot tables |
| 22:06.02 | macnewbold | mindjuju: seriously?!? pivot tables in google docs spreadsheets?! That's AWESOME!!! |
| 22:06.10 | mindjuju | word, bro |
| 22:06.12 | mindjuju | word |
| 22:12.43 | mindjuju | what to buy fungus for his bday - http://www.noisebot.com/be_rational_get_real_t-shirt.htm |
| 22:14.30 | influx | bro |
| 22:19.01 | mindjuju | sup influx |
| 22:19.20 | influx | Workin' till it's time to go home and work some more. |
| 22:19.24 | mindjuju | influx, did you listen to the music i sent to DtD? |
| 22:19.34 | mindjuju | you need to listen to that, it's WAY good |
| 22:19.37 | influx | I think I did not. What music was that? |
| 22:20.08 | mindjuju | this is the crazy good song - http://www.youtube.com/watch?v=-mRYaEmxRck this is the whole album that i heard the song from http://soundcloud.com/j4yj4y/of-soot-and-cinder |
| 22:20.14 | mindjuju | listen to youtube first |
| 22:20.41 | mindjuju | you like breaks, right? |
| 22:21.42 | influx | I do, actually. |
| 22:21.49 | influx | I like this song a lot. |
| 22:22.18 | mindjuju | word |
| 22:26.42 | stderr- | http://www.youtube.com/watch?v=8CWP863GJWA |
| 22:29.18 | mindjuju | physics, got to love it |
| 22:48.59 | PoeticIntensity | mindjuju, good stuff... |
| 22:51.42 | PoeticIntensity | Not sure if I could listen to this all day, but it's not bad at all. Just too many breaks. Doesn't flow evenly enough for my taste. |
| 22:53.40 | influx | ~lart flow |
| 22:53.40 | ibot | throws a AN/M-8 smoke grenade at flow |
| 22:53.59 | influx | ;) |
| 22:58.22 | *** join/#uphpu beandog (~sdibb@173-165-130-129-utah.hfc.comcastbusiness.net) |
| 22:58.22 | *** join/#uphpu beandog (~sdibb@gentoo/developer/beandog) |
| 22:58.22 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 23:00.35 | josephscott | $8ball is flow important? |
| 23:00.35 | raifbot | josephscott - Concentrate and ask again. |
| 23:00.42 | josephscott | $8ball is flow important? |
| 23:00.42 | raifbot | josephscott - Very doubtful. |
| 23:03.14 | mindjuju | curious - http://www.wired.com/threatlevel/2011/05/dropbox-ftc/ |
| 23:09.30 | beandog | $8ball am I losing my mind |
| 23:09.32 | raifbot | beandog - As I see it, yes. |
| 23:35.01 | carmony | soooo close... come on conversion scripts, hurry up! :P |
| 23:36.16 | beandog | carmony is almost a girl |
| 23:36.23 | carmony | rofl |
| 23:36.27 | carmony | not that kind of conversion |
