The Nineteenth Byte

9:00 PM

@Mego @Downgoat I managed to get an average-byte-count-calculator sort of working: data.stackexchange.com/codegolf/query/edit/552618

Now to figure out how to ~~sort by AverageBytes~~ remove languages which less than 10 answers

Anonymous

@Mego It wouldn't let me post to the Sandbox. — Oliver Ni 32 secs ago

quartata

ORDER BY

Anonymous

Brb ripping hair out

quartata

@Mego what

Anonymous

Same user who has been posting a dupe challenge daily, after being told to use the Sandbox for the umpteenth time, is now claiming that "it wouldn't let [them] post to the Sandbox"

quartata

9:03 PM

No I know. Just mind boggled by the actual comment

which he appears to have deleted

Anonymous

@ETHproductions Add having count(1) >= 10 after group by Languages

mınxomaτ

@Mego They probably mean the "too much answers" popup. Which isn't an excuse, but maybe an explanation.

Anonymous

@mınxomaτ It's yet another example of that user being unwilling to put in a tiny amount of effort to make good challenges

mınxomaτ

I meant the "it wouldn't let [them] post to the Sandbox" part specifically.

quartata

Winning solution to that challenge: CJam score 1: 3

ETHproductions

9:07 PM

@Mego Thanks, that works great :) data.stackexchange.com/codegolf/revision/552791/698279/…

Anonymous

I know. It's just frustrating to no end that people won't put in a tiny amount of effort in writing challenges, when I (and many others) put in a huge amount.

Anonymous

@ETHproductions Glad to help :)

Anonymous

having is like where, but works on aggregate data (like count), and requires the use of group by

Downgoat

@ETHproductions wat cheddar is shorter than pyth ._.

ETHproductions

They say you learn something new every day, and I'm learning a ton about SQL today...

I gave up on trying to extract the byte count, so it just extracts the length of the first code block and uses that as the byte count

@Downgoat Are there a bunch of cheddar solutions less than 33 bytes or something?

Anonymous

9:10 PM

@ETHproductions Languages which use non-ASCII code pages will have an incorrect byte count using that method

ETHproductions

@Mego I know, that's one of the dozens of problems the query has

The best way to fix this would probably be to switch to JavaScript

quartata

@Downgoat It isn't a great statistic. Python3 for instance isat the bottom because usually people will answer hard challenges only in a non golf language

Anonymous

@ETHproductions You spell Python weirdly

quartata

In the case of Cheddar you're mostly picking battles you can win :P

ETHproductions

@Mego I don't know much Python

not that I know more SQL than Python

New Sandboxed Posts

9:13 PM

-1

A: Sandbox for Proposed Challenges

3.14159265358979323846264... Your task is to write a program or function to print Pi accurately to as many digits as you can. Here are the requirements: Your program must actually calculate pi, not just print a string hard-coded into the program or a built-in. Your program must end in under 1...

quartata

@ETHproductions Why not just use the byte count in the header? Then you can handle hexdumps too

ETHproductions

@quartata I would love to, but the parsing required is more than I know how to handle in SQL

Downgoat

@ETHproductions i know median is pain to do in SQL but i think mode/median will be a much better metric

ETHproductions

I'd have to handle all these cases:

JavaScript, 123
JavaScript - 123
JavaScript 123
JavaScript, <s>126</s> 123
JavaScript, 123 <s>126</s>
JavaScript 123 <s>126</s>
JavaScript, 108 + 12 = 123
JavaScript (ES6) 123

And a bazillion more

Downgoat

just handle %lang% n bytes

ETHproductions

9:17 PM

@Downgoat That sounds great, but I have no idea how to do that :P

quartata

@Downgoat Would be better to get the first number from the right

ETHproductions

Grabbing the last number in the header seems like a good way to do it, but I'm not sure how to do that either

In JS, it'd probably be body.match(/<h\d>.+(\d+)</h1>/)[1]

New Main Posts

0

Q: ASCII PPCG Beta Logo Golf

We shall soon have a new logo & site design, let us use this last breath of the simple times and golf this ASCII version of the speech bubble beta logo: +-------------------------------------------+ | .---------------------------------. | | .EPEpEpBPEpEGCXCgCgCGJgCgP&PWP&P&P&Y` | | .R...