skysight-inc/HackerNews huggingface dataset:
Well

select sum(pay) from employees group by organisation

is perfectly legal (although doesn't make sense because you don't know to which organisation each sum belongs to)

Regarding:

select *, sum(amount) from payslips group by organisation, pay_date

Remember: you get exactly one row for each unique combination of organisation and pay_date.

Assuming the following table:

branch | organisation | amount | pay_date
-------+--------------+--------+-----------
1 | one | 10 | 2020-01-01
2 | one | 20 | 2020-01-01
4 | one | 30 | 2020-01-01
7 | one | 40 | 2020-01-01
5 | two | 50 | 2020-01-01
13 | two | 100 | 2020-01-01
11 | two | 200 | 2020-01-01
15 | two | 300 | 2020-01-01

a "group by organisation, pay_date" yields exactly two rows. Which of the values for "branch" do you want to see for organisation "one"?
I backup all my iTunes movies on a drive to take with me so I can watch movies with no internet connection. All work fine. What am I missing?
> I think we're blessed to live in a time where we have such a plethora of scientific knowledge that shows how deeply connected we are to the natural world and each other.

We are mostly connected to each other via sanitized business transactions. Meanwhile, we don't even know the names of most of our neighbors.
I didn't know about gridcoin. Thanks for that.

However when i play chess the moment i smell that my opponent is female i immediately start playing more aggressively, and my opponent starts backs down. The statistics of the top chess players do prove me right. I have tried it myself many times. Against female players i don't try to play the objectively best move like usual, i consciously try to make the female player be afraid of their position and they lose by themselves.
Complete API Gateway and CORS Guide
I've found the "around" proximity search to be one of the most useful, if not THE most useful operators. It's SUPER useful if you're looking for something you just know someone must've already posted somewhere but you just can't find it!

It always reminds me of learning how to search databases back in the 90s when you had to pay by the minute and you really needed to know all the operators and how to use them! Old school librarian skills :-)
Hirohito and Hitler had similar thoughts about the US population. History tends to repeat itself
I would be interested to learn more about that analysis.
Responding to your other comments here, I'm given to being a data nerd, but I also think that there's little replacement for the hive inspection.

I like that your system seems to be out of the way more than, say, the Flow hive super.

The Flow super is a good example of something that is good for beekeepers interested in -not- scaling up. By that I mean that the cost of outfitting one hive is tenable because it offsets the infrastructure for extraction. But it doesn't offset the Flow super for the next hive. At three hives, you're better off with some supers you can lift and a two-frame extractor.

A lot of the monitoring systems I've seen are similar. You spend $300 per hive to know what's going on and for N hives you spend 300*N.

Broodminder lets you piecemeal that a little bit and hang "80" hives (temp/humidity sensors?) off one Cellular hub.

My gut here is that the data are more valuable when you have more correlations in a similar area, so the best case for hive monitoring is when it is cost effective to outfit a whole yard, rather than just a "flagship" exemplary hive.

I'm also very interested in edge-case detection like when a hive becomes honey-bound ( putting on weight, but no room for brood ).

I've read up on the auditory analysis before, and the anchor seems to be with the Apidictor. Have you been able to head off swarms? What's your window for sensing that?

Sorry for the barrage, I'm keenly interested in this. I don't mean to pick it apart because I think your solution is inferior. I don't. I want to understand.
Don't think it counters your argument at all, but Beyond Meat is pea-protein based and contains no soy. The Impossible Burger is soy based.
They are not the only company making electric cars but they are the biggest and most profitable company that makes ONLY electric cars. And they are one of the companies pushing the tech forward. And they are the company pushing the market forward. It is fair for Tesla to be tightly associated with the concept of replacing ICE cars with electrics.
Killing a bitcoin billionaire can also be a way to inflate its value.

