The Nineteenth Byte

Alex A.

11:06 PM

That feeling when you make something you think is cool then realize someone already did it better.

quartata

heh

Alex A.

The only difference is that mine also shows who withdrew

Downgoat

@AlexA. is that a bug, feature, or both?

Alex A.

If you scrape the HTML, it always shows people who withdrew during the primary. Mine adds an explicit (withdrew) next to a candidate's score if they withdrew.

quartata

When in doubt it's a corner case

@AlexA. I kinda find it strange that it shows people who withdrew in the primary but not the nominations

Alex A.

11:11 PM

¯\_(ツ)_/¯

Quill

23

A: May 2015 Community Challenge

StackSTV Stack Exchange uses an STV-based system for holding elections. They use the software OpenSTV to host it. That software is no longer being maintained, and the system is being rebranded as OpaVote, and will no longer be free. This month's challenge: Build an implementation of the sa...

New Main Posts

0

Q: Awk or vim. Trying to generate numbers like so {1,2,3,4}...{1,2,3,4}

I'm trying to generate numbers between {1,2,3,4} up to {1,98,99,100} by using awk or vim. Can anyone help?

game

Alex A.

brb

Geobits

Because you're close-hammering?

GamrCorps

Ill take that as a yes

Alex A.

11:18 PM

yes

quartata

ur 2 slow

I clicked on that expecting to see it already closed

I was disappointed

oh well

Alex A.

I was writing a comment.

quartata

I just realized the Unikong guy is supposed to be Jon Skeet

Alex A.

Yes

Also I just realized that the guy who posted that off topic question posted it to SO an hour ago. ಠ_ಠ

quartata

rofl

Geobits

11:22 PM

SOP for a certain portion of users.

Downgoat

@Geobits SOP?

Alex A.

Standard operating procedure

Geobits

New Challenge Posted! Generate numbers between {1,2,3,4} up to {1,98,99,100} by using awk or vim. code-golf

Alex A.

Oh god really?

brb

Geobits

>_>

quartata

11:24 PM

(joke)

Alex A.

Hey now.

You're an all star.

Also you just tricked me

Downgoat

"I like awk" certainly doesn't mean that awk is the right tool; If you're after playing code golf, I recommend codegolf.stackexchange.com. — Marcus Müller 53 mins ago

ಠ_ಠ

Alex A.

OH

DAMMIT

WHY

Geobits

Awww, I was going to say something slightly harsher. quartata's a softy :/

quartata

We should set up Duga for PPCG

@Geobits It's called "finesse"

Geobits

11:26 PM

Well I wasn't going to be really rude :P

Alex A.

@quartata Your comment is nice and appreciated, thanks.

@Downgoat Your comment was a little hostile and kind of offensive to the user.

Downgoat

@AlexA. how?

Alex A.

You're basically saying that his question belongs in the trash can

While that may be factually accurate, it's not very nice

Downgoat

@AlexA. oh, okay, I removed that bit

Alex A.

ok

GamrCorps

11:31 PM

@AlexA. remember my proposal for a "Welcome to PPCG!" meta post? Whether you do or not I made an example for the time being for people to deliberate over.

Alex A.

Of course I remember. I remember all.

GamrCorps

nevermind, that link doesnt work....

@AlexA. I blame caching, otherwise this one should work: stackedit.io/…

My Ham DJ

Interesting SEDE query here: data.stackexchange.com/codegolf/query/463276/top-challengers

GamrCorps

Wow. I didn't realize HelklaHomba was so far ahead in the challenge game

My Ham DJ

Haha, yeah, almost twice martin.

Alex A.

11:36 PM

> Welcome to Programming Puzzles and Code Golf Stack Exchange (PPCG.SE)

Geobits

I'm 20th. Not bad I guess, considering I've only posted one challenge in the last six months or so.

Alex A.

We're not PPCG.SE

We're PPCG or CodeGolf.SE

GamrCorps

Yeah, Ive never known how to write that properly

My Ham DJ

23rd. I really want to work at moving up. I like writing challenges.

Geobits

Average score = 27.26 :D

Zgarb

11:39 PM

@MyHamDJ 4th! Although I've also been busy lately.

GamrCorps

Huh, well 74th isnt bad

Quill

data.stackexchange.com/codegolf/query/463643/top-challengers

