| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> Jax, Requirements change. <1> but I set the requirement! :D <2> Jax: hehe, you need to get out until the real world. It's... messy :) <0> And it can change! <3> not always <1> i guess i have to go work i na big company one time ;) <0> Jax, Na, doesn't have to be big company. <4> Jax: column name? never, really. but you may want to split a table into several. then make a view that simulates the original layout, for compatibility. <1> i'm just too perfectionist to let other code ;) <4> that's just one thing it may be useful for <4> Jax: write your won DB then. <1> yeah but that sounds like an ugly hack if you ask me <4> no, actually, it's not a hack <0> It is a hack <4> it's called "abstraction".
<1> you should adapt your app to the new DB schema <0> Well :) <3> compare your code doing the JOIN, and then you just calling a view <2> Jax: it keeps the app working and allows for structural changes <1> not make some view to compensate for people that weren't able to design right in the first place <2> Jax: at what cost? <0> Jax, When it was designed in the first place, it could have had a different set of requirements. <4> Jax: a db schema can be considered to be an interface to access the data. so, a view is to keep the interface while chaning the implementation. <2> Jax: say you're just moving a couple pieces of data around for performance purposes.. What a waste of programmers if you hadn't already abstracted the data and had to make m***ive changes to your app <0> We need to teach the bot a game. <0> We could teach it to play Uno. <0> Oh, so yesterday I shocked myself with 120V... <1> we could teach it to actually OBEY me <5> I wouldn't worry about that <6> only 120 you yanks have a wimp power voltage <0> It made my forearm tingle... It was pretty fun. <5> back in my foolish youth, I toasted myself with a neon-sign transformer a couple of time <1> hm <5> 9-12Kv (it was on an adjustable autotransformer) <1> i was messing with some Batteries for my guns the other day <0> archivist, It's not the voltage... it's what you do with it. <0> Batteries... guns... lol <5> fortunately, it was only 20milliamps <1> Metalhydride ones.. and somehow shorted by accident.. nice orange clame to burn my fingers <1> :D <0> lol <0> 20milliamps? <1> s/clame/flame <0> What kind of batteries do you guys have over there? <1> well you know the 12V 2400mA ones <5> and I was immediately disconnected by the resulting contraction of all muscles in my body at once which propelled me about 5 feet back and 4 feet up into a blackboard behind me (in a physics cl***room) <1> 8 cells <0> Isn't 2.400ma like 2.4A? <6> yes <0> Sneaky_Bastard, From 20mA? <5> Jax: Gel Cells ? <5> will: from 20mA at 12Kv <0> 20MA! <0> heh <1> Nickel-Metalhydride <1> don't have memory ;) <0> I still don't get what volts and amps are... <5> neither do Gel Cells <5> ;-) <5> (Lead-Acid with gel electrolyte) <1> a volt is a joule/coloumb <1> an ampere is Coulomb / s <5> Jax: far too technical <1> (1 coulomb / s) <1> *shrug* <0> hehe <7> What's a coulomb? <5> will: voltage is difference potential and it's always between two poitns <1> well... <0> This is why I like SQL... much easier to understand :) <5> voltage is what makes the potential for a current flow, if you like <6> 1 volt pushes 1 amp through 1 ohm <1> a coulomb is the charge of 6.241*10^18 electrons
<5> amperage is the magnitude of the current <0> I do like that number... 624 <1> DONT remind me of computer arhcitecture crapness exam :D <7> wikipedia is back finally <8> what happened to it bobfield ? <0> Who uses wikipedia anyways? <9> me <6> power outage <7> I use it a lot <9> wikipedia is a great place to get started with research <7> ah is that what is was <5> voltage corresponds to *pressure* in liquids and amperage corresponds to *flow volume* <0> ah <10> I'm having a weird problem .. the same query on the same data on two separate machines is returning different results .. http://pastebin.com/652506 .. Machine One appears to be incorrect, but maybe I'm just going crazy .. <0> Sneaky_Bastard, I get that part :) <1> Woosta versions? <4> funny... <4> what ahppened to wikipedia actually *was* a power problem :) <0> They got their volts and amps mixed up. <7> voltage or lack thereof <0> Reminds me, I need a UPS <6> 800 amp breaker failure <10> Machine One: 4.1.15-Debian_1-log, Machine Two: 4.0.17-standard-log <4> doesn't do you much good if the breaker between the UPS and the rack blows :/ <1> haha <7> I have about 1-2 hours of battery time on my critical computers <10> Surely differing versions wont mean the later version does the wrong thing? <4> as i said... <0> I have about 3-4 on my servers at work. but no monitors connected. <6> Woosta if a bug has been fixed between versions <10> archivist .. then I'd expect the RIGHT behavior on the newer one .. <10> It's a simple query .. so surely they couldn't have broken the newer one THAT much? <6> also there are some other changes in syntax <10> Someone would have noticed .. <1> gah <10> changes between my two queries?? <1> need to download Gang of Four from uni, but de-installed VPN client >;/ <6> check with mysql docs for changes 4.0-4.1 <10> Have you looked at the query or are you just sending me off there .. ? <6> no I havnt looked at the qry <4> n8 <1> Woosta might be the as count <1> try AS `count` *shrug* <1> might think count is a function name count() <10> ahh .. interesting .. <10> nup <10> changed it to xcount and same result <10> jax: Can I confirm that the results look wrong to you too? <1> *shrug* <1> lots of things are wrong with lots of thing lately <10> LOL <11> is this the right channel to ask about configuration issues? <11> i'm attempting to get remote connections working, on my 1and1 root server, but i'm having some trouble <0> They don't allow remote connections. <11> that's lovely <11> this is a root server though <11> not a shared hosting package <0> Oh <0> Sorry. Should have asked. <11> np <0> What error message are you getting? <11> appreciate the snappy response <11> http://www.bradlanders.com/dev/olp.php <0> I want to cancel my account with them. <11> i don't blame you haha <0> Are you calling me snappy? <11> snappy in a good way, as in quick :) <11> sorry, i'm from the south <0> I am from the s'th and I want some s'p <11> :) <0> If anyone gets that quote... ++ <0> Anyways... <0> !m bradland lost connection <12> bradland: Nothing found
Return to
#mysql or Go to some related
logs:
apt-setup: command not found etch amarok dapper-fix TLS negotiation failure openldap mysql dump java application jrdud ddapper #css #perl #perl growisofs etch error
|
|