skysight-inc/HackerNews huggingface dataset:
> Fetching the right rows for all of them at once using joins and where conditions (+temporary tables and multiple return sets in the same query roundtrip) is going to be more efficient for the DB than the backend first fetching the type, then branching on type, then fetching from another table and so on.

Nope, not if done correctly.

Now, this isn't to say there's not valid reasons to do it all at once in the DB, the chief among them being ACID requirements. However, from an efficiency standpoint both for the application and the DB the most efficient action is to first request from the parent table and then turn around and, in parallel, send out requests for the child tables of the various types as needed.

Assuming you have a connection pool, the overhead of doing multiple requests in parallel is small. The DB has less data to lookup. The DB has less temporary memory to store (which in our case was a problem). The response io is smaller (not a bunch of empty columns sent back) and both the DB and the downstream application are capable of querying against these tables in parallel.

There is a latency downside in needing the load up the parent table first, if the datasize is large enough then you could overcome that problem by making batch requests to the DB as the parent dataset comes back. Say every 1k values of a given type start the parallel request to load that data.

Splitting the request into these smaller and parallel requests also has systemic benefits to the DB, new writers are able to sneak in which isn't possible when you try to do everything at one go (another issue we had).

The added benefit here is the optimizer in the DB is more likely to do the right thing for the subtable requests than it is for the temp table mess request. A simple fetch is far easier to optimize than a complex one.
This: https://compasse.aas.org/aas-releases-a-compasse-led-stateme...
Yes, Cloudflare does that but they don't hand out blocks of dedicated IPs to low paying customers. IIRC you need to be on a contract instead of a monthly plan which is typically a big price increase.
Worth mentioning photoprim, if you maintain photos on local hardware, nas, etc.

https://www.photoprism.app/
> The USSR was going to invent some pretext or other anyway, that was simply the chosen one.

I've little knowledge of Russian mental health facilities. If I were to imagine the worst, I'd put them against FL's 5 state institutions - which are true hellholes. There is a long history of patients and staff dying there.

They're beyond full and understaffed. There's no room to add anyone.

What's more common are private care facilities and the VA. Both of which I have a fair amount of experience with, while caring for my spouse.

They can be quite good. Private inpatient facilities are mostly unavailable for the uninsured though.

I'd comment on fully public, inpatient, mental healthcare facilities but I don't know of any in the SE. I've looked.
It’s not exactly an outlier among the many arguments.
I don't see how this is going to work.

Rewards cards already bribe me at 2% (and there are better offers). Big merchants often offer a store card, sometimes a store card that's also a general use card, but they typically bribe people with 5%.
That's a very reductive and limited way to look at art. You're right in stating it as decoration but I would not conflate the two. Different things, both valuable in its own right.
Perspective is strange. I suspect we're not far from a time when a show such as the Brady Bunch will be as bizarre to the modern mind as the most severe Twilight Zone episode was in its time.
If they aren't worried about some backlash for hiring a person arrested for domestic violence, then why would they pick another? If there's no potential for backlash, then there's no reason to avoid them or pick "other options".
> Apart from fuel efficiency improvements

Those have been huge, and are a primary driver for new airplane designs. The reason is simple. Back in the 80s, fuel was 40% of the operating cost.

The 757 came about because of new, more efficient engines and a more efficient wing. If my brain hasn't fully rotted away yet, it offered a 35% reduction in fuel costs.

The 737MAX was green-lighted because it offered a 15% improvement in fuel consumption. That's Big Money for the airlines.
> The beauty of the MOE model approach is that you can decompose the big model into a collection of smaller models that each know different, non-overlapping (at least fully) pieces of knowledge.

