| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> Well..
<0> Will there always be two attributes?
<1> no, there is a maximum number
<1> but the minimum is 0 attributes
<0> If there were only two, you could join twice.
<0> Well, if there was a specific number of attributes, you can join to that table that many times. But cannot be variable...
<1> it's for splitting bills between people... the first table stores the items, and the attributes are the cost of the item that each person owes
<0> Well, I guess it could if you had a reasonable maximum...
<1> right
<0> oh
<1> reasonable maximum is 5
<0> You *COULD*, but in all honesty, it's easier to process one per row :)
<1> ok :)
<1> thankyou for your help
<0> I didn't really help. Just made your life worse.
<1> I know i can do it... but i hate doing something only to have someone say later.. duh why didn't you just do it like this
<0> heh
<0> Well, hey, maybe I don't know of a better way either...
<0> But when you're dealing with a 1 to many relationship table, with an unspecified number of attributes per parent, how could an app possibly handle it?
<0> Maybe in an OOP model?
<1> yeah, i really should be mapping all this over to objects
<1> actually i might do that now to make my life easier
<0> :)
<2> _don't_ make a object, key, value table
<0> Make the output/result in some sort of object?
<2> make explicit tables that work with your objects
<2> do. not. make a object id, key, vlaue table
<1> EricB: yeah thats pretty much what i'm doing
<3> oop is not fun
<3> basicaly you have to become stupid to learn oop
<3> e.g. rails
<1> hmmm, the hardest bit i find is thinking of the names for cl***es
<1> rails any good?
<3> i just started
<3> it's annoying
<3> lot of new conventions to learn
<3> it feels strange because i can't just jump into things
<3> there's a proper way to do every little thing
<1> i've heard from a lot of people it's the **** they say it is... but i hold out my decision until i've tried it for myself
<3> i'm used to jumping straight into the html and generating my own html code on the fly using perl
<3> everything is right there in the code ..but with this i have to worry about my model, controller, view, etc etc
<1> hmmm i usually use mvc for all of programs anyway
<1> mcv*
<3> that's a software design strategy that is annoying for me
<1> it's pretty applicable for web applications though
<3> i'm gonna have to install radrails
<3> this is pretty retarded otherwise
<3> too many files to keep open
<3> or i can tab the gvim's
<2> tab konsole
<3> fluxbox ...
<2> that too
<3> i don't use many kde' apps only konqueror, k3b, amarok sometimes
<2> I actually used konsole under fluxbox for a while
<4> somoeone familiar with configuring mysql odbc for os x ?
<2> why are you using odbc from os x?
<4> EricB`: just got a program called DataArchitect and it needs odbc i have mysql on tiger
<2> I'm sorry :(
<5> vr_mex: How do you like DataArchitect? Are there other similar programs for Mac OS X?
<4> peqe: i really dont know i am just setting it up but cant get odbc mysql to work
<5> From a review: "Data architect has a more complete package of things with it's domains, data types, and entities, but sadly kept crashing on me"
<4> peqe: on what platform?
<4> in linux works great
<5> Other comments: the interface is kludgy ... slow ... very un-aqua ... it crashes ... save after practically every change ... In the middle of a save it crashed on me, completely zero-ing out the file and losing every bit of my work
<4> and i am installing on tiger...
<5> (from the reviews, not me, see here: http://www.macupdate.com/info.php/id/11113 )
<4> peqe: what version?
<5> It's Java, I'd steer clear
<5> Read at that URL for details
<4> those reviews have nothing to do with the just released v3.5 they are too old...
<5> I used Database Design Studio on Windows, but I wish there were a similar Mac program
<4> yes
<5> Well, I haven't tried it, but the killer for me is "un aqua like" -- that sort of problem tends to not be fixed in later versions, since it shows Mac cluelessness on the part of the developers
<4> I need somone to help me set up correctly mysql odbc in tiger
<6> how do i enable user to use store procedures?
<7> grant execute perhaps ?
<4> I need somone to help me set up correctly mysql odbc in tiger
<0> I want a tiger.
<0> damn_I_am_good...
<8> will, you need to work harder on changing that. You're supposed to be evil:)
<0> I am? That ****s. That's longer to type...
<8> be "bad" instead, then :)
<0> Right now, I just type "d a m n <tab>"
<9> :))
<8> who do you curse to the depts of hell most often?
<0> Is that a trick question?
<0> Well, besides Larry Ellison?
<8> Yes. I want it to be you making his bell ring, not me:)
<0> heh
<8> hear about the wikipedia fun a day or two back?
<0> Nope. What happened?
<0> Was it your fault?
<8> 800 amp circuit breaker tripped. took out much of colo and all our boxes
<0> ahhhh Yes I remember that.
<0> 800amp...
<8> was supposed to be impossible:)
<0> Down for like three hours or so?
<8> anyway, good news is that the work with our system builder paid off and all but one server recovered the feew hundred gb fine, guessing that one had drive write cach on.
<8> 6 total
<8> anyway, few minues ago we just did a server split
<0> "server split"?
<8> english language is now split from the rest for master-slave setup
<0> ah
<8> so now have three independent sets of master-slaves for main production: en, asia, rest
<0> All hosted at the same colo? :)
<8> no, asia split is inyahoos seoul data center
<8> have been software issues inhibiting more ful split, memcached still a pain
<10> has anyone here configured mysql-ruby? I am experiencing something strange...
<8> really want to be moving to be able to be up with florida completely down, is slow going though
<11> Jamesday: where is en hosted?
<8> infi, Florida, want the colo name?
<11> because sometimes it is god-awful slow from Japan
<11> nah, just wondering.
<8> think japan is korea
<11> is asia only CJK languages, then?
<8> varies
<11> but no English?
<8> have something around 150 total languages I think, use UTF16 internally for many
<8> dont' know
<0> wow
<8> anyway, have't counted qps recently, is well over a billion a day now,t hough:)
<0> heh
<8> is amusing, UC last year google guy said you had to be efficient or else suffer that fate:)
<8> so we do it while being efficient :)
<0> Google guy?
<8> also do read splitting - different boxes get reads for different projects, to get better effective cache size
<12> um, task splitting would be most fun
<8> some google speaker at one of the keynotes, forget who.
<0> Do you use NDB?
<0> you/wikipedia
<8> domas, there's the future to think about:)
<12> will: consider at some places
<13> is there a good reference on .my.cnf files? The 4.3.2 section on "Using option files" doesn't seem to be a very good reference
<8> domas is the guy who did the work today - I just sat and watched and congratulated him:)
<0> hehe
<13> like.. "what can you do with it"?
<13> "what syntax is valid"?
<0> XaXXon, You set variables with it...
<0> !man server variables
<14> (System Variables) : http://dev.mysql.com/doc/mysql/en/System_Variables.html
<8> XaXXon look at the my-huge.cnf example fle and others
<10> !lmysqlclient
<13> Jamesday: where is this file?
<8> included in standard mysql supplied installations. search for my-huhge.*
<13> ok
<8> search for my-huge.*
<13> -h?
<13> ok
Return to
#mysql
or
Go to some related
logs:
site:www.quotesdb.info doctormo
#web
scroll lock memtest86 badram
nm-applet kde
#mysql
nagios statusmap_background
#perl
Cannot access /root/CVSROOT ssh
#gentoo
gentoo power-manager messagebus
|
|