I can imagine one bitcoin billionaire killing others to do just that in order to reduce the supplies.
Isn't that just BMH? It's a good choice in practice and no doubt many others have reinvented it or some small variant: https://old.blog.phusion.nl/2010/12/06/efficient-substring-s...
A tip we rediscovered a few years ago(it's well over a century old) is that adding a bit of borax to the washer not only helps get your laundry cleaner, but it will make all your laundry smell better, too, since borax/boron is an extremely powerful agent for killing bacteria, molds, and fungus. My wife is sold, and almost refuses to do the wash w/o borax anymore!

(This might even help deal with the continually scummy front-loader problem, but I can't speak to that as we prefer our 33-year-old Kenmore top loaders that can still actually be repaired rather than replaced with expensive new Chinese/Korean crap every few years. Mechanical timer controls and durable design and mfg FTW! For what it's worth, our total cost of purchase and repairs over 33 years is maybe $1200.00 for the washer/dryer set.)
> You can't google yourself out of every situation.

I attended a user group presentation on Hadoop a while back (back when Hadoop was pretty new) and the guy giving the presentation was talking about how difficult troubleshooting was. One woman in the front said, "but whenever there's a problem, why don't you just google the error message?" The presenter (and most of us in the audience) were struck by the horrifying realization that not only had she never had to resolve a problem that "googling the error message" couldn't fix, it literally didn't occur to her that that could happen. (And yes, she was a project manager).
Maybe not.

But if you're thinking "Should I upgrade my 6 year old i7 system?" or "Will I notice the difference from spending an extra $200 on my CPU?" these days it isn't easy to come up with a sure answer.
Bitcoin bro registered Argentina's Google domain and (literally) broke the net
As to distrusting large companies, I think that is an intuitive understanding we have that in any organization larger than 100 people, it is likely led by a sociopath. They gravitate towards positions of power, they have superficial charm that hold in large groups where you don't get to know people well, and they occur at about 1 in 100.
Now you're being condescending and projecting things onto me simply to try and undercut my point. Try talking to people without calling them huffy or assuming the people you're talking to are stupid. Maybe they just have different opinions from you.

I have no problem with honest critique. But once you get into talking about the ethics of a company, especially one you may have taken money from for an extended period of time, that's an entire subjective area. I'm not willing to go there with either employers or employees.

My way of avoiding the issue is to simply not work for companies I find ethically questionable. And if I were working for a company that I found later to be ethically questionable, I'd get another job.

The eight didn't get new jobs, they started a new company. It's like Activision and Atari. And it's a far cry from "I don't agree with their management structure" or "I don't like their method of crediting work" to "I think they're unethical".
Leicester was not too long ago not in premiere league, now they constantly spend 25 mil a player. There are plenty of teams who do that and clubs absolutely do reborn from ashes. Nothing like that with ESL.
Domain squatting is scummy if you do it to should be ashamed of yourself imo
I relate to this energy.
My mother-in-law has this talent - she's the one who becomes lifelong friends with someone she sat next to on a plane one time, etc.

And while it sometimes seems like a gift (folks in this thread in awe at the ability to easily chat folks up in a bar), it feels like a burden sometimes too. She'll talk to someone somewhere, get emotionally invested in their life, and next thing you know she needs to give someone a ride hours away, or she's calling other friends looking for a job for her new friend, etc. I guess those are normal, friendly, human social behaviors, but it feels like she takes it to a level that I personally find exhausting. Which makes sense, as I tend to be slightly introverted.
Please cite US involvement in a genocide since the 40s. Kind of an odd timeline to pick considering other US histories
Just define the value in home equivalents after the actual power amount.
Brother WP looks like it sells for ~$200 on eBay. But I think a mint Tandy 4000 would really be a museum piece ;)

Going down to the level of a quantum maxwell demon, a superconducting qubit, a single photon. One still finds measurable dissipation. An inherent non-linearity of optics in a medium. If the entire system could be constructed of light, manipulated by light energy. we could perhaps see a memory entropy lower than the systems ;)
Interestingly enough, this is more a case of being a dick. That is not illegal. If an AG does not levy a charge, no crime has been committed.

This does not at all mean the behavior in question should be condoned. This fails the sniff test worse than thioacetone.
"we all" references here my parents, my siblings and probably all people around me. I don't mean to use like as love, but no one complains about it.

