| 01:44.52 | *** join/#uphpu KingMichael (~KingMicha@c-67-177-40-132.hsd1.ut.comcast.net) |
| 01:53.56 | *** join/#uphpu HumanCell (~Humancell@207.224.214.130) |
| 01:56.18 | *** join/#uphpu itimber (~Adium@ip72-209-186-65.ks.ks.cox.net) |
| 01:56.40 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 03:41.38 | *** join/#uphpu jsmith (~jsmith@207.198.119.103) |
| 05:23.18 | *** join/#uphpu UtahDave (~boucha@174.52.220.233) |
| 05:23.19 | *** mode/#UPHPU [+o UtahDave] by ChanServ |
| 05:29.28 | *** join/#uphpu ninnypants1 (~ninnypant@unaffiliated/ninnypants) |
| 05:29.29 | *** mode/#UPHPU [+v ninnypants1] by ChanServ |
| 07:52.49 | *** join/#uphpu supernovia (~Adium@66.219.200.107.provo.dynamic.broadweavenetworks.net) |
| 07:52.50 | *** mode/#UPHPU [+v supernovia] by ChanServ |
| 13:21.46 | *** join/#uphpu jsmith (~jsmith@fedora/jsmith) |
| 13:21.46 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 13:37.37 | *** join/#uphpu clintberry (~clintberr@c-76-27-26-207.hsd1.ut.comcast.net) |
| 13:37.37 | *** mode/#UPHPU [+v clintberry] by ChanServ |
| 14:15.21 | *** join/#uphpu clintberry (~clintberr@c-76-27-26-207.hsd1.ut.comcast.net) |
| 14:15.21 | *** mode/#UPHPU [+v clintberry] by ChanServ |
| 15:14.14 | *** join/#uphpu josephscott (~josephsco@proxy.iad.automattic.com) |
| 15:16.01 | *** join/#uphpu MikeHansenMe (~mike@c-67-166-123-7.hsd1.ut.comcast.net) |
| 15:29.04 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 15:29.04 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 15:41.31 | *** join/#uphpu macnewbold (~macnewbol@wfw.vivint.com) |
| 15:41.32 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 15:47.42 | macnewbold | hhatfield: delayed pong |
| 15:51.03 | josephscott | sent details for next week to carmony, so we should be able to post about it a full week in advance :-) |
| 16:01.04 | *** join/#uphpu MikeHansenMe (~mike@c-67-166-123-7.hsd1.ut.comcast.net) |
| 16:08.56 | *** join/#uphpu littleSkinner (~JSkinn@asa-2.fbp.ore.fiber.net) |
| 16:16.27 | carmony | josephscott: yup :) |
| 16:16.32 | carmony | will post today |
| 16:18.14 | *** join/#uphpu supernovia (~Adium@66.219.200.107.provo.dynamic.broadweavenetworks.net) |
| 16:18.14 | *** mode/#UPHPU [+v supernovia] by ChanServ |
| 16:24.14 | *** join/#uphpu supernovia (~Adium@66.219.200.107.provo.dynamic.broadweavenetworks.net) |
| 16:24.15 | *** mode/#UPHPU [+v supernovia] by ChanServ |
| 16:31.17 | *** join/#uphpu kendsnyder (~kendsnyde@67.214.245.39) |
| 16:31.26 | *** mode/#UPHPU [+v kendsnyder] by ChanServ |
| 16:33.24 | *** join/#uphpu SunSparc (~jonathan@69-27-175-74.acedatacenter.com) |
| 16:33.24 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 16:45.42 | *** join/#uphpu hallamigo (~hallamigo@75-145-59-129-Utah.hfc.comcastbusiness.net) |
| 16:46.40 | *** join/#uphpu HumanCell (~Humancell@216.51.68.1) |
| 18:00.40 | *** join/#uphpu TuxToaster (~TuxToaste@wfw.vivint.com) |
| 18:00.40 | *** mode/#UPHPU [+v TuxToaster] by ChanServ |
| 18:00.50 | TuxToaster | ~rlart |
| 18:00.50 | infobot | smacks josephscott up side the head with a clue-by-4 |
| 18:01.00 | josephscott | ~smack TuxToaster |
| 18:01.00 | infobot | ACTION smacks TuxToaster upside the head. |
| 18:01.06 | TuxToaster | aww |
| 18:01.43 | TuxToaster | ~8ball was it a critical hit? |
| 18:01.43 | infobot | I'm sure of it. |
| 18:02.36 | josephscott | hehe |
| 18:07.44 | carmony | ok, wordpress question for those who are here :P |
| 18:08.01 | carmony | I need to allow someone to put some raw HTML into a page |
| 18:08.20 | carmony | and WordPress's filters and such are not allowing it (with good reason) |
| 18:09.53 | josephscott | carmony: http://codex.wordpress.org/FAQ_Security#Why_are_some_users_allowed_to_post_unfiltered_HTML.3F |
| 18:11.55 | carmony | josephscott: thank you! :) |
| 18:12.06 | carmony | one down side to WordPress's popularity |
| 18:12.12 | carmony | is when you google for stuff |
| 18:12.22 | carmony | you get like 20 different ways to solve something |
| 18:12.47 | carmony | 18 of which are really, really bad ideas |
| 18:12.58 | josephscott | unfiltered HTML issues come up all the time |
| 18:13.06 | josephscott | usually in regards to bogus security reports :-) |
| 18:17.11 | utahcon | Is there still a jobs mailing list for UPHPU? |
| 18:17.24 | utahcon | My company is going to start looking for local developers |
| 18:17.33 | utahcon | need to know the best place to spam, I mean advertise, the position |
| 18:17.47 | herlo | lies! |
| 18:18.13 | utahcon | NOT LIES! |
| 18:18.25 | josephscott | utahcon: http://uphpu.org/mailing-lists-and-irc/ |
| 18:18.26 | herlo | lol |
| 18:18.59 | utahcon | if only there were an obvious link on the main page of the uphpu.org, like on the right hand side of the page... <facepalm> |
| 18:19.04 | utahcon | thanks josephscott |
| 18:19.14 | josephscott | np |
| 18:19.19 | josephscott | :-) |
| 18:45.07 | carmony | I need to get the server creds from wps |
| 18:47.26 | shalkie | utahcon: Your going to be hiring PHP folks? Or python folks that listen to the PHP channels? |
| 18:55.49 | utahcon | shalkie: Those who will stoop low enough to program in PHP |
| 18:56.48 | utahcon | Anyone know where I can find the list of lastest updates to ubuntu? like an rss feed or something, their sites are not yielding the results I want |
| 18:57.39 | utahcon | shalkie: we love polyglots, but our main systems (on my team) are PHP. We will have openings in Java and .Net soon too. |
| 18:58.00 | utahcon | We are also looking for very experiences QA with automated testing experience |
| 18:58.04 | josephscott | Java and .Net? and you were calling PHP devs names :-) |
| 18:58.14 | utahcon | lol |
| 18:58.25 | utahcon | Java has but one place I allow it to be cool: Android |
| 18:58.29 | utahcon | .Net can DIAF |
| 18:58.56 | josephscott | but then what will all of the windows mobile devs write code in? |
| 18:58.56 | utahcon | For the record, I wish Android were Python |
| 18:58.58 | utahcon | :) |
| 18:59.13 | josephscott | Python as the first class native language for Android would be cool |
| 19:03.34 | *** join/#uphpu mgeary (~mgeary@bro67-2-82-225-7-120.fbx.proxad.net) |
| 19:03.34 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 19:39.55 | *** join/#uphpu undertakingyou (~undertaki@danix.eaerich.com) |
| 19:39.55 | *** mode/#UPHPU [+v undertakingyou] by ChanServ |
| 19:40.59 | macnewbold | ~seen hhatfield |
| 19:41.02 | infobot | hhatfield <~hhatfield@64.147.139.68> was last seen on IRC in channel #uphpu, 2d 2h 53m 6s ago, saying: 'macnewbold: ping'. |
| 19:49.09 | *** join/#uphpu mgeary (~mgeary@bro67-2-82-225-7-120.fbx.proxad.net) |
| 19:49.09 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 19:56.56 | *** join/#uphpu john-anderson (~john-ande@192.150.9.201) |
| 19:57.41 | fungus | utahcon, ubuntuupdates.org is third party, but pretty good. |
| 19:59.33 | utahcon | fungus: is there an official ubuntu page/feed? |
| 19:59.52 | utahcon | I swear I found it last week, but my Chrome history says otherwise |
| 20:00.08 | fungus | not that I have found. |
| 20:14.07 | *** join/#uphpu MikeHansenMe (~mike@173-165-131-122-utah.hfc.comcastbusiness.net) |
| 20:42.41 | *** join/#uphpu clintberry (~clintberr@53.sub-70-197-6.myvzw.com) |
| 20:42.42 | *** mode/#UPHPU [+v clintberry] by ChanServ |
| 21:09.38 | unum | ok an other postgresql question |
| 21:10.17 | unum | lets say I wanted to be able to get the average of a value based on an indeterminate time interval |
| 21:10.25 | unum | the best way I can think to do it is: |
| 21:10.46 | unum | TIMESTAMP WITH TIME ZONE 'epoch' + 982384720 * INTERVAL '1 second'; |
| 21:10.48 | unum | TIMESTAMP WITH TIME ZONE 'epoch' + 982384720 * INTERVAL '1 second'; |
| 21:10.51 | unum | oops |
| 21:10.53 | unum | sorry |
| 21:11.11 | unum | SELECT avg(value),TIMESTAMP WITH TIME ZONE 'epoch' + (EXTRACT(epoch FROM time)::INTEGER/60)*60 * INTERVAL '1 second' AS newtime |
| 21:11.30 | unum | but that seems really messy |
| 21:11.39 | unum | is there a betterway |
| 21:11.52 | unum | I could make that a function |
| 21:18.51 | *** join/#uphpu KingMichael (~KingMicha@c-67-177-40-132.hsd1.ut.comcast.net) |
| 21:24.59 | *** join/#uphpu john-anderson (~john-ande@192.150.9.201) |
| 21:31.33 | fungus | wow that is messy. |
| 21:31.59 | fungus | I'm having difficulty understanding it. Perhaps you could use NOW() and a better interval perhaps. |
| 21:34.17 | *** join/#uphpu clintberry (~clintberr@208.106.28.36) |
| 21:34.17 | *** mode/#UPHPU [+v clintberry] by ChanServ |
| 21:38.38 | *** join/#uphpu josephscott (~josephsco@proxy.iad.automattic.com) |
| 21:40.29 | fungus | OIC, your query converts a timestamp, to a unix timestamp, multiplies then divides by 60 (why?), then converts back to a timestamp. |
| 21:40.39 | fungus | Looks like lots of wasted effort. |
| 21:40.49 | fungus | SELECT avg(value),time |
| 21:51.02 | *** join/#uphpu MikeHansenMe (~mike@173-165-131-122-utah.hfc.comcastbusiness.net) |
| 21:56.25 | fungus | from what I understand it would look something like this: |
| 21:57.17 | fungus | SELECT avg(value) FROM table WHERE time > NOW() - interval '1 month' |
| 21:57.29 | fungus | that would give you the value of all records in the last month. |
| 22:12.34 | *** join/#uphpu UtahDave (~boucha@63.230.12.160) |
| 22:12.34 | *** mode/#UPHPU [+o UtahDave] by ChanServ |
| 22:33.35 | *** join/#uphpu jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 22:33.36 | *** mode/#UPHPU [+v jnbek] by ChanServ |
| 22:33.36 | unum | fungus: but then I would need to run that query 12 times inorder to get all the values for a year |
| 22:33.53 | fungus | use a GROUP BY |
| 22:34.07 | unum | that works for months |
| 22:34.15 | unum | actually no it doesn't |
| 22:34.21 | unum | 1 month is not a valid interval |
| 22:34.29 | unum | but anyways it works for days or hours |
| 22:34.36 | unum | but if yo uwant to 2 months |
| 22:35.25 | unum | I mean 2 hours rather |
| 22:35.28 | unum | or 5 minutes |
| 22:37.15 | fungus | Why not. a "5 minutes" works fine |
| 22:38.11 | fungus | according to the pgsql wiki, interval supports years, months, weeks, days, hours, minutes, seconds, and milliseconds |
| 22:39.08 | unum | funny thought I tried months recently and it didn't work |
| 22:39.19 | unum | a month is not a consistent unit of time |
| 22:39.32 | unum | how do I group by 5 minutes |
| 22:40.09 | fungus | convert to epoch, and divide by 5 minutes |
| 22:40.18 | unum | exactly |
| 22:40.20 | fungus | then group by that value |
| 22:40.49 | fungus | EXTRACT(epoch FROM time)/300 |
| 22:41.09 | unum | then if want to display that value back to the user in a nice format, I have to convert back to timestamp |
| 22:41.17 | fungus | SELECT avg(value), EXTRACT(epoch FROM time)/300 as newtime FROM table GROUP BY newtime |
| 22:41.44 | *** join/#uphpu HumanCell (~Humancell@207.224.214.130) |
| 22:43.33 | unum | except newtime is now an integer |
| 22:43.40 | unum | what if I wanted it to be a time stamp |
| 22:44.12 | *** join/#uphpu MikeHansenMe (~mike@173-165-131-122-utah.hfc.comcastbusiness.net) |
| 22:45.52 | fungus | have you tried "time / interval '5 minutes'" |
| 22:47.40 | fungus | don't have a postgres server handy to test myself. |
| 22:49.28 | unum | that is not allowed |
| 23:04.36 | fungus | I guess postgres only has that hideously ugly way to convert back to timestamp. Unless you want to do that in code outside the query... |
| 23:35.18 | unum | Ya I could grab the integer and easily convert it back |
| 23:35.25 | unum | might solve the other problem I'm having |
| 23:36.01 | unum | I'd expected an interval of 1 day to convert to 00:00:00 and instead it converts to 17:00:00 |
| 23:36.44 | unum | maybe if I was doing it with out timezones |
| 23:57.45 | *** join/#uphpu macnewbold (~macnewbol@66.219.204.99.provo.dynamic.broadweavenetworks.net) |
| 23:57.45 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 23:57.51 | *** join/#uphpu hallamigo_ (~hallamigo@75-145-59-129-Utah.hfc.comcastbusiness.net) |