| 00:01.22 | beandog | ok |
| 00:01.22 | beandog | how the heck do I test a MySQL ODBC connection on windows. |
| 00:01.44 | beandog | I vaguely recall you can do it with Access, but geez, that was a long time ago. |
| 00:01.47 | fungus | You could use Access |
| 00:02.14 | beandog | well Ive got my DSN |
| 00:02.20 | beandog | I cant remember wehre you go to use it. |
| 00:03.02 | fungus | or look to see if the commandline tool "isql" is installed? |
| 00:03.32 | fungus | I don't remember the Access way either. It is either in the Open... Dialog or the Import External Data dialog. |
| 00:04.11 | beandog | yah that was it |
| 00:04.12 | beandog | thanks |
| 00:08.13 | beandog | wow |
| 00:08.17 | beandog | I havent done this in a looooooooooooong time |
| 00:08.24 | beandog | and I still have to admit ... its kinda cool. |
| 00:14.52 | *** join/#uphpu RedHeron (n=RedHeron@c-98-202-56-80.hsd1.ut.comcast.net) |
| 00:14.53 | *** mode/#UPHPU [+v RedHeron] by ChanServ |
| 00:18.29 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 00:34.33 | burnin | there is also the msquery.exe in the MS Office package that you can use to test a DSN. |
| 00:34.46 | burnin | but you have to find it, its not in the menus. |
| 00:36.17 | beandog | ok |
| 00:36.22 | beandog | well I have ODBC working okay |
| 00:36.25 | beandog | Now I just need to setup SSL |
| 01:02.14 | *** join/#uphpu unum (n=unum@70.89.247.221) |
| 01:18.55 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 01:27.14 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 01:27.14 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 01:31.32 | *** join/#uphpu Utah_Dave (n=David_Bo@24.244.156.236) |
| 01:31.33 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 01:37.47 | RedHeron | Can I hate you now? |
| 01:38.20 | Utah_Dave | :) |
| 01:38.22 | jsmith | Utah_Dave: Yeah, but I'll bet my dinner was better ;-) |
| 01:40.57 | RedHeron | My dinner was ramen, raw veggies (with ranch dip), and steak (oddly enough). |
| 01:44.01 | *** join/#uphpu undertakingyou (n=will@undertakingyou.dsl.xmission.com) |
| 01:44.13 | *** join/#uphpu orsonj (n=orson@b22222.bookstore.usu.edu) [NETSPLIT VICTIM] |
| 01:45.37 | Utah_Dave | jsmith: what did you have for dinner? |
| 01:45.58 | Utah_Dave | I had a really good General Tzo's chicken |
| 01:46.14 | RedHeron | General Tzo's chicken rocks. |
| 01:46.24 | RedHeron | High in cholesterol, but yummy. |
| 01:47.03 | jsmith | Utah_Dave: I had one of the best hamburgers I've ever had in my entire life |
| 01:47.17 | RedHeron | jsmith: Oooh! Do tell! |
| 01:47.46 | jsmith | RedHeron: There's a little hamburger joint that started in the Washington D.C. area called "Five Guys" |
| 01:48.21 | RedHeron | I don't think I've heard of it. |
| 01:48.28 | jsmith | RedHeron: Fresh hamburger ground fresh in the store every day. French fries made fresh. French fries and hamburgers are the only thing on the menu. |
| 01:48.43 | jsmith | RedHeron: They even tell you "Today's fries are from Rigby, Idaho" |
| 01:48.49 | RedHeron | Yep, I think I like the place already. :D |
| 01:49.03 | jsmith | RedHeron: To make a long story short, the chain is exploding... something like 1000 stores going in in the next two years. |
| 01:49.11 | RedHeron | :O |
| 01:49.23 | jsmith | RedHeron: They just opened one here in Huntsville, AL (where I'm teaching this week) |
| 01:49.44 | beandog | we need a Waffle House. |
| 01:49.47 | beandog | and Dunkin Donuts |
| 01:49.49 | RedHeron | I think this is something most people could actually get into. |
| 01:50.28 | RedHeron | beandog: Agreed, on both accounts, though I think Krispy Kreme stores, too. |
| 01:51.03 | beandog | we also need Fry's |
| 01:51.12 | RedHeron | Don't we have a Fry's? |
| 01:51.16 | beandog | no |
| 01:51.18 | Utah_Dave | cool |
| 01:51.25 | beandog | and hifi buys |
| 01:51.38 | jsmith | beandog: I had Waffle House for breakfast yesterday morning |
| 01:51.40 | beandog | and more gentoo devs |
| 01:51.42 | Utah_Dave | Five Guys sounds good |
| 01:51.49 | jsmith | Utah_Dave: You ain't a kiddin' |
| 01:51.53 | beandog | jsmith, oh yah? Man I love their waffles. |
| 01:52.08 | beandog | theres a waffle house on every corner. |
| 01:52.09 | jsmith | Utah_Dave: Come to one of my claasses in HSV, and I'll take you to Five Guys |
| 01:52.27 | jsmith | beandog: And you'd rather have Dunkin' Doughnuts than Krispy Kreme? |
| 01:52.31 | jsmith | beandog: Traitor! |
| 01:52.36 | beandog | jsmith, DD has more cake donuts |
| 01:52.39 | beandog | thats the ones I like |
| 01:52.51 | jsmith | Yuck |
| 01:53.03 | jsmith | I mean, don't get me wrong... a cake donut is better than no donut at all |
| 01:53.10 | jsmith | (even if it's a DD donut) |
| 01:53.42 | RedHeron | I don't mind chocolate cake donuts, but I think I'm a big fan of bear claws more. |
| 01:53.50 | RedHeron | And good baklava. |
| 01:53.54 | RedHeron | The Greek kind. |
| 01:56.43 | jsmith | RedHeron: Amen, brotha' |
| 01:56.54 | jsmith | RedHeron: (about the baklava, not the bear claws) |
| 02:02.26 | beandog | you know what we need |
| 02:02.30 | beandog | a #uphpu fortune mod |
| 02:02.35 | RedHeron | heh |
| 02:02.43 | beandog | ~fortune |
| 02:02.44 | jbot | i heard fortune is a kickass app available for Linux. Packages are in OZ and http://frob.us/modules.php?name=Fortune lets you use fortune over the web. |
| 02:05.26 | RedHeron | You know, there *used* to be this Greek place up in the northern part of Salt Lake, but I can't seem to find it any more. Actually owned by Greek people who made the best baklava in the state. |
| 02:05.49 | RedHeron | Anyone know if it's still there? |
| 02:14.49 | jsmith | RedHeron: There was a good place on 3rd West, up north of town. |
| 02:14.58 | jsmith | RedHeron: I haven't been there in years though |
| 02:15.02 | RedHeron | Yeah, that's the one I'm thinking of. |
| 02:15.15 | RedHeron | Not far from the Historical Museum |
| 02:15.30 | jsmith | Yup |
| 02:15.41 | RedHeron | Can't seem to find it, though. :-( |
| 02:26.54 | *** join/#uphpu wps (n=wps@208.53.47.251) |
| 02:26.54 | *** mode/#UPHPU [+o wps] by ChanServ |
| 02:40.49 | RedHeron | Okay... just thought about it, and I'm actually convinced this is an awesome idea. :-) |
| 02:40.52 | RedHeron | https://www.fundable.com/groupactions/groupaction.2008-03-13.5930615647 |
| 02:40.57 | RedHeron | Wrong group, though... |
| 02:48.33 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 02:48.34 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 03:24.02 | *** join/#uphpu mrkrow (n=Chad@dsl093-228-239.slc1.dsl.speakeasy.net) |
| 03:24.13 | *** part/#uphpu mrkrow (n=Chad@dsl093-228-239.slc1.dsl.speakeasy.net) |
| 04:14.48 | *** join/#uphpu josephscott (n=josephsc@63-228-200-73.slkc.qwest.net) |
| 04:14.48 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 04:47.43 | *** join/#uphpu bradym (n=bradym@63-197-255-78.ded.pacbell.net) |
| 04:47.43 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 06:23.26 | *** join/#uphpu bradym (n=bradym@63-197-255-78.ded.pacbell.net) [NETSPLIT VICTIM] |
| 06:23.26 | *** join/#uphpu cycokilr (n=cycokilr@216.112.116.6.ptr.us.xo.net) [NETSPLIT VICTIM] |
| 06:23.26 | *** mode/#UPHPU [+v bradym] by irc.freenode.net |
| 06:28.40 | *** join/#uphpu wps (n=wps@208.53.47.251) |
| 06:28.40 | *** mode/#UPHPU [+o wps] by ChanServ |
| 13:16.57 | *** join/#uphpu timinator (n=timothy@c-98-202-102-189.hsd1.ut.comcast.net) |
| 13:16.57 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 13:17.25 | timinator | sup guys |
| 13:30.56 | *** join/#uphpu jsmith (n=jsmith@216.207.245.1) |
| 13:30.56 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 14:37.27 | *** mode/#UPHPU [+v orsonj] by ChanServ |
| 14:43.59 | *** join/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 14:45.07 | *** part/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 14:55.52 | *** join/#uphpu josephscott (n=josephsc@63-228-200-73.slkc.qwest.net) |
| 14:55.52 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 15:01.35 | *** join/#uphpu mrkrow (n=Chad@166.70.178.114) |
| 15:15.01 | *** join/#uphpu mindjuju (n=mindjuju@76.8.222.130) |
| 15:15.01 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 15:16.34 | *** join/#uphpu fungus (n=olsonl@fungus.broker.freenet6.net) |
| 15:16.34 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 15:19.31 | *** join/#uphpu thebigdog (n=thebigdo@0006yE-Yn.dsl.xmission.com) |
| 15:19.31 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 15:36.53 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 15:36.53 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:37.15 | brasto | so, why does .profile work and not .bashrc on my Leapord-based Mac? |
| 15:38.15 | mgeary | you know, i believe the syntax is different for each file |
| 15:38.27 | mgeary | in .profile, i believe you do this: export PATH=/opt/local/bin:/opt/local/sbin:$PATH |
| 15:38.38 | mgeary | whereas in .bashrc, you do this: PATH=/usr/local/bin:/opt/local/bin:$PATH |
| 15:38.42 | mgeary | (no export) |
| 15:38.52 | mgeary | that may be part of the problem |
| 15:39.27 | fungus | Nope. Syntax is exactly the same. |
| 15:39.44 | fungus | they are just called during different types of logins. |
| 15:40.12 | mgeary | well, then, brasto, i dunno |
| 15:41.00 | fungus | When bash is invoked as an interactive login shell it first reads and executes commands from the file /etc/profile, if that file exists. After reading that file, it looks for ~/.bash_profile, ~/.bash_login, and ~/.profile, in that order |
| 15:41.22 | fungus | When an interactive shell that is not a login shell is started, bash reads and executes commands from /etc/bash.bashrc and ~/.bashrc, if these files exist. |
| 15:42.29 | fungus | Personally, I just add this line to my .bash_profile |
| 15:42.48 | fungus | [ -f ~/.bashrc ] && . ~/.bashrc |
| 15:43.54 | brasto | fungus - including the left-square-brace at the beginning? |
| 15:44.46 | fungus | yup |
| 16:21.50 | wps | is it possible to pluck a sub array out of a multi-dimensional array based off of multiple conditions without looping through the entire array? (let me know if that doesn't make sense and I'll try to explain better) |
| 16:22.06 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 16:22.06 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 16:22.27 | eggyknap | At some point, something's gotta loop the array |
| 16:22.55 | wps | if I only need one condition, I can pluck like this: |
| 16:23.07 | wps | $array[$value] |
| 16:23.45 | wps | but I need multiple values, like this… |
| 16:23.51 | wps | if… |
| 16:24.40 | wps | $array[][$val1] && $array[][$val2 && $array[][$val3], then give me $array[][$val4] |
| 16:26.29 | wps | hmm… I need to structure that array differently |
| 16:33.17 | beandog | http://scriptures.nephi.org/feeds.php |
| 16:33.18 | beandog | :) |
| 16:34.57 | PoeticIntensity | looks good, beandog |
| 16:35.13 | PoeticIntensity | is it supposed to just be a huge block of text? |
| 16:35.19 | beandog | uh |
| 16:35.23 | beandog | only if I did it wrong. |
| 16:35.30 | PoeticIntensity | lemme take a screenshot. |
| 16:35.30 | beandog | Im not sure how you do line breaks |
| 16:35.38 | PoeticIntensity | yeah.... |
| 16:35.40 | beandog | I got it working in liferea though |
| 16:35.44 | beandog | what are you using |
| 16:35.44 | PoeticIntensity | it just looks like a big square. |
| 16:36.02 | PoeticIntensity | Firefox live bookmarks |
| 16:37.39 | beandog | hmm |
| 16:37.40 | beandog | ok |
| 16:37.54 | PoeticIntensity | http://www.poeticintensity.com/Screenshot-4.png |
| 16:38.22 | PoeticIntensity | thars ya a screeeeeenshot |
| 16:38.29 | beandog | poo |
| 16:38.29 | beandog | ok |
| 16:41.07 | unum | do postgresql views allow you to set an update interval? |
| 16:44.11 | eggyknap | unum: You mean, an interval on which the view is updated? |
| 16:44.27 | eggyknap | <PROTECTED> |
| 16:50.20 | PoeticIntensity | mindjuju, might wanna consider changing the topic to reflect the lunch today... |
| 16:51.53 | *** topic/#UPHPU by mindjuju -> Geek Lunch today @ Brickoven @ 12:30p in Provo | UPHPU | http://uphpu.org |
| 16:52.05 | mindjuju | thx for reminder! |
| 16:52.38 | unum | eggyknap: thanks |
| 16:52.42 | eggyknap | yw |
| 16:52.45 | *** part/#uphpu eggyknap (n=eggyknap@unaffiliated/eggyknap) |
| 16:56.12 | PoeticIntensity | ;-) |
| 16:56.45 | mgeary | btw, Treeline will be sending it's contingent of 3 developers to the lunch today, so mindjuju, consider this a formal rsvp |
| 16:57.01 | mgeary | s/it's/its |
| 16:57.12 | PoeticIntensity | awesome! |
| 16:57.16 | PoeticIntensity | You'll be there, mgeary ? |
| 16:57.17 | mindjuju | :) |
| 16:57.20 | mgeary | yu |
| 16:57.20 | mgeary | p |
| 16:57.25 | PoeticIntensity | sweet! |
| 16:58.17 | mindjuju | this is going to be fun. I'm going to leave work erly today, in about 15 minutes in fact, run, pick up son from school, run pick up wife from home, run to geek lunch then hang out in Utah Valley until Sunday |
| 16:58.24 | mindjuju | nice little break from work / what not |
| 16:58.52 | wps | is it possible to have an SQL query return a multidimensional array? |
| 16:59.05 | beandog | no |
| 16:59.17 | macnewbold | ~salute GreatWhiteWizard |
| 16:59.17 | jbot | ACTION shows GreatWhiteWizard how to count in binary on his fingers... then stops conspiciously on the number 4 |
| 16:59.17 | beandog | well |
| 16:59.18 | beandog | no. |
| 16:59.36 | macnewbold | hm, that was odd. Who taught you that one, jbot? |
| 16:59.45 | mgeary | wps: a sql query always just returns a query result |
| 16:59.55 | mgeary | e.g. a resource |
| 16:59.59 | wps | yeah |
| 17:00.00 | wps | :( |
| 17:00.06 | wps | I am trying to figure out how to save calls to the DB |
| 17:00.22 | wps | I am creating an XML site map of our site |
| 17:00.32 | wps | with over a thousand pages |
| 17:00.54 | wps | each page has multiple tags and multiple authors and such |
| 17:01.16 | PoeticIntensity | sounds like a fun project, wps. |
| 17:01.29 | wps | and I can't figure out any way to do it so far without having to have multiple queries to the DB for each node of the XML file |
| 17:01.44 | wps | I'd like to just have a big query at the beginning and then just loop through it spitting out each node |
| 17:02.14 | wps | otherwise it'll bring the server to it's knees trying to build the file (with three thousand DB calls that fast) |
| 17:02.33 | beandog | union++ |
| 17:02.39 | wps | union? |
| 17:02.45 | beandog | that may or may not help. |
| 17:03.01 | beandog | select foo, bar union select poo, ping; |
| 17:03.44 | beandog | yah that wont help. |
| 17:04.14 | beandog | wps, I dont see why you cant just pull all of it once |
| 17:04.17 | beandog | and parse it in php |
| 17:04.51 | wps | what would be more overhead, a bunch of queries at the beginning and then building a MASSIVE array? or multiple DB calls? |
| 17:06.00 | beandog | 2nd one |
| 17:06.47 | PoeticIntensity | I second that. |
| 17:07.05 | PoeticIntensity | do your queries, then build the array. |
| 17:07.16 | PoeticIntensity | it's generally not a good idea to loop through queries. |
| 17:07.48 | wps | k |
| 17:09.26 | PoeticIntensity | also.... having arrays around with db info might come in handy later on. |
| 17:10.11 | thebigdog | ~seen timinator |
| 17:10.15 | jbot | timinator is currently on #uphpu (3h 53m 18s). Has said a total of 1 messages. Is idling for 3h 52m 50s, last said: 'sup guys'. |
| 17:22.23 | RedHeron | http://digg.com/politics/Obama_Receives_Endorsement_of_Flag_Officers_from_Army_Navy |
| 17:22.25 | RedHeron | WOW |
| 17:22.28 | RedHeron | Woops. |
| 17:22.33 | RedHeron | Sorry, wrong tab. |
| 18:33.29 | timinator | I'm back |
| 18:36.09 | *** join/#uphpu beandog_ (n=steve@67.42.124.159) |
| 18:39.29 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 18:39.29 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 18:51.19 | beandog | now_playing[Jesse Cook - Tempest - Tempest] length[0:17/3:03] |
| 19:27.57 | wps | can anyone help with some regex? |
| 19:28.04 | wps | I need to match all blocks of javascript |
| 19:28.26 | wps | so everything that starts with "<script" and ends with "</script>" |
| 19:29.24 | wps | is this sufficient? |
| 19:29.24 | wps | <script(.*)</script> |
| 19:29.49 | timinator | check this out: http://www.getdropbox.com/index |
| 19:30.22 | timinator | (that's not for your regex wps) |
| 19:54.13 | timinator | wps: I only use regex when absolutely necessary |
| 19:54.19 | wps | same |
| 19:54.43 | timinator | usually on sanitizing user submitted data |
| 19:55.02 | timinator | and usually on integers and such |
| 19:55.19 | timinator | for something bigger than that, I tend to use strpos |
| 19:55.26 | timinator | and then an if/else |
| 19:55.51 | timinator | it's easier on the CPU I've heard |
| 19:58.03 | wps | I think that this would be ugly using strpos |
| 19:58.21 | wps | ha ha ha… I just tried opening a 12 MB XML file over VPN and crashed my editor |
| 19:58.32 | timinator | well, it could be the initial tipoff that you'll have to swap the string |
| 19:58.37 | timinator | LOL |
| 19:58.56 | timinator | then you could do a string replace |
| 19:59.02 | timinator | or an explode |
| 19:59.04 | timinator | or something |
| 19:59.29 | wps | doesn't this seem easier than that though? |
| 19:59.29 | wps | preg_replace('/<script(.*)<\/script>/i', '', $page['p_code']) |
| 19:59.32 | timinator | from what I've heard about regex's pull on the CPU, it may be worth it |
| 19:59.45 | timinator | easier, and sexier |
| 20:00.00 | wps | your CPU thoughts are worth considering though |
| 20:01.54 | timinator | that's the only reason I bring up the other solution |
| 20:02.20 | timinator | and I've never tested it on large strings |
| 20:03.34 | wps | I'm so sick of hearing about Facebook |
| 20:04.01 | unum | wps: have you seen MY facebook page |
| 20:04.11 | unum | I didn't something really different with it... |
| 20:04.17 | wps | I've never seen any favebook pages |
| 20:04.26 | unum | I'm just kidding I don't have a facebook account |
| 20:04.57 | wps | and I'm especially sick of hearing about it as a platform |
| 20:05.34 | wps | …and about programmers/businessmen talking about build apps for it as a viable business model |
| 20:07.44 | timinator | I think the CEO will regret not selling it when he had the chance |
| 20:07.51 | timinator | ..... for BILLIONS |
| 20:07.55 | timinator | hell man |
| 20:07.56 | wps | no kidding |
| 20:07.57 | timinator | BILLIONS |
| 20:08.01 | timinator | take the $$$ |
| 20:08.20 | wps | even if it does get bigger he could have had enough dough to wipe his butt with 100 dollar bills the rest of his life |
| 20:08.33 | wps | why wouldn't you have taken the money? |
| 20:08.44 | wps | he's insane |
| 20:14.01 | timinator | fo sho |
| 20:14.04 | timinator | I agree |
| 20:14.25 | timinator | fo some reason, he thinks he can be the next Google or Microsoft |
| 20:14.33 | timinator | that's the only reason to pass on the check |
| 20:14.43 | timinator | but he won't be |
| 20:14.52 | *** part/#uphpu mrkrow (n=Chad@166.70.178.114) |
| 20:14.57 | timinator | FaceBook is a fad, not a platform |
| 20:21.57 | mgeary | i'd have taken the money in a second |
| 20:35.18 | wps | I'd have sold it for 1 million |
| 20:45.15 | timinator | he did well to push the price...... he's probably getting a ton off advertising..... but once you can walk away and never work again in your life, take the $$ and run baby |
| 20:46.11 | timinator | and his target audience is getting older and older |
| 20:46.34 | timinator | I think business week did an article to that effect a little while ago |
| 20:46.41 | timinator | I only read the first few lines |
| 21:09.40 | *** join/#uphpu josephscott (n=josephsc@63-228-200-73.slkc.qwest.net) |
| 21:09.40 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 21:29.00 | mgeary | not that Danica whatsherbucket did either |
| 21:31.20 | wps | in case anyone ever wants to use the "." character in a regex pattern to look for anything, even including new line characters, note that added an "s" to the end of your patten will for "." to include new line characters |
| 21:31.33 | wps | took my two hours of googling to find it |
| 21:31.41 | wps | s/my/me/ |
| 21:32.06 | wps | man, I sure can't type |
| 21:32.10 | wps | will force it to |
| 21:32.43 | beandog | wps, what? |
| 21:32.50 | beandog | no it wont. |
| 21:32.50 | wps | sorry |
| 21:32.53 | beandog | .s? |
| 21:32.55 | beandog | er |
| 21:33.01 | beandog | that would look for any character, than an s |
| 21:33.05 | beandog | \s is spaces |
| 21:33.07 | wps | vs |
| 21:33.15 | wps | this… |
| 21:33.20 | wps | <PROTECTED> |
| 21:33.22 | wps | vs |
| 21:33.32 | wps | <PROTECTED> |
| 21:33.40 | wps | see how the first has an 's' at the end? |
| 21:33.42 | beandog | wps, oh, on the end |
| 21:33.45 | beandog | the .. modifiers |
| 21:33.47 | beandog | whatever theyre called. |
| 21:33.54 | beandog | gotcha. |
| 21:33.57 | wps | that causes the "." in the middle to not stop at newlines |
| 21:34.35 | fungus | wps the /m modifier should work too. |
| 21:34.42 | wps | what does m do? |
| 21:34.48 | fungus | Multiline |
| 21:35.09 | fungus | http://us2.php.net/manual/en/reference.pcre.pattern.syntax.php |
| 21:35.21 | fungus | Scroll half way down to "Internal Option setting" |
| 21:35.39 | fungus | err, even better... |
| 21:35.40 | fungus | http://us2.php.net/manual/en/reference.pcre.pattern.modifiers.php |
| 21:37.06 | fungus | oh, maybe you need both /sm |
| 21:37.14 | wps | thank you |
| 21:40.10 | PoeticIntensity | ok... |
| 21:40.22 | PoeticIntensity | I need help finding a page which will summarize what "view" in a database is. |
| 21:40.32 | PoeticIntensity | people have told me again and again, but it just won't stick... |
| 21:40.42 | mgeary | you want to know what a view is? |
| 21:40.49 | PoeticIntensity | anybody have a good webpage which explains what a view is? |
| 21:40.52 | PoeticIntensity | (yes, mgeary) |
| 21:41.07 | wps | http://en.wikipedia.org/wiki/View_%28database%29 |
| 21:41.07 | mgeary | you could think of it as a virtual table |
| 21:41.08 | PoeticIntensity | I believe it will help me quite a bit here, but I just can't grasp the concept. |
| 21:41.19 | PoeticIntensity | ok.... |
| 21:41.21 | PoeticIntensity | yup |
| 21:41.27 | mgeary | or as a permanently joined set of data |
| 21:41.35 | fungus | Or consider a view as a saved query |
| 21:41.36 | PoeticIntensity | and how often is that data updated? |
| 21:41.40 | mgeary | instantly |
| 21:41.42 | fungus | Every access |
| 21:41.48 | PoeticIntensity | really..... hmm.... |
| 21:41.50 | PoeticIntensity | so... |
| 21:42.01 | fungus | assigning a shortcut name to a query |
| 21:42.03 | PoeticIntensity | let's say I have a page which requires like 15 joins and takes 4 seconds to load... |
| 21:42.15 | PoeticIntensity | will a view help me there? |
| 21:42.23 | mgeary | why does it take 4 seconds? |
| 21:42.23 | PoeticIntensity | (page = query) |
| 21:42.30 | PoeticIntensity | because the joins are nasty. |
| 21:42.33 | fungus | It will pull that long hairy query out of your code, and put it in the database |
| 21:42.36 | PoeticIntensity | the query takes 4 seconds, not the page. |
| 21:42.44 | PoeticIntensity | ah... |
| 21:42.46 | fungus | Not help speed of the query though |
| 21:42.52 | mgeary | nasty joins != long joins |
| 21:43.02 | PoeticIntensity | is the query run everytime the view is accessed? |
| 21:43.03 | mgeary | a long query often indicates the absence of an index |
| 21:43.08 | mgeary | yes, every time |
| 21:43.09 | fungus | Yes, every time. |
| 21:43.11 | mgeary | heh |
| 21:43.11 | PoeticIntensity | no... this one is nasty. |
| 21:43.12 | fungus | lol |
| 21:43.17 | mgeary | ^5 |
| 21:43.22 | PoeticIntensity | so, really, a view wouldn't help me. |
| 21:43.30 | mgeary | possibly not |
| 21:43.45 | fungus | In Oracle there is an idea of a "materialized" view, which does what you want. Caches results of a query. |
| 21:43.46 | PoeticIntensity | I'm just trying to fudge around re-factoring my db... |
| 21:43.52 | fungus | but not available in MySQL |
| 21:43.56 | PoeticIntensity | I'm using Postgres. |
| 21:44.40 | fungus | I don't know if Pg supports them or now. |
| 21:44.44 | fungus | s/now/not/ |
| 21:44.59 | fungus | erg. |
| 21:45.03 | beandog | lol |
| 21:45.05 | PoeticIntensity | so.... |
| 21:45.27 | PoeticIntensity | help me understand how a view could be good, if it's just like running a query every time something hits it...? |
| 21:45.39 | PoeticIntensity | what are the benefits? |
| 21:45.43 | mgeary | well, if when you use a set of data, you ALWAYS join it to something else |
| 21:45.47 | fungus | Easier queries in your code. |
| 21:46.09 | mgeary | or maybe you ALWAYS want the 5 newest records in a table, and you want those joined with something... |
| 21:46.25 | mgeary | thebigdog uses views for backwards compatibility of his DB architecture, which is cool |
| 21:46.42 | mgeary | e.g. he upgrades his DB, but creates a view for older code which emulates the older DB archi |
| 21:46.44 | PoeticIntensity | I get the easier thing... |
| 21:46.53 | PoeticIntensity | gotcha. |
| 21:46.55 | fungus | It could also be used for security, to limit what data is displayed. |
| 21:46.56 | PoeticIntensity | that is cool. |
| 21:47.05 | PoeticIntensity | ok... |
| 21:47.20 | PoeticIntensity | for some reason, I was under the impression that views sped up joins or something to that effect. |
| 21:47.31 | mgeary | no, that's what indexes do ;) |
| 21:47.35 | PoeticIntensity | what you guys are telling me makes perfect sense... |
| 21:47.37 | PoeticIntensity | (yes) |
| 21:47.54 | PoeticIntensity | thanks, mgeary / fungus |
| 21:47.57 | mgeary | yo |
| 21:48.10 | PoeticIntensity | yo momma |
| 21:48.31 | PoeticIntensity | (and wps, for the link) |
| 22:05.42 | beandog | meh |
| 22:05.47 | beandog | wordpress-- |
| 22:05.52 | beandog | versioned releases++ |
| 22:06.01 | beandog | md5sums++ |
| 22:08.42 | wps | working over VPN-- |
| 22:20.30 | thebigdog | PoeticIntensity, on the database views i do like fungus suggested alot |
| 22:20.39 | thebigdog | i create views that have security joins in them |
| 22:20.48 | PoeticIntensity | I see... |
| 22:20.53 | thebigdog | this allows me to pull back data that only that person has access too |
| 22:21.00 | thebigdog | to view |
| 22:21.04 | PoeticIntensity | yup. |
| 22:21.10 | thebigdog | simplicity is one thing |
| 22:21.27 | thebigdog | also i like to use them with stored procedures and other types of code like that |
| 22:21.35 | thebigdog | so you might have a query like this |
| 22:21.46 | thebigdog | select * from view1 where user_id = 2; |
| 22:21.59 | thebigdog | well in that view i can do all those things mention above |
| 22:22.10 | thebigdog | think in terms of interface |
| 22:22.23 | thebigdog | i have the contract set for the application |
| 22:22.34 | thebigdog | but behind the contract/interface i can do whatever i like |
| 22:22.35 | PoeticIntensity | right. |
| 22:22.46 | PoeticIntensity | kinda like an API. |
| 22:22.52 | thebigdog | exactly |
| 22:23.03 | PoeticIntensity | thanks... that does help quite a bit. |
| 22:23.06 | thebigdog | and with stored procedures you can really do some amazing things |
| 22:23.27 | thebigdog | for example make multiple queries for data |
| 22:23.38 | thebigdog | the benefit is that the queries are in the database and not on the ui |
| 22:23.42 | thebigdog | or application level |
| 22:23.59 | thebigdog | with oracle it is even 10x better |
| 22:24.18 | thebigdog | cause you can do cross database queries |
| 22:24.27 | *** join/#uphpu jsmith (n=jsmith@216.207.245.1) |
| 22:24.30 | thebigdog | now that is freaking awesome |
| 22:24.48 | thebigdog | im talking full on across network queries |
| 22:25.05 | thebigdog | pgsql cannot do that ;( |
| 22:35.21 | thebigdog | also what is really sweet it so to create sprocs that are like inserts |
| 22:35.30 | thebigdog | if you need to hit multiple tables |
| 22:43.54 | beandog | okay this is really pissing me off |
| 22:44.00 | beandog | mysql-- |
| 22:47.16 | RedHeron | Knowledge is power. |
| 22:47.50 | *** part/#uphpu pelaofeliz (n=PelaoFel@67.108.236.230) |
| 23:01.57 | thebigdog | haha |
| 23:26.32 | *** join/#uphpu influx^^ (i=influx@67.137.218.51) |
| 23:26.32 | *** mode/#UPHPU [+v influx^^] by ChanServ |
| 23:49.39 | *** join/#uphpu jsmith_ (n=jsmith@216.207.245.1) |
| 23:59.37 | *** join/#uphpu Lone_Wanderer (n=chatzill@206.61.134.77) |
| 23:59.37 | *** mode/#UPHPU [+v Lone_Wanderer] by ChanServ |
