skysight-inc/HackerNews huggingface dataset:
Great. Then you're not the elitist group I'm referring too. I'm basically talking about the difference between MCU style blockbusters and br. The pacing is a huge delta.
>I am not sure how to extrapolate your personal experience into global trends, although I am sorry that you have to go through that. I don’t personally have that experience at all (I am always able to visit a GP the same day) and am also in Europe. My experience lines up with the data in the links, both now here and in the US when I lived there.

As an American with expensive (~$800/month, rising to over $1000/month next year) insurance, I often have to wait to see a specialist and only go see my GP for regular check-ups.

If I have an issue that needs to be addressed immediately, I have two choices: an "urgent care" facility or an emergency room.

Urgent care, at least in my experience, is a misnomer as I've (with a small sample size) alternately been refused treatment and been told to go to the emergency room ("we can't handle that sort of thing") while still being charged for something, or given substandard treatment.

Which, I guess, is why urgent care is 1/3 the cost (out of pocket) of an emergency room visit.

Should I wish to see my GP, I likely would need to wait at least a few weeks, possibly longer. With even longer waits for specialists.
Bums will not leave public transit just because non-bums start using it more often. Only practical mechanism here to achieve the effect you predict is that non-bums are angry about terrible conditions in public transit they are dependent on using, and force the government to kick the bums out. If this is viable, why won’t the government, you know, kick out the bums now? That it does not do so, I take as evidence that it won’t do it in future either.
The author is likely Canadian given their current biography snippet.

There were Radio Shacks in Canada, before they ended up being renamed The Source in 2004[0]. So in 2009, the year cited in the article, they would have gone to "The Source", but likely still thought of it as Radio Shack, the old name of the chain.

[0] https://en.wikipedia.org/wiki/The_Source_(retailer)
Because they can buy the law. What's a couple hundred thousand fee for them? Pay and keep on doing the same.
Chicago definitely doesn't have an "only the bums use public transit" problem.
Why are bike lanes held up as the optimal solution in small municipalities with an aging population?
Does anyone know the meaning of "all finally settled claims" in point III?

> III. Blanket indemnities. I'm not wealthy, and my insurer won't cover claims that you settle without their consent. Asking me to indemnify you against "all claims" exposes me to the risk of bankruptcy – and still doesn't protect you. I change this to "all finally settled claims."

A claim not finally settled leaves nothing to indemnify against. I'm missing something here.

Edit: Maybe "I indemnify Publisher against all claims which at the time of contract signing are finally settled"?
Why are you so certain that Apple will have to kill Safari if Chrome and other browsers are allowed on iOS?
> Hot take: It’s fine when it happens to extreme hubris with paper wealth. It is not fine when it was someone unsophisticated chasing the herd who lost a meager sum that was meaningful to them. Comedy vs tragedy.

I think this is overlooking why people are engaging in these types of investments to begin with: they're greedy speculators who got caught up in a get rich quick scheme. They don't know what this tech is, why it is or isn't useful, or how it works. They don't know what the investment risks are and don't make any attempt at mitigating risk. They don't seek expert assistance. Instead of doing basic research to make informed decisions, they see dollar signs and yolo with their life savings. I don't feel bad for them in the same way that I don't feel bad for people who fall for 419 scams. If you participate in get rich quick schemes that you don't understand, there is a high probability of getting owned. This exact same collapse in value happened only 5 years ago, how could people be caught flat footed twice?
theyve been telling us crypto has been melting down and bursting and dying for a many years, its still here. my bet is that itll still be here in ten years and theyll still be posting on buttcoin.

seems much more interesting to explore, hack, risk, and learn by playing with crypto, id much rather to that than post "bitcoin ded" for a decade.

prices go up and down, culture persists.
Database Design for Mere Mortals by Ray Hernandez
Yes. For obvious reasons, people are more prone to lose 2FA authenticators (be they code generators or hardware keys) than passwords. Both passwords and 2FA mechanisms are customers of account recovery, which is the process that kicks in when you can't log in. Security questions are a particularly bad account recovery system. Reset emails are somewhat better.

