skysight-inc/HackerNews huggingface dataset:
> But these kind of judgements based on use case isn't something the database can do, and you're likely to end up with dozens of semi-useless indexes eating up your disk space and insert performance

That is an empirical question and another comment points to this working just fine: https://news.ycombinator.com/item?id=31991469

Even ignoring that, creating indexes is a matter of tradeoffs - it's not the index creation that's difficult but the decision on whether the tradeoff is worth it. Seeing this, possible issues arising from automatic index creation can be mitigated by allowing the admin to set parameters that dictate where the tradeoff should be made (as a naive example: "I'm okay with using 10Gb of storage if it results in a 20% improvement for P95 queries on this table").

This is not an unreasonable idea and it sounds like it would greatly improve UX for devs working on median-sized DBs (people needing FAANG scale can manually tweak their DBs). Worst case, you can have a whitelist approach to automatic indexes, where the admin is shown index suggestions which require manual approval.
I wonder if you could make a luhn-like check that would require an additional approval step to post if it comes back positive. Something like "It looks like you may be posting a secret *****. Do you wish to continue?
Look forward to custom stylesheets! I am trying to push an update but it's failing at the moment:

```
blog scp ./*.md prose.sh:/
_readme.md 0% 0 0.0KB/s --:-- ETAlost connection
Connection to prose.sh closed by remote host.
```

What can cause this? `ssh name@prose.sh` works though.
They didn't back out on these: They were forced to give them up in the Netherlands. And then, when South Korea passed a similar law... Apple has announced the same tricks the Netherlands refused to accept as their plan to comply with the South Korean law.

You can bet they'll start playing the same games with the EU once this goes into effect. Regulating big tech requires not just passing the law, but a heavy handed enforcement that doesn't put up with delays and antics.
Oh, is there a competitor to the app store that will let me get apps for my iOS devices?
makes no difference, same error.
** one.one.one.one can't find whatever.localhost/: Non-existent domain
Driver issues, right.. is that why my archived shell histories have hundreds if not thousands of entries for `pulseaudio --kill ; puslseaudio --start` ? Does restarting the userland sound daemon reset the drivers operating in kernel space? How would that work?
Guessing they're not counting stuff at their flight sim training center (12 bays) as a 'data center'. There is zero % chance that the workloads supporting simulators are gonna run in the cloud. They're incredibly latency sensitive, extremely finicky, and just getting the stuff virtualized continues to be a struggle for aviation OEMs and flight training centers (though FedEx was a pioneer in this regard).

Granted, the footprint per sim bay isn't huge (1-2 racks, usually, sometimes 3), but it can add up at the larger sim facilities. Several of the major airlines are running 30+ bays simultaneously, with United poised to come in with the most at 40+ in the near future.
CAPSTONE Update on Communications Issue
NIST Announces Four Post-Quantum Crypto Algorithms to Be Standardized
The tenders, as those trucks are known, would be from the fire department themselves. Filling from nearby-as-possible ponds or tanks, a good-sized structure fire will still go through multiple trucks' worth of water.

I volunteer with our rural, island-based fire department. The more populated part has 90% or more of the people, and is part of our coverage area. The larger part is more parks and forest, and sees regional coverage such as chopper- or truck-based crews, helicopters and so on.

Each of the engine trucks carries something like 1000 gallons of water, and is kept full. So are the tenders, which can dump into the "porta-pond" as in that video. The water supply team has a list of available sources of water that they can go to to keep that water flowing, but if there is nothing nearby, the round-trip time will get longer, and firefighters will have to leave the building until there is water available.

Wildfire fighting is very different, and much more focused on containing the edges of the fire by using natural fire breaks or creating new ones. (Think picks and shovels, heli buckets, and heavy equipment where available.) If there is a house or two threatened, maybe some sprinklers can be set up ahead of the fire. If the house is on fire, too bad, efforts are on what's ahead.
Good point, make that only apply to fixed length chars (not varchars). I think JOINs use indexes which are often done on the primary key.
https://www.mssqltips.com/sqlservertutorial/3207/make-sure-a...
> to open them up would almost certainly require revisiting DMCA 1201[0] and removing the prohibition on circumvention tools