I was under the impression that this was not how MoE models work. They are not a collection of independent models, but instead a way of routing to a subset of active parameters at each layer. There is no "expert" that is loaded or unloaded per question. All of the weights are loaded in VRAM, its just a matter of which are actually loaded to the registers for calculation. As far as I could tell from the Deepseek v3/v2 papers, their MoE approach follows this instead of being an explicit collection of experts. If thats the case, theres no VRAM saving to be had using an MOE nor an ability to extract the weights of the expert to run locally (aside from distillation or similar).

If there is someone more versed on the construction of MoE architectures I would love some help understanding what I missed here.
Causality itself is a complex philosophical topic. I agree it probably can’t be established.

That’s why death reportings tend to use “died with X”. I understand that there is a sensitivity to ascribe liability or fault. But if someone dies in recovery from a surgery, or worse under anesthesia, that seems like something that could be identified and reported.
> individuals feeling empowered to advocate for their safety and treatment

To butcher a Rick & Morty quote, "that just sounds like malpractice with extra steps".
Rather than regulate crypto, it might have been better to not elect him in the first place.
It’s funny because they didn’t actually defund them.

That would have saved taxpayer money, and allowing second order positive effects like that would prevent it from being an unmitigated disaster.
Mortality is taken over the population as a whole. You want the case fatality rate (probability of death if you're infected), which in the US is 7-9%. Globally, some countries have TB case rates >30%.

TB is a very ancient, very scary disease that's co-evolved with us. It's not much of an exaggeration to say that large parts of modern medicine were invented specifically to get a handle on TB because it has historically ravaged entire populations when left untreated.
> There are enough Wayland whiners that, by now, they could've banded together and started maintaining / improving X and (if their complaints and theories were correct) left Wayland behind.

They already have. X is already more full-featured and stable than Wayland (yes it is missing certain niche features that Wayland has). Sometimes the most important thing you can do with a piece of software is not screw around with it.
I agree, the emphasis probably should be on “recorded”, not “largest”.
The death of the high school essay will be when people realize best learning is done on the job and we get rid of highschools altogether.
A Chinese AI model just dropped – but don't ask it about Tiananmen Square
Ones without a straitjacket of bureaucracy.

It's not like I can't exfiltrate all their data with a python script and a web cam.
Exactly this! I just don't understand how this is hard for otherwise competent people to grasp. The explanation I've used in the past is the choices are either being stabbed in the face or kicked in the balls. Ideally I'd not have either, but forced between one or the other I know which one I'd pick.
Nice, it's a universal binary! Works great on my PPC machine.
i run nvidia/intel/optimus/wayland in optimus/integrated mode on my laptop. i have anecdotally noticed perceptually salient increased response times when:

1) dpi scaling is in use
2) external displays are used via usb-c/displayport
3) the nvidia memory clock has been scaled down by power management

that said there have been fantastic improvements overall to both stability and response times since kde6 and nvidia-open have stabilized and i haven't noticed any of it in a long time now. it really is pretty great these days.
> But if someone dies to recovery form a surgery, or worse from anesthesia, that seems like something that could be identified and reported.

