« first day (420 days earlier)      last day (3612 days later) » 

12:04 AM
later @Marc-Andre!
@SimonAndréForsberg you need 23 more answers in for your 4th gold badge!
(as of last recalc)
can't wait for recalc :)
 
@Mat'sMug yup, I know!
 
@ckuhn203 next time I see that apostrophe in the possessive declension "its" I'm throwing it off a cliff
 
byte[] bytes = new byte[count];
String result = new String(bytes);
silly me -.-
Tests run: 8, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 1.766 sec <<< FAILURE!
That will do for now
TTGTB
 
12:26 AM
good night!
 
12:53 AM
You try to teach my phone the difference between its and it's @DaggNabbit
 
We need a new coding challenge
 
@AlexL funny, I have a meta post in writing!
 
@Mat'sMug Well now that's some good timing!!
 
@SimonAndréForsberg Hmmm...I'd forgotten that Java was so retarded required different code to sort different collection types.
2
 
0
Q: Let the CR Games begin!

Mat's MugJune is about to end. Summer's here (well, if you're in the northern hemisphere, that is.. otherwise, ... yay, winter!), and with it, vacations. We need a new community-challenge. Let's play. I mean, let's find a game to play. The game... Has to revolve around reviewing code, or posting code ...

 
1:03 AM
Nice nice!
 
1
Q: Let the CR Games begin!

Mat's MugJune is about to end. Summer's here (well, if you're in the northern hemisphere, that is.. otherwise, ... yay, winter!), and with it, vacations. We need a new community-challenge. Let's play. I mean, let's find a game to play. The game... Has to revolve around reviewing code, or posting code ...

 
@rofl is a genius. ^
2
 
Would that be... all the JAVA questions on SO? — Jamal ♦ 10 secs ago
 
> If a challenge on Code Golf is interesting, and you think you could do it properly, then do it, and post it for review.
@rolfl doesn't it sound like a foot in a door that leads to the golf club?
That's mighty awesome... but isn't golfing off-topic on CR? — Mat's Mug 44 secs ago
could very well be the tag what will take CR to the next level! Should we re-think our "Did I write this code?" rule?
or perhaps ?
 
1:28 AM
A slightly late, but deeper review:
0
A: Can I make this simulation written in C more "C++-y"?

Jerry Coffin@Nobody has already commented on a number of issues at the level of individual lines of code. While these changes would help the code make a little better use of C++, most of them apply about equally to C. To make noticeably better use of C++, you probably want to look at the basic structure of ...

 
nevermind the "did I write that code" question, I overlooked an important part. The code is under CC, so if you grab it and maintain it, ..it becomes "code that you own or maintain"...
@JerryCoffin nice little answer there! :)
 
@Mat'sMug Short and pithy, isn't it?
 
tempted to flag as "should be a comment"!
 
@Mat'sMug Yeah, but they require a minimum of 15 characters for a comment, so I'd have to add "thank you for your time" or something to pad it out a little... :-)
 
hehe
 
1:39 AM
@ckuhn203 lol that explains it
never seen it happen that consistently ;)
 
Is this a kind of regular team building excersise? — Lucas Kauffman 10 hours ago
 
@JerryCoffin: I think I'm almost done cleaning up the vector questions. Not much else to retag, other than some questions that needed larger changes (such as the latest one about std::stack).
 
@Jamal I'd call it the end of an era, but it's inevitable that if I did, the very next post would be from Captain Obvious, with mis-applied. :-|
 
We may see more someday, just as we may see another question tagged as ...
I've also given this not-so-special answer to another question. I'm surprised they weren't already pointed out.
 
@Jamal looks like something has changed in the site's type of content since 2011! nice answer, +1
 
1:49 AM
I've seen some good reviews in '11 (as well as "1)" instead "1." for listing...). I thought I've already found the last C++ question that needed another answer.
 
zombie-hunting are you? ;)
 
I was, at an earlier time. Now I'm just looking at the vector questions. But Jerry could answer more zombies, if he wants to reach 10K sooner. ;-)
 