This is a non-sequitur. If there were a new law that requires Sony and Nintendo to offer side-loading on their platforms, they would have every right to do so, as they own the copyright of those platforms. The DMCA protects copyright holders from the actions of others, it puts no limits on their own actions. If Sony wanted to break into your PS3, you wouldn't have any standing under the DMCA to sue them about it (of course, there are other laws that protect your data, your past contracts etc).
RavenDB (noSQL) does this already: https://ravendb.net/docs/article-page/5.3/csharp/indexes/cre...
If you can, without a pay cut, do it. You'll live like a king with $500K in FL.
I have a feeling we have not gotten the hostile "You'll get over it"[1] redesign from scratch because 1. HN doesn't have a team of UX experts desperately pleading to try out all their design experiments, 2. HN doesn't have a team of webdevs who want to re-factor everything into using the next framework-of-the-month, and 3. HN doesn't chase all these vanity metrics like engagement and time-on-site because it's a side-project of Ycombinator not their main business.

1: https://www.youtube.com/watch?v=YnVeysllPDI
That's pretty much the point of the regulation. If you're okay with being preyed upon by billion-dollar companies, stay in the US. If you'd like to be protected as a customer, come to the EU.

Besides, the DMA has specific exemptions for small companies. Once a company reaches the "gatekeeper" level, they will have had all the necessary time to figure out how to comply with the law.
GCHQ helped catch 'hurtcore' paedophile, Matthew Falder
> What's your alternative for stuff that needs to run on more than one server for reliability or scale?

Same as most people, and as previously mentioned: I pay pay a cloud provider, unless my business is being a cloud provider.
Location: Great Falls, MT.

Remote: Yes

Willing to Relocate: No

Technologies: React, JavaScript, Firebase, MongoDB, Node, Express, Git, Jest

Résumé: https://drive.google.com/file/d/1Nd6N3xEV5Uuzkn_LlqrzpDv6g2m...

Email: jsemana054@gmail.com

I'm a recent CS graduate looking for remote positions in the US. Don't see your stack? I'm willing to learn it and everything else that comes. I want to get into some real hands-on experience in the industry and I hope someone will take the chance on me. Thank you!
Well, HN is a link aggregator, not a DNS tool.
You do understand that uBlock Origin has private, profit-generating relationships with advertisers.

And you want them to have full access to every URL that you visit ?

Rather than use AdGuard or any other ad-blocker that can't go and sell your data to third parties for money.
These are not the same at all, at least generally speaking.

IT workers are usually not causing direct environmental impact on those around them. And if you assessed the percentage of environmental cost per individual, you would likely find that IT workers would be way, way below industrial farmers.

There are certainly many industries that create significant pollution. But pragmatically, we care when it's a small few people creating a high concentration of said pollution. That is the case for Dutch farmers.

The services of the farmers is appreciated. Their methods are not. They don't want to change their methods (or reduce their output) for any reason, environmental or otherwise. That is the problem. Other industries change (usually after throwing fits like the farmers are doing now).
Let me update your scenario, instead of the innocent granny installing an iOS app the evil dude asks her to just give her the security code she just revived from a bank, or she should open a link and login to her bank.

I think you need a Big Brother for your granny, Apple needs to make Safari granny proof and whitelist websites and they should also force user to provide a national ID before calling to an iOS device, think of all the grannies.

Imagine though an universe where Apple could hire some competent people that could create a genius popup that would explain granny that she should not enable that, and to enable that maybe she needs to use a code that is printed on the phone box.
Channel Charting – Mapping the Radio Environment
What kind of breakage, complexity, and general fragility are you seeing with PulseAudio? Can you elaborate?

