skysight-inc/HackerNews huggingface dataset:
>I mean, isn't this just a button that adds some named ranges for you?

No, named ranges don't automatically expand when you add new rows, and they aren't automatically created when you add new columns. And they don't remain in groups, e.g. you can't make a reference like Namedrange1:Namedrange3, but in a table you can do Column1:Column3. Named ranges exist in a global namespace; column references exist in a per-table namespace. The table syntax makes columnwise operations clearer to express in formulae. Let's say you want to refer to the cell in the same row as the current cell, but in a different column: how do you do that if everything is just a named range? You need to do some kind of juggling with indexing and lookups, or else fall back to alphabet soup A1/R1C1 style referencing, because a named range is only good if you want to do an operation on every cell in the range. But that's often not what you want! In tables it's as simple as [@[other column]].

You would know this if you actually read the documentation or watched the video I posted. Or I could just repeat myself again (maybe I will write a macro to automate such tedium).

>Similarly, if you think there is something that "Power Query" can do that SQL cannot, then please show that.

Grab data from a csv file, a JSON file, a SQL database, and an Excel sheet, and combine them all together using a normie-friendly GUI.

Your question doesn't even make sense, it's like a type error. SQL and PowerQuery are not competing technologies, they're complementary.

>You could even write a quick macro in that generates the named ranges from column headers with one keystroke, it would be really trivial.

Yeah and you can also make Dropbox by getting an FTP account, mounting it locally with curlftpfs, and then using SVN or CVS on the mounted filesystem.

Spreadsheets are the only remaining programming system that people not inducted into the Programming Cult use.
> You don't own your games on steam

On Steam at least games don't depend on Steam for network play, nor do they depend on Steam's existence for them to work.
If all you do is expose simple models, it's fine. But then not much different than an auto-generated REST-api. But if you want to query deep, list of childrens etc you quickly get into queries that are very hard to write on the backend (n+1 issues quickly pop up etc). To solve those you need to write complicated loaders, which all should be very general in nature and thus you can't rely on two fields backed by the same data sharing a query without doing something special. Which is much more hassle than just writing whatever join you want for a tailored endpoint.
Sure but signed and unsigned division are different.
None. Life is too random to try to manage. No expectations, no disappointment.
it effectively needs to be fatter than the speed of sound. sound needs to hit the mic of the noise cancelling device, its inverse needs to be found before the sound hits your ear drums so it can be played at exactly the same time. all this needs to happen in the time it takes for the sound to travel from the devide to your ears. super fucking fast.
Bingo. Me and a buddy went to a Dillinger Escape Plan [1] show and he walked out with a giant gash above his eye (affectionally nicknamed "The Dillinger") and a smile on his face.

[1] Not this one, but same energy: https://www.youtube.com/watch?v=r-lxwlgyhhA
PV’s require minimal rare materials because the part that makes power is only ~1/5000th of a meter thick. It works out to around 80 gigawatt hours per cubic meter and most of that material is silicon. By comparison a nuclear powerplant goes through around 240 kg of uranium to generate that much power.

The casing on the other hand can be made from an extremely wide range of materials. And of course long term you can recycle PV panels because they arn’t consuming the material.
Probably the NSA...
I find it disconcerting that this has apparently been known since the 1970s. Seems like the Big Tobacco playbook all over again (only with even worse effects).

From the book “Exposure” by Robert Bilott, the real-life lawyer portrayed in the “Dark Water” movie:

