| *** DarylM has quit IRC | 00:03 | |
| *** toumi01 has quit IRC | 03:03 | |
| *** withdefault has joined #ingres | 07:39 | |
| *** ChanServ sets mode: +o withdefault | 07:40 | |
| *** grantc_offline is now known as grantc | 08:18 | |
| *** Gerhard has joined #ingres | 08:27 | |
| grantc | morning all | 08:43 |
|---|---|---|
| grantc | freenode has been bought by yahoo! - http://blog.freenode.net/2009/04/pdpc-yahoo-acquisition/ | 08:44 |
| SlimeyPete | first one of the day, then | 09:09 |
| grantc | ? | 09:10 |
| grantc | frist post? | 09:10 |
| SlimeyPete | first April fool | 09:10 |
| * grantc is an idiot | 09:10 | |
| SlimeyPete | :) | 09:10 |
| grantc | my excuse is that it's not april fools here in spain :) | 09:10 |
| SlimeyPete | I do wonder how many people get caught out by timezones today | 09:11 |
| SlimeyPete | or indeed cultural differences | 09:11 |
| * grantc resolves not to read his news feeds today | 09:12 | |
| SlimeyPete | half the internet starts making April fool jokes and the other half goes "Y'whut? Are you mad?" | 09:12 |
| grantc | :) | 09:12 |
| grantc | the thing is in the case of freenode, you could see it being a possibility... | 09:12 |
| SlimeyPete | Mmm. I suspect there'll be plenty of non-westerners who get taken in by it. | 09:13 |
| SlimeyPete | Oh well. 's their fault for being foreign! ;) | 09:13 |
| SlimeyPete | this is Google's attempt: http://www.google.com/intl/en/landing/cadie/index.html | 09:14 |
| grantc | skynet - cute... | 09:18 |
| grantc | i still remember the radio 1 fool of emulating stereo using the two MW frequencies... yes i fell for that too :) | 09:19 |
| SlimeyPete | heh | 09:20 |
| *** Alex|off is now known as Alex| | 09:57 | |
| *** Gerhard has quit IRC | 11:33 | |
| *** Gerhard has joined #ingres | 11:34 | |
| *** Gerhard has left #ingres | 13:40 | |
| *** toumi01 has joined #ingres | 13:49 | |
| *** mull has joined #ingres | 14:44 | |
| *** mull_ has joined #ingres | 14:46 | |
| *** thiagomz has joined #ingres | 14:51 | |
| *** thiagomz_ has joined #ingres | 15:19 | |
| *** thiagomz has quit IRC | 15:31 | |
| *** mull_ has quit IRC | 15:31 | |
| *** Gerhard has joined #ingres | 16:28 | |
| *** DerMeister has joined #ingres | 16:43 | |
| *** mull has quit IRC | 17:24 | |
| *** Gerhard has quit IRC | 17:30 | |
| *** mull has joined #ingres | 18:08 | |
| *** mull has quit IRC | 18:18 | |
| *** mull has joined #ingres | 18:19 | |
| *** lefred has joined #ingres | 19:17 | |
| lefred | hello | 19:17 |
| *** pleemans has joined #ingres | 19:17 | |
| lefred | you're late Mr P | 19:17 |
| *** sdog has joined #ingres | 19:18 | |
| pleemans | I know. | 19:18 |
| sdog | all 4 ? | 19:18 |
| sdog | there's only 3 you dummy ;) | 19:18 |
| *** sdog has left #ingres | 19:21 | |
| *** grantc is now known as grantc_offline | 19:34 | |
| *** pleemans has quit IRC | 19:44 | |
| *** coderanger has joined #ingres | 20:29 | |
| coderanger | troal01: Aha, there you are | 20:29 |
| coderanger | troal01: We were wondering what the status of the trac ingres backend is? | 20:29 |
| coderanger | You mentioned a few days ago that you had a patch, but the ticket hasn't been updated in 17 months | 20:32 |
| *** flyer_ has joined #ingres | 20:33 | |
| coderanger | (we've been adding a lot of cross-db testing and some other functionality during this sprint, so we could now actually have some level of confidence that the patch won't break any of the other 3) | 20:34 |
| *** pleemans has joined #ingres | 21:11 | |
| *** DarylM has joined #ingres | 21:36 | |
| *** pleemans has quit IRC | 21:59 | |
| *** DerMeister has quit IRC | 22:12 | |
| *** vikram has joined #ingres | 22:27 | |
| vikram | Hello Everyone, not bad, almost 20 people | 22:28 |
| SlimeyPete | hi | 22:28 |
| vikram | I've got a slightly related question for everyone. I know you guys are all very smart RDBMS folk | 22:28 |
| vikram | You need to store (music) album names into a database | 22:29 |
| vikram | Albums typically only have 1 artist, but compilation albums ("Greatest Hits") can have more than one artist. Multiple artists can also have albums with the same name | 22:30 |
| vikram | How do you setup tables, so as to allow you to build a unique list of albums | 22:31 |
| vikram | For example, clean db, you are going through a folder called Frank Sinatra\Greatest Hits\track%.mp3, you see the first track1.mp3, retrieve the metadata, and create an entry in the album table for Frank Sinatra - Greatest Hits | 22:32 |
| vikram | You then come across a folder of Dean Martin songs, the metadata says they are from a "Greatest Hits" album, how do you know that this album is a different "Greatest Hits" album, or part of a compilation cd of "Greatest Hits" | 22:33 |
| vikram | Now one method I thought of was to look to see if they are in different file paths, but this doesnt work if you had folders labeled cd1 and cd2 containing songs from a compilation disc | 22:38 |
| vikram | so getting the right combination of references/foreign keys and UNIQUE columns has got me struggling | 22:38 |
| *** DarylM has quit IRC | 22:42 | |
| *** zxiiro_ has quit IRC | 22:50 | |
| *** zxiiro has joined #ingres | 22:50 | |
| *** ChanServ sets mode: +v zxiiro | 22:50 | |
| *** mull has quit IRC | 22:57 | |
| *** coderanger has left #ingres | 23:06 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!