[13:48] <bluebomber> So, Florida LoCo, what's up?
[13:49] <bluebomber> What kind of ideas do we have for Software Freedom Day, 11.10 launch, anything else...?
[13:49] <bluebomber> Or are we going to discuss some of the above the next IRC meeting?
[13:54] <mhall119> hey bluebomber 
[13:54] <bluebomber> Hey, mhall119 
[13:54] <mhall119> bluebomber: you can add those as items to discuss in the next meetin
[13:55] <munz> morning all :)
[13:55] <munz> sorry been soooo busy lately
[13:55] <mhall119> bluebomber: http://loco.ubuntu.com/meetings/ubuntu-us-florida/193/detail/
[13:55] <mhall119> log in and you should be able to add agenda items
[13:55] <bluebomber> I thought I could add those, too, seeing as it's a wiki, but kept overlooking the incredibly-easy-to-overlook login button at the top left.
[13:56] <mhall119> it's not a wiki
[14:00] <bluebomber> Ahh, you're right, but I always click over to it from https://wiki.ubuntu.com/FloridaTeam
[14:00] <bluebomber> Anyway, agenda items added.
[14:13] <mhall119> awesome
[15:17] <DammitJim> hey guys
[15:17] <jamalta> hey
[15:18] <DammitJim> hey jamalta maybe you can help me... totally off topic, though
[15:18] <jamalta> what's up?
[15:18] <DammitJim> are you familiar with SQL stuff?
[15:18] <jamalta> yeah
[15:18] <jamalta> well, depends
[15:18] <DammitJim> so, I have a table that holds something like this:
[15:20] <DammitJim> http://pastebin.com/e9CViUqp
[15:20] <DammitJim> and I want it either SQL or another program to return what's under the +++++s
[15:21] <DammitJim> what's more effective? to use SQL or something else like awk?
[15:21] <DammitJim> of course, there are 800 locations and about 40 channels
[15:21] <DammitJim> I think they call this pivoting or something like that
[15:23] <jamalta> you can do that with sql
[15:23] <jamalta> i have no clue how you would do it with awk though
[15:24] <DammitJim> oh really? I can do this in sql?
[15:24] <DammitJim> I'm using mysql
[15:24] <jamalta> there's a simple way
[15:24] <jamalta> which would be to query the locations and then loop through them and query for the person for each channel
[15:24] <jamalta> and then i'm sure there's a way to do it with a group by which i would need to create the table to make sure i did right, since i'm a bit rusty with that
[15:25] <DammitJim> hhhmmmm... I guess that's the piece where I don't know how to approach... the looping piece. Sounds like I'd need a procedure?
[15:25] <jamalta> although, it might just require sub-queries
[15:25] <jamalta> You're accessing the DB directly?
[15:25] <DammitJim> do you know what this is called? what I want to do... so I can search online?
[15:25] <DammitJim> yes
[15:25] <jamalta> Ohh
[15:26] <jamalta> So it's not an application you're building? You just want to pull the data?
[15:26] <DammitJim> well, I have flexibility to make it an app
[15:26] <DammitJim> I was just trying to figure out what gets done in SQL and what gets done in the application layer
[15:27] <DammitJim> I'll have scripts that run automatically to do all this stuff
[15:28] <jamalta> I mean, something like this _might_ work but I haven't tested it
[15:28] <jamalta> SELECT Location, (SELECT Owner FROM Table WHERE Channel = 1 AND Location = ParentTable.Location) AS Channel1, (SELECT Owner FROM Table WHERE Channel = 2 AND Location = ParentTable.Location) AS Channel2 FROM Table as ParentTable
[15:28] <jamalta> Oh, add a Group by in there
[15:28] <jamalta> GROUP BY Location
[15:29] <DammitJim> oh ok, but at the end of the day, I have to hard code the channel column, don't I?
[15:29] <jamalta> Yep, that's why I wouldn't do it that way
[15:29] <DammitJim> lol
[15:29] <jamalta> Instead, I would have a Locations table, a Channels table and then a user/owner table
[15:29] <jamalta> Then a table that joins all 3
[15:29] <DammitJim> no biggie... the channels aren't going to change
[15:29] <DammitJim> oh, I have the locations table and the channels table already
[15:30] <jamalta> Does an owner have it's own table?
[15:30] <jamalta> Or do you only ever need a name / username?
[15:30] <jamalta> If you have an owner table then you just want a table that has owner_id, location_id, channel_id
[15:31] <DammitJim> the table example I pastebin'd is derived from other tables so yeah, the owner has it's own table at the beginning
[15:31] <jamalta> Ah
[15:31] <DammitJim> yup, that makes sens
[15:31] <DammitJim> e
[15:31] <DammitJim> but I still don't get how to do the pivoting
[15:31] <jamalta> So what you want is a list of locations with each channel, right?
[15:32] <DammitJim> I want to see a matrix of locations vs channels with the owners in the corresponding cells
[15:32] <DammitJim> it's like a report, ya know?
[15:33] <jamalta> and a location always has an entry for every channel?
[15:33] <jamalta> well, that doesn't matter really
[15:33] <DammitJim> jamalta, I'll check with you later, if this is distracting, I'm sorry
[15:34] <DammitJim> I have to run an errand and I'll be back later if you have any other ideas
[15:34] <DammitJim> I just wanted some pointers so I could google what I need to do, but I don't even know what to call it LOL
[15:35] <jamalta> well, i don't know if there's a term for this but it's just getting data and printing it
[15:35] <jamalta> i would do it outside the sql level though
[15:35] <jamalta> for example
[15:35] <jamalta> here's some pseudo-code on how i would go about it
[15:35] <jamalta> http://pastebin.com/CaTvRwDQ
[15:35] <jamalta> the {} in the query is how i was referring to data coming from the script and not the DB
[15:35] <jamalta> so {channel.id} is coming from the channel that's being looped on
[15:35] <jamalta> etc.
[15:36] <jamalta> OwnerChannel is what I called the table that joins Owner, Channel and Location
[15:36] <jamalta> brb
[15:40] <jamalta> back
[17:31] <jamalta> global jam is at 9:45am?
[17:35] <DammitJim> thanks jamalta 
[17:35] <jamalta> ah, np!
[17:35] <jamalta> hopefully it was helpful, rather than confusing :\
[17:35] <DammitJim> it's a different approach
[17:35] <DammitJim> I've been reading on http://www.artfulsoftware.com/infotree/queries.php#78
[17:36] <jamalta> Ahh
[17:36] <jamalta> That's all SQL then :)
[17:37] <DammitJim> yeah, but again, I've just been trying to figure out if I should do it all in SQL or part sql and part application
[17:37] <DammitJim> so, I guess there are many approaches to this problem and you did it with one
[18:40] <cjohnston> jamalta: my house tomorrow.. can you come?
[18:40] <jamalta> cjohnston: ohh, the loco site has something in lakeland listed
[18:40] <jamalta> what itme?
[18:40] <jamalta> time*
[18:40] <jamalta> and where?
[18:40] <jamalta> rather, where is your house? :)
[18:41] <cjohnston> ya.. we changed it.. but i didnt put up my address
[18:41] <cjohnston> pine hills
[18:41] <jamalta> ah, alright
[18:41] <cjohnston> during the day
[18:41] <jamalta> ah alright, down by colonial?
[18:41] <jamalta> (down considering i'm in sanford)
[18:42] <cjohnston> statik: ping
[18:42] <cjohnston> jamalta: pm
[18:45] <statik> hi there cjohnston 
[18:47] <jamalta> statik: he just left, i sent you a pm
[18:49] <jck77> hello
[18:49] <jck77> is anybody from the broward or dade county?
[19:14] <mhall119> I think jcastro is close now
[19:15] <mhall119> some others too, I don't remember which though
[19:15] <mhall119> reya, but he's offline
[19:19] <jck77> umm ok
[19:20] <jck77> I would like to participate in a meeting or software release party down here
[19:27] <jcastro> I am in Boca
[19:27] <jcastro> but I thought I was all by myself!
[19:32] <itnet7> jcastro: there are close to 10 Florida Team members that live within an hour south of you, You're about 2 hours 10 Min. south from me
[19:33] <itnet7> zus also lives closer to you and jck77
[19:33] <jamalta> is ubuntu-us-fl@lists.ubuntu.com the right address for our mailing list?
[19:33] <itnet7> jamalta: yes, but you're no longer subscribed
[19:33] <itnet7> I just let it through
[19:33] <jamalta> oh :(
[19:33] <jamalta> oh thanks!
[19:34] <itnet7> I can try and add that address you used for ya
[19:34] <itnet7> but I moderated it using listadmin
[19:34] <jamalta> that'd be great! :)
[19:34] <itnet7> cool
[19:35] <jamalta> is anything else going on for the jam this weekend?
[19:35] <itnet7> Not sure, I was planning to get a group together up here, but haven't had time to plan it
[19:36] <jamalta> Ah, alright
[19:37] <jcastro> jck77: we should get beer.
[19:38] <jcastro> oops, I mean "jam this weekend".
[19:38] <bluebomber_satel> Would someone provide me cjohnston's address for the event tomorrow, please?
[19:38] <bluebomber_satel> He appears away.
[19:55] <bluebomber_satel> Thanks, everyone. I guess there's nothing like asking for a physical address to silence an IRC chat.
[19:56] <itnet7> bluebomber_satel: lol
[19:56] <itnet7> I don't have it, otherwise I'd PM you
[19:56] <itnet7> bluebomber_satel: you have off from school tomorrow?
[20:04] <bluebomber_satel> itnet7: I might be able to make it for a couple hours. I'm a grad student => Few classes.
[20:07] <itnet7> bluebomber_satel: cool! I was going to try and swing by, but I found out I have to work tomorrow for coverage
[20:07] <itnet7> Hope everyone has some fun!
[20:14] <bluebomber_satel> itnet7: Thanks, I'll have some extra fun on your behalf if I make it and you don't.
[20:14] <bluebomber_satel> How have you been?
[20:14] <itnet7> +1
[20:14] <itnet7> I have been pretty good, and you?
[20:27] <bluebomber_satel> Fine, thanks, busy.
[20:27] <bluebomber_satel> Kindasorta
[20:27] <bluebomber_satel> We had an amazing time in Portland.
[20:27] <bluebomber_satel> I loved that city so much, I'm seriously considering moving out there. I hear a lot of good things about the pacific northwest in general.
[20:27] <itnet7> Oh, you went there for Linuxcon?
[20:28] <itnet7> I'll bet it was awesome!
[20:30] <jck77> hey itnet7 
[20:31] <jck77> jcastro: I live in fort Lauderdale, well is almost Davie cuz is close to i95 and 595
[20:32] <jck77> jcastro: I dont know my plans for this weekend, my mother in law is in town and that sucks
[20:32] <jck77> lol
[20:38] <bluebomber_satel> Not Linuxcon (I wish). For IEEENano.
[20:39] <itnet7> Ah!
[20:39] <bluebomber_satel> Well, should I email cjohnston?
[20:39] <itnet7> jamalta: If you get a chance, can you PM bluebomber_satel the address please
[20:39] <itnet7> for the Community Web Jam tomorrow
[20:44] <mhall119> jamalta: are you going to be at the jam tomorrow?
[20:44] <mhall119> itnet7: should check with cjohnston before sending out his address
[20:45] <itnet7> mhall119: thanks
[20:46] <jamalta> mhall119: yeah :)
[20:46] <jamalta> although i'll be working and won't be able to participate on the jam too much
[20:47] <jamalta> oh, bluebomber left.. i guess he can get it when he comes back.
[20:49] <mhall119> jamalta: are you still with flickr?
[20:50] <jamalta> mhall119: yeah
[20:52] <mhall119> working remote now or something?
[20:56] <jamalta> sorry keep going away from irc and not checking back
[20:56] <jamalta> yeah, i'm working remotely now
[21:00] <mhall119> cool