When i talk about crypto, people do prefer to have their money at the bank where they can use it versus in bitcoin where it could just disappear by loosing their wallet.

I have never heard of banks stealing money. Do you have a src for this? I'm aware that there is a bank insurance for your money as long as you are in the EU (around 100.000,- Euros protected by the central bank) but in Germany i never heard of money gotten stolen from banks?

I personally don't have debt and i do think its a good think to be able to get debt when investing it in something like a house. But i can't follow your argument here again, how would that be gone with bitcoin? People would just start borrowing bitcoin, or not?

The big issue still is here: for Bitcoin we produce currently co2 from producing and consuming over 100twh. Bitcoin has a higher energy consumption than googles datacenter. We are now trying to get our co2 output to zero 2050 or so which we have to do. Everthing which produces more co2 adds to the issue. We have to invest in renewable energy without bitcoin and germany did this a few years back. Right now solar energy is the cheapest energy you can produce and on the other side, there is now a power plant in NY which runs 24/7 because it can mine for bitcoins and before that it was not feasable and no one is forcing those people doing this to reinvest their earnings in removing that additional co2 again. They probably consume more as they just spend it
I know it was not the most important thing by a long shot, but having a named that is verbifiable was/is still handy. "Just google it". You can't do the same with other search tools. "Just bing it" is the closest, but "binging" is not only not an important skill, it's something they do on Netflix.

Yahooing? Ducking? Dogpiling? Altavisting? Binging?

The ability for the word 'google' to be transformed to multiple use cases still impresses me.
Kubeflow 1.3 Is Out
Yes, this point is so obvious, I feel like I've got to be missing something. I am a professional programmer. I am vaguely aware that Intel chips have X-Lake based codenames. I have no idea how to compare the chip in my current laptop to a new laptop based on Intel's marketing names. To convince myself to upgrade, I just go to Geekbench, because nothing else in the marketing tells me the new chip is better. Seems like a very fundamental marketing failure that could be resolved by exposing the X-Lake names to the public in some friendly form.
An interesting realization that it could, though.

Overwhelming majority of MacOS/iOS software is written on Obj C and Swift, which have the same underlying semantics.

That said ARC doesn't have such a great impact on performance as some people (esp. fans of Java's GC etc.) would convince you. Most ++/-- operations on the refcount are eliminated by the compiler.
It's a paradox of knowledge Vs knowing or know-how.
Considering the chipped edges, it is not far off.
I'm writing this on a dual core i3 with hyper threading.
Long-term, more important than Googling, is building a mental picture of 'who can be trusted to give solid advice or write great code'.

Nowadays, I don't hit StackOverflow, but go to GitHub to look at what the best Software Engineers I know did to solve a problem. For each topic, there is somebody that comes to mind that I think is better than everybody else, and I look to them for direction.
SFYL? What does that mean?
> Since you mention relevance for beginners later on in your post I'd argue this isn't relevant either.

Agreed. At the time that variables are introduced, it should just say "a variable is a name for a location where a value is stored". I didn't mean to suggest that the tutorial should go into needless detail at that point. Just that the needless detail that it currently goes into is wrong.

> Same with passing variables via stack.

Again, my problem is just with the needless detail. When you pass a value it is copied (that is the relevant part) somewhere where the callee can find it (that somewhere is the irrelevant part).
An air driven Wells turbine?
As with other wave/tidal schemes, they are not viable at scale.

Consider the flagship 'LIMPET' project: https://en.wikipedia.org/wiki/Islay_LIMPET
Love the idea, and great effort put in! My initial impression is the same, overwhelming UX. There's a lot of information and there with very little visual hierarchy, it's hard to decide where to look first.

I find https://refactoringui.com/ has some digest-able design stuff for us developers. I'm not affiliated with them, but I've been the same boat with product design.

For me the key was understanding what roles spacing, color, and font-weight play in building a hierarchy.