One big problem here is that the "good path" for audio without PulseAudio applies to a shrinking segment of Linux user base.
I'm seeing an error in the logs, your _readme frontmatter for `nav` looks to be incorrect. Could you share your _readme file?
Sickboy's Philosophy of Life. We all get old and cannae hack it anymore.

https://www.youtube.com/watch?v=a94jraWNG-g
Do you have any basis for this assertion? I find that my state constitution is far better than the federal one in most regards.
This is brilliant. I can't believe I haven't thought of it.

I also recommend Distraction Free YouTube for blocking recommendations and (optionally) comments.
Yes, the interesting part of Spycatcher wasn't Wright trying to be George Smiley in real life and trying to find a mole but rather his descriptions of things like his analysis of Leon Theremin's (of electronic music fame) bug and other technical things like that.
Price is going to go down some more too. As the economy slowly but surely enters recession, and low net worth HOLDers sell their BTC to pay rent, the price will continue to go down. This system only works if people pump money into the system, not out of it.
Can you syntactically write a SELECT query that also does an UPDATE/INSERT/DELETE? And Bobby Tables doesn't count - using a ; clearly indicates the start of a new query/ statement.
Biggest worry:

I have massive doubts that this show would bring in profits similar to Avengers: End Game. Because that's what it'll take.

Even if this is a smashing success by streaming standards, Season 2 will be ridiculously toned down to keep the costs down to like 50MM. People will instantly say "quality dropped significantly" and then it'll collapse. Feels like this will go the way of Marco Polo which was an amazing show, destroyed by Netflix's lack of desire to spend any money.
Diablo Immortal is bringing in over $1M a day in microtransactions
Ask HN: Why oil prices are going down but gas prices are still the same?
Rhythm / Pitch Duality: hear rhythm become pitch before your ears
> It's been 11 years since the last ASOIAF novel.

To put this in context: All 9 books of The Expanse were written during this period along with a six season TV show based on the same material. The two writers were involved in both actively.

I've 100% given up on ever seeing how ASOIAF ends. Same with Rothfuss's Kingkiller, it's been 11 years and I stopped caring during the previous decade
it is called Quanta Magazine
> "The main problem is that users can be tricked to do it."

That's because the GUI is badly implemented;

On macOS, your parents would never disable SIP (system integrity protection), because it's quite cumbersome to disable and there are enough warnings and hurdles.

This is already has been reality for years: it is simply not an issue.
> If Signal is forced to interoperate with e.g. WhatsApp, the end-to-end encryption of one or both will have to be compromised

Wrong https://matrix.org/blog/2022/03/25/interoperability-without-...
> How do you conclude "absolutely a dark pattern" if even one person realizes benefit from it?

That's the wrong way to think about Dark Patterns. It's not about whether they are ever helpful, but whether they are ever harmful. It doesn't matter what your intentions are, it matters how the end user experiences the design. 3 modal boxes to cancel is absolutely harmful when it can be done in 1 and that 1 modal can even include all the reasons you shouldn't cancel. But you get one shot to keep a customer, not three tries to keep and frustrate them.

And I have personally given up on cancellation before because it was too complicated/long/frustrating. So yea, dark patterns are real, they are not ethical, and you shouldn't defend them.
NTRU-Prime, NTRU, Kyber and SABER are all great KEMs. NIST could've chosen any one of them. NIST never standardised Ed25519 and OpenSSH still uses it, which is perfectly fine.
This is exactly what happened.

GRRM wrote himself into a corner he hasn't been able to disentangle.

And the showrunners didn't have the luxury of waiting 11 years between seasons.

I do think they could still have done a better job, but it's hard to say from the outside because we don't know the budget, time and story constraints they were working under.