@Jamal I think you forgot the "hint, hint, nudge, nudge" there. :-)
 
lol
 
Hello, world.
I think I actually forgot to log out from my work PC... oh well.
 
2:04 AM
hey @Phrancis
seen this?
3
Q: Let the CR Games begin!

Mat's MugJune is about to end. Summer's here (well, if you're in the northern hemisphere, that is.. otherwise, ... yay, winter!), and with it, vacations. We need a new community-challenge. Let's play. I mean, let's find a game to play. The game... Has to revolve around reviewing code, or posting code ...

thoughts?
 
I had not
I like the idea of using SEDE, although I think it is mostly limited to SQL...
"Shouldn't require any specific programming language to be used."
 
Is it worth closing? Or should someone write an answer?
 
@AlexL looks reviewable. Revival/Necromancer anyone?
 
@Mat'sMug - that idea 'came to me'.... I think, if applied well, it could be useful.
 
Holy whitespace Batman!
 
2:16 AM
I feel like starting a 50pts bounty on it, with a description that says "look, a zombie!"
 
Someone could also retag that (replace with ).
 
Would be appropriate?
 
> Look, a zombie! This question is totally reviewable and is still unanswered after an eternity and a half. The time has come. 50 uncapped points to the best review.
@SimonAndréForsberg I just broke another 50 mugs!
 
Someone answer it before it eats someone's brain!
 
and who knows...
OP was last seen Nov 18 '12 at 19:46
 
2:25 AM
Looks like Enlightened is out of the question.
...except he was last seen yesterday on SO.
 
^^ that. you never know!
 
Now I wonder what will happen first: graduation, or the accept for this answer.
2
 
I wonder if graduation is still possible in 2014
 
Who knows...
 
I'm not a PHP guy but this strtotime annoys me
I do think that would be so easy in SQL, but that's neither here nor there
I may just sip my beer and watch someone collect the bounty
 
2:33 AM
@Phrancis I meant using SEDE for crunching numbers, like to rank users accordingly with the challenge's criterion.. "leaderboards" type of thing.
with @rolfl's idea we could calculate users' tag score for and see who's leading, what's their average score, how many answers they posted, etc.
 
I'm curious how SE factors in rep... I fail to see any table with action types (e.g. upvote, accept answer, etc.) with rep amounts, which would tie in to [codereview.stackexchange].dbo.Users.Reputation
 
select se.ApprovalDate as tstamp, 'edit' as action, 2 as rep
select v.CreationDate as tstamp,
                   'invote' as action,
                  case when v.VoteTypeId = 1 then 15
                       when v.VoteTypeId = 2 then p.PostTypeId * 5 -- cheeky 5 or 10 for question/answer
                       when v.VoteTypeId = 3 then -2
                       when v.VoteTypeId = 9 then IsNull(v.BountyAmount, 0)
                       else 0
                  end as rep
            from Posts p, Votes v
            where v.PostId = p.Id
 
Ah. Seems convoluted, I would've designed it differently, but that's good to know
 
SE probably has a better / more complete schema than the SEDE one ;)
 
I hope so :)
Thanks to fellow CR programmers I've come to stay away from CASE..WHEN..THEN statements if I can help it... I would just plug these numbers into VoteTypes imo
 
2:47 AM
@rolfl oh, how about ?
you could always insert them into a temp table at the beginning of your script
 
But what if someone DROP PROCEDURE on that CASE..WHEN..THEN script?
 
You're talking about SEDE right?
 
Well, yeah I guess
Maybe I'm overthinking it though
 
0
Q: Dynamic Programmming SPOJ Problem Wrong Answer

The BearI am doing a SPOJ problem called MBALL - http://www.spoj.com/problems/MBALL/ - it is similar to the coin change problem where you are asked for the number of ways you can make a certain amount of cents. In the case of the problem it is the number of ways you can make a certain score playing Mouse...

 
@Phrancis hmm this much: <-->
 
2:51 AM
No idea what that means...
 
@CaptainObvious A bear? sets exploding bear traps
 
