skysight-inc/HackerNews huggingface dataset:
I agree with you that it's a pain writing join conditions with many fields...

But I think that's a shortcoming of the client tool, rather than the language.

If SQL tools auto completed the join conditions as best as they could it would probably be a great help.
Formula E cars are currently not just slower than F1 cars but also F2 cars (a new generation is coming but it still won't come close to F1 speeds).
> To tie your company to your identity so explicitly is unhealthy

They're just clothes! Most people aren't that much into fashion that they'd care like you think they would!
But there are RINO Republicans as well. I assume there's no problem hitting 50 votes. It was only a few weeks ago they were suggesting to use budget reconciliation to pass gun control via a tax to bypass the filibuster. If this is such a big issue, then I don't see why they wouldn't use it for this.

I do see that it could just swing back if things change.
especially in the price
No longer an issue with things like Spanner, CockroachDB etc
> creating hierarchies where none is needed. Toml is fine, it’s perfect, it’s exactly what people would expect and remember. [...] And it’s not like you need to have multiple separate tomls in different places in the hierarchy.

Yes, "toml" would be perfect, but we're getting "tomllib" instead, due to the lack of namespacing that the parent comment is lamenting.

The problem with the current situation is that (1) every project has to keep all the standard library modules in mind and make sure to never name a module "io", "site" or "email", etc. and (2) once a non-conflicting name has been picked (e.g. "toml") it will break if the standard library later introduces a module with the same name.

(I'm not advocating for Java's endless chain of single-child directories though.)
Here's a trick: always approve the code review, unless it's an actual bug, a security risk, or obvious quality issue. Then you can use whatever tone you want without much damage.

"approved, but I think this should be in a separate function"
I have a justifiable reason, you have a respectable argument, they just feel like it.

What I'm saying, of course, is that you're obviously right but our problem isn't because anyone disagrees with your position, but because we can't agree on what constitutes a justifiable reason in individual cases.
Whether or not that's an incredible effect size sort of depends. For infectious disease epidemiology, which regularly sees extremely strong effects because of the very short causal chain between an infection and an outcome, it's not all that extraordinary.
It's amazing to me that poor developers are still having to deal with email quirks. I was coding html emails in tables when I started 10+ years ago. It seems as though tooling may be better but the underlying client support is still drastically lacking. Why haven't standards body agreed upon a subset of html/css to be supported by email clients? perhaps they have and I'm unaware? I guess the issue with email is that there is so much more market fragmentation than browsers... It's just crazy to me how bad email clients support is for rich media, and how many people still rely on it as primary source of communication over newer technologies.
> Plus, all you need is raw, uncooked veg/meat and electrical outlets for pots. Little startup cost besides building.

Nope in plenty of jurisdictions every single pot needs to be ventilated. Massive startup cost.
Why couldn't you accept it, then wear it when you're not pregnant or nursing? Could be a nice gift to your future self (depending on the t-shirt!)
Yeah, this reminds me of one of the swag items at KubeCon a few years ago. Someone was giving out DevOps Magic 8 Balls. My first thought: “oh that’s fun!” My second thought: “wait this is annoying to get back home on the flight.”
Who do you think cane up with and wrote his domestic policies? That’s literally what lobbyist are for. They have these things drafted up ready to go years in advance (just like the Heritage foundation and SC picks). The only thing that might be last minute is the decision to go with it.

They know exactly what the downstream effects of these programs will be. Regulatory capture is a well attested phenomenon, so I’m skeptical of any claims that all the Byzantine policies that just so happen to favor big business came about haphazardly
I did this for sleep hygiene reasons because my office is windowless (the light goes from cool, to warm, to red as the night goes on) and as a side effect I stopped working so late because it was easier to notice "hey, it's 6 pm, I should probably stop for the day".
Ah that's fair. I do it for the warm and fuzzies, not for my own self-interest.
I also have an M1 MacBook Air. It's very snappy on both Firefox and Safari.

Sometimes when I woke the computer up from sleep, Firefox would be crazy laggy. I suspect some resource leakage but at least RAM and CPU were fine. Closing and reopening the browser would work around it.
I think the intended use of the blackmagic production camera line is for broadcast studio stuff where the whole workflow and switcher is pure SDI all the way to the encoder.
> I think it would be entertaining to have a recurring competition where teams sign up to compete on a few metrics [...]

Pretty sure this competition exists. Isn't it called "JavaScript"? ;)
> UTF-8 should only concern itself with encoding arbitrary 24-bit integers

I mostly agree, but situations in which there are two or more ways to encode the same integer should use a canonical representation; so that is to say, it is well and good that overlong forms are banned in UTF-8.

So there is the rub; those pesky surrogate pairs create the same problem: a pair of code is used to produce a single character. When you're converting to UTF-8, a valid surrogate pair which encodes a character should just produce that character, and not the individual codes. The separate characters are kind of like an overlong form.

If a surrogate occurs by itself, though, and not part of a pair, that means the original string is not valid Unicode. That is the case here with the "\udead" string.

The choices are: encode that U+DEAD code point into UTF-8, thereby punting the problem to whoever/whatever decodes it, or else flag it here.
Well, this behaviour of Oracle may be debatable too.

INSERT INTO test_number VALUES(10.0500);

SQL> SELECT * FROM test_number;

I

----------
10.05
> Google Cloud Platform Console is really slow for me.

While this definitely isn't because of Angular, I will note that it's currently deployed in development mode.
A more charitable description of NYMBY-ism would be that these people are mainly against the externalities that construction projects in their neighbourhood would cause, as opposed to being strongly for one end result over another.
First thing I noticed: There seem to be multiple entries for one product. One would expect that Coca-Cola is the same everywhere, but it has at least two entries for same can. Also Nutella, two entries for the same thing but in different sizes.
Yeah, the lack of connection to reproduction is why I'm skeptical of aging being an evolutionary mechanism. The above quote (appears to be from Steve Jobs) seems like an application of old ideas about the natural order to our current understanding.
I really don't understand this logic. Just income-cap the rentals, so high paying renters aren't eligible for the low-tier housing. Only filling out highest tier means that only high tier housing gets built.
The tech interview system employed by FAANG is an example of a weak correlation style interview. Actually the structure of the interview is mostly fine, but the criteria being judged is usually off.

1) Questions should be structured such that they're modeled in a real world context, and somewhat close to the nature of the type of problems your company/division solves.