By the time the final few seasons came around, almost all the actors had become famous on their own right, who were taking on a ton of other shows (and I doubt they were under contract for the entire run, especially since it was never expected to last as long as it did) and it must have been a massive challenge bringing them together to film the final few seasons.
It is just me, or is this an open call for a proletariat revolution against the bourgeois? Any successful "plunge past the first-class passengers" will not be a peaceful event.
use yandex to search for youtube videos.
That's a myth, and obviously false on the surface: What are they supposed to do when they need that capacity back for Black Friday? Kick out all their customers for a day?
I'm loving how half the comments are, "I don't know why I'd ever need to look at my program's memory?" And folks wonder why things are so bloated!
I was going to suggest that search should just redirect to DDG or Brave search with the !hn tag, but I tried it out and both of those just redirect to the same search page that HN uses (hn.algolia.com). That's both really nice because why not have your site-specific search results reference the search page that site uses and really annoying if the problem is that that page's search doesn't work very well.

It looks like redirecting the search to "site:news.ycombinator.com" does leverage their individual search results instead of going to algolia.com, so that's still an option.
Oh sure, of course.

But if you're the one raising them, you've got a hell of a way to bias that coin flip. Or, to extend the metaphor, mint new coins.
I like Cory, and I think he's right. But he's preaching to the choir. No one who can get hold of the wheel is listening.
https://github.com/fabiomaia/pssht
> They didn't feel the need to provide multiple recommendations during the AES, or the SHA-3 process, even though Rijndael and Keccak used different constructions relative to RC6/TwoFish and SHA-2/Blake2. Why now?

SHA-3 was explicitly alternative reccomendation. The entire point was to come up with something that was not based on sha-2, because they were worried that the attacks on md5/sha1 could be extended to sha2 (which didn't really happen the way people were worried about). Even to this day, general advice is not to use sha3.

Less clear cut for aes, but at time of standardization (and even now afaik), triple des was considered secure, so its not like there wasn't a secure alternative.

These standards arent meant as implementation guides. You still need cryptography knowledge to securely use them.
Apparently season 4 is pretty good.

The angry scottish man likes it

https://www.youtube.com/watch?v=OLoToWBbbAU&t=166s
Oh they exist alright, I have met them. They are bearded old men that rule the kingdom of Oracle in a dusty room that smells of stale coffee. If you ask them if you may please have a table they respond angrily "NO, you may NOT have a table!"
Ask HN: Recommendations for Good Developer Conferences?
I would love to get more involved in developer conferences, meet new folks, and learn from them. It's really difficult to find these opportunities though. Do you have any recommendations on where I can find them or specific conferences I should attend?
Yeah superhero movies are not quality TO ME. But I have family members who do and will see every single marvel thing made. Even the ones they dont love they will enjoy because its the characters they enjoy and its building a universe they are invested in.

They are well filmed. The action tends to be good. They have stars in them. They have characters in them people care about. Those are all things that will draw a lot of people towards them.

Halo has 1-2 characters people give a shit about and zero stars. The LOTR show seems to be the same...

I'm not saying you HAVE to have those things for something to be quality but to keep people coming back those things help a lot.
Semantic diffs are great (I did some experiments with it myself [0]), but we can't entirely automate away "narrative problems" in a PR. No matter how good a diff is, a diff tells you what changed but not why and sometimes not even how. That's what we need good commit messages for. That's what we need good PR descriptions to do. If a branch has a ton of seemingly unrelated files modified (automated tool output or not), sometimes you have to ask the narrative questions: "Why did this change? What does it have to do with the other changes in this branch?"

Admittedly, narrative problems are hard to solve in general. It's a lot easier to "build a new tool" than to train a junior developer to always explain why/how in commit messages, to order their commits to "tell a story" of what the branch accomplishes, to avoid unrelated changes in digressions and asides along the way (moving those into their own branches/narratives), to tell that story in a PR description in a way that is useful to understanding the whys/hows of the branch (especially if the commits themselves lack some of the narrative or aren't ordered well for proper storytelling). I often settle for one or two of those at a time from a given junior developer.

I don't think we can automate ourselves out of narrative problems. I think narrative problems are one of the unsung creative problems of our industry and something that separates good programmers from great programmers. It's a human skill that takes practice.