> The internal alarm bells had first been sounded at 3M and DuPont after the publication of a scientific paper by the American Chemical Society in 1976. The paper had a curious impetus: Donald Taves, a University of Rochester toxicologist, had discovered two different kinds of fluoride in his own blood. Finding inorganic fluoride was not surprising—it is routinely put into the public water supply as an aid in preventing cavities. But the other form, organic fluoride, is man-made in industrial labs. What was it doing in his blood?
Dr. Taves wanted to find out. So he teamed up with W. S. Guy, a faculty member of the College of Dentistry at the University of Florida. They gathered plasma from blood banks in five cities and tested them for the presence of both kinds of fluoride. They also obtained records of how much fluoride was put into the water of those cities. As expected, the levels of “regular” (inorganic) fluoride in blood correlated with the levels of fluoride in the public water. But the levels of synthetic fluoride (organic) did not. Where was it coming from?
Guy and Taves noticed that the compounds found in the blood had a chemical structure consistent with compounds “widely used commercially for their potent surfactant properties.” In their publication of those findings, they hypothesized that the source was industrial fluorochemicals manufactured by 3M.
+ is not concatenation in any spreadsheet program I've seen, and it probably shouldn't be concatenation in anything. That's the solution, having a separate concatenation operator.
Can you watch Netflix on FreeBSD yet? That was what prevented me from switching from Linux last time I tried.
> By basically telling users "if you really care, you could do $laborintensivething" often they realize that they do in fact not care enough.

That's the trick. Instead of offering no way to get the feature they want (which means they'll try to convince you to do it anyway), you show that they can in fact get that feature — for a price probably beyond their reach, but that's not something you can remedy, so hopefully they'll leave it at “I can't do/afford that”.
> But others say that no cause and effect can be proven between these chemicals and poor health.

If the health effects of these chemicals are really as bad as it's claimed they are, then shouldn't it be easy to conclusively show some small but nonzero effect?
I just use Beyond Compare from Scooter Software. Best program ever. Been using it for 20 years now. I swear by it as an evangelist user.

Diff images, Excel documents, PDFs, whatever.
Passkey will be helpful in this regard.

https://developer.apple.com/videos/play/wwdc2022/10092/
Same answer as for the United States: Multi-member national house election by a competent method of single transferable vote (although Meek's method is newer than that, and my Bucklin-based method isn't even fully analyzed yet, so only somewhat-competent methods existed); single-winner elections by a single transferable vote nominating primary followed by a Smith-efficient final election (although the Smith set wasn't defined until later; Condorcet paradox was known, and inventing the Smith set wasn't hard, modern methods which would allow for rapid hand-counting were only invented a couple decades ago though).

Easy problem today, harder problem at the time due to lack of knowledge.

They used a list proportional system (the same system used today in Germany, and similar to that used across Europe). Candidates were controlled by the party, rather than self-nominated. It's a huge oligarchical system that lends itself to enormous perversions of democracy. We have self-nominated candidates in the United States, but party primary elections and every type of election used here (MNTV, SNTV, first past the post, and run-offs) are broken and create extreme distortion, polarization, and disenfranchisement by their mathematical nature.

Democracy only works when it's actually democratic. When it's not, a polarized minority can become dominant over the majority, thus dominating the public discourse and shaping the public reason, retaining and expanding power. Most systems tend to reject whichever represents the view of the voters as a whole body; STV deals with the problems of fair and equal single-winner elections (which suppress minority voices) by proportionality for solid coalitions, capturing the median voter group as well as those minority views leaning away from the median voter in proportion to the size of the groups, which are of roughly-even size, thus introducing diversity into the conversation without lopsided a priori voting power, maximizing the efficiency of the public reason.
I'm noting, quite correctly, that the overwhelming amount of opposition to LGBTQ life in the US comes from modern Christian doctrine.

As of 2022, there aren't a lot of secular thinkers/thought leaders/morality preachers in our culture who are telling people to stop being gay/trans, or equating being LGBQT with being a groomer or a child predator.

So, yes, having a few books on LGBQT life (both religious and secular), and a few hundred books on Christian life (some of which happily and loudly condemn the former) in your library is a pretty good proxy for covering a wide range of viewpoints on the question of whether or not it's OK to be gay.

