I wish it just had a "group by all the stuff I selected without aggregation" shortcut
yeah, this is the right answer. Are there any examples where this isn't what you want? I guess GROUPING SETS and ROLLUP, but those could be special.
Readit Newscoderzach commented on SQL language proposal: JOIN FOREIGN gist.github.com/joelonsql... · Posted by u/JoelJacobson
coderzach commented on A mental model for decentralization jacobobryant.com/p/mental... · Posted by u/jacobobryant
coderzach commented on Are you hosting a memetic parasite? apxhard.com/2021/03/17/ar... · Posted by u/monort
It's a reference to this: http://scp-wiki.wikidot.com/antimemetics-division-hub There Is No Antimemetics Division and its sequel Five Five Five Five Five are some of the best sci-fi stories I've ever read.
haha, that's not a visual programming language!
coderzach commented on Are you hosting a memetic parasite? apxhard.com/2021/03/17/ar... · Posted by u/monort
There is no antimemetics division.
I've been feeling very paranoid about posting ANYTHING online, honestly. Or chat, email, video call, etc. Is that what we're talking about?
coderzach commented on Bitcoin may consume as much energy as all data centers globally digiconomist.net/bitcoin-... · Posted by u/brianxp
Ripping myself off from another "bitcoin will destroy the world because climate change" thread:
> But visa doesn't provide most of the functions of bitcoin infrastructure. Visa does[n't] need to hold the balance of my account. Visa does[n't] need to or makes available all of my equity worth of assets for me to transfer. Visa does not custody my assets. This is literally apple to oranges (or visa to bitcoin)
> Visa does[n't] need to hold the balance of my account.
Yes they do?
> Visa does[n't] need to or makes available all of my equity worth of assets for me to transfer.
This is a horrifying bug, right? A thing that no person would ever want, and it's so rare that visa would make you talk to a person and raise your limit first, or they'd get more people involved to make sure you're not being coerced because it's such an abnormal thing to do. Lawyers in some cases, just because you're being so silly. But if you REALLY wanted to make a $1b debit card transaction, you probably totally could, just call the visa billionaire line.
> Visa does not custody my assets.
But a regular bank can, and visa will send to and from there with a debit card.
coderzach commented on Why are so many athletics records falling? economist.com/the-economi... · Posted by u/prostoalex
IDK about pro track but in HS track, pacing in meets is illegal. I've seen runners DQ for a teammate running on the infield urging them along.
Having a human rabbit isn't something you can really stop.
Am I an idiot who went out way too fast for the first 600m and then died, or did I exactly hit my teammate's pace, and then fall off intentionally?
coderzach commented on Packrat Parsing: Simple, Powerful, Lazy, Linear Time [pdf] pdos.csail.mit.edu/~bafor... · Posted by u/gjvc
Guido van Rossum's series on PEG parsing
https://medium.com/@gvanrossum_83706/peg-parsing-series-de5d...
Proposal to use PEG parser in python https://www.python.org/dev/peps/pep-0617/
Python PEG grammar https://github.com/python/cpython/blob/3.9/Grammar/python.gr...
coderzach commented on GitHub has completed its acquisition of NPM github.blog/2020-04-15-np... · Posted by u/0xedb
I never quite got a warm-fuzzy feeling from npm -- the tool, the service, the company. This announcement does nothing to help, from my perspective. Is my dependency on this or that JavaScript library something that really needs to be owned by a for-profit company?
I also kind of wonder what is the real value of a centralized repository versus just directly referencing git repos. I haven't used this gpk[0] project yet, but it looks like an interesting alternative, on paper.
You'd be surprised how often git repos disappear when you have 100s or 1000s of deps.
coderzach commented on Dgit: Git with decentralized remotes github.com/quorumcontrol/... · Posted by u/QCSmello
A thread from 2016: https://news.ycombinator.com/item?id=11430009
I think that's a different dgit