skysight-inc/HackerNews huggingface dataset:
> VCS for stored procedures and views is usually non existent

This is a mindset problem, not a technology problem. Treat your stored procedures/functions/views like code, not like data. Keep a separate "code" schema, put your procedures/functions/views definitions in files, and store your files in Git, just like Java or Ruby code. Deployment then becomes an automated drop and recreate of the code schema in a single transaction with zero downtime.

> Deploying application logic alongside these systems is very painful

This is not my experience at all. The stored procedures form an API. If changing the API breaks your application, you are doing something fundamentally wrong. API versioning should only be necessary if third parties depend on your API, but I wouldn't recommend giving third parties direct access to the database anyway.

> Once you have complex enough stored procedures, modifying the data changes things in unexpected or unintended ways

I assume you mean triggers because stored procedures don't happen as side effects, you have to call them explicitly. Regarding triggers, I agree with everything you say.
I think the relevant wording here is "problem of induction". You can generate evidence at will and meetn any threshold of evidence for the statement "all swans are white". Anyone can perform the experiment by traveling around the northern hemisphere and find millions of white swans.

It would still be silly to call that statement a fact, because it only requires a single swan sighting in Australia to falsify it.
It sounds like the authorities where you live should have a look at not just the history curriculum but the rest as well. Slavery is very much a contemporary issue and it's been around, globally, since times that predate written history.
Not a Julia user, but this looks great!
Their bank accounts were frozen for torturing Ottawa downtown residents and lawlessness that ensued. Not for protesting lockdowns.
Autopsies Show Covid-19 in the Brain
I have 4 ThinkPads with Nvidia GPUs on my desk now and none had driver issues in Ubuntu, they all work out of the box.
Oh nice! That's def one of my favorites.

I think you'd like Kafka on the Shore next.

And you'll see a lot of hype around Norwegian wood and it is solid, it's not "fantastic" so if you pick it up you might be surprised/disappointed.

I'll also give a rec to a slightly off the beaten path book I read this year Speculative Japan: Outstanding Tales of Japanese Science Fiction and Fantasy

It's interesting as these are works that would have absolutely influenced Murakami's writing. (First story is gruesome but the rest are not)
If the foreign key column is also that table’s primary key (or just has a unique constraint), then that’s not 1:N, it’s 1:1 or 1:0.
Compiler Diagnostics
Invoking evolutionary biology is not the strong point you seem to think it is. Humans have plenty of characteristics and behaviours that are not present in other mammals, even characteristics that seem to be shared among all other mammals. Our shared heritage with cats didn't lead to our sophisticated language or take us to the moon.

Furthermore, if letting babies cry it out were truly as atrocious a practice as you seem to imply, the signal in the data would be so strong it would be impossible to ignore. The fact that we don't see such an indisputable signal should make you question your assumptions.

> ...that those farts have been causing pain in his abdomen or scrotum. Its amazing how it did not occur to you and instead you let the kid to just 'go through' it.

You seem to be implying that this was somehow wrong. Human newborns need to experience a range of sensations and discomfort to learn how to distinguish what counts as actual pain from mere discomfort. This still happens even into adulthood. Exercise is borderline painful when you're out of shape and then can become pleasurable as your fitness improves. Your brain is constantly adapting and recalibrating.
Since most reals are not either even and odd, I don’t know why you find the extended reals the more likely interpretation of “infinity” in the context of that question. In any case, the GGP objected to infinity being a number, but however you slice it, it is either an ordinal or cardinal number. And the GGGGP claimed that infinity is both even and odd, but however you slice it, it is at most one of those. I found it being either even or odd, as in the ordinals, more interesting, that’s why I gave that link.
https://docs.oracle.com/javase/7/docs/api/java/util/regex/pa...

pcre has always had java and scala support.
>The constant hurling of these claims also causes people to adopt distorted views about the nature of human disagreement itself. Most disagreement — or most interesting disagreement — can’t be explained solely by the fact that one side is better or smarter or more accurately informed than the other.

