« first day (126 days earlier)      last day (4895 days later) » 

11:00 PM
@NickT What's the point of flashy design if I can't read what's on the screen?
 
@George So there's zero middle ground?
 
@NickT Well, what would you suggest then? Marque? ;)
 
Hey everyone. Can't stay long, just wanted to give my friends at the bar first dibbs on my really easy SQL question
0
Q: Does a MySQL Primary Key on two columns help with queries on the second column?

JoshI have two classes, Foo and Bar. Each Bar will contain many Foos. Foos can be in multiple Bars but each Foo can only be in a given Bar once. I have the following table structure: CREATE TABLE `bar_foos` ( `bar_id` INT UNSIGNED NOT NULL, `foo_id` INT UNSIGNED NOT NULL, PRIMARY KEY ( `bar...

 
Something with some levity, but that's just me
 
I'm not a newbie, but I sure feel like it right now!
 
11:08 PM
@TheUnhandledException Use jQuery ORM. $.db()
(I see the joke is going old and stale, but that may be the point.)
 
@radp bah. Of course, what was I thinking using a database! I'll totally drop that and use jQuery instead.
 
lmao
 
How are you doing @radp and @drachenstern?
 
@TheUnhandledException Unproductive as usual
 
@TheUnhandledException Seriously tho Josh, I think that's an implementation specific detail no?
 
11:10 PM
@drachenstern What is?
 
@TheUnhandledException good here, I move into my new apartment this weekend (well I start anyways, fortunate part about currently living in family owned housing)
 
wow, since when is text on SO this large?
 
@TheUnhandledException if that will help the indexer ... I mean, it will vary by SQL, MySQL, ORA, etc, no?
I don't think it's called out in any SQL spec, naturally
 
@drachenstern MySQL
Hence the title "Does a MySQL Primary Key on two columns help with queries on the second column?"
and the [mysql] tag ;-)
 
11:12 PM
@TheUnhandledException ja ja :p I meant it will vary tis all
 
I was gonna followup with "cos I wanna know how each vendor does it" but that was like too much typing and my brain is juggling two other projects ;) :p
 
1
A: Does a MySQL Primary Key on two columns help with queries on the second column?

Dan Grossmanhttp://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html "If the table has a multiple-column index, any leftmost prefix of the index can be used by the optimizer to find rows. For example, if you have a three-column index on (col1, col2, col3), you have indexed search capabilities on (col1), (c...

@Dan is that true even if the key is a PRIMARY KEY ?
 
Why wouldn't it be?
 
@the yes, even for primary
 
11:13 PM
A PRIMARY KEY is implemented as a UNIQUE index.
 
OK. Just checking. So now my question is the same as @drachenstern 's comment, do I need a second index?
 
@TheUnhandledException so when do you have time slotted to look for a new place / move?
 
For that particular query, yes
 
@drachenstern sigh I am looking, but I can't get the time to move until mid Jan at the earliest...
 
@TheUnhandledException oh that sux
@TheUnhandledException have you seen padmapper.com? Don't know if it'll help you but it did me
 
11:15 PM
@Dan and @George, let me rephrase my question. Given that the only time I'll need to know what Bar s use a given Foo is when I'm checking to see if the Foo is in use prior to deleting, would you recommend a second index? I expect this table will have hundreds (not thousands) of mappings.
I.E. it's a balance of extra time for the query (which will be run very rarely) vs extra disk space (which will be rarely needed)
@drachenstern I have not! I will check that out, thanks!
 
A table with hundreds of rows is tiny, it'll probably fit in memory on its own
 
it's a handful of ints, it should be fairly fast. Also, need we remind you the general rule of thumb? profile profile profile
 
@TheUnhandledException I'd say probably not. There is also the consideration of the index needing to be updated.
 
@GeorgeMarian exactly re the index being updated
 
@TheUnhandledException yep, I owe that particular link to a random twittering I got on my feed, and ever since I've been singing praises of at least one site that helps narrow things down easily and on a map
 
11:18 PM
Ok, thanks @Dan and @George! Now I have to decide which of your answers to accept ;-)
 
@DanGrossman was first but @GeorgeMarian has less rep
 
less is more!
 
shrug no biggie
 
:D
That's what I told my students about remembering to use less instead of more on Linux. :)
 
11:20 PM
How about I flip a coin and decide whose answer to accept that way? ;-)
You were first @Dan, want to call it?
 
Dan's answer is slightly better, since he beat me to the punch on the link.
:P
 
tails :>
 
Tails it was
but I have to wait 29 seconds =p
 
I think I've read the entire MySQL reference manual
 
heh I've had to read a fair bit of it myself. That was totally from memory and I haven't touched MySQL in a quite a while.
Needless to say, I've read that part of the manual several times.
 
11:23 PM
I've read a lot of it, I just was unsure of this particular question. And EXPLAIN in this case confused me more
 
@TheUnhandledException BTW, only the first @reply in a comment notifies. (unless, that has been changed.)
 
I should read up on b-trees again so I understand why it's only efficient to traverse by the leftmost keys
 
@GeorgeMarian I thought it was changed, but maybe I imagined that ;-)
 
@GeorgeMarian I think it has actually... I can't put my finger on where I think that from tho
@TimStone where r u mr. faster-than-google?
status-faster-than-google
 
Easy fix, I'll reverse them
 
11:24 PM
Heh, that's the reason I qualified the statement.
 
31
A: How do comment @replies work?

Implemented in January 2010, you can use @name syntax anywhere in your comment to reply to a specific user. This will notify that user in their recent replies. There are a few rules to follow for it to work: Notifications apply to the author, commenters, and editors of the question or answer ...

Oddly enough I had linked to that earlier today in a comment on meta, so it was just a click away.
 
LOL. hey there @Tim
 
'Ello
 
How do you link in comments when the URL has parenthesis in it?
 
@NickT TinyURL?
 
11:26 PM
ick
 
Encode the parenthesis.
 
Yeah, that's the right answrer
 
Yay my commit hung.
 
18
A: Links to URLs containing parentheses

Sam HaslerThere are many ways to format urls in Markdown. Parentheses work better with some methods than others. 1. Bare - http://example.com/test(1).html 2. Bare, encoded - http://example.com/test%281%29.html 3. Delimited - <http://example.com/test(1).html> 4. Hyperlink ...

 
O_o.
 
11:27 PM
OK. I gotta rush to finish this deadline. Thanks for the help @GeorgeMarian and @DanGrossman!
 
Good luck @TheUnhandledException
 
@TheUnhandledException Anytime.
 
@TimStone Why don't you have more rep on meta??? You're like the meta search engine!
:-)
 
@TheUnhandledException I just seek out answers others have already given ;)
 
Meta site is scary
 
11:27 PM
Plus I get too lazy to draw FHC
 
There should be a badge for that
 
Is there a meta meta SO?
 
@Tim you want to answer that one too? ;-)
 
And please, Grace Note's ability to pull up references puts mine to total shame. ;)
 
At the risk of sounding like a noob: FHC?
 
11:28 PM
13
Q: What about meta-meta stackoverflow.

Nick BerardiMeta.stackoverflow is great, it gives you a chance to talk about stackoverflow in a disconnected forum so that you don't have to break the flight club rules of talking about stackoverflow on stackoverflow. http://blog.stackoverflow.com/2009/06/cmon-get-meta/ But what about the cases when you w...

 
@TimStone Is there some online tool to encode everything then?
 
Ok. I'm headed out of this place before I get sucked back in. Later @DanGrossman @drachenstern @GeorgeMarian and @TimStone!
 
@GeorgeMarian meta.stackoverflow.com/questions/19478/the-many-memes-of-meta/
FreeHandCircle
 
URL encoding tools won't change parentheses, because they're allowed in URLs
 
@TheUnhandledException later
 
11:30 PM
See ya!
 
@drachenstern OIC!
 
11:32 PM
@DanGrossman didn't do that when I tested it, but I had something that looked like a url
ok, now it's just being silly ... I swear it did it a minute ago
ffs
 
Asterisks fail too? [test](http://www.google.com/search?hl=&q=2*2) test
 
@DanGrossman oh we believe you
 
@DanGrossman It works differently in comments versus posts I believe
 
I was just saying the URLs with parentheses are valid as is, encoding won't change them, so it's really the markdown parser's fault for not linking them correctly :/
Thus, only alphanumerics, the special characters "$-_.+!*'(),", and
reserved characters used for their reserved purposes may be used
unencoded within a URL.
 
@DanGrossman Yep. The regular expression that handles identifying these links is, unsurprisingly, not good at this particular case.
 
@TimStone Oh, meta-search-engine: Do you know if there's a post about about moderator votes binding, even if you undo your vote? They seem to get stuck as such. That is, twice I've voted then undid the vote, only to be stuck with a non-vote because the system told me that I can't change my vote.
 
We should throw a botnet at that site until its counter reads 3141592
 
There's also a number of inconsistencies between the client side and server side rendering too, which is a bit annoying..
@GeorgeMarian As in vote-vote or close/delete-vote (I assume the latter)?
 
http://3.141592653589793238462643383279502884197169399375105820974944592.com/index3.html
> If you really REALLY want to see the million digits, you're going to have a GUESS at what the .html file is called. No, it's not index4.html, but go ahead and take a stab at what it might be. It shouldn't be too tough to figure out. :)"
 
11:37 PM
Hello all
@drachenstern - Yea, who is the guy in the picture?
 
Dr. Evil is a fictional character, played by Mike Myers in the Austin Powers film series. He is the antagonist of the movies, and Austin Powers' nemesis with aspirations of world domination. He is a parody of any number of villains, primarily Donald Pleasence's Ernst Stavro Blofeld of SPECTRE. Dr. Evil routinely hatches schemes to terrorize and take over the world, and is typically accompanied by his cat Mr. Bigglesworth and his side-kick Mini-Me, a dwarf clone of himself. On May 10, 2007, Mike Myers announced that he is developing a 4th film in the Austin Powers universe, which will fo...
 
SHARKS WITH FRIGGN LAZERS
 
@TimStone As in vote-vote. They're all binding, which is fine. But getting left out due to reconsideration kinda sucks.
If i vote on a question (up or down), but then change my mind and undo that in some (probably short) period of time, I get stuck without being able to vote later.
 
@NickT you did figure it out right? it's 314
 
@GeorgeMarian Are they still getting credit for the original vote?
 
11:39 PM
@drachenstern - no it is not.
And, it's not in the whois db, btw
 
@TimStone AFAIK, no. The vote gets undone.
 
@Moshe on that URL s/3/314/g
he asked people to not link it ;)
 
@drachenstern 314 and 314.html fails
 
fail
@drachenstern ?
link it! link it! link it!
 
@TimStone So, there is some window during which the vote can be changed. After that, whatever it is sticks, even if that is a non-vote.
 
3.14.15.92 doesn't reply :(
 
^ there
 
3
Q: Can I vote again after undoing a vote?

user138940I voted on a response to my post that seemed very helpful, and quickly rescinded it because I hadn't tested it. After testing the answer and finding that it works, I marked it as the correct answer and went to upvote it again, but got a message that it was too late to change my vote, which was lo...

Like that maybe?
Of course, you can always find a reason to edit their post, which resets the whole deal...
 
@DanGrossman - thanks.
 
@TimStone Ah, yes. Hmm...that kinda sucks, but understandable.
 
11:42 PM
@DanGrossman that was a bit too much hoop jumping :P
 
Yay, stupid python snippet
>>> print 'http://'+''.join(["%%%x" % ord(c) for c in "www.google.com"])
http://%77%77%77%2e%67%6f%6f%67%6c%65%2e%63%6f%6d
 
@GeorgeMarian Yeah, I'm kind of divided on that one myself.
 
@NickT no formatting on multiline posts, except for the "fixed font" button (four spaces indentation per line).
 
:(
 
That said, the snippet works.
 
11:45 PM
Is that URL supposed to work or are browsers just being nice to us?
 
It works
 
I'm going to open a raw socket to port 80 and find out.
 
at least the markdown parser doesn't hork it up, in comments or elsewhere
 
It sucks to have 137 upvotes for a tag with 90 questions.
 
@TimStone yeah, I didn't like the fact that some people were gaming the system by temporarily down-voting competing answers. However, it kinda sucks that I'm not allowed to legitimately change my mind. Ah well, just means I'll have to give it more consideration before voting.
 
11:47 PM
You totally earned your badge, but because of some jerk on Stack Overflow you can't get it yet.
 
@radp Heh :P
 
When will badges be mailed out? I need to sew them onto my vest...
 
Make that 138. :/
 
Where's everyone at today?
 
@radp Just make @RebeccaChernoff start playing Minecraft and demand she ask questions.
 
11:51 PM
o:
 
It says I'm in your house
 
Mind gettin' me a can of soda from the fridge?
 
I drank it all
 
@DanGrossman Firenze?
 
11:53 PM
You're in Italy?
 
Aye.
 
I suppose that's where it thinks you are
Firenze = Florence
 
Oh, so you're not actually in Italy.
 
@radp do you not know what that is?
 
No, it says "Bridgeport, PA, US" for me :)
 
11:54 PM
Oh... right.
 
it's an auto-image-generating script that takes your requesting IP and matches you to a geo-ip locating service
 
Pesky you :P
Anyway, it's really off. I'm nowhere near Florence.
 
except that @TimStone's just says somewhere between NC and Canada
 
Hahah ;)
 
11:56 PM
@RebeccaChernoff lol, I was curious to ask him what his said but didn't think he would fall for it ;)
 
@drachenstern She tried that yesterday, but it backfired. :P
 
brrrr.
 
there's no way it's in the sixties outside my window
hell I wouldn't believe the 50s
 
11:57 PM
If I really wanted to know I could cheat, but knowing where @TimStone lives isn't truly a priority of mine.
 
@DanGrossman MMM...yellow.
 
It's below zero outside?
 
@TimStone Which one?
 
it's below zero outside here
 
Yep, -2 right now.
 
11:58 PM
@radp C
 
The drama continues:
> On Tuesday, Oracle blasted out a press release announcing the Java Community Process vote in favor of Oracle's Java 7 and 8 plan, saying its Java roadmap has been endorsed by "all major Java players."
( [source](http://www.theregister.co.uk/2010/12/08/oracle_downgrades_google_apache/) )
 
+7°C here, a nice change from that annoying snow-rain stuff.
 
grrr
Ok, I give up. Markdown just doesn't like me quoting stuff in chat.
 
@GeorgeMarian Newline = no formatting
 

« first day (126 days earlier)      last day (4895 days later) »