Edit: spelling.
> At some point legislators are going to come and ask the question how we stop things like this happening

Bob Martin talks about it a lot, how the software developers of the world need to have an "oath", like the hippocratic oath. Two posts that summarize things well (but there might be more where he talks about these things) https://blog.cleancoder.com/uncle-bob/2011/01/17/software-cr... https://blog.cleancoder.com/uncle-bob/2015/11/18/TheProgramm...
Just want to mention something, I am not demanding so feel free to ignore me, if you make a game (and do it because you want to make the game and not to learn some language/framework/CV padding) then keep in mind that existing game engines are probably more accessible then something you try to re-invent(especially with text based games).

I admit I am a bit upset that when I see some people asking what good game engine for say a text adventure or virtual novel should he use I see people promoting their incomplete, buggy, unsupported engine(and most of the time the single feature is that is using the CoolLanguage)
Did Mores Law take into account 3D density or was it just single layer compactness?
Honestly, that's nobody's business but the Turks.
Digital Identity Through Time: From Finger to Facebook
Google used to be better, I feel.

Nowadays when you add a particular word to make the search specific (otherwise it's too general), Google decides for you, there aren't many results with that keyword, so it excludes the word and gives you a list of irrelevant things.

Yeah I know to put the words I want in quotes, but why doesn't it do that by default?
If you work in a large organisation and use Slack, I think that Slack search is overlooked by people. Most forget that it's even there, but I've found it has saved me a lot of time for getting answers to any organisation specific issues that I cannot google. "query in:#channel" and "query from:@person" are very useful.
The power of operating leverage-and how it could explode the stock market
To a first approximation, I would agree with the statement that "longer needles are better for searching." They just tend to have more useful properties: better chance of containing a rarer byte (or bytes), better chance of skipping characters, less of a chance of occurring at all, and so on. Of course, longer needles can sometimes result in a much slower search for pathological cases, depending on the substring algorithm you use.

The grep tools do track line endings, yes. ripgrep does it by default where as GNU grep does not. Line endings are only tracked to print line numbers. If you don't need to print line numbers, then you don't need to track all line endings.

The thing with tiny needles is that they aren't all created equal. If your tiny needle is a single byte and that byte doesn't occur too frequently, then it's going to be very fast to find occurrences of that byte.
I am an engineer. I use math everyday in my job. You could have just disagreed, without trying to make it sound like the reason we disagree is because I must be clueless. The article said the courses incorporate, "data analysis, mathematical modeling, and probability." How is this "everyday math" for people who will never do STEM? I use far more data analysis, probability, and modeling than I do pure geometry (although I use that too as well).
This is what capitalism is for.

Demand is high, supply is low. So prices are high. Only rich can accord.

Early creators make a lot of money.

Seeing the absurd profits, others will start supplying zombie sushi.

Demand is high, but now supply is high.
Prices drop.

Now even common folk can enjoy zombie salmon sushi.

No laws needed, no government regulators needed to control prices.
latest x86 chips have patently gigantic decoders metastasising into backend.

It's still a tiny percentage of the area. The caches are the biggest.
Well not to wander off topic too much, but someone has to wonder, wall street which is male dominated, is it really doing economics, or maybe they are doing a form of war, a modern warfare? A rhetorical question, i don't have the answer, somebody else may has it. If it is so women will restart the economy by themselves, in some way, by creating a digital coin, embryocoin maybe. Chesscoin would be fun i guess too, but too many male players in chess.
This is just vapid snark. Of course some abstraction is helpful, but there's also a point at which abstraction impedes understanding. Ergo, we're debating where the "sweet spot" is. Note also that we can say "Go is the sweet spot for most applications" while also acknowledging that it makes certain kinds of programming difficult (e.g., writing a compiler). It's okay to recognize tradeoffs; there's no need to oversimplify or otherwise engage dogmatically.
You want them to sell their product with a "if it doesn't work it's not our problem" label? I'm sure there are consumer protection laws against that.
Investors in uproar over Biden’s proposed capital gains tax rise
That's the thing: it doesn't!

(i.e. Processing data doesn't need energy - more correctly "work")

In the limit, you can process information adiabatically.(*)
i.e. you can perform a computation without heat exchange, and you can perform computations reversibly.

Maxwell's demon as a thought experiment is actually quite a deep and subtle probe into the boundary between information and thermodynamics.

What you CAN'T do adiabatically or reversibly is clear or set bits and throw away their initial state.

In theory you could make a classical mechanical turing machine that could perform a computation for an arbitrarily small amount of work, but to prepare a blank tape for it (or to configure a tape into a known configuration) will take a certain minimal expenditure of work.

* Ignoring Quantum Physics for now

The Wikipedia page for Reversible Computing might be a place to start reading if you're interested in following up.
Thing is, in order to have pervasive reuse of data structures (mitigating the overhead of GC) while maintaining safety and correctness, you have to track uniqueness and mutability throughout the program. At that point, you've got something that's practically indistinguishable from borrowck.

The real use case for GC is managing data where there's no well-defined "ownership" pattern, such as when dealing with general graphs (e.g. in a symbolic computing or GOFAI application). That's a remarkably niche domain.
Electrics made a comeback because Tesla showed there is money to be made. That is why all the others are catching up. Without Tesla, all established car manufacturers would happily continue to make ICE cars and maybe fake emissions tests to claim they are thinking of the environment.
>You are wrong on that.

>The consensus majority is only needed if there are 2 or more way to make valid (not breaking any rules) forward progress (aka a double spend attempt) Only in this case nodes side with the majority of their trusted nodes.

so basically "if there's a double spend just trust whatever the majority of the trusted nodes say"? It's better than trusting the entire state to the majority of nodes, but still quite centralized compared to other consensus mechanisms.
That’s intentional. It’s so that the salesperson can use messaging to guide you to whatever machine they have the best margins on.
>If you downclock Zen 3 to match 15W TDP, you may well get M1 beating it by double digit margin.

Nah, people have done that experiment and it is competitive
FWIW, your repo screenshot is 404
Any idea on CIA and NSA pay? FBI pay is garbage but no idea on the others
"Would you buy a meal if the restaurant refused to tell you the ingredients? Would you buy a car if you weren’t allowed to look under the hood?"

Ok, but I'm not buying the website, just using it.
Throwing in some more anecdata:

- 16GB MBP (Intel, not M1)
- Running MacVim w/ coc.vim & coc-tsserver (so it's running partial TS compiles on save, much like VSCode)

- One image running in Docker

- Slack, Zoom (at idle), Safari (with a handful of tabs), and Mail.app running as well

Per Activity Monitor, 8.97GB of 16.00GB is used with 4.97GB marked as "Cached Files" and another 2.04GB of swap used.
Shows removed from a streaming service is not really the same, because you don't pay specifically for that particular show. You pay for access to the library which is updated every now and then. Just like your taxes might pay for a public library in which certain books are sold off every now and then.

The problem here is when you buy a movie, show, book, album ect. that you suddenly do not have access to. That is problematic.
Interesting. It's a pity that shipment costs to my country multiply the price by 5 :\
Then why not give them 99.9% of the take if they are such big heroes?

Because for the lawyers to get all the money each time harm happens means they more from harm to people than the people themselves benefit, this is a perverse incentive to keep the system exactly as it is for people who often become our lawmakers.

This also applies to 80/20 splits.
Yep, welcome to the US. Bonus points for the fact ambulance rides usually cost thousands of dollars and aren't covered by most insurance plans.
For free books in the public domain, https://standardebooks.org

> Standard Ebooks is a volunteer-driven project that produces new editions of public domain ebooks that are lovingly formatted, open source, free of copyright restrictions, and free of cost.

(Not affiliated, just think they do great work!

Discussed before:

2019 https://news.ycombinator.com/item?id=20594802

2020 https://news.ycombinator.com/item?id=25138534
)
Yep because they would not get anything done ;)

In my experience as a web dev, all the performance goes out the window as soon as the tracking scripts are added.