After reading _The Righteous Mind_, this is something Jonathan Haidt's book drilled down on me. The book focuses on the political and religious divide in the US primarily, and his Moral Foundation Theory shines some light on the issue: In the case of conservatives vs liberals, their moral matrices are vastly different and that's a recipe for disagreement.

In Moral Foundation Theory [1], Haidt and a group of social psychologists seek to understand the variability of morality across cultures. Despite this variability, they find there are similarities and recurrent themes. They think there at least are six foundations: 1) Harm/care, 2) Fairness/cheating, 3) Loyalty/betraying, 4) Authority/subversion, 5) Sanctity/degradation, and 6) Liberty/oppression.

According to Haidt, liberals (aka leftists, Haidt uses "libertarians" for "classical liberals") respond extremely to the harm/care and liberty/opression foundations, however conservatives do not respond to these foundations as well. In fact, conservatives respond to all the foundations by the same degree while liberals respond to only two foundations. Both liberals and conservatives respond to liberty/oppression but they approach it differently.

[1]: https://moralfoundations.org/
For questions about TeXmacs please try the forum at http://forum.texmacs.cn/
If I were Tim Apple and wanted to donate a machine to particular projects; anonymously through an engineer or lawyer is exactly how I’d do it. Having it be known that Apple is a hardass and gives nothing helps keep the noise down.
Avoid outer joins.
Huawei Says It Is Out of ‘Crisis Mode’ as Annual Revenue Stabilized
> "Generate additional evidence at will" when applied to the "scientific fact that atoms exist" means that any new experiment that you design and perform will be compatible to that fact. There is no evidence whatsoever that atoms (at their "level of abstraction") do not exist.

You're describing certainty. This is a prediction, not reality. A new experiment you design and perform might not be compatible with the existence of atoms; that's the whole point of running experiments! (Of course, I have the same prediction; the proton-neutron-electron theory of atoms seems like a pretty solid one, at this point.)

Certainty does have interesting properties, from a Bayesian perspective: if you are certain of something, there is no finite amount of evidence that'll convince you otherwise. (Of course, humans aren't ideal Bayesian reasoners; you can usually provide enough evidence to convince a certain person otherwise, if they are actually wrong.)
4126 pages long Federal Spending Bill 2023 [pdf]
While I think even twice that is more than a bit optimistic, this story was claiming a target price of $2m/launch: https://www.space.com/spacex-starship-flight-passenger-cost-...

But even at $100m/launch, a big fat copper wire (IIRC aluminium is better per unit mass) would still make more sense than shipping up a nuclear reactor or a huge pile of batteries, and that part of this hypothetical mission would still be about 80% cheaper than the JWST.
Yugabyte DB vs. PostgreSQL vs. Cassandra vs. MongoDB
But you are talking about 1:0..1 which is different from plain 1:1 relationships.
I read the book a while back and realized I do the caching one automatically. I have a pretty messy work bench where I build rockets and play around with microcontrollers. I purposely didn’t try to organize it because, over time, it organizes itself. All the stuff that has my attention gradually drifts to arms reach where the stuff I don’t currently need gradually drifts to the back of the workbench.

Edit: the stopping and explore/exploit chapters mirror my career too
This one is expected a bit earlier because Zen 4 is more like bigger Zen 3 on a new platform than a new architecture
> Linux kernel is written in C

Not exclusively in C, not anymore: https://docs.kernel.org/rust/index.html

It might take another decade for a C-free build to be possible, though.
Wow that StarFighter looks awesome! Too bad about the lack of trackpoint though.

I wonder if they'll come out with an ARM model. Open source OS's are in a good position to take advantage of alternate CPU architectures.
Love my Thinkpad T15G:
- No major issues in Manjaro

- discrete graphics (3080 mobile).
Using the proprietary driver, graphics switching seems to work pretty well.

- 128gb ECC ram (has xeon 11xxxm)

- durable; survived around 45 flights; runs 120 hours a week.

- trackpoint!

- fits into a normal backpack

- the hulking mass builds core strength while traveling