But if you do want to thoroughly all-sides this question, there's also nothing that stops you from throwing in some secular, or Islamic, or Hindi anti-lgbqt literature onto the shelves. I'm sure it exists, but it's not a major axis of thought in this country, at the moment.
Damn, that's pretty close to my dream keyboard right there, thanks! Though Ideally I'd prefer something like a clit mouse near the home row, with 3 click buttons on their own row under the modifier row. With the Atreus design which is what I'm using currently.

Switched to a split ortholinear keyboard to force myself to relearn typing with touch, because I had this crazy ad hoc 5 finger system that was typing at up to 110wpm, but really messing with my nerves. Back up to 100+ WPM and my wrists are much happier.

Keep at it, you'll be flying again in no time.
It's a lagged Fibonacci generator
https://en.wikipedia.org/wiki/Lagged_Fibonacci_generator

In the third edition (1998) there are a few more notes, most importantly:

"Lagged Fibonacci generators have been used successfully in many situations since 1958, so it came as a shock to discover in the 1990s that they actually fail an extremely simple, non-contrived test for randomness" with reference to exercise 3.3.2-31 asking "prove that if we generate 79 consecutive random bits ... starting at a random point in the period, the probability is more than 51% that there are more 1s than 0s".

The solution references this paper on the tests: https://arxiv.org/abs/cond-mat/9406054

There's a recommendation to generate X numbers and only use the first Y an order of magnitude smaller, citing Lüscher's RANLUX, but I don't know how much that holds up either.
Some variation of the anthropic principle maybe comes into play here. If it had more deleterious effects, we may not be here to make these observations.
Ha, yes, that's the etymology for pajero, hence the similarity to "wanker" :D
Seems like a perfect example of the pitfall described in the John Scalzi blogpost discussed here earlier today.

https://whatever.scalzi.com/2010/06/16/the-failure-state-of-...

Update: the highlight for anyone who doesn't care to follow a random link:

> The failure mode of clever is “asshole.”
Every one of them also had kidneys, but that's not an objective argument for the pre-eminent moral value of kidneys.

There is an inescapable choice in choosing the grounds from which to reason out to an ethical conclusion - there is no self-evident starting point, hence the riotous confusion of moral philosophy over the last two millennia.
Let me ask this another way. I know how we determined noise was a good standard and that was talking to a lot of people who had built sophisticated crypto systems and then doing the research ourselves, but that’s only because we had the people on staff who had the capacity to evaluate such systems.

If we didn’t have those people, how would you suggest figuring out which system to implement?
Streaming royalties are broken, Rashida Tlaib thinks Congress can fix them
> or they capture ^c and interpret it to behave like the classic shells do because that’s the behaviour people expect from shells.

Which is kinda the point.

> So literally every ‘if’, ‘echo’ and ‘for’ (etc) has its own process ID in Linux/UNIX. Thus you can ‘kill’ an ‘echo’.

Do they? Because if I try like this `while :; do echo; done` and in another terminal I do `ps -x --forest` I can see the original bash running but it doesn't have any child process.

Besides, is it relevant to the discussion at hand?
I get this and I more and more fall into this category because I realise you can't control the world and a lot of what happens to you will be random, chance events, even if you do everything right, something random can happen that makes it all pointless and likewise, even if you do everything right, you still likely need a few random bits of luck to 'get anywhere'.

So you shouldn't overly try to control life.

However, i'm curious, do you use nothing at all then? You have no goals? No way of remembering tasks or things to do? How do you stop your life just being chaos jumping from one fire to the next or how do you even give it any direction? Else it's just about what is shiny and what is in front of you?
I'm fine with losing some functionality. Let's say community leader boards. Ofc, a nice thing would be then to provide API description and configuration options and allow fans to implement their own.
It's nr 2 variant is a lot less pleasant apparently, not to mention how it would affect dating prospects and such, so it's rather sad that science has no solution for these and many other viruses. What I don't understand as a lay person is the extremely slow rate of progress against viruses like these - imagine computing as a field progressed as slowly as this...
Everybody knew, Lord British made Ultima.
Wikipedia is great for some types of information (math, well-established science), but really bad for others. It's not accepted as a proper reference source for a reason!