We do (for example: https://www.cdc.gov/healthcare-associated-infections/index.h...), but there's significant difference between "malpractice" and "died due to surgical/anesthesia complications". Perfectly administered anesthesia is still risky, which is why we don't give it for, say, mole removal.
I suspect it was said ironically, meaning all the recent immigrant scaremongering.
Have you seen the documentary Tim's Vermeer? Its thesis is that Vermeer, through advanced lenses at the time, was able to paint essentially mechanically rather than having a fine grasp of artistic brushstrokes in the traditional sense. Some, as well as in the documentary itself, think that it'd ruin the purpose of the art but I see it differently, especially with all of these AI artists now online, where the intent of the human making the art is all that matters, not the instrument or manner in which they do it.
The cruise speed is selected for maximum fuel efficiency. The airplanes can fly faster, and do under special circumstances.

Your gas car's maximally efficient speed is about 35 mph.
I’ve even seen some wallets with built in “Find My” support.
ML workloads where I can do a few epochs locally to see where the data is going wrong before running the full training run in the data center.
Submissions like that often get flagged because they are mainstream political news items. As the HN guidelines say: “If they'd cover it on TV news, it's probably off-topic.”
I'm aware that you already know everything I've written here. I agree that spillover from bats in Wuhan is not impossible (nature is big and mysterious), but your implication that proximity to such bats affected Dr. Shi's choice of working location just isn't correct. She can be wrong about a lot of things, but she can't be wrong about her own intentions.

I guess we're just endlessly arguing the same uncertain technicalities now. I miss the days when actual new information was becoming available, and appreciated the chance to discuss with someone informed with opposing views. It would be nice to confidently learn the truth someday. Perhaps the new administration will release something, but I think it's much more likely they'll just poison the topic politically even more.
True, she was a party of billionaires that want to burn it all down more slowly. GOP-lite, as they say.
> If that happens to be a bottleneck and you can do better, you should definitely do it in code locally. But these are two ifs that need to evaluate to true

If the OP said what you are saying, I'd probably agree. However, the above statement makes it clear that the OP is saying "put it in the database unless you can prove it doesn't belong there".

That is what I disagree with. There's a lot of reasonable things you can do with a database which aren't the best thing to do from both a system and performance perspective. It is, for example, reasonable to use the sort method on a database. It's also not something you should do without proper covering indexes. Especially if the application can reasonably do the same sort.
Someone should author an ELI5 (or slightly older) guide to how LLMs, RL, Agents, CoT, etc, all work and what all these acronyms mean. And then, add to it, daily or weekly, as new development arise. I don't want to keep reading dozens of articles, white papers, tweets, etc, as new developments happen. I want to go back to the same knowledge base, that's authored by the same person (or people), that maintains a consistent reading and comprehension level, and builds on prior points.

It seems like the AI space is moving impossibly fast, and its just ridiculously hard to keep up unless 1) you work in this space, 2) are very comfortable with the technology behind it, so you can jump in at any point and understand it.
It's arguable that many of them are important, we just don't know yet which ones, although some (like this one) are more likely than others.
I absolutely do not want to read that. I want google to stop sending me that. Either it’s written in French or English and I can read it directly, or it’s written in another language and I can ask for automatic translation myself, but do not lie to me about who wrote it and in what language.

I’m so tired of translation slop. I live in France, and when I search for building related stuff in French I have to wade through pages of translation slop to find stuff written with the actual building standards and codes in mind. Avoiding sales pitch, AI, and translation slops is getting really tiring when you’re looking for contextualized expert knowledge.
Google employees felt that way at one time, relying on the old motto “Do no evil”. How’d that work out?
A few times. Hence the switching to Arch.
Precious metal floor value is not immune either, since (1) it is dependent on supply and (2) specific technologies/industries that require their use may become diminished or obsoleted. Definitely a lot less volatile than something not bound by reality though.
Full disclosure: I've probably "lost" more by following advice like this article than everybody on this thread has lost on bitcoin.
Evidence more than strong enough to be published in most fields. Not quite strong enough to qualify as "discovery" in high-energy physics.
Good for you if you enjoy that.

I really don't care for it though. I have 0 interest in watching Harry Potter 20 times. And considering new content comes out over 10x faster than I can consume it, I don't see "depending on new content" as being a problem.
> Short quips lead to lazy thinking. Learn what your database can and can't do fast and work with it.
Playing the tape to the end, what happens is the protest votes win? Start a new election cycle? What happens if that cycle now extends past the end of the current admin’s term which cause their time in office to extend beyond 2 terms? How do you then prevent the incumbent from using that to their advantage to stay in office?

Jeebus, I can’t believe I’m actually saying this, but dems the times we live in I guess.
I believe disruption can come in the form of underwriting and servicing loans. The old model of large call centers that do buying and servicing loans has been around forever. It scales fairly well but it is costly and very inefficient. If those processes are lean then savings could be passed to pricing. Basically creating a credit union model to a national scale.
Oh man, now I totally want to 3d print a full sized interlocking Han Solo in Carbonite with embedded magnets to stick on the front of my refrigerator!