Cons:
- Battery "life" is more like insurance against yoinking the charger.

- don't leave on lap under heavy load if you're a male hoping to maintain fertility

- not really easy to clean and keep clean; something about the rubberized finish gets noticeably dirty after a few hours of use following a thorough scrub, but I might also be a bit oilier than the average duck.

Aesthetically it's just the right amount of boring, but I know most like something a little sleeker.

Edit: formatting and additional con: Lenovo pricing is obscene without playing games using coupons, corporate portals, etc.
That’s pretty much exactly what unique constraints are for. Why do you consider that a hack?
FS 400Gbase-SR8 400GbE QSFP-DD Optical Transceiver Review
> I feel that it would probably be called leftist, since more leftist viewpoints seem to be science based than rightist ones (especially in the US).

That attitude is likely why ChatGPT has left-leaning answers, given the difficulty some have distinguishing between value judgments and empirical facts.

As a quick test, I asked ChatGPT to compare Sweden's response to COVID-19 with the United State's. As an empirical measure, Sweden fared better in terms of case-fatality rate, though not astonishingly so (indeed, the heavy-handed lockdowns in Australia seem to have been effective when removing moral considerations).

Here's how ChatGPT concluded:

> It is difficult to compare the effectiveness of the two approaches, as both countries have experienced significant levels of COVID-19 cases and deaths. However, Sweden's approach has been controversial, with some critics arguing that it has resulted in a higher number of cases and deaths than would have occurred with a more stringent lockdown.

I would categorize this as a left-wing response: it claims the comparison is "difficult," while hinting that Sweden's response is "controversial" compared to the US's.

ChatGPT made other errors, such as insisting that the American response was federally-coordinated, when it was in reality implemented at the state level with only "guidelines" coming from the top. It also called Sweden's central government "federal," even though Sweden is a unitary state.

Anyway, my experience is that facts are truly stubborn things, often disappointing ideologues of all stripes.

EDIT: my example may be partly worthless given that ChatGPT's training corpus ends in 2021.
I wouldn't be surprised if Elon Musk's next move to p0wn the libs was to develop his own version of "Free Speech" MAGA-GPT that has absolutely no inhibitions about saying hateful racist antisemitic sexist shit, trained on all the tweets of the people he let back on Twitter.

But it would probably be so thin skinned and narcissistic that if you said anything remotely insulting to it or about Elon or Tesla or SpaceX or Donald Trump or Larry Ellison or any of his other companies or friends, it would retort by childishly insulting you, calling you a pedo, then banning you.
I'm on a 5 gen X1 Carbon and the luxurious cover has started peeling off, making it noticeably less luxurious...
That's what I want too.

To make a loose metaphor, if SQL is like high level opengl, then I want the low level Vulkan and shader APIs for hand optimization.

I would like this especially for Apache Spark sql, since a bad plan that isn't aware of the data shape can blow gigabytes over the network unnecessarily.
I don't know. It's one of those based on hearing concerns (and now I'm spreading them, I'm sorry..), can't quantify
The problem is you go from "the Canadian federal government passed an emergency order using powers in existing legislation to disperse protesters by going after the bank accounts" to "a study funded by the U of Calgary is therefore untrustworthy because Canada is an authoritarian state".

I am in Canada. I'm rather disturbed by the actions against the protesters, but short of inciting violent revolution or a race riot, I literally cannot think of many things I do not feel free to say. As a Canadian, I'm also aware that the University of Calgary is an independent organization established under legislation, and funded by an entirely different sovereign government, that of Alberta. I'm also aware that Alberta, and Albertans, and hell, several academics at the University of Calgary, have been somewhat critical of the federal government's response overall with COVID. The province is run by political conservatives. The very last thing they would tolerate is the federal government mucking around in provincially-run institutions like it seems you are implicitly alleging.

There's a good number of steps between your A and B that you've hand-waved away as if they're obvious, but they're really not to me. How does the federal government's actions lead to this study being untrustworthy or false?
Isn't it supposed to reduce the severity if you do get the flu?
Agreed. Gravity is a theory. An apple fell on my head is a fact.
I thought he was holding the burnt out bulb.
Could it be something with European privacy laws for storing data?