lol
@Jamal it's actually off-topic...
 
Yeah
 
Uh-oh. I smell a On-hold coming on to this one, or a migrate to SO...
 
thing is, member for 4 months, not his first question. my "Welcome to Code Review!" RTFM auto-comment would be awkward.
 
2:56 AM
Just take out the "Welcome" part and you should be good
 
It seems like you have misunderstood what this site is about.
hmm.. no.
I mean, yeah, but not like that.
got it
On Code Review we help with improving the cleanliness of your working code. We are unfortunately not the site to ask for help in fixing or changing what your code does. Once the code does what you want, we would love to help you do the same thing in a cleaner way! — Mat's Mug 8 secs ago
 
Or be all casual like, "Hey dude, we appreciate what you've done so far, but this code is broken... Check out [link here] as to why this is not a good fit for CR"
 
@Phrancis that might have actually been better.
♪ Hey dude, don't make it bad. Take working code, and make it better. ♪
 
Yours is very PC, I would pick it over mine. But I'm a bit of an &97;&115;&115;
 
Hey, @Mat's, it's almost like you are in a good mood?
 
3:00 AM
almost?
 
Anything to celebrate today
 
lol
(cough)
 
Freedom!
 
I should be drinking ya?
 
@Mat'sMug Yes.
 
3:02 AM
^^^ For you, Mat's
 
ah, thanks!
 
So many things I could say right now .....
 
lol
♪ freedoooooom ♪
You've earned the "c#" tag badge
Get a gold tag badge: check.
 
And Palacsint got ... but he may be losing it soon.
 
3:17 AM
Man... moving would be so much easier if I could just code it.
SELECT Id, Title, Weight FROM OldPlace.Books INTO #Box_MyBooks
SELECT Id, Title, Weight FROM #Box_MyBooks INTO NewPlace.Books
Oh well. Guess computers can't do everything
 
Home automation is the residential extension of building automation. It is automation of the home, housework or household activity. Home automation may include centralized control of lighting, HVAC (heating, ventilation and air conditioning), appliances, security locks of gates and doors and other systems, to provide improved convenience, comfort, energy efficiency and security. Home automation for the elderly and disabled can provide increased quality of life for persons who might otherwise require caregivers or institutional care. The popularity of home automation has been increasin...
 
@Phrancis SELECT neighbors FROM neighborhood WHERE age > 12 AND age < 18 AND job = null
 
Yeah in my case it's more...
SELECT * FROM coworkers WHERE ass = No AND gender = 'M'
But yeah, basically.
Good news is, instead of driving 40 minutes to my job I'll be driving 6 minutes
 
wow.. can't you just walk it then?
 
Yeah. Was planning on dusting off the old bicycle
Walking would put me right back there around 30-35 mins I think
 
3:30 AM
right
 
30 minutes on foot is far better then some commutes I've heard of
 
> this user has not cast any votes
 
Yeah, not really the case in rural Indiana
 
what's up with the [supporter] badge then?
 
0
Q: What should be Meta's master community challenge tag?

JamalWe currently have two Meta tags regarding community challenges: weekend-challenge (8 questions) code-challenge (1 question) The main site equivalent of these tags are also synonymized, which will eventually be done here as well. However, does it make sense to also synonymize them with a new ...

 
3:33 AM
Odd.
 
@Mat'sMug Question deleted?
 
maybe
 
He only has one question.
 
So I got a question... You know how you JOIN tables or datasets in SQL. Is that concept existent in other programming languages?
 
with Entity Framework you navigate through entities via navigation properties
(essentially, foreign keys)
Like, an OrderDetail entity would have an OrderHeaderId property (FK) and an OrderHeader navigation property, so you can do context.OrderDetails.Where(detail => detail.OrderHeader.CreationDate >= DateTime.Now.AddDays(-30))
detail.OrderHeader.CreationDate -> EF deals with the joining
@Jamal is a meta tag?
it's on the main site
 
3:40 AM
I know. We don't have one on Meta. I'm asking if we should have one on Meta, or a different one.
 