Again, 2FA isn't an account recovery process at all; it's a reason you need account recovery.

To get a general sense of where we're at as an industry with this, look at the process for what happens when you lose an AWS 2FA secret:

https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credenti...
NIMBY is just one kind of activist. We live in the age of the "tyranny of the tiny minority" where a small number of passionate people have their already-loud voices so amplified by the media that they drown out everything else. Social media tends to make extremes go viral, and traditional media looks for controversy and amplifies it.

Nuanced messaging and debate is a thing of the past. It doesn't fit in tweets and sound bites. Now, if you disagree with me, easier for me just to say you're evil than try to rebut your points. And this in turn feeds the media amplification effect. Who has the most emotionally compelling narrative? Who can parade out the most horrifying pictures? It doesn't matter if they're from a completely unrelated incident two years ago (and were staged), or that the "victims" are paid activists.

"Politician" is now a career. This means perverse incentives for such people; instead of ONLY considering what is best for constituents. They must also think about getting reelected.

Bureaucracies and government careers make decision-makers risk-averse, and most people react to having to make risky decisions by wanting more study before deciding. So the politicians and the bureaucrats only have up-side to accepting delays (they would call it "listening to constituents"), and suffer a huge risk of down-side if they green-light something that ticks off some noisy NIMBY or activist. And they rarely have the skill set or incentives to write contracts that result in the best outcomes.

The article talks about the perverse incentives associated with unions; these are only made worse with public sector unions.

Finally, our courts don't have loser pays and no longer are "speedy" by any reasonable definition. So you can tie things up for years with an activist lawyer on your staff, and make your opponent spend millions in legal fees to respond to all your noise. Plus, if you get lucky with a jury of people who don't understand the science of your issues and just buy the narrative, then you can win really big.

We need a lot of reforms in our republic. Most of them center around removing perverse incentives and externalities.
Wow !
Great idea !
Great product !
I’m in
I don't think I'd put it that way. For the average NIMBY their friends and social circle are often suffering or benefiting from the same projects as them and from the inside it feels more like protecting their community than protecting themselves. But of course a community is just as much defined by who is outside it as who is inside.
I've found that SSR is generally quite slow. If you're using it, you'd want a CDN or some other caching layer in front of your server so you don't need to render each page server-side.
A lot of armchair scientists in the comments. It's quite striking effect but why is it published on IOS press? Looks like there might be more worth exploring in that dataset. What are the ways in which their result could be an artifact?
Stateful Workloads on Kubernetes Are a Thing, but There Is a Twist
I've been using the beta for a bit, it's a great tool, amazingly seamless streaming experience.
In SF people could read up on the history of the Embarcadero Freeway. It took a half a century and the Loma Prieta earthquake to work through all that.

https://medium.com/@UpOutSF/old-san-francisco-a-look-at-befo...

https://www.sfchronicle.com/projects/2022/visuals/san-franci...
only suggest improvements, and provide reasons if possible, never tell anyone they should do something in a certain way unless it’s an obvious bug. I fucking hate know it alls that confuse their opinions and preferences with some absolute truth.
If you have identical field names, you can do in sql:

Select * from a join b using (a_id)

Don't do this in Oracle though, pain follows when you try to touch an a_id column.
Personally, I've never understood why first to publish matters? As far as I can tell, the only people who care are other journalists, who seem to think that any story about a breaking news item MUST credit the person who wrote about it first (see: ESPN's NBA and NFL "insiders").
Why? A poster suggested geo-context was «needed», to which was noted that said information is present in an expectable place. The "homework" of translating '.lk' is one click away.
So if 100% of uninsured people have taken out credit card debt for insulin, merely 60% of insured people have! That doesn’t sound much better.
You may not have had memories of very cheap toys in the 60's and 70's that had a "made in china" stamp on them. Back before any of this modern world, China was the source for extremally cheap, low quality products.
> As a developer, I don’t see a situation where I need the whole codebase, just the portion I work with.