My Ham DJ

@Quill Haha, I was just writing that exact same one.

Great minds think alike.

Quill

<3

El'endia Starman

@Quill I wrote basically that too. I'm going a step further and adding ranks though. :P

Geobits

11:42 PM

Eww, order that by average if you're going to average them :P

Alex A.

XD

El'endia Starman

@Geobits You can sort it yourself.

Click on the tabs.

Quill

@Geobits ;-;

Geobits

I know... I just want everyone to see my name higher up when they open it ;)

My Ham DJ

Lol, this one doesn't work right: data.stackexchange.com/codegolf/query/463276/top-challengers

I suck at SQL.

El'endia Starman

11:45 PM

Now with ranks: data.stackexchange.com/codegolf/query/463648/top-challengers

Quill

blog.erratasec.com/2016/03/…

Alex A.

@MyHamDJ Try avg to get the mean and use count(Id) instead of count(*)

Idk if it'll help but that's all I noticed when I looked at it briefly

My Ham DJ

That works, but I'm trying to figure out how to add a minimum challenges posted.

El'endia Starman

Took me a moment to realize why the "Average votes rank" column is discontinuous. It's because there are other users with higher votes/question ratios, but they don't make the top 50 in terms of votes.

My Ham DJ

I just don't know where to put WHERE users.postCount > 5

Alex A.

11:48 PM

Subquery or CTE maybe?

Wait

Quill

17

Q: Top users under age 30, sorted by age, with rank

In the pursuit of SQL enlightenment, I wrote a quick SEDE query to display Rep, Age and Overall Rank. Sorted by Age, then Rank (Which is generated by Rep). SELECT TOP 150 ROW_NUMBER() OVER (ORDER BY Users.Reputation DESC) AS Rank, Users.Id as [User Link], Users.Age, Users.Reputation as R...

sql sql-server stackexchange

Alex A.

There's no PostCount field in the Users table. Did you mean your derived one?

My Ham DJ

I know.

That was psuedocode.

Geobits

I'm feeling good about having the 5th highest average of those users with >10 posts.

My Ham DJ

=P

Alex A.

11:50 PM

@Quill SCREAMING SQL IS BEST SQL?!?!

El'endia Starman

Anyway, I quite like how I have almost the exact same average votes per question as Helka Homba, but only about 5% as many questions. That mostly just speaks to how good Helka is at writing good questions over a long period of time.

My Ham DJ

@Quill For whatever reason I never show up on that one. I'm 8th of the names that show up.

Quill

sequel is fun, but please
use spaces like geobits drinks
very generously

Geobits

:D

My Ham DJ

For that matter, Doorknob isn't up there either.

Geobits

11:52 PM

@Quill If by "very generously" you mean a lot at once, then sure. What you might not know is that I only drink at all every few months ;)

Alex A.

Oh damn, get rekt, Geobits

Quill

Alex A.

@Geobits Every few months? o_O

@Quill Doorknob is 16 now?

Geobits

Yea... being a single parent kinda gets rid of the "regular drinking" thing for me.

Quill

> instead of complaining
try fixing... it was on cr
you had to swap it

Geobits

11:53 PM

@AlexA. They grow up so fast... sniff

2

Quill

@AlexA. 2016 - 2000 = 16

Alex A.

@Quill Yeah, but has his birthday happened yet this year?

Oh shit hide he's here >_>

Doorknob

Yeeeees?

I'm 15 >_<

Don Muesli

@Downgoat Use a URL shortener? :-=

Geobits

Nah. Set up your own domain that redirects instead.

Alex A.

11:56 PM

@Doorknob That's what I thought!

Don Muesli

@Doorknob In which base?

Doorknob

Negabinary

El'endia Starman

First Crash Course Physics episode is up, and at one point, the host mentions going at 100 kilometers per hour. I had to do some mental math to figure out that that was about 60 miles per hour. >_<

Downgoat

@DonMuesli naaah, I'l just setup vihan.org/Cheddar to redirect to a rickroll

Geobits

I used to have a link that would redirect anything from the whole subdomain, but I can't remember it. It was useful, since you could just use the.domain.com/…

Quill

11:58 PM

sede works using years
memory like a goldfish
i've said this before

Geobits

s/goldfish/songbird/

Transcript for