IRC log for #gllug on 20070604

03:10.37*** join/#gllug londo (n=georgiou@82.133.49.59)
04:01.26*** join/#gllug clive-h (n=ch@chills.demon.co.uk)
04:56.25morsingclive-h!
04:57.56clive-hMorning morsing!
04:59.36*** join/#gllug irc_ (n=irc@chills.demon.co.uk)
05:01.06*** join/#gllug [Clive] (n=chills@chills.demon.co.uk)
05:02.36*** join/#gllug clive-h (n=chills@chills.demon.co.uk)
05:19.27*** join/#gllug clive-h (n=ch@chills.demon.co.uk)
05:31.14*** join/#gllug clive-h (n=ch@chills.demon.co.uk)
05:43.32*** join/#gllug resudaed (n=tom@82-47-216-50.cable.ubr06.shef.blueyonder.co.uk)
06:02.41*** join/#gllug clive-h (n=ch@chills.demon.co.uk)
06:59.10*** join/#gllug clive-h (n=ch@chills.demon.co.uk)
07:41.26*** join/#gllug AnneC (n=AnneC@87-194-46-187.bethere.co.uk)
07:44.14*** join/#gllug niv_one_three (n=niv@85.65.212.180.dynamic.barak-online.net)
07:45.11*** join/#gllug niv_one_three (n=niv@85.65.212.180.dynamic.barak-online.net)
07:50.33JosefAssadmorning
07:51.52sabinef72morning all
07:54.51niv_one_threehello world
08:40.15*** join/#gllug Ch0Hag (n=mking@87.127.170.250)
09:40.17*** join/#gllug zOOz (n=vaijab@host81-151-55-105.range81-151.btcentralplus.com)
09:40.34zOOzhello
09:59.53adhocevenen zOOz
10:23.14rhowePeople are fucking idiots - http://www.theregister.co.uk/2007/06/04/wi_fi_panic/
10:25.23z00daxhallo
10:27.37z00daxwtf is Scooter Computer!
10:29.18rhowenfi
10:32.28kjalilmorning all
10:32.37*** join/#gllug AnneC_ (n=AnneC@cmarfw01.marlow.spinvox.com)
10:32.45rhowez00dax: home computer support company
10:33.42z00daxrhowe: yeah just looking up their website... the pink is horrible.
10:34.05z00daxlooks like they have jobs! for people who can fix broadband, ipod's and home networks!!!
10:34.09z00daxi might qualify!
10:34.44z00daxsince they dont ask for it, i suppose the Scooters are company supplied....
10:34.58rhowez00dax: They're also still advertising their January discount for people who can't use their xmas presents
10:35.25adhocrhowe: perhaps people should throw away their mobile phones first... they pump out ten times more power anyways
10:35.30z00daxrhowe: its not clear, which year's xmas gifts they are talking about
10:35.31rhoweadhoc: Indeed
10:35.38rhowez00dax: It says Jan 2007 in the PDF
10:35.41adhocthen move on to mobile phone base stations
10:35.48z00daxalso, if people in June still cant use the gifts they got 6 months back, they really *do* need help!
10:36.11z00daxooh.. i didnt look at the pdf.
10:36.25adhochey z00dax i have gift vouchers i got 11 months ago i still need to use
10:36.47z00daxadhoc: you need help.
10:36.50JosefAssadwow, such amazing old documents in my backups
10:36.56adhocz00dax: pffft
10:37.00kjalilz00dax: did you get the s-video working?
10:37.35z00daxkjalil: not yet, i need to get off my arse and go buy a s-video -> scart cable
10:41.51kjalilz00dax: my current media center setup works that way, s-video to scart. i haven't tried in linux though
10:42.23adhoclaters
10:42.26*** part/#gllug adhoc (n=kim@ppp102-220.lns10.adl6.internode.on.net)
10:42.55z00daxadhoc, c ya
10:45.07JosefAssadwhy, when I am hungry, am I making coffee?
11:28.47zOOzwhen is the next meeting?
11:30.53boudiccasfriday 8 june, maidstone social meeting in the british queen
11:32.15zOOzwhat is maidstone?
11:32.52boudiccasthe name of a place in kent
11:33.26zOOzit is out of london, isn't?
11:33.55boudiccasyes, its the capital town of kent, and is the loose HQ of Kent lug
11:34.17boudiccasand friday 8 june is our next meeting
11:36.57zOOzok
11:40.06*** join/#gllug clive-h (n=ch@chills.demon.co.uk)
11:41.39clive-hgood afternoon
11:45.15wethrinahoy
12:16.28*** join/#gllug catalyst (n=catalyst@allegro/user/angelchild)
12:17.54*** join/#gllug catalyst` (n=catalyst@allegro/user/angelchild)
12:24.29*** join/#gllug ranner (n=ranner@88-106-21-153.dynamic.dsl.as9105.com)
12:32.25niv_one_threehi all
12:34.05boudiccasmwop
12:34.50niv_one_threeis anyone aware of a program that runs in shel that has icq sms access?
12:34.50niv_one_threebitlbee only gives me icq , no smsicq
12:46.01*** join/#gllug niv_one_three (n=niv@85.65.212.180.dynamic.barak-online.net)
12:56.01*** join/#gllug SlayerXP (n=Mart@82-69-6-203.dsl.in-addr.zen.co.uk)
12:58.05*** join/#gllug flips_and_rails (n=stu@cv-kraken.cv.ic.ac.uk)
13:15.21halimost important task of the week already completed! *yeay*
13:15.28halinaming a set a of new QA servers
13:15.36halii think my favorite is "leatherjacket"
13:20.36*** join/#gllug SlayerCE (n=Mart@82-69-6-203.dsl.in-addr.zen.co.uk)
13:20.47cpufreaklets play hang man
13:21.36boudiccaswhich man shall we hang?
13:21.58cpufreakbilarh
13:22.34boudiccaslets hang ibot
13:23.49cpufreaknah bilarh
13:27.23Leedsibot hangman
13:35.16Leedsmy flatmate is watching a silly chick-flick, but the subtitles are amazingly bad :-)
13:38.34Leeds"Why the sad face?" = "Your face how?"
14:47.32JosefAssadI'm guessing it isn't abhorrently expensive to get a cell phone line in the UK?
14:49.10zOOzdoes anyone know good website/s to find new friends and smth. like that? I mean in London
14:49.22wethrinJosefAssad: Technically, one can never get a cell phone line
14:49.31JosefAssadAlright. Rent.
14:50.04wethrinThat'd involve renting a base station :)
14:50.15wethrinMaybe sir would prefer a wireless connection?
14:50.30wethrinThey can be had from anything between 0 and a few hundred quid a month
14:51.04JosefAssadA wireless connection or a line?
14:51.35antiphaseVirtual Circuit
14:52.38SlayerCEfg
14:52.52wethrinNo such job
14:53.17JosefAssad...
14:54.01antiphasekill %1
14:56.53SlayerCEand I still need more customers, damn them
14:58.41zOOzI'm looking for Linux admin/support role, any offers?
14:59.01cpufreakperm or contract?
14:59.34antiphaseLooking to hire or be employed? If the latter, it's not conventional to ask for offers ;)
14:59.54wethrinantiphase: But it does sometimes work :)
15:01.43JosefAssadoff _and_ out? My my
15:03.56zOOzcpufreak, doesn't make any diff
15:04.29cpufreakif you want perm, and odn't mind moving to holland, we're hiring.
15:05.11zOOzfirst thing I don't know language
15:05.15zOOz;-
15:05.24cpufreakI speak english
15:05.24cpufreakI assume you do too
15:05.31cpufreakthats the common language here.
15:05.41zOOzyes, I do
15:06.53cpufreakthen if you don't mind the idea of working in holland, using ubuntu, and don't mind working crazy hours to make stuff work send me a cv.
15:07.13zOOzdrop me your email address
15:07.41antiphaseI might be in a position to emigrate once my gaff is flogged
15:08.00cpufreakexcellent ant
15:08.04cpufreaksend me a CV too.
15:10.04SlayerCESending "reverse job offer" emails to the GLLUG list has resulted in me getting work
15:10.38JosefAssadWish it were that simple for me :)
15:10.50antiphaseYou must be lacking mad skillz
15:11.26JosefAssadyes and no
15:11.39Leedsit didn't help me - but then I was asking something slightly more complicated than usual
15:11.44JosefAssadwant to see what kind of CV will make it tough to find the right job, antiphase?
15:12.29JosefAssadnever mind... silly idea. Yes, I am probably lacking some mad skills on many levels :)
15:12.33SlayerCEmy CV is ace
15:13.39antiphaseJosefAssad: Do you mean your CV is shit?
15:13.52JosefAssadantiphase: sure
15:14.09antiphaseIn terms of presentation or content?
15:15.26JosefAssadantiphase: I am not an enineer by any stretch. Done supply chain management, marketing, open source consultancy, microfinance, industry-level strategy building... Odd stuff.
15:15.39JosefAssadI look like an amalgamation of about five people :)
15:15.53antiphaseSo you're intent on not reusing your existing skills
15:16.18antiphasei can imagine how that might look unattractive to an employer ;)
15:16.31JosefAssadThat's a long story. :)
16:24.50clive-hlol
16:25.07clive-hi've got two job interviews tomorrow
16:25.17clive-hthat's a tad scary
16:26.03boudiccasbut plenty of time to walk between them and also get something to eat :)
16:26.15clive-hyeah
16:26.21boudiccasoh, and btw, good luck :)
16:26.38boudiccasits only a 20-minute walk
16:26.41clive-hthank you i could do with some luck right now
16:26.49boudiccas40-minutes if you're walking backwards
16:26.55clive-hlol
16:27.49clive-hthen my only worry will be not having anywhere to live
16:28.15boudiccasi've got a spare bedroom, in Maidstone
16:28.21cpufreakhalfords are doing a good deal on tents a tthe minute
16:28.50clive-hheh
16:29.14clive-hif i get a job i may be able to avoid being homeless
16:30.06Leedswe've got a sofa-bed here
16:30.44boudiccasclive-h; there you go, two offers of a bed for the night!
16:30.58clive-hheh thank you both
16:31.17boudiccasclive-h; you're more than welcome :)
16:33.47clive-hhaving someone to talk to would in fact be much better than this miserable place
16:34.39clive-hwhere i live presently
16:38.53z00daxI am just down the road from you - maybe we should meet for a beer sometime ?
16:39.11clive-hBetter make it soon
16:39.39clive-has things go i'm like to be homeless by next thursday
16:39.46clive-hlikely
16:40.06z00daxwhat ?
16:40.19clive-hseriously
16:40.47z00daxwell you said 2 job interviews lines up....
16:40.59clive-hyep two tomorrow
16:41.32clive-hif i get one i should be able to avoid homelessness
16:51.49*** join/#gllug adminjs (n=ba1020@host-84-201-157-189.xdsl.lixxus.net)
16:54.35clive-hbut yeah a beer would be good
17:00.20rhowez00dax: F&B tomorrow
17:00.45rhoweclive-h: I've a sofabed in SE1 going for very reasonable rates :P
17:01.14clive-hlol
17:02.48clive-hi've slept on my sofa many times
17:19.40rhoweAnyone know of any decent tools for cleaning up diry databases?
17:19.50rhoweer, dirty databases
17:21.04SlayerCErhowe: "drop <dbname>"
17:21.11rhoweSlayerCE: heh
17:21.14rhoweSlayerCE: I wish
17:21.15clive-hhow dirty
17:21.28clive-hand what rdbms?
17:21.34rhoweclive-h: Well, mainly just tidying up the values in a single attribute on a table
17:22.06rhoweclive-h: Say there's a 'country' attribute, which accepts freeform text, and we're redoing the schema so it instead references another table
17:22.11rhoweclive-h: SQL Server 2k
17:22.15clive-hcopy the tables , set the unique constraint the attribute?
17:22.22clive-hon the
17:22.48rhoweclive-h: Nah, I want duplicates, but I want them consistent
17:23.06rhoweclive-h: Not a mix of "USA", "U.S.A." and "United States", for example
17:23.18SlayerCErhowe: I would have one big country table and then have the maintable reference it
17:23.39clive-hwhat i'd call multi-values then since my background is Pick/Reality
17:23.43rhoweSlayerCE: That's what we're going for, but I still need a mapping of current values to a canonical value
17:24.05rhoweSlayerCE: There are many many places in this database where such a cleanup needs doing
17:24.18SlayerCEalter table foo add column countryref references countries.id;
17:25.01SlayerCEupdate table set countryref = countries.id where country=countries.name;
17:25.05rhoweSlayerCE: I was thinking of perhaps a GUI tool where you point it at a canonical listing and then you could drag&drop the non-matching values to the relevant canonical one to update them to match the canonical entry
17:25.20rhoweSlayerCE: Yeah, and then rinse and repeat for all the others
17:25.30SlayerCEthen fix the odd dupes with "select * from table where countryref is null;"
17:25.41clive-hi can't remember if tora works with ms sql
17:25.44SlayerCEand some updates
17:25.56clive-hotherwise i'd suggest toad
17:26.13rhoweSlayerCE: set countryref = (select id from countries where name = 'United States') where countryname in ('USA', 'U.S.A.', 'United States of America', ...)
17:26.17rhoweSlayerCE: I'm talking hundreds of dupes
17:26.39rhoweSlayerCE: Across multiple parts of the schema
17:26.49rhoweclive-h: I think it does.. haven't tried though
17:26.52clive-hexport it as a text file, run sed/perl/awk on it, import it again?
17:26.55rhoweclive-h: I think it crashed on me last time I tried
17:27.22rhoweclive-h: It's a bit messy when I'm doing about 40 different attributes full of crap, each with potentially hundreds of variations on what they ought to be
17:27.53clive-hthose atrributes need to be constrained then
17:28.13rhoweclive-h: Yes, and they will be, but it's cleaning up the crufty historical data
17:28.23rhoweclive-h: Future entries aren't a problem, but past ones are
17:29.04clive-hI suppose i'd write a perl script
17:29.15clive-htest it it on a backup db
17:29.59clive-hit sounds like a bit of a project though
17:30.24rhoweThere's probably stuff out there to do it, but finding it would be hard
17:30.32rhoweStill, sounds like fun to do
17:31.54clive-him my salad days, when i was a programmer, i used to specialise in that kind of thing
17:32.04clive-h*in
17:32.57rhoweLet's see what we can knock together
17:33.19clive-hdba's who don't grok 3rd normal form worry me
17:33.34rhoweBCNF baby :)
17:33.49rhowealthough I'm a bit out of touch on the specifics.. I don't do enough DB work really
17:34.26clive-hbackus naur ++
17:34.37SlayerCEi do enough to be very scared on some of the "best practices" in use
17:34.43rhoweBoyce-Codd, no?
17:34.44SlayerCEof some
17:34.52rhoweSlayerCE: heh
17:35.04wethrinBackus Naur ain't database
17:35.10clive-hhmm
17:35.17rhoweSlayerCE: best practices are just out there so that they can sell more "for dummies" books
17:35.41rhoweSlayerCE: They kinda work for the simple stuff, but for anything real you seem to need the odd hack or two
17:36.01clive-hahh yes boyce-codd
17:36.57rhowewethrin: Well you can use it to describe SQL, no? :)
17:37.53clive-hso many sql dialects so little time
17:38.07clive-hms embrace and extend sql
17:38.22rhoweclive-h: GO!
17:39.35clive-hi've got some little ms press booklet here about sql
17:39.55clive-hand i was going d'uh that's not in oracle
17:40.09rhoweSELECT TOP <n> * FROM...
17:41.11clive-hi'm proud to have decommisioned ms sql servers and replaced em with oracle ones
17:41.25wethrinrhowe: Yes, well....
17:41.41clive-hin the process migrating to linux
17:41.55clive-hi really loathe oracle on doze
17:42.36SlayerCEactually, ms defaults to ANSI SQL
17:43.01SlayerCEyou can use their own features if you like, but dumps etc are all done in ansi sql
17:43.29clive-hi suspect most dbas use the extensions
17:43.45rhoweSQL Server's not that bad really.. so long as you stay away from their JDBC driver, which is utter tripe, and use jTDS
17:44.31SlayerCEa better plan would be avoiding java entirely
17:44.45clive-htds shows ms sql's roots in sybase
17:48.59morsingSlayerCE!
17:49.11morsingSlayerCE: Where's goibhniu? :(
17:49.11wethrinmorsing!
17:49.14morsingwethrin!
17:49.22SlayerCEno idea
17:50.35morsingwethrin: I need to contact goibhniu
17:50.42rhoweSlayerCE: Java gets you Hibernate, which is pretty cool
17:50.53wethrinSend him an email
17:53.56clive-hi'd rather use perl DBI
18:00.25clive-hhow big is the db?
18:01.18rhoweclive-h: Small enough that sqlite would do
18:01.21rhoweclive-h: 50M or so
18:01.37clive-hoh right not that big at all
18:01.45rhoweNah, but the data is important
18:02.24rhoweahh, lazy food#
18:02.58clive-hpizza?
18:04.49morsingwethrin: Address?
18:07.10rhowecurried beans
18:07.40clive-hahh i had curry for lunch
18:11.58wethrinmorsing: don't know
18:20.18trousers_Evenin'.
18:20.42trousers_clive-h: I've never been daring enough for curry for lunch... But how I do desire...
18:21.09clive-hi eat kebabs for lunch too
18:27.23morsingwethrin: Oh - what did you have for lunch?
18:28.19wethrinBeef stroganoff
18:34.37clive-hvery ethnic
18:35.33morsingBeer?
18:35.34wethrineffnic food++
18:35.39morsingReally?
18:35.43morsingLike Danish?
18:36.00wethrinNo. British beer > Danish beer
18:36.02clive-hborsht is beetroot soup ish
18:36.08morsingHa ha - lol :P
18:36.24clive-hi prefer belgian beer
18:37.08clive-hthough british ale is good
18:39.06wethrinI don't count mass-produced pish as beer
18:39.31clive-hsome british ale even
18:39.41clive-hlike theakstons
18:39.52clive-hor summer lightning
18:40.54boudiccasthreakstons
18:41.01wethrinA lot of Belgian beer's a bit shite
18:41.02boudiccasshepherd neame
18:41.11boudiccasthats the bees knees
18:41.18wethrinWhich Shepheard Neame?
18:41.19clive-hheh
18:42.08boudiccasmasterbrew
18:42.08wethrinScottish beers++
18:42.08clive-hI used to drink shephard neame
18:42.09boudiccasor spitfire
18:42.09clive-hbishops finger
18:42.14wethrinI've never had a bad beer from Houston brewery
18:42.54clive-hgood kentish brewery
18:43.10clive-hor is that a brewery of kent
18:43.13morsingDAnish beer++
18:43.30clive-hi never really did get the distinction
18:43.31morsingWhere's Richard?
18:46.17wethrinHK
19:00.05andrew__4I have never had bad beer from Houston, but that is trivailly true :-)
19:04.39JosefAssadTuborg christmas brew FTW
19:05.20clive-hshephard neame's xmas ale is nice
19:06.54JosefAssadlong flight tomorrow. Night.
19:07.49morsingibot FTW
19:07.51ibotftw is probably wtf backwards, or for the win
19:08.00morsingHmm...?
19:08.51clive-hfor the win
19:15.36wethrinFor Teh Win!
19:36.55rhowehttp://siksai.co.uk/~rhowe/mimihascatears.jpg
19:41.21morsingBeer
20:02.36morsingWhere does sound juicer extract to?
20:08.35morsingHello?
20:11.00morsingWhat can convert ogg tp mp3?
20:11.00wethrinOutput the ogg to a wav file, and put into an MP3 encoder
20:11.24*** join/#gllug AnneC (n=AnneC@87-194-46-187.bethere.co.uk)
20:11.25zOOzmorsing: http://freshmeat.net/search/?q=ogg+mp3+converter&section=projects&Go.x=0&Go.y=0
20:11.27morsingAnneC!
20:11.56AnneCmorsing!
20:15.52wethrinPubtime!
20:16.21morsingBeer
20:20.22*** join/#gllug [Clive] (n=ch@chills.demon.co.uk)
20:20.53[Clive]Hmmmm
20:36.12morsingChives
20:36.40clive-hChives?
20:37.02z00daxcurry!
20:37.27clive-hMmmm curry now you're talking
20:39.19z00daxwhats the best kebab joint in the neighbourhood ?
20:39.37clive-hwhich bit?
20:40.00adminjsthai-curry
20:40.04z00daxI'd presume the whole kebab, i didnt know there were places that specialised in bits
20:40.16clive-hThere's a nice one in Bexleyheath - cyprus village
20:40.21z00daxoh you mean as in which bit of the 'hood - well, all over really.
20:40.34clive-hKia kebabs are good in Dartford
20:41.12z00daxah right. humm
20:41.49clive-hThere's plenty of kebab shops
20:41.58clive-hCrayford has 3
20:42.08morsingclive-h: You live in Crayford?
20:42.14clive-hDartford has about 6
20:42.28morsing?! Seriously?
20:42.32clive-hYes I live in Crayford
20:42.38morsingHow's Geir?
20:42.42z00daxi think bexley village has a few as well
20:42.54z00daxmorsing: Geir moved to newcastle
20:42.57clive-hBexley village has some
20:43.20morsingNo he didn't!
20:43.36morsingclive-h: Ever see a small man with a large hat walking a dog?
20:43.42clive-hi used to walk to the one near the Old Mill
20:44.01clive-hNot that I recall morsing
20:44.04z00daxclive-h: thats a fair walk from here :) but the old mill is nice too - I've been there a few times
20:44.18z00daxmorsing: sure he did, the dog didnt like the local weather too much
20:44.43clive-hI used to drink at the george
20:45.21z00daxso how long have you been living in this area then ?
20:45.42clive-hErrr I'm 51 I've lived here all my life
20:46.27z00daxrighto, thats 47 years longer than I have, lived in this area
20:46.34clive-hI went to school in Bexley
21:11.38*** part/#gllug adminjs (n=ba1020@host-84-201-157-189.xdsl.lixxus.net)
22:30.21*** join/#gllug resudaed (n=tom@82-47-216-50.cable.ubr06.shef.blueyonder.co.uk)
22:33.44*** join/#gllug catalyst (n=catalyst@allegro/user/angelchild)

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.