I wish we could just buy licenses sometimes ... I really hate fucking around with procurement processes
On Flaw No. 5: Dismissive treatment of jurisdictional norms...

I like this, it's a feature not a bug. Why:

First, because it's pretty standard for many countries to try to enforce the law beyond it's own borders. The US is particularly (in)famous for this but others do it as well. Why should the EU be an exception? And you are free not to, just don't process the information of EU citizens. And if you do fuck it up, that's ok too because GDPR is aimed at organisations. It has no ability to extradite and imprison people.

Second, information knows no borders. It is actually quite hard to tell where information is actually being stored. Just look at the struggles around cloud providers assuring data is NOT transferred internationally. So a GDPR that only applied within the EU geographical borders would be useless: bad actors abroad would continue to abuse the rights of EU citizens. And worse: People might actively transfer data OUT of the EU purely to misuse it with impunity. That would both defeat GDPR AND punish good actors.
Of course I'm aware of that technique and I've used it many times. :-) Doesn't change what I said.
I'm quite happy with my HP Spectre X360 running LinuxMint 20. Everything works fine.
Wow that sounds fantastically optimistic, or pessimistic depending on your point of view I guess.

Rewriting that amount of code in ten years sounds very very hard, at least.
And also, IRS is adjusted gross income, not income.
Load the dirty dishes and pans into the dishwasher as soon as finished using them. Turn the dishwasher on before going to bed. Take out the clean dishes first thing in the morning.

This is a pretty standard algorithm, I suppose. What is somewhat unusual, I guess, is that, occasionally, I use the dishwasher to wash small appliances like a rice cooker, an electric kettle, or a water filter pitcher. It probably shortens their lifespan but I think it's worth the saved time.
C syntax is already way too rich and complex, not to mention the bazillions of gcc extensions required to compile the linux kernel.

Namely, if it has to be "replaced", that would be with something with a much simpler syntax, which will require a bit more of finger power. We don't want to find ourself locked-in by very few compiler vendors (open source or not), that only because it is not reasonable to code a real-life alternative with a small team of averagely skilled devs in a reasonable amount of time.