Maybe I'll have to get huge commercial refrigerator for the proper effect, but it will be worth it.

3d printed life size Han Solo in Carbonite replica Part 1:

https://www.youtube.com/watch?v=lOj3yZ-iMjM
A quick search on Amazon shows a number of generic trackers compatible with “Find My”. In fact, the one on my dog’s collar is one of these.
Going faster means a lot more fuel consumption. Air doesn't like being violently shoved aside. In fact, it gets all hot about it :-/
Yup, there was a project recently that used the airtag network to transmit data from a hardware keylogger. The computer could be totally gapped and the data still gets home via the typist's iPhone.
Specifically it tends to be referred to as a test of “good moral character”. So depending on what the reviewing officer thinks about your arrest (not conviction!) record you can be denied due to lacking good moral character, which is obviously a completely arbitrary determination hence why that practice is working its way through the courts.
It already led to their freedom, at least. Even if Bitcoin went to zero, most of them have pulled out enough into fiat to be set for life.
I'm not an Arsenal supporter.

It was mainly sneaking in some levity.

That call was poor.
Wouldn't this have showed up in the reports last year when the numbers were actively happening? There's been 1 case this year it says.

If the ideology was what you're saying, then wouldn't they want to spread the info and blame it on the "dirty illegals" or whatever?
> Now, if you’re all in on quantum, and you want to tattoo Schrödinger's equation on your arm, I’d suggest using this shorter version

I’m amused because I actually got the short version of Schrödingers equation tattooed on my ankle about 3 weeks ago.

Yes I am a nerd.
I understand democrats have kicked all the social conservatives out of the party but I didn’t think it was retroactive! I was a registered Democrat until 2017. I went to Wingdings in Iowa in 2019 as a Tulsi Gabbard supporter.

Hawks are by no means the majority of democrats, but Romney 2012 types are the margin democrat voter. And while the majority of democrats aren’t hawks, the party’s dominant principle as of late seems to be trusting credentialed experts, which makes them suckers for the intelligence community.
I had a TB scare last year. Coworker was exposed to a confirmed case. Got tested, and we all turned up negative. I then asked if I could get a TB vaccine, but was told no, because it makes the TB visual assessment test useless. So, to aid future potential diagnoses, I need to be able to be infected by the genuine article.
Plus hum, would you deposit large money amounts in a small fintech company ? The advantage of giant banks is that you sort of trust their size will make them able to weather a crisis, if only because so many taxpayers are involved that the government has no choice but to help.

A fintech with 1M users screwing up loan rate timings being unable to finance savings accounts and facing a run, would not have much runway and the government would simply slowly try to make people get 50c on the dollar and tell them to go back to a big bank if they want better...
... or weren't purged from the voter rolls or were otherwise prevented from voting.
Yeah, not sure many people are aware their beloved tech is spying on them.
At this point face recognition and other tech can make it such that everyone is traced, filed and automatically sent summons of some sort.
Yes. It just proves that all you needed is a better way to specify the per-monitor DPI, one that can be updated afterwards, or even set by the WM on windows.
burn it all down nicely
>If history is anything to go by, we’re only ever an election, or other political churn, away from your particular sets of beliefs / identifiers being persecuted, or at least your least favourite political prisoners being released and coming after you.

it goes other way around too - you are only one election cycle away to be pardoned.

And if the protest is succrssfull, you dont need a pardon anyway.