Unless you are very special/lucky then your code will need all sorts of the repo to work.

One of the joys of working at a big tech company with a single repo is just how much shit is pulled in by your dependencies.

my code shouldn't need a custom C++ library that does BLAS 0.15% more efficiently than the opensource lib, its just moving data from one bucket to another. However, it does because of a massive chain of dependencies.

> State actors have security clearances for employees with equipment that allows them to contain state secrets on devices

What level of secret? and how many secrets? all of them? No. Security services don't generally allow people to store secrets on mobile devices, because they get lost a lot. They certainly don't allow all secrets ever stored in the DB to be carted around on >70k employee's laptops (of which at least 1 a day is stolen, most often in sleep so the disk encryption key still accessible)

Thats not to say that low-side devices don't ever contain secrets. They clearly do, but they are supposedly risk managed to limit the blast radius. ie, they need to have a good reason to have that secret, a time till destruction, and clear paper trail to see where and when that secret went.

Thats not really scalable to a repo with > 5 million files.
A Path Towards Autonomous Machine Intelligence
The problem is that some folks insist that “we can’t inconvenience automobile users until public transit is perfect” and others say “we can’t justify investing in transit unless way more people start using it”.
Environmental laws/regulations, Cheaper building costs, Chinese speed of building. Pick only 2.
Basically anything were you want to update data locally on different devices then sync. Or any multi-database system where you want all nodes to accept writes. In these scenarios there will be conflicts.
Because we need to rely on new people financing the economy with money we don't have yet because it is all gone up in smoke.
I stopped using buses and trams in the US out of fear for my personal safety. I'm not going to wear a bulletproof vest and carrying a handgun concealed just to get around town. Now I drive between safer areas to do things and meet people and don't have to put myself in danger by exposing myself in the in-between areas. A metal box goes a long way to prevent an assault. The whole situation is just pathetic.
Why is facebook using GPT-3? Generate fake content it wants to push out?
Pratchett?
The Cape Wind project, which was going to be the US's first offshore wind farm, was famously killed by wealthy and powerful people worried about their views with environmental causes as a pretext. I think that bureaucratic review could be much better than the current case of "anybody wealthy enough can sue to stop the project" but that would have required spending money spinning up the department when the law was introduced and relying on lawsuits from the public looks free.

EDIT: And of course recently fossil power interests were able to stop some power lines to bring hydro electricity in from Canada.
You can retain foreign key constraints by having one column per type of reference. It is also possible to ensure that exactly one column of several is NOT NULL, so that the columns can always be mapped to an enum in application code. Also, in PostgreSQL, the storage for the extra NULLs uses just one bit per column in a bitmap.

CREATE TABLE dirents (
parent bigint NOT NULL,
child_dir bigint,
child_file bigint,
child_symlink bigint,
basename text NOT NULL,

-- Ensure exactly one type of child is set
CHECK (num_nonnulls(child_dir, child_file, child_symlink) = 1),

CONSTRAINT dirents_child_dir_fkey FOREIGN KEY (child_dir) REFERENCES dirs (id),
CONSTRAINT dirents_child_file_fkey FOREIGN KEY (child_file) REFERENCES files (id),
CONSTRAINT dirents_child_symlink_fkey FOREIGN KEY (child_symlink) REFERENCES symlinks (id),

PRIMARY KEY (parent, basename)
);
You're right when framed within the context of the Apple ecosystem. I was merely making the point that Chrome's dominance is not based on merit (alone).

It's a lie, and a very relevant one. If Apple were to open up browser competition on iOS, Google can/will use their enormous reach to destroy the "last man standing"...Safari.