> I feel like git was perfect when "code" was nearly almost completely text and patches were sent over email

That "perfect" never existed. Even codebases like the Linux kernel that work entirely in email still have their random binary blobs (often from outside vendors) and auto-generated files from tools. What the email flow focuses, arguably to some (such as many of the folks at Sourcehut) better than most other PR tools, is that conversation around the narrative and they why/hows. You expect a lengthy narrative discussion in a mailing list. Sometimes people see those comment fields in a Github PR and expect then to be less about narrative and more about nitpicking specific lines than having narrative discussions. (Nitpicking happens in mailing list discussions, too. It's mostly unavoidable. But to nitpick on a mailing list you have to do a lot more copying and pasting by hand.) There is something of a different story telling "pressure" when you are staring at an empty email with a file auto-attached than when you click the PR button in Github and get pages full of diffs and all the commit logs laid out before you before you ever start writing. (Sometimes people do see that and think their job is "done" and what they would write in the PR description would be redundant, because it is not a "blank email" that needs a greetings and salutation and maybe a description of the attachment.)

[0] https://github.com/WorldMaker/tokdiff
And a Go implementation I wrote for Cloudflare. https://github.com/cloudflare/circl/tree/main/kem/kyber
Android / Google App Store is much more lax, isn't it?
A lot of their work is speculative (e.g. it's not clear that the layers of linen were glued, but they went with the assumption). It's interesting that they did not consider one of the most likely combinations: linen layers sewn onto leather. This would be more flexible (glue makes linen quite stiff) and more sweat resistant.
Is this a quine where the processor is a CEO?
POP and IMAP are just transfer protocols and don't dictate what the client does with the mail once received. IMAP should always be used for various reason, the biggesting being:

POP is a real disaster if you have multiple clients trying to use the same mailbox. There is no way to sync message state (read,unread,flagged,replied,...) across clients. Clients randomly delete mail from the server side.
> Or we reduce our meat consumption, that's probably even better for the planet.

I don't disagree on that.
I thought it takes more than just groping someone to be forced out of civil society? How do we have full on rapists with cushy union protected NGO gigs, and some drunken conservative grabs someone and apologizes and everyone loses their minds? Is that kind of thing just taken more seriously across the pond? I gave up on anything supposedly queer friendly at places like Defcon or Tech Policy Happy Hour because of one too many handsy staffers. (And never the ones you'd want to make a pass when single, always someone ugly in body and soul.)
Smart. Was so obvious in retrospect (of course).
FWIW, Google apps also ignore the default browser setting on Android in favor of their embedded Chrome instance, and consistently "conveniently reset" the internal setting that would make it use the default browser.
You bring a very valid point up here! Thanks for putting things into perspective :)
Browsers now are so verbose we really don't even need cookies any more... Google knows everything via Chrome (which is based on log-ins tied to email and ID accounts, and likely shares that data with many other companies if they pay... I'm in the US, and any time I come across a cookie banner it's more annoying than anything else, because regardless of what I click, I know that tracking is occurring somehow, but at least on non EU sites I have one less annoying pop-up. We pay a lot undercover for that limited free email account that it's too late to get rid of... :(
Sound stops and doesn't work until I restart pulseaudio. You know, the usual. I think some people restart their whole computer and blame their drivers, but restarting pulseaudio alone is what fixes it nine times out of ten.
NASA's CAPSTONE spacecraft suffers communications problem
> You can set a third party voice assistant but it can't launch apps

Facebook and Google are going to love this.

They can build a voice assistant app which will provide them with all of the apps people use the most, people they contact, places they visit, searches they do etc.

It's going to be a privacy nightmare.
> We have no proof (and it's probably impossible to do so), that anything we've found is fundamental.

this entire discussion is fully outside of my knowledge wheelhouse but why should we believe that the universe is anything less than infinitely fractal at the micro scale? like you said, how would we even know if something is fundamental?