2) For most companies, coding ability and quality is more important than CS theory strength. Success on a coding problem for these companies should be judged by pace of coding and quality of solution, rather than time complexity of the result. Run time complexity of an algorithm is almost 100% orthogonal to ability to write high quality code quickly, yet this is where 99% of the interview focus is for most companies.

That being said, if you're hiring somebody to design a database storage system, sure, theory is more important in that context. But 99% of jobs are not that.

Can't tell you how many people I've seen join FAANG that I've worked with who are actually quite poor performers in a real world context. It's very easy to grind leetcode and game the system as its structured.

Its true too that at scale the correlation is probably good enough to end up with a decent workforce though. But also very easy to tweak judging criteria to be more highly correlated to real world success. I've hired close to 100 engineers, and its immediately obvious to me who will perform well by how they carry themselves in the interview. I pretty much don't even take into consideration whether they reach an optimal runtime solution. One of the best guys I hired couldn't even implement a tree traversal/DFS/BFS in the interview
? as opposed to buggy reimplementation of subset of RDBMS functionality on the Application side?
https://archive.ph/g1ygz
See eg. https://www.oecd.org/els/soc/growingunequalincomedistributio... which states that the United States has the most progressive tax system among developed countries. It has not fundamentally changed since 2008.
I love the idea but hate that I'm so cynical about the likely outcome.
Nice job. Must be a busy neighborhood.
Very interesting to see someone with significant life experience quantifying this in terms of time instead of dollar value.

I found this comment helpful as I approach my mid 20s and think about the costs of some of the bigger investments l’d like to make in life. Thanks
People are sensitive. Directness is underappreciated. Inability to take critique is killing code quality. Try going to an art school. Critique is how we get better. Check your ego at the door and you'll go far as a programmer
I hate it too, and not just because it's making my body a free billboard that advertizes the company. It's because I don't want more clothes, period. I think it's fair to assume that anyone who works at a tech company - certainly in the dev department - is not going to be experiencing any personal shortage of clothing. Unless the point is to provide a corporate uniform, why give people more day-to-day stuff that they clearly already have enough of, seeing as they survived perfectly fine up until getting that job? It's profligate and gross.

And that holds true for pretty much every form of company swag, to be honest. Is there any product the average upper middle class professional is seriously lacking in their personal life that would be cost-effective for an employer to provide in a swag bag? Realistically, no. It's all just a massive waste.
Also, politicians actually are supposed to represent all of their constituents, not just the ones that vote. There is no incentive to do so of course, but that is what they are supposed to do.
These are wonderful, thank you!
Great idea. I double up my office space for work and for personal projects / hobbies outside of work (same desk and chair, different computers), but didn't consider having a dedicated colored light for it.

I think I'll leave normal lighting for work, but then do a more playful color for hobbies, like purple or blue or red or something. I already have the light even, I just haven't been using it.
Great so ten years from now after all the manufacturers remove this feature we'll have articles saying that the missing wear leveling feature is causing data loss and early failures.
Does squirrel hair make a good paintbrush? Never knew.
> C on the other hand is great. What you wrote in 1990 still is understandable today?

