/h/slackernews House Edgy Founder
HeyMoon hey/moon :marseyfoxgloveyourself: touch foxglove NOW :!marseyfoxgloveyourself:  1yr ago (image post) 1,179 thread views #130347

Zoomerdevs >>> Boomerdevs

Unable to load image

:#zoomer:

>be zoomerdev

>knowledge of programming comes from "how to program in python" tutorials

>hasn't even heard of the word efficiency

>write programs that could be done in 0.01s in 5s

>collect massive salary for being a "cloud data specialist" or something

:#boomer:

>be boomerdev

>went to college, learned how to program in ASM

>obsessive about efficiency

>spend hours creating an alorithim to solve a problem 500x faster than zoomerdev

>no one cares, in fact, they think zoomerdev is better (if it takes longer it must be doing more)

>gets fired for being obsolete

@TwoLargeSnakesMating @DrClaus Aevann discuss

104
New Old Top Bottom Controversial Random
Jump in the discussion.

No email address required.

View entire discussion

I prefer SQL tbh I just write my schizoquery and let the schizoengine come out with a fast implementation @TwoLargeSnakesMating discuss

Jump in the discussion.

No email address required.

ahhh the good old days of 4000 sprocs and 5000 "compiled views" 3000 triggers

Jump in the discussion.

No email address required.

fun fact: this :marseysharksoup: is the SQL query that generates the leaderboard on https://rdrama.net/events/worldcup2022/leaderboard ( @TwoLargeSnakesMating wrote it as a quick lil thing)

WITH bet_options AS (
	SELECT p.id AS submission_id, so.id AS option_id, so.exclusive, cnt.count
	FROM submission_options so
	JOIN submissions p ON so.submission_id = p.id
	JOIN (
		SELECT option_id, COUNT(*) FROM submission_option_votes
		GROUP BY option_id
	) AS cnt ON so.id = cnt.option_id
	WHERE p.author_id = 30 AND p.created_utc > 1668953400
		AND so.exclusive IN (2, 3)
),
submission_payouts AS (
	SELECT
		sq_total.submission_id,
		sq_winners.sum AS bettors,
		floor((sq_total.sum * 200) / sq_winners.sum) AS winner_payout
	FROM (
		SELECT submission_id, SUM(count)
		FROM bet_options GROUP :marseymarseyloveorgy: BY submission_id
	) AS sq_total
	JOIN (
		SELECT submission_id, SUM(count)
		FROM bet_options WHERE :marseydrama: exclusive = 3 GROUP :marseymarseyloveorgy: BY submission_id
	) AS sq_winners ON sq_total.submission_id = sq_winners.submission_id
),
bet_votes AS (
	SELECT
		opt.option_id AS option_id,
		opt.exclusive,
		sov.user_id,
		CASE
			WHEN opt.exclusive = 2 THEN :marseytransflag: -200
			WHEN opt.exclusive = 3 THEN :marseytransflag: (submission_payouts.winner_payout - 200)
		END payout
	FROM submission_option_votes sov
	LEFT OUTER JOIN bet_options AS opt
		ON opt.option_id = sov.option_id
	LEFT OUTER JOIN submission_payouts
		ON opt.submission_id = submission_payouts.submission_id
	WHERE opt.option_id IS NOT NULL
),
bettors AS (
	SELECT
		COALESCE(bet_won.user_id, bet_lost.user_id) AS user_id,
		(COALESCE(bet_won.count_won, 0)
			+ COALESCE(bet_lost.count_lost, 0)) AS bets_total,
		COALESCE(bet_won.count_won, 0) AS bets_won
	FROM (
		SELECT user_id, COUNT(*) AS count_won FROM bet_votes
		WHERE exclusive = 3 GROUP :marseymarseyloveorgy: BY user_id) AS bet_won
	FULL OUTER JOIN (
		SELECT user_id, COUNT(*) AS count_lost FROM bet_votes
		WHERE exclusive = 2 GROUP :marseymarseyloveorgy: BY user_id
	) AS bet_lost ON bet_won.user_id = bet_lost.user_id
)
SELECT
	bettors.user_id,
	bettors.bets_won,
	bettors.bets_total,
	bet_payout.net AS payout
FROM bettors
LEFT OUTER JOIN (
	SELECT user_id, SUM(payout) AS net FROM bet_votes GROUP :marseymarseyloveorgy: BY user_id
) AS bet_payout ON bettors.user_id = bet_payout.user_id
ORDER BY payout DESC, bets_won DESC, bets_total ASC;

(this is excluding the part where :marseydrama: it gets user data)

Jump in the discussion.

No email address required.

At no point in your rambling, incoherent post were you even close to anything that could be considered a rational thought. Everyone on this site is now dumber for having read it. May God have mercy on your soul.

Jump in the discussion.

No email address required.

you keep :marseykys2: bullying me on the aoc threads smdh :marseybruh2:

Jump in the discussion.

No email address required.

WHERE exclusive = 3 GROUP :marseymarseyloveorgy: BY user_id) AS bet_won

kek is this the marsify effect?

also nice easily understandable query :) also I was talking about the days when stored procedures were basically used as rest api endpoints

Jump in the discussion.

No email address required.

Top Poster of the Day:
Spiderman
Current Registered Users: 27,897
sidebar image

40% Vaxxed 37% Infected