, d'uh!
 
2
Q: What should be Meta's master community challenge tag?

JamalWe currently have two Meta tags regarding community challenges: weekend-challenge (8 questions) code-challenge (1 question) The main site equivalent of these tags are also synonymized, which will eventually be done here as well. However, does it make sense to also synonymize them with a new ...

 
Someone needs to throw together a matrix of what terms have been used, and where. — rolfl ♦ 3 mins ago
 
would that do?
0
A: What should be Meta's master community challenge tag?

Mat's MugIt started with weekend-challenge, in this post (the rock-paper-scissors-lizard-spock challenge). Then it was used pretty much every week of December 2013 when a new meta post came up for voting on what the next challenge should be. Then we "rebooted" the thing after taking a break, and since it...

 
I suppose so. We'll see what others think. Maybe I'm just being nit-picky here. :-P
 
3:49 AM
I guess non-SQL code confuses me because all tutorials start by showing you stupid stuff like writing Hello, World. and never get into fundamental concepts. SQL was a mistery to me until I understood JOIN for instance...
 
Phrancis. SQL was my first paid job... I go back a long way with it.
It requires a set-based thinking pattern to do it well.
I am hoping that those lessons will help me with some Lambda-type logic at a later point.
It took me a while to move from the SQL type thinking to decent Java thinking
... I like that (much more politically correct than .
 
Can we close a post as a dupe of a post that's on another site?
 
No
 
if someone just copy+paste the code from PCG or SO, it should be off-topic
 
Not necessarily.
The post on Code Review would still have to work.
so, a copy/paste from SO would be unusual to be on-topic for both.
If it is off-topic for SO, it can be migrated here and the answers merged
 
4:00 AM
yeah, I mean, it's still your code we want to review, right?
"code that you own or maintain"
maintain would be the loophole
well that's a good idea:
I should add, that part of the idea would be to hit posts that are high-view posts, and then link back to Code Review. — rolfl ♦ 3 mins ago
 
no it would not be..... we review people who do programming challenges, etc. all the time
 
Uh-oh... SEDE really didn't like my query
 
that's throw-away code.
 
right
 
857
Q: Generating random integers in a range with Java

user42155I am trying to generate a random integer with Java, but random in a specific range. For example, my range is 5-10, meaning that 5 is the smallest possible value the random number can take, and 10 is the biggest. Any other number in between these numbers is possible to be a value, too. In Java, ...

^^^ Java question, could write up a short 'my challenge response', and throw it up here for review.
 
4:03 AM
got it
 
1.2 million views on SO, what could possibly go wrong ... ;-) ?
 
dare?
1328
Q: RegEx match open tags except XHTML self-contained tags

JeffI need to match all of these opening tags: <p> <a href="foo"> But not these: <br /> <hr class="foo" /> I came up with this and wanted to make sure I've got it right. I am only capturing the a-z. <([a-z]+) *[^/]*?> I believe it says: Find a less-than, then Find (and capture) a-z one or ...

lol
 
This highly viewed answer is wrong:
956
A: Java: iterate through HashMap