That's a weird example. In my career I've noticed big stylistic changes over the years in C. I can usually point out C code from the 90s right away. Usually it just has dated style or is missing what are now common libraries or features. C didn't have a standard bool type until C99 which is usually a good sign of code's age. I remember once I came across some mid-90s code written with the pre-ANSI style of function declarations. It was the first time I'd ever seen it and I was confused on how it even compiled.

Outside stylistic things, there are a few idioms and features that I've never seen in newer code bases that might be lost on some newer developers. I can't think of many times I've seen longjump used in modern C.
This is totally contradicted by TFA.
I think there is a way to get the inserted trailing zeroes in Oracle as well.
So if you explicitly inserted 10.0500, you want to get 10.0500 but not 10.05 ?
Nutritionix is your best bet, in my opinion.

https://www.nutritionix.com/food/boiled-potatoes
If you unleashed 5 full F1 teams to solve EV F1 racing they would most certainly come up with record-breaking solutions to tackle issues you mention. With how good the F1 car aero is and how good the batteries’ low centre of gravity is, I would’t put it past them to be able to create magic.
Anything private should ideally be put behind authentication. If that isn't possible, than robots.txt. Search engines are _meant_ to index everything that is publicly accessible and not blacklisted on robots.txt.
The brainlet and sage text is “maybe x causes y.”
> the rewind button didn’t function, which pushed the recorder past the point of usefulness.

What's more impressive is this being a hardware problem that can be fixed by rewiring the button. The electronics or firmware of the recorder is still functional.

Compare this to software apps and smart devices where it is so complex that we have absolutely no hope to fix when they break.
Anyways, I am more interested in how PostgreSQL can make us have trailing zeroes or no trailing zeroes depending on the type you choose or other work-arounds.
Didn't this happen in May?
Right and it’s specifically used for cornering downforce, since the coefficient of friction isn’t high enough to justify generating downforce like this in a drag race.
Parent never claimed it was going to be fast.
Back in the nineties, I worked for a big company where lots of people wanted to work. We had what I called "resume reading parties". A half-dozen of us, managers and ICs, would sit around a pile of resumes in the middle and start reading. When we finished each one we would check either "Y" or "N" and pass the resume to our left...except two noes and the resume was put in the reject pile. Sometimes they fed us. From there would be phone screening then on-site interviews. HR didn't like being cut out of the loop but we knew we were better at screening than they were.

A benefit of this process is that your resume-writing skills improve a lot. Read a hundred or so resumes and you'll learn what catches your eye and what gets ignored.

Alas, nobody else does this. I used to mention this process at places I worked but people thought I was nuts. It worked, though. We rarely had a hire that didn't work out.
Russia Slashes Environmental Protections as War Rages, Economic Crisis Looms
This doesn't seem like a bad thing to me. In the same way we have public defenders who professionally defend scoundrels, it seems good to have people who professionally critique new technologies.

I'm old enough to remember the naive optimism around the internet in the 2000s. "The long tail", "cognitive surplus", "one laptop per child", Creative Commons, the Arab "Spring", breathless Youtube videos about how social media is gonna revolutionize society for the better, etc. Hardly anyone forecasted clickbait, Trump tweets, revenge porn, crypto scams, or social media shaming. If we had a few professional critics who were incentivized to pour cold water on the whole deal, or at least scan the horizon for potential problems, maybe things would've turned out better.
OpenFoodFacts offers variety of options to consume their data: https://world.openfoodfacts.org/data. From my experience, their coverage for packaged foods from various countries is amazing, though it can be fairly noisy.