I'm not at all defending Apple, I'm merely pointing out that even if for selfish reasons, iOS Safari truly is the last browser in existence that acts as a counter force against Google doing whatever the hell they want regarding the web and web standards. It's a perverted dynamic, but a lack of competition has an upside here.

The downside is that this reduced competition means the gap with native apps can't be closed. I consider that to be a massive stake too. Even within Google there's friction between the Android and Chrome teams regarding this matter. The incentives are really complex.
Australia's gun laws allow pump/lever/bolt action rifles for hunting along with shotguns for rural home defense (primary producers and farm workers can buy pump shotguns). Pistols and anything semiautomatic are mostly restricted to occupations that require them. There's also exceptions for sport shooters, so rural people can start an organized gun club and actively train in order to own shotguns or pistols (a "well-regulated militia"?). This means, though, that an 18 year old is only going to be able to buy a bolt action rifle without coming under some extra scrutiny of having to join a sport shooting club.
> Perusing this map, Richard Hanania remarks

Record-scratch: I associate that name with dumb twitter takes
I tend to be overly “nice” in code reviews and phrase things more like suggestions and provide some justification for them:

> have you considered x? It is standard practice in y to do z.

> should we do x instead? I think it would be better in the long run because y.

If there is a more serious issue, I prefer DMing the author and hashing things out synchronously.

I think it is important to phrase things gently as much as possible, as tone is hard to read from text, and being overly harsh might discourage other teammates from taking risks and asking for feedback.
I'm not sure if it is the case that there is a commitment to nuclear family structure as it seems things are trending even further towards the atomized scale with more single parent households and many people delaying marriage and a family or even going child free.

I can't speak for elsewhere, but American society seems to incentivize against the factors that allow for high fertility. I think it is also apparent in Asia with the Sampo/ Satori generation phenomenon in Korea and Japan respectively.
And if I were a man, there's no way I would just let a house become marital property if I owned it outright before the marriage, especially considering how family courts screw men over.

That's a surefire way to homelessness, unless you are very (SV engineer or doctor) rich.
> It will be intimate con artistry at scale driven by big data, a massive DDOS attack on human cognition and our ability to conduct any form of honest discourse.

This is an unfounded fear. For one thing, if the value in doing this is high then it's already cheap enough to be practical. The Chinese govt can pay millions of people to do this to dozens of people each. They basically do this already, for specific topics and issues. LLMs won't significantly move the needle here.

Second, are you proposing that attempts to stop Facebook from releasing models will somehow slow down or stop the Chinese, US, or Russian governments? What's the goal, to buy us 6 months? I would much rather the technology be out in the open for everyone to research and understand vs accessible only to state actors or huge tech companies.
Self-driving race car crashes straight into a wall from the starting line during the world's first autonomous race series: https://www.youtube.com/watch?v=x4fdUx6d4QM
On the brink of ruin, Juul files emergency petition to fight FDA ban
Ah, apologies, it seemed like you were accidentally conflating the two. Thanks for clarifying!
The concept sounds good in theory, but I think it's going to be nigh unworkable in practice. The NCLB/high-stakes testing era exposed many problems with tying educator pay to student outcomes -- chief among them that student outcomes didn't improve.
I thought my friends installing smart speakers I feel compelled to unplug was annoying...you're my worst nightmare!
> Could not wrap my head around it ...

The First Amendment means that there has to be extraordinary proof of direct and immediate harm before the government will step in and stop speech. Note I'm referring to the the prescription drug ads (which actually are pity heavily regulated - they have to be very careful what they claim), not the quack cures. The quack stuff is typically illegal as it's being described in TFA, but it's international, and the FDA/FTC would have trouble enforcing an action against a Mexican hospital.
Ask HN: What to buy/visit when in SF?
Hi, I am in a SF for a week from europe and I thinking what can I find only or mostly in SF, including non expensive experiences, something bit less known.

I am interested in practical things related to tech, everyday and health. So:
- darn tough socks
- cabin backpack like minaal, aer travel or similar
- supplements - magic mind, cocoavia
- maybe some tech like oura ring (which is much cheaper here)
- try Cafe X, go to The Interval at Long Now