Part of the job of the educational system is to teach kids to do independent research while maintaining appropriate levels of incredulity, which can be very difficult if not consciously and rigorously skeptical. They don't always do a good job, but abandoning classroom education in favor of self-study is probably not a proper solution for the vast majority of students.
Put a link to your Bitcoin public key and tell them to send you $500 or however much you want.

If they don't want to... tell them to send a PR themselves.
If this is something worth saving maybe you could go to reddit r/datahoarders and get someone to back it up?
The world is bigger than North America.
What is your application? No one knot fits all.
The biggest problem with graphql is that you have to do a lot of non-obvious work to harden your system against DOS attacks or people that want to fly by and download your whole database. It's easy to construct a query which puts unreasonable load on your system.

The more fine-grained nature of boring REST calls makes it more easy to control client impact on the system.

If you want to see the kind of work you actually need to put in to make a graphql API, look at Shopify. They have rate limits based on quantity of data returned. Cursors and pagination. The schema is a huge ugly mess with extra layers that never show up in the pretty examples of GraphQL on the internet.

Note that even if you use graphql for a private api to your web client, folks will reverse engineer it and use it for their own purposes. There are no private apis on the web.

I'm not a fan of graphql for anything that the public could see. It's somewhat akin to exposing a SQL interface; it opens up too many avenues of trouble. Keep public communication channels as dumb as possible.
wonder if there's some kind of "virtual microphone" like device that let's you hear sounds further away than a mic in the headset. Google fu showed some ultrasonic virtual microphone but idk if it is useful here..
Not true. Daily Dose of Internet mentioned it. Within a few weeks of that they came close to maxing out total Discord users on one server (1 million).
There may be nothing wrong with the idea, but it’s not a feature that the author thinks is correct for their project.
From the customer side of things, there is one upside to people returning things - Amazon sells the returned stuff as Warehouse Deals, often at a great discount. Unless it is a gift, I don't usually (ever) care if the box is gone/damaged or if the item is slightly used, as long as it is cheap. So far, in Canada, I've never had to return a Warehouse Deals item.
I always prefix zipcodes with a single quote. It tells Excell “this is text” and the leading single quote does not render.
You're right. Tom Clancy used it in The Sum of All Fears
Understanding Is Rare
This is an honest question. Stop acting like asshat redditors with the downvotes. A downvote on this is not a no vote to the question.
Would you further explain what you mean by it not being true? I don't understand how banks not lending the money isn't considered cash creation.

I know that US banks have reserve requirements, but that doesn't mean they don't lend any money out.
How about Lemmy? At least it's connected to the Fediverse: https://join-lemmy.org/
How about the world installs such an excess of solar/wind/renewable that the even the lowest variable takes care of the base-load?

I don't know ... call me suspicious ... but having Ukraine and and Russia fighting in amongst a nuclear reactor gives me the willies.

Something previously unthinkable. Until the unthinkable becomes thunk.

You don't know what's around the corner. And those in support of nuclear have such a hard-on about it that they're starting to sound like the crypto cult. I'm not convinced.
> The competition is for cost

Ideally there would be competition for end user low costs as well as investment costs. Electricity should be cheaper than tap water.
Hollywood is a city of ego. Lots of have developers are too humble to insist on serving as the marketing vehicle for their work - they want the work to speak for itself.
Ignore or send them Stack Overflow's guidelines for how to ask a good question.

e.g., "I can help you if you provide [this]"

https://stackoverflow.com/help/how-to-ask

Some people ask for help in a low-effort way: (1) out of sheer laziness, while others (2) just don't know better yet. The SO doc is pretty good for (2).
What is your definition of "file" that precludes calling these text files, files?

The word "file" has a very broad definition. HTTP/0.9 itself could be accurately described as a protocol for sending a text file as a query and receiving one in response. A basic HTTP client can be implemented by reading and writing files into netcat.