karim79Iterate through the entrySet like so: public static void printMap(Map mp) { Iterator it = mp.entrySet().iterator(); while (it.hasNext()) { Map.Entry pairs = (Map.Entry)it.next(); System.out.println(pairs.getKey() + " = " + pairs.getValue()); it.remove(); // avoids...

 
wow these scores are insane
and the CR Games post has become "hot" on the CB
 
4:07 AM
Why is stackoverflow.com/questions/11227809/… the most voted question? Could this be the worlds most common question regarding the world of programming!?
 
I'd say because people thank the OP for asking a question that prompted this answer:
12286
A: Why is processing a sorted array faster than an unsorted array?

MysticialYou are the victim of branch prediction fail. What is Branch Prediction? Consider a railroad junction: Image by Mecanismo, via Wikimedia Commons. Used under the CC-By-SA 3.0 license. Now for the sake of argument, suppose this is back in the 1800s - before long distance or radio communicati...

 
Yea, the amount of upvotes on that baby is... a lot
 
+1050 in bounties!
 
Still my favorite SO answer:
12286
A: Why is processing a sorted array faster than an unsorted array?

MysticialYou are the victim of branch prediction fail. What is Branch Prediction? Consider a railroad junction: Image by Mecanismo, via Wikimedia Commons. Used under the CC-By-SA 3.0 license. Now for the sake of argument, suppose this is back in the 1800s - before long distance or radio communicati...

 
OK... @rolfl or others... run this code on SEDE and tell my why they designed it that way??
SELECT CAST(Tags AS VARCHAR) FROM Posts GROUP BY Tags;
 
4:11 AM
there's a PostTags table too I think
the string is easier for simple queries I guess, probably the 80/20 rule in action.
 
There is, and I was trying to JOIN them but kept getting errors specifically because of this
Maybe I'm doing my JOIN wrong but hard to tell from the schema
 
Phrancis, you should join PostTags.PostId to Posts.Id
I did an SEDE earlier today.....
It does a full tag-process join
 
Good, but where is your JOIN???
OH. You're using old-style JOIN I get it now :-P
 
@rolfl is old-school, he goes with WHERE joins
^^^^ that
 
I'm not a fan of those, but OK I got it
 
4:19 AM
@rolfl stupid question, does it impact the query plan in any way or it's just a matter of preference?
 
It is normally better for the query plan
 
It is?
 
s/normally/often/
It lets the database determin the best join order
 
hmm
 
Obviously, the good databases will do better than other databases.
In theory it is .... supposed to be about the same.
 
4:20 AM
I feel it is not so good for Mr. Maintainer... I like the clarity of explicit join conditions
 
The real issue I have with the ANSI style is that people abuse it all the time with outer joins which do not need to happen
On the other hand, I love the CTE style of SQL Server
Let me reteract what I was going to say, and just say that I am old school, and it works for me.
Also, you can do a lot of things old-school..... @Phrancis, check out this query:
 
But the real issue I have with where joins, aside from clarity, is that if you happen to forget one where condition, it does a cross join which really sucks
 
^^ that's f***ing impressive
 
@Phrancis Think about that statement, and tell me why it is different from an ansii joiin....
 
4:24 AM
WOW. @rolfl that is [expletive] cool.
 
takes a bow ... ;-)
 
I feel in ANSI you would have to specifically tell SQL to do a cross join
 
You can skip the on condition in ANSI
 
Otherwise if you tried another type of join but without a on condition you would get a syntax error
 
You can also put it anywhere you want as well.
@Phrancis Oh, you can't skip the on?
 
4:26 AM
Oh. I never tried that on purpose, maybe I need to rethink it
Let me fire up the RDBMS
USE sakila;
SELECT * FROM customer
INNER JOIN rental;
It did what seems like a natural join
00:27:30 SELECT * FROM customer INNER JOIN rental LIMIT 0, 1000 1000 row(s) returned 0.089 sec / 0.006 sec
 
USE sakila;
SELECT * FROM customer
CROSS JOIN rental;
00:28:29 SELECT * FROM customer CROSS JOIN rental LIMIT 0, 1000 1000 row(s) returned 0.002 sec / 0.017 sec
wtf
 
Pleased I could be of confusion
3
Also the on clauses do not even need to relate to the tables you are joining
 
May just be MySQL being weird (as it does)
 
SEDE is SQL Server
You have Mysql
could be all sorts of things, but SQL server seems to need an 'on' condition, though it does not care what the condition is.
 
4:30 AM
I realize that
So ruling out that MySQL sucks ass bollocks popsicles, I do think join with on condition is at least better for Mr. Maintainer
MySQL seems to be really picky about some things, but really liberal about others. Though MS SQl is the same way, just different things...
 
I have an old-timer habit. I do like some of the flexibility and standardization that comes with the ANSI, especially around outer joins when you need it, but on the whole, with decent SQL formatting, the old style works fine for me.
Damn, flakey net tonight
 
How would you do an outer join old style? ... Let me try
SELECT * FROM customers c, orders o WHERE c.CustomerId=o.CustomerId OR c.CustomerId IS NULL
 
1
Q: App.yaml configuration for Google App Engine

MoriI wonder if the following configuration is correct and the handlers are in the right order: application: myAppName version: 1 runtime: python27 api_version: 1 threadsafe: true handlers: - url: / static_files: website/index.html upload: website/index.html - url: / static_dir: website I...

 
Or some such...
That's likely wrong
How about o.CustomerId IS NULL
 
depends if you want a left or a right join
 
4:38 AM
Left in this case
 
you want all rows from c and only the rows from o where there's a corresponding record.
like, your database doesn't have foreign key constraints and you're searching for orphaned orders (those without an existing customer)
 
@Phrancis, it is the reason for ANSI ... outer join syntax is messed up on the different systems.
For SQL Server, and Sybase, it was the *= or the =* for left/right join
from outer, inner
where outer.id *= inner.id
 
huh, never seen it like this. interesting.
 
Huh, I thought SQL Server used this still, but it does not, apprently
You do know that SQL Server is Sybase, right?
A SQL join clause combines records from two or more tables in a database. It creates a set that can be saved as a table or used as it is. A JOIN is a means for combining fields from two tables by using values common to each. ANSI-standard SQL specifies five types of JOIN: INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER and CROSS. As a special case, a table (base table, view, or joined table) can JOIN to itself in a self-join. A programmer writes a JOIN statement to identify the records for joining. If the evaluated predicate is true, the combined record is then produced in the expected format, ...
Click the page, it links to the alternate syntaxes
 
@rolfl yeah, but I only know Sybase by name, we've never met.
 
4:53 AM
Sybase, is my favourite DB, sucks that it is in its decline
Of course, now I know DB2 quite well as well.
 
VB used to be my favorite language. things change ;)
 