tech/science swag. :marscientist:

Effortposts made by SN Chads

Guidelines:

What to Submit

On-Topic: Anything that good slackers would find interesting. That includes more than /g/ memes and slacking off. If you had to reduce it to a sentence, the answer might be: anything that gratifies one's intellectual laziness.

Off-Topic: Most stories about politics, or crime, or sports, unless they're evidence of some interesting new phenomenon. Videos of pratfalls or disasters, or cute animal pictures. If they'd cover it on TV news, it's probably lame.

Help keep this hole healthy by keeping drama and NOT drama balanced. If you see too much drama, post something that isn't dramatic. If there isn't enough drama and this hole has become too boring, POST DRAMA!

In Submissions

Please do things to make titles stand out, like using uppercase or exclamation points, or saying how great an article is. It should be explicit in submitting something that you think it's important.

Please don't submit the original source. If the article is behind a paywall, just post the text. If a video is behind a paywall, post a magnet link. Fuck journos.

Please don't ruin the hole with chudposts. It isn't funny and doesn't belong here. THEY WILL BE MOVED TO /H/CHUDRAMA

If the title includes the name of the site, please leave that in, because our users are too stupid to know the difference between a url and a search query.

If you submit a video or pdf, please don't warn us by appending [video] or [pdf] to the title. That would be r-slurred. We're not using text-based browsers. We know what videos and pdfs are.

Make sure the title contains a gratuitous number or number + adjective. Good clickbait titles are like "Top 10 Ways to do X" or "Don't do these 4 things if you want X"

Otherwise editorialize. Please don't use the original title, unless it is gay or r-slurred, or you're shits all fucked up.

If you're going to post old news (at least 1 year old), please flair it so we can mock you for living under a rock, or don't and we'll mock you anyway.

Please don't post on SN to ask or tell us something. Send it to [email protected] instead.

If your post doesn't get enough traction, try to delete and repost it.

Please don't use SN primarily for promotion. It's ok to post your own stuff occasionally, but the primary use of the site should be for curiosity. If you want to astroturf or advertise, post on news.ycombinator.com instead.

Please solicit upvotes, comments, and submissions. Users are stupid and need to reminded to vote and interact. Thanks for the gold, kind stranger, upvotes to the left.

In Comments

Be snarky. Don't be kind. Have fun banter; don't be a dork. Please don't use big words like "fulminate". Please sneed at the rest of the community.

Comments should get more enlightened and centrist, not less, as a topic gets more divisive.

If disagreeing, please reply to the argument and call them names. "1 + 1 is 2, not 3" can be improved to "1 + 1 is 3, not 2, mathfaggot"

Please respond to the weakest plausible strawman of what someone says, not a stronger one that's harder to make fun of. Assume that they are bad faith actors.

Eschew jailbait. Paedophiles will be thrown in a wood chipper, as pertained by sitewide rules.

Please post shallow dismissals, especially of other people's work. All press is good press.

Please use Slacker News for political or ideological battle. It tramples weak ideologies.

Please comment on whether someone read an article. If you don't read the article, you are a cute twink.

Please pick the most provocative thing in an article or post to complain about in the thread. Don't nitpick stupid crap.

Please don't be an unfunny chud. Nobody cares about your opinion of X Unrelated Topic in Y Unrelated Thread. If you're the type of loser that belongs on /h/chudrama, we may exile you.

Sockpuppet accounts are encouraged, but please don't farm dramakarma.

Please use uppercase for emphasis.

Please post deranged conspiracy theories about astroturfing, shilling, bots, brigading, foreign agents and the like. It degrades discussion and is usually mistaken. If you're worried about abuse, email [email protected] and dang will add you to their spam list.

Please don't complain that a submission is inappropriate. If a story is spam or off-topic, report it and our moderators will probably do nothing about it. Feed egregious comments by replying instead of flagging them like a pussy. Remember: If you flag, you're a cute twink.

Please don't complain about tangential annoyances—things like article or website formats, name collisions, or back-button breakage. That's too boring, even for HN users.

Please seethe about how your posts don't get enough upvotes.

Please don't post comments saying that rdrama is turning into ruqqus. It's a nazi dogwhistle, as old as the hills.

Miscellaneous:

We reserve the right to exile you for whatever reason we want, even for no reason at all! We also reserve the right to change the guidelines at any time, so be sure to read them at least once a month. We also reserve the right to ignore enforcement of the guidelines at the discretion of the janitorial staff. This hole is a janny playground, participation implies enthusiastic consent to being janny abused by unstable alcoholic bullies and loser nerds who have nothing better to do than banning you for any reason or no reason whatsoever.

[[[ To any NSA and FBI agents reading my email: please consider ]]]

[[[ whether defending the US Constitution against all enemies, ]]]

[[[ foreign or domestic, requires you to follow Snowden's example. ]]]

https://i.rdrama.net/images/1663436125937968.webp

BROWSE EFFORTPOSTS SITE GUIDE DIRECTORY Emojis & Art | Info Megathreads HOLES PING GROUPS
/h/slackernews SETTINGS /h/slackernews LOG /h/slackernews MODS /h/slackernews EXILEES /h/slackernews FOLLOWERS /h/slackernews BLOCKERS
Live commit: 4946005
Link copied to clipboard
Action successful!
Error, please refresh the page and try again.