In US, USDA provides a more curated dataset through FoodData Central (https://fdc.nal.usda.gov/) - smaller dataset but higher quality (nutrient coverage, number of samples tested, etc).
> How do I break the text up into segments that will fit within the horizontal width of the graphical window without changing the meaning of any of the text?

This is language dependent. For instance, the Japanese don't care. I was reading a novel a few months ago, and a chapter ended in a sentence ending in "た。" (ta.) due to some past tense verb. This "た。" did not fit, and so was just punted to the next page, which was otherwise entirely blank. There is no concept of hyphenation.

So if the text is Japanese, you just chop it into the required line length,
and you're pretty much done; no hyphenation is required, no multi-pass breaking algorithm to create an evenly gray page, nothing.
This is especially common in churches because in addition to having an existing trust relationship, in many more conservative denominations you also have a large population of women who are expected to be mothers first and working second but are also expected to be the frugal wife running the household like a small business (there are several scriptures like Proverbs 31 which mention this in contexts which make more sense if your household is a small farm & you're selling your surplus). Those pitches explicitly borrow from that tradition and they always refer to it as being a small business owner, which sounds a lot better than working part-time at Starbucks even if the latter tends to pay considerably better, and that's also appealing to the people who see working outside the home as being out in the world exposed to all kinds of dangers and temptations since you can tell yourself that you'll mostly sell to people you already know.

What tends to happen is that the first person who picks up some new scam does fairly well because there's no exact competition for whatever they're selling. They tell their friends, who are likely to join because they made an enviable amount of money, but returns drop off rapidly because most of the people who want whatever that company is selling already bought it from the first person (whose social network overlaps considerably) and at some point most of the money is coming from the people buying the initial inventory which will mostly sit in their garage.

The social dynamic also means that _nobody_ will ever admit that they lost money or made the equivalent of $2/hour even as they're giving away that unsold merchandise at baby showers for the next 5 years.

Cryptocurrencies have largely been the brilliant idea of capturing this dynamic for a different demographic (libertarian men).
This was a good podcast with Bushnell where he talked about the his personal backstory and founding of Atari. https://www.acquired.fm/episodes/atari-with-nolan-bushnell
It's a terrible idea to give all the power to idealists (even granting this is possible). Corrupt cynics can be bargained with. The damage idealists can do is unbounded.
The console threat model is far too different to the mobile device threat model for any direct comparison.

Console users will deliberately withhold security updates, so that they can later hack their devices. Console security updates protect the vendor from their users.

Mobile users (who care) will always be on the latest updates. Fresh browser exploits are exponentially more expensive, generally speaking.

Allowing users to use different browser engines doesn't necessarily widen the remote attack surface, it just changes it. But yes, ultimately I think Apple cares more about losing their walled garden, than they do about security.
Specular reflection (a mirror) would be ideal for sending energy back out into space most of the time but would occasionally death-ray your neighbors. White paint isn't quite as good (some of the diffuse reflection will hit non-reflective things) but it also won't incinerate anything. Feels like a good compromise.
Why don't you just donate the clothing?
Lower case is locale-sensitive, however. For example, tolower('I') in Turkish should be 'ı'.

And within unicode, doing it in a "dumb ascii" way probably needs some normalization of diacritics. Eg. 'é' should be U+0065 U+0301 ("e\xcc\x81"), not U+00E9 ("\xc3\x89").

Not sure how punycode handles this, I did once look deeply into it but that was years ago.
This assumes that the supermarket took the photos - what I mean is the supermarket might buy those product photos under license.
That's only a problem for the few that actually read the articles...
That's as may be, but it's orthoganal to the question I asked:

Are you implying (not saying you are, but it is a
parsimonious reading of your assertion) that not getting
caught doing something makes that activity legal/ethical?

So. do you believe that as long as you don't get caught, it's ethical?
Well, there is a giveaway, but one would need to know it and have good points in perception.

I generally use the assumption that I’m being recorded (with people / groups I don’t know well) as a speech filter / clarity motivator.
I'm a NIMBY, unfortunately. Not because I'm anti-progress or whatever, but because so much of my financial life is tied to my house, and whether I like it or not, there's a lot that can adversely affect its value. So, if building a new apartment complex nearby is gonna reduce my property value by 5%, taking around $50K out of my pocket, of course I'm going to oppose it. I don't feel like that makes me a bad person. Who wants to flush $50K down the toilet?

Fifty years ago houses weren't so expensive, relative to income, and thus the risk wasn't as high. My parents bought their first house in 1969 for $17K, no student debt, no health insurance expenses, etc. So, if a highway was built in their backyard, they would've been much more concerned about the hit to their quality of life than to their finances.
My problem needing multiple machines is less weird than needing more than python for my dag?
The cease & desist mentions Asda [1] and [2] says "Asda chose NielsenIQ Brandbank, their existing digital content provider for 13 years"

So I'd wager the C&D came from Brandbank - who presumably supply product photos and product data (barcode, pack size, and all the other data like nutritional information you'd find on the packet if you were browsing in store)

[1] https://www.trolley.co.uk/imgs/cease-and-desist-letter.png
[2] https://www.brandbank.com/asda-accelerates-their-rich-conten...
This comment has the same energy as people who still use a dollar sign when spelling "Microsoft".
>What's the best use case that you care to name?

Censorship and central authority-resistant value transfers are worth it alone, in my eyes. Coming up second is the ability for money to be programmable in a way that both parties can trust the execution of that program. Those are both primitives upon which pretty cool stuff can be built.

>Or put differently: "I've seen 98 scams in a row, so this increases the odds that the next ones that I see won't be a scam!" It's a conclusion in search of a justification.

I think it's OK to believe in the core value of an area that also has a lot of scams. When they first invented electricity there were an enormous number of conmen who sold miraculous electro-cures for ailments, etc. It's just because people are interested in new technology, so operating scams in new technology is a good way to find people you can scam. In 50 years all the scams will revolve around whatever newfangled technology exists then, it's a pretty basic human pattern. Find the society-altering technology of the time and there will be people trying to deceptively use it to their own benefit, whether it hurts someone else or not.