Now it is JAVA ?
 
lol maybe ..eventually.
 
Everybody loves JAVA!
6
 
@Jamal that as a title = hot network question. could be a "hello world", it's still going to work.
2
 
5:01 AM
@JerryCoffin: I've bumped some other C++ questions that really needed some edits. Perhaps they can benefit from more answers? ;-) hint, hint, nudge, nudge
@Mat'sMug Unless someone attempts to edit out the "JAVA" part.
 
right that would screw it all up big time.....
 
Perhaps JAVA will someday be added to Uncyclopedia (although Java is already on there).
 
Does everybody still love JAVA?
 
Past TTGTB
 
Hey people.
 
5:10 AM
hello!
'night @rolfl!
 
if I change about 50% of my code after a review and want to get improvements /review on the changes, should I update my question, or post a new one?
 
Good question, ....
We have a meta post on that one... ;-)
oops
 
I guessed as much.. just don't trust SE's search engine for results
 
Not that one, hang on.
21
Q: For an iterative review, is it okay to edit my own question to include revised code?

JoelIs it okay to edit the question to include the improved code? I would like to do so for the following reasons: To share the improved code with others To show the answering persons that I take their feedback seriously To make sure that I understood (and implement) the feedback in the right mann...

^^^ that one.
 
Cool. Good answer there. I'll either link a jsfiddle as a comment to the reviewer, or post a new question, depending on whether it's 50% or 75% changed, sort of as a rule
 
5:17 AM
sounds like a plan!
@rolfl @Jamal should the CR Games post be featured?
 
@Mat'sMug It can
 
done
 
I really think you're on to something with that answer @rolfl
 
and my wife says I can't miltitask...
 
0
A: Finding the largest mirror image of a subset/set of integers present in an array of integers