Any recommendation are highly appreciated thanks
> a dirty read occurs when you perform a read, and another transaction updates the same row but doesn't commit the work, you perform another read, and you can access the uncommitted (dirty) value

It's even worse than this with MS SQL Server. When using the READ UNCOMMITTED isolation level it's actually possible to read corrupted data, e.g. you might read a string while it's being updated, so the result row you get contains a mix of the old value and new value of the column. SQL Server essentially does the "we got a badass over here" Neil deGrasse Tyson meme and throws data at you as fast as it can. Unfortunately I've worked on several projects where someone apparently thought that READ UNCOMMITTED was a magic "go fast" button for SQL and used it all throughout the app.
I believe it means being in a state of mind where you ignore new data and and don't update beliefs because you are sick of contemplating some issue.
I increasingly get the feeling that the only winning move is to not play. I have no idea how we got to this point either.
Well I definitely wasn't talking about people like Timnit but rather researchers like Stuart Russell who actually are at the forefront of the field and discuss AI safety broadly.
Which could be pretty easily done in some locations by making more expensive copies of the same transit (think "express" busses that are double the cost vs the once an hour bus that is cheap or free).

Then the people who care about it (read: not poor) will pay to ride the bum-free version, and then more people will use it, and it will begin to improve.

Of course, that cannot be done because then it's called "making the poor version crappy" and so everyone is forced to use the crappy version and it remains crappy forever.
I’m on the latest production iOS, not a beta version, and the video on this page loads fine: https://en.m.wikipedia.org/wiki/WebM
It's actually the same, you watch others not to excersize but to improve your technique
we need planning, not just building
No problem. (I didn't downvote.)
Yes, that's what I meant by "not sure about the reverse".
Support-a-Creator Program
After Epic Games’s complaints about the Apple App Store fees, they’ve announced they’ll be charging 95%:

> An Epic Games Store example: if your supporters purchase $100 of games, you’ll earn $5 (at the base Epic-funded rate).
Are you sure it's not in your ability? Whenever I introduced something like that people were in general indifferent-to-happy, as long as you did the majority of the job and they could somewhat easily run those tools (e.g. anything written in Java is more or less a lost cause because people cling to their IDEs)
Part of my question would be how to deal with the pyramid. The pyramid should get less pronounced as time goes on as birth rates normalize. Basic human needs industries like clothing, food and shelter should't need that many people to support the retired. Health care may need some intervention.

I guess part of the problem is maybe some of this is too much like socialism and/or being able to give non-working persons actual dollars.
You should read BotNS
That's an unmakable book.

Also one of the best experiences of my life for sure. But I did it by following an podcast chapter by chapter analysis (Alzabo Soup)
match/case is similar to other languages. Walrus is just assignment-as-an-expression. The subtleties of dict mergining don't matter 99% of the time. Type annotations are great and not hard to learn.
>There are quite a few comments in this thread already jumping on the 'correlation != causation' train.

Complaining about correlation not being causation is the perfect theme for the midwit meme. It's one of my pet peeves.
You know what's better than one click? Zero clicks. My time is a precious commodity.
You need to get a poll of people who will vote in the next election should this pass, and a different poll for people who will vote in the next election should this fail to pass. Note that different people will show up should this pass vs not pass, and it is people who turn up on election day that matter (show up means their ballot is counted, absentee ballots count as showing up)

This is very different from statistical polling.
True. If you want true load balancing, you need a layer 3 solution (BGP.)
EuroLLVM 2022: LLVM-MOS 6502 Back end: Having a Blast in the Past [video]
Wiki: https://llvm-mos.org
GitHub: https://github.com/llvm-mos/llvm-mos-sdk
Slides: https://llvm.org/devmtg/2022-05/slides/2022EuroLLVM-LLVM-MOS...