The entire HTTP header is a text file.
Sounds like the article should have been titled, "Why you shouldn't use ZFS".

ZFS does not have such [recovery] tools, if the pool is corrupt, all data must
be considered lost, there is no option for recovery.

In other words, this marvelous piece of over engineered technology is fragile. When it works, it's great. When it fails, it's a complete disaster.

Everything fails eventually. How do you prefer your failure served? In small manageable increments or one spectacular, complete, overwhelming, unrecoverable helping.
As a heavy user of both, may I suggest the answer lies right in your post: "personally" :)

I like not leaving the home row. That's possible with a pad or ball, but then you have to use your thumbs. My index finger is much more dexterous.
Every time I look into the big new tech thing, or someone is explaining even some old tech, they get lost in technical jargon.

They just prioritize that over any of the details or useful terminology to actually explain what they did or how this thing relates or builds off something that already exists.

Everyone's so worried about getting as many new tech keywords thrown out as they can in order to gatekeep others. Even when communicating to other devs-- I realize some of these sound like they're aimed at non-tech people. These are not out of place statements on Stack Overflow or in YouTube tutorials.

"The Cloud is a revolutionary technology that you be will literally unable to comprehend unless you have these 20 certificates like me." But then it can just be summarized as saving and accessing a file on someone else's computer.

"Typescript is a literally brand new technology built from scratch that you cannot begin to comprehend until you put 10k hours into it and become a master like me." But then it's just JavaScript with extra steps. Just like every other main front end language. They're all JavaScript plus X.

"I built my own computer and then operating system from scratch. Why don't you try the same before suggesting your ideas." Well, you ordered pre-assembled parts from a list somebody else wrote and then you plugged them in with less steps than a Lego kit. And your OS from scratch was just a GUI checkbox installer than you clicked through that now has a thousand driver errors you neglected to mention.

"I passed my FAANG leetcode interview because I'm a better programmer than you. If you can't pass a leetcode interview, are you even trying?" You passed your leetcode interview because you spent hundreds of hours memorizing every question and answer in order to recite it from memory under pressure. You also got lucky by getting a question you happened to memorize. Memorizing the answers before a test doesn't make you better at that subject.

etc.

I honestly can't find a way to explain this that's not negative. If someone can rephrase my points, I would be curious to hear a respectful counter argument.
'John Romero is about to make you his bitch'.

I also think that the massive failure of Daikatana helped people see that attaching your reputation to a game might not be the best idea.
I can't say I've found grain fed to be anything other than a bit bland and greasy. That being said, it's usually been Aberdeen Angus, which is okayish at best.
I support _every_ method of power generation getting this treatment. But it's only nuclear that's held to this standard. No other source routinely has all deaths in the life cycle from ground to ground counted as part of a piece that's essentially a press release.

Imagine if we had a solar article that started with:

>While promising the new solar cell tech does nothing to address the ever increasing number of deaths associated with roof top solar, which has surpassed Chernobyl as of 2015.

You'd call that article a coal industry hit job. Yet this is exactly what the OP's article does.
This is the correct link.

https://www.inaliminalspace.org/blog/barn-raising?rq=Barn

Also for those who know about barn stars on Wikipedia, barn raising and the particular idea of barn stars is the concept that inspired it.

http://meatballwiki.org/wiki/BarnRaising
Super sad. Some may remember his erratic behavior when he was struggling with mental illness, but I'll remember him for his incredible work ethic and ability to shine a light on just about every corner of the software development industry. I'm really sad for how much he suffered and that he's no longer with us. I was hoping to see him get well and do so much more.
It used to be retail. For the particular product I use a lot (Audition, audio editing SW), they moved to a rental model without adding any new features in the last 5-6 years. In fact, there are older versions of the software that I keep around because they have features that Adobe took out after they acquired the product from Syntrillium software.