Source -- been to places, done the things, a special law shields me from the thiengs being brough up by autorities
When I was a kid, we lived near an AF base. I enjoyed the sonic booms, and was a bit perplexed at the animosity towards them. Thunder is a lot louder. My dad would laugh at my antics with a car, saying there was nothing like flying on the deck with the afterburner on.
Needs a free trial.
The people that didn't vote don't count, figuratively or literally. You may as well have pointed out that only .1% of all mammals supported this, after accounting for dogs, cows, raccoons, mice...
They had to disable AVX-512 only because Microsoft was too lazy to rewrite their thread scheduler to handle heterogeneous CPU cores.

The Intel-AMD x86-64 architecture is full of horrible things, starting with the System Management Mode added in 1990, which have been added by Intel only because every time Microsoft has refused to update Windows, expecting that the hardware vendors must do the work instead of Microsoft for enabling Windows to continue to work on newer hardware, even when that causes various disadvantages for the customers.

Moreover, even if Intel had not said that Alder Lake will support AVX-512, they also had not said that the P-cores of Alder Lake will not support AVX-512.

Therefore everybody had expected that Intel will continue to provide backward compatibility, as always before that, so the P-cores of Alder Lake will continue to support any instruction subset that had been supported by Rocket Lake and Tiger Lake and Ice Lake and Cannon Lake.

The failure to be compatible with their previous products has been a surprise for everybody.
Kindle cover would be extremely useful.
Would there be a way for the bluetooth device to rotate its broadcast keys in a predictable way to avoid the iphone notification of "unknown airtag close by" messages? Seems like this could be exploited for surveillance.
Perplexity AI proposes to merge with TikTok, with US Government getting half
That's the marketing bullshit. It's simpler that that.

He's selling weapons to both sides, the ai bullshit spam machine gun, and the anti spam identity verification system.

He knows what he's doing.
The readme has links to various resources including tutorials: https://codeberg.org/ngn/k
Which trade, specifically, is Bitcoin facilitating in practice?
I inherited similar boxes of thousands of unorganized photos when my mom died. I threw them all away. They weren’t meaningful enough to her to organize, and they meant even less to me.

My lesson is I don’t take photos. I realized long ago that I never look at them again.
Malpractice is when a sophisticated person navigates the legal system and receives a settlement.

What im wondering is why the general public doesn’t know that surgery isn’t an absolute good.
Lol people were getting called racist for suggesting it was anything less than the spawn of a bat and an asian water racoon.

It still isn't even acceptable to acknowledge the (blatant) possibility that Omnicron was intentionally leaked because of low vaccine effectiveness.
Yeah I feel like Monzo and Starling really forced the high street banks to level up their game. A friend of mine was a PM on an app at one of the big high street banks and they said the instruction from the top was explicitly to be like Monzo, and they did iterate, get better at app development, and ship a bunch of features that people like (spending notifications, in app card freezing, etc).
use adaptive lightning
https://beyondloom.com/decker/lil.html

See also https://beyondloom.com/blog/rankingoffruits.html for a nice introduction to the query syntax and its relation to K. (And RodgerTheGreat is John Earnest, the author).
Rationale is probably the same that the current president used to claim there'd be no covid 19 if we didn't test for it
> Your Hacker News referrer screams "I argue in the comments unironically," your 12 CPU cores confirm you need all that power to procrastinate on Catalina like it's 2019, and Richmond's only quirk here is hosting a Mac that somehow hasn't died of FOMO from missing software updates.

I'm on an M4 MacMini, running MacOS Sonoma. It's definitely a little confused, but that could be Arc failing to properly report the User Agent? Not sure. Kinda funny, none the less.
Independent archiveteam archivist, I’m just here to make backups of the internet.
It's what Trump said he was going to focus on and it's unfortunate that none of his voters decided to listen. He wants to leverage the power of the US as a mob boss to dictate favorable terms but this go around feels very different in terms of people no longer dealing with it.

Tariffs can be useful in very specific scenarios but we generally don't produce any of the things we import from Colombia. So we eat higher prices, Colombia gets pissed off and trades with other countries and everything is a bit worse off. All for the sake of stupid posturing and harassing immigrants.