JosayAs your code doesn't really work and I got quite interested by this problem : I took mjolka's precious comments into account. Re-adapting code from the link in his comment, here what I got : public class MirrorString { /* Returns length of longest common substring of X and Y */ public s...

Flagged as NAA
 
5:21 AM
brushing teeth, chatting, and breathibng
 
by the OP
breathing counts?
@Jamal does this question need YADA? (yet another deleted answer)
 
It looks a bit NAA-y, but I'm still a bit unsure.
 
I agree it's not really an answer though
 
Well, I self-feleted an answer there.... I am recused, and now in bed.
 
it looks like useful and relevant content, but it's indeed not a review
which is awkward
 
5:27 AM
Plus, he has already given a valid review. Perhaps this one can go.
 
See my comment on it.
Post this as your own question, @Josay, and I will happily review. I have solved LCS a few times — rolfl ♦ 43 secs ago
 
awesome @rolfl!
 
Is there still someone ?
 
hey @Marc-Andre
what the hell man?!
 
Hey nice
I'm a bit tipsy well this question need more attention i think there is a invalid edit on the question
1
A: Finding the largest mirror image of a subset/set of integers present in an array of integers

JosayAs your code doesn't really work and I got quite interested by this problem : I took mjolka's precious comments into account. Re-adapting code from the link in his comment, here what I got : public class MirrorString { /* Returns length of longest common substring of X and Y */ public s...

There was a Low-quality post
but it was fine
so I don't know if I should rollback
the question
 
5:30 AM
we were just discussing that very post!
 
I let you decide
damn sorry
maybe I was too quick on the looks good
 
what do you mean sorry? lol I mean hey that's timely!
 
on the low qaulity post flag
 
oh
 
I meant to be sorry
 
5:31 AM
any game ideas for the CR Games 2014?
rolfl has a pretty neat one already:
4
A: Let the CR Games begin!

rolflContent posted to Stack Exchange websites is under the Creative Commons license. Specifically, code posted to Stack Overflow and Code Golf are available for use, ..... and abuse! I suggest we take on the challenge of finding the worst code out there on our sister sites, and making it the best! ...

 
Humm Rogue Leagacy is a ton of fun, Binding of Isaac too
I'm really into rogue like games lately
 
rogue review?
 
So what's the difference between Java and JAVA anyways??
2
 
@Phrancis Java is for the real, JAVA is for everyone else :P
 
does not compute
So if someone uses JAVA you know they don't get it?
 
5:34 AM
you know they don't know how the name of their favorite language spells...
 
exactly :P
 
JAVA is for those who don't understand Java.
3
 
Need to go to bed cya guys !
 
Night!
 
OK. I want a coffee now... Bye @Marc-Andre
 
5:35 AM
me too, good night!
 
Cya @Mat'sMug
 
coffee if I would not go to bed it would be another beer :P
 
Hear ya
 
Night all!
 
5:57 AM
INSERT INTO 2nd_Monitor.Users (UserName, Status, TimeStamp) VALUES ('Phrancis', 'Sleep', CURRENT_TIMESTAMP);
'night all
 
6:30 AM
Bah... insomnia
0
A: SQL query to remove multiple duplicate entries from table

PhrancisI think you guys overcomplicate things a lot. This should work just dandy: DELETE FROM YourTable WHERE Accno = ( SELECT Accno FROM YourTable WHERE COUNT(SELECT Name FROM YourTable) > 1 AND Hash IS NULL GROUP BY Accno ) ;

Did anyone on SO even bother to look at how bad this query is? SRSLY...
9
Q: Vertica and joins

user997904I'm adapting a web analysis tool to use Vertica as the DB. I'm having real problems optimizing joins. I tried creating pre-join projections for some of my queries, and while it did make the queries blazing fast, it slowed data loading into the fact table to a crawl. A simple INSERT INTO ... SELE...

 
@Phrancis Did you ever get an answer on key-value stores?
 
@Donald.McLean ?
Sorry it may be but I don't recall that one
 
6:58 AM
I hate SO...
0
A: Vertica and joins

PhrancisI think your query could use some more of being explicit. Also don't use that Devil BETWEEN Try this: EXPLAIN SELECT referer_via_.url as referralPageUrl, COUNT(DISTINCT session.id) as visits FROM owa_session as session JOIN owa_referer AS referer_via_ ON session.referer_id = ref...

 

« first day (420 days earlier)      last day (3612 days later) »