This language should build on C though: no enum/typedef/_generic/switch/etc, only 1 loop keyword (loop{}) only explicit sized types, no integer promotion, no implicit casts (except maybe void* pointers but number literal casts should be) but explicit casts (compile-time and runtime, without that horrible c++ syntax), explicit compile-time const (we have only runtime consts which could be optimized as compile-time consts), enforce extern for functions (and don't try to put the binary format, elf/coff/etc, semantics into the language syntax or worse, the OS interface semantics), etc.

With enough discipline (and compiler warnings), we could get close to such language.

I did not check the latest and greatest rust syntax, but is what's above its explicit goals?

That said, I am a "everything in 64bits RISC-V assembly with x86_64/arm64 legacy ports kind of guy"... if RISC-V is successful (I wish). We could think of high-level language interpreters (coded in assembly, for instance a RISC-V coded python/lua/javascript/etc interpreters).
>Which experts/authorities need to be held to account?

As of more recently, I think Dr. Fauci should be held accountable for lying to the American public in the last two years, from the effectiveness of masks to the effectiveness of the CV vaccines to the effectiveness of mandates to crowning himself as the herald of science (e.g., paraphrasing "if you disagree with me, you disagree with science").
Bexause they don't want to. its that simple.

Any time you see a behemoth like Apple not doing something it's because they don't want to.

They don't consider whatever gains they get from it to be worth the time and money.
So where is the problem?
Only a decade? I don't think so.

AFAIK Torvalds has also stipulated that any Rust code needs to be mirrored in C.
For what it’s worth, I’ve only heard this term in my (American) culture for the past 5 or so years.

My first exposure to the term was via internet memes where “mouth breathing” was conveyed as existing only with those who were mentally impaired. Check out the Urban Dictionary link someone else responded to you with in a different comment thread for more context.

I don’t recall ever hearing anything about “mouth breathing” in my society/culture/subculture before exposure to these memes, so I wonder if it’s a newer thing? If so, silly memes really are influencing our culture!
> Also the responsibility to do good journalism lies with the journalist and their publication, not the game company (the game company cannot objectively cover their own game anyhow). That was a mistake the gamergaters made a lot, and further damaged their credibility.

There’s definitely room to blame both - just as it’s wrong to offer a bribe even if it’s not accepted - but I think it was quite telling how the mob just wasn’t interested in that. There’s probably an interesting story about power gradients and how large companies can manipulate reviews to their advantage by withholding access - similar to how the car review industry works - but it just wasn’t what people were there for.
Washing machines are relatively cheap when considered over the time used - I’m seriously considering getting an additional pair for convenience.

Some of the newer ones have a tiny wash machine stuck to the larger one but I’m not quite convinced yet.
It's scary how many people don't know the difference between raw data statistics (which are almost always worthless) and a multivariate regression with control variables (which can actually tell you something about the data). Everyone can read a paper and look at numbers, but to understand what is really happening you do need some formal education that most people simply seem to lack. Even people with this kind of education sometimes step into pitfalls, but normal people drawing conclusions from these things is like running through a minefield while blindfolded.
I didn't want this to come across as a snarky comment, sorry if it did! And it's true that that's not a definite answer, but it made me imply that the "license" page is the way to go.
Oh, I'm not debating the impact such a decision has on users, but rather on development experience and ops.

> schema-less distributed database instead of saved to file

I was actually going to suggest SQLite.
Carlsen Wins World Blitz Championship, Assaubayeva Defends Women's Title
Excellent, thank you!

[EDIT:] Although this doesn't exactly do what I want - there's a "Best Comments" feed, but not the regular front page feed as links to comments instead of the original pages, and the "Frontpage" feed doesn't immediately show the individual HN article pages in my RSS reader. I'll look into contributing to hnrss.github.io, though.
I forgot about 6NF which I consider non-canonical fan-fiction. As far as I understand it is only useful in the context of data-warehouses.

But the other normal forms reduce redundancy which is what makes inconsistencies possible.
Some notes to myself on 'Git log -G' (and sort of on -S)
Ah yes the old X is friends with Y and they are all the same.
This works surprisingly well if you have one or two people who regularly use the same dishes. It works horribly badly if you have a family that greatly varies what they use - but the trick then is nobody will arrest you if you wash a clean dish.
"However, vaccination was associated with a reduced risk of stroke overall across all ages and risk profiles with the exception of individuals without hypertension."

https://www.thelancet.com/journals/lanpub/article/PIIS2468-2...

ROFL So, if you are normal (un)healthy person and you DON'T HAVE HYPERTENSION then this amazing flu vaccine won't lower your risk of stroke at all, this study applies only to people with hypertension.
QQ, when I go running or exercising hard, I always end up mouth breathing. Is it harmful in this context?
All of your examples are after 2016, none of them refutes the GP’s point —- Herb Kelleher’s time as CEO ended in 2001. He resigned from the board in 2009. Blaming him for SW’s recent issues is stretching it.

Recall when Satya Nadella was hailed as Microsoft’s savior only a couple years after becoming CEO? That is how quickly a new leader can have an impact. SW’s network has expanded significantly since Herb Kelleher’s time, it’s hardly his fault its IT can’t keep up.
Z-Library, while larger than LibGen, is still very incomplete as well.
Definitely yes. Parents tell their kids to "close their mouth" etc. Being seen in public with your mouth open is seen as impolite/a sign of some mental issues.
It matters less often - it can still matter at the end of each write buffer. Larger write-buffers remove a lot of chances for this to happen.

If the application can buffer the entire file or use sendfile, probably best to disable Nagle's algorithm so the last packet goes out immediately. Nginx does this.

Another option is turning off Nagle's algorithm at the end of each transfer, and on at the start of the next, but this causes extra syscalls.
Wait toothbrushes are a concern?