skysight-inc/HackerNews huggingface dataset:
> but there's not enough information in EXPLAIN to tell you where it's actually getting tripped up

Unfortunately I don't think providing that information is generally possible. In some specific cases there are useful details it could provide, but there would usually be a myriad of other similar details that are irrelevant and if it included all those you'd not see the wood for the trees.

EXPLAIN and query plan outputs in other DBs are “this is what I did” not really “why I did what I did”. To make the query planner bright enough to know what details would be useful to you, would probably pretty much require making it bright enough to do the optimisation job without you¹.

[1] picking better indexes without hints, even creating those that are often needed, etc.

MS's SQL Server tries to do this a bit with index suggestions. These are sometimes handy, but often at best for guidance². I've seen people blindly follow these suggestions to get a %-or-few gain from a small set of queries that could see orders of magnitude improvement with just a little tweaking elsewhere³, slowly amassing collections of indexes for very specific cases, sometimes multiple on the same key columns but each INCLUDEing a different mix of other data, that balloon their storage requirements⁴.

[2] a nudge in the direction of “Mr Dev/DBA, you might want to think about how I'd avoid scanning this large object or performing many many thousands of seeks on this other one”

[3] refactoring non-sargable predicates, index changes on other tables being referred to, getting rid of “SELECT *” particularly when referring to hideous views, ...

[4] and having the knock-on effects of slowing insert/update activity & important admin functions (particularly backups)
Because every comparable country that has a government-run healthcare system has somehow ends up with it being ~twice as efficient. I get that there's theory that says a private healthcare system should be better at keeping costs under control, but it's not borne out by the evidence.
Or simply sour grapes. He is right that your investments cloud your thinking, but maybe he doesn't have enough experience to understand that the desire to see the price go down against something you decided to never buy, or recently sold, is driven by the same bias.
That's really a narrow-minded view on the scientific method. While it's true that the process of carrying out an experiment should (at least in theory) be free of human biases, the reality is that bias pervades science just as much as any human endeavour.

Even if you manage to completely get rid of biases in the actual experiment, what we choose to study, how the study is structured, and how we interpret the results will be subject to our biases. Science doesn't "care if you're black, white, trans, bi, or toxically masculine" because it doesn't "care" about anything. It's the fallible humans carrying out science that choose what to care about and investigate.
Sure, but the lies by omission might only exist in your head. There's no way of him proving that there's no omission, which makes it look like your argument is made in bad faith.
Excellent tip, thank you!
That might be true for developing countries like China but for sure its not the case in Europe and US.

China by itself can skew global average by a huge margin due to sheer amount of ppl living there.

But even in China market observes middle class crisis - slowing down or ppl getting back to lower class.
I came from java and compared to that even our slowest rust build time is faster than I have ever experienced in java. I remember we had a Java springboot application who had a buildtime of 8 minutes on my 2015 MacBook. I am so happy I don't have to deal with this anymore.
Warp uses a lot of generics, which can produce extremely deep and long types. In turn, these cause a particular compile stage to take a long time (> 40 seconds).

Boxing disguises/splits the chain by taking a pointer to a trait object, which doesn't require the same depth of checks.

(This is especially important if the algorithm is superlinear, which is implied but not stated in the article.)
> - EU/US will yield to Putin on Ukraine

Was there any chance NATO would accept an applicant that is currently fighting a war?
- Apple will release the first gen of its VR/AR-headset.

- Google will buy Tiktok

- Meta/Facebook will release some VR solution that fail to gain traction

- Roblox will face legal pressure due to its use of child labor and child gambling
why? it's not a binary choice
Over the last 6 years I've built up a rather extensive media collection that I run from a dedicated Kodi server on the LAN.

MusicBrainz Picard has played a key role in organizing it.

My reasons for starting this home collection was the endless amount of ads and the surprising amount of times content would disappear from the streaming platforms.
The problem is indeed room height. I built my wall to the specs of the Moonboard Mini (they are available on their website). Unfortunately that meant I had to go for a 40 degree wall. I have maybe 3-4 routes that I can climb on that wall now, all with big/good holds. I cannot even do a route that's designated as V3 in the official app (I did buy the yellow Moonboard holds+one wooden set) but I suspect the grades are not for 40 degrees but for a less steep wall. In fact, I only recently managed to do one move on the small holds. Last week I finally constructed a circular route of about 20 moves that I plan to do as endurance training.

My advice: just go to a gym and do it. Everyone will be super friendly and you can climb by yourself if you want. There's some jargon and it might be a bit tricky to figure out how you're supposed to climb routes but simply tell them at the entrance that you never climbed and would like a short introduction. Make sure the rental shoes fit, not too tight, comfortable but snug is what you should aim for. If in doubt, they'll always let you exchange them. Just start with the easiest routes and work your way up. It's very addictive and there's always something to try and eventually succeed at.
Do it. First thing next year :)
Must agree with all of the predictions 100%
I have my Picard and beets configs hosted here - https://github.com/hashhar/picard-beets-config

I currently have a workflow like:

1. Add tags, move and rename files using MusicBrainz Picard.

2. Run beets on the files with the writing, tagging and renaming options disabled.

The keys which are left empty in the yaml need to be provided by a local config file like beets -c secrets.yaml. A sample secret file can be seen here[1].

This means that I can still use beets to do things like fetching lyrics (but not writing to ID3 tags), creating smart-playlists, updating my MusicBrainz collections etc.

Due to this workflow you might find that the beets config is lacking a lot of plugins and configuration that would allow it to replace MusicBrainz Picard like the chroma plugin, fetchart etc.

Some of the cooler beets plugins that complement Picard are:

mbsync: It can fetch updated metadata for existing tracks solving my biggest issue with Picard.

lastimport: To import playcounts from Last.fm

smartplaylist: To generate rule-based playlists. Now I can have playlists by decade or by genre or even something like "songs from 2000-2010 with danceability > x (from AcoustID)"

missing: to list missing tracks from an album

[1]: https://github.com/hashhar/picard-beets-config/blob/master/b...
It reminds me when they made a big things of their robot 'mule' being evaluated by the US army/marines. It wasn't accepted. Reasons that I picked up included:

* tactically unacceptable noise

* short range before being refuelled

* not as autonomous as advertised

* Increased maintenance / oil leakages.

These issues of course won't be such a problem in the warehouse environment but I'd be keen to see an independent assessment of the thing's utility.
What's democracy? Is that when stuff gets done to you by corrupt politicians, and you have to shut up and suck it, except that every few years you get to swap one bunch of corrupt politicians for another bunch?
This is inspiring, especially if you want to create something good, clearly seeing how bad that part of the world is now. It seems that it gets only worse each year, so opportunities should open up. But then the latter doesn’t feel like it should. Then you realize that your picture is missing a perception of value, a shift in which costs a fortune of scale and belief, so it takes an Elon Zuckerberg to do that. This is uninspiring.
My plan is keep learning too. I used the holiday days to work on my 3D renderer and brushing up on 3D tech. I just figured out an O(N) way of applying the shadow-map in post-processing. Now I am implementing Screen Space Reflections, and the next step is "Geometry Images" (similar to Nanite).
There’s a YT video of a guy taping over the cams one by one. The car performs still pretty impressively even with most cameras blocked.

(I was pointed to this video because I, too had been skeptical after seeing normal “navigate on autopilot” disable itself due to one camera being blinded by the sun. Apparently, FSD is much better at handling such situations.)
Related:

Reporter may be prosecuted for using “view source” (currently 151 comments): https://news.ycombinator.com/item?id=29737412
I certainly didn't mean to imply that hacking the SSD firmware on its own requires state-level resources; rather, covertly rooting the SSD and chaining that into a successful attack on the host system is what adds up to an impressively impractical attack, especially if it's against a target where the host system is sufficiently secured that using the SSD as part of the attack vector is worth the trouble in the first place.
Happy New Year!

I am in the same line as you, I don't have any "new year promises" but I will try to focus on my health: eating better and training more.

This is discussed in a video I think is specially relevant today: https://www.youtube.com/watch?v=NVGuFdX5guE
>Why do people optimize every KPI?

Because if it's not worth optimizing around, how key can it be?
https://contexts.co/

Enjoy!

I actually use it for the opposite function—to make cmd+` better at switching between windows within the same app—but it works great as an alternative cmd+tab if “window switcher” fits your mental model better than “app switcher”.
Linus isn't computer illiterate, a computer illiterate person doesn't decide one day to replace their OS nor bruteforces through several warning messages a command-line based administration tool is telling them because they were trained from a different OS over many years to completely ignore warning messages.

If anything the most likely person to have issues and break Linux is the kind of person Linus is: an experienced Windows power user.
That's a great example of decentralization, but expecting anything which gains value from being decentralized ala Wikipedia to be handled solely or even marginally by volunteers is unrealistic.
Regarding shortcuts: one that often gets overlooked is Move focus to next window under Shortcuts > Keyboard which lets you cycle between windows of the active application. I have it mapped to ⌘`.
I think we're already past that point....
Do you think not being invested and watching the value grow 500x over the past few years leaves you embittered and too pessimistic to see the value? Or is it only the one side of the coin that clouds judgement?
https://www.blake2.net/ says: "CONSIDER USING BLAKE3, faster than BLAKE2, see https://github.com/BLAKE3-team/BLAKE3"

I'm glad we're on Blake2 and seeing the benefits, but why not go straight to Blake3?

What are the differences and why do they matter in this instance?
> Isn't anything that people want to spend money (resources) on by definition a real and worthy cause to at least those people?

No, not if they’re being misled or scammed, or simply making financial decisions under wrong assumptions about outcomes. Just some examples.
Well, I showed that a statement you made is not supported by the evidence.

As for this supposed "Mansa Musa's wealth was built almost entirely by slaves", where's your evidence for that?
That list I think is a good lesson/motivator that the "golden" product youre developing may not become the product defining your company but instead a side project.
I’m absolutely sure that Putin and his cronies will find enough use for crypto (avoiding sanctions, carrying out criminal enterprise) that they’ll be more than happy about this minor inconvenience.
I hope that smartphones photos become inadmissable. Because photos taken don't reflect what really happened.

I also hope smartphones start storing unprocessed version of every photo that will be admissable in court.
Thank you, that is a good explanation. Genes as learnt behavior also makes sense the way you described it.
Is your 64MB memory ECC?

Why do you RAID-1 NVMe? They are likely to fail simultaneously so maybe make them independent and schedule regular backups from one volume to the other, or to a remote disk drive somewhere.
Made me chuckle!
Earlier there were only about 5 comments, two of which involved this "most predictions here will be false" - however one was sadly deleted and nobody else decided to play ball :D
The trillion dollars is a dream, it's not real.. Fugazzi.

Once the price starts falling, the scared 'investors' will get rid of it at any price to reduce loss. The network won't handle the load, so the price will drop even more. It happened before with BTC, where the 'billions' evaporated in hours, it will happen to the 'trillions'.
Damn. Are you me? I had the same experience.
SMS lol what year is it...
Noticed how rare it is too see libertarians promote some sort of "Great Reset"? That is, to make sure that people in their new "fair & meritocratic" system don't get a head start by wealth accumulated under the flawed previous system. Well...its absence pretty much shows their hand. It's just another power grab by the incumbents. Furthermore it is more accurately referred to as Propertarianism, since upholding private property is the sole purpose of that entire ideology.
Slide 15 of this current CDC document for boosters with what they share as the relevant measured data on how effective the two dose vaccine is over time. Look at the severe disease vs. time. Without stating my opinion, Draw your own conclusion.

https://www.cdc.gov/vaccines/acip/meetings/downloads/slides-...
Even deeper question. Why does "web3" need to make money? Wouldn't it be better to go hobbyist providing services? Or everyone running their own things at their own cost, marginal let's say 10 or 100 a year? Like true decentralization, that isn't burden to profit...
There are often occupancies where I'd like this in ad-hoc queries, but it would be something to avoid and discourage in production code for the same reasons “SELECT *” is discouraged (because it is “SELECT *” with a bit of sugar added)
The countries that have fought (and paid a great price) to eliminate COVID will just give up in the face of Omicron. A small amount of unvaccinated elderly people will die in the most horrific way imaginable, and the general population will use it as an excuse to be smug.

China will experience an economic meltdown, starting in the real estate sector and exacerbated by the need to maintain the appearance of the triumph of Common Prosperity at any cost. Both Xi and the CCP will retain power domestically, but it will make life miserable for millions.

Australia will elect a Labour government. Nothing will change.
-there will be one COVID vaccine for all variants (pretty secure as there is rumoured to be one ready for release soon)

-the research into COVID will have major rewards in producing flu and cold virus vaccines.

-GDPR fines will increase on major companies.

-Blockchain based tech like bitcoin, NFTs will suffer due to increasing legislation to handle environmental issues. If it turns out that countries can hit their mandated targets by outlawing bitcoin mining etc. it will happen.

-Someone will try to make an NFT competing solution that does not rely on the blockchain. Good chance of success.

- previous 2 points lead to failure of web3. This is a major problem for public intellectuals on the web because now the web3 term is polluted but they need to have some sort of next phase of the web otherwise how to justify their existence?
The lifestyle of an Amazon boxes collector (2017)
> Even the somewhat centralized platforms have so much high speed commerce on them that they don’t disrupt anyone. Even people that quickly exit to the bridges are not stopped and couldn't be, on the centralized-ish ones.

What do you mean by "high speed commerce" and "people that exit to the bridges"? Why do you talk in riddles?
I think that the original idea behind crypto is still the most interesting. It's programmable money. Large swaths of the finance industry exist to make money programmable. Why not build it into the monetary system directly?

The general historical trend is to make money more abstract and to be able to perform more complicated functions with it. But fundamentally money is a social technology that consists of three things: An abstract unit of value in which money is denominated, a system of accounts, which keeps track of the individuals' or the institutions' credit or debt balances as they engage in trade with one another and the possibility that the original creditor in a relationship can transfer their debtor's obligation to a third party in settlement of some unrelated debt. [0]

Crypto seems to satisfy the essence of that in a pretty cool way. DeFi projects are experimenting with the question of, "can we build the financial instruments and capabilities that a complex economy require on top of, and directly integrated with, this type of monetary system.

Like any technology that requires a large network of users to be valuable it has a difficult bootstrapping problem. But it seems to be gradually working its way to larger and more important transactional contexts. First with illegal digital marketplaces and now in countries with weak monetary system like El Salvador (and with unbridled speculation along the way).

Maybe all of the current crypto projects will fail but it will be interesting to see the nature of monetary systems in 10, 20 and 50 years from now. What aspects of these current experiments have been adopted?

[0] Money: The Unauthorized Biography
(The underlying issue is https://github.com/rust-lang/rust/issues/91598.)
For the top voted “predictions for next decade” on jan 2 2020

https://news.ycombinator.com/item?id=21941278

Increase in adoption of non-scientific beliefs such as …anti-vaxx … as a counterbalance to the increased complexity of everyday life.
Parallelizing the Racket Web Server
That's more to do with Spring, not Java. The compilation time of Java is infinitely faster than that of Rust.
Easy setup with:

- traefik (nginx proxy with auto letscencrypt)

- portainer (docker container management)

- fail2ban (basic security)

- logwatch (server / security stats by mail)

- munin (server stats)

- restic (cloud backup)

- unattended-upgrades (auto install security updates)

- apticron (weekly info)

- n8n (automatisation for e.g. quick info via telegram, if something not work)

Run every app that you want in your container.
This. I want my scene releases to be and remain SFV OK. But that doesn't mean the metadata is necessarily good. Its about data preservation as-is. That's why I never bothered with MusicBrainz Picard.
The incentives for the judge and for the prosecutor are very different, though it sounds like the incentives for the police in Japan might be similar.
Nope. The image data _is_ actually lost. What happens is that it gets pimped with what on average was lost when a training process artificially degraded a training set. For the results to look(sic) natural, you need both the training set and the degradation to be close to what you're shooting. If that is not the case, hallucination happens.
There are helpers if you have a guile-only project, which also integrates with guix.

I try to only use autotools if I really have to juggle the project between incompatible versions or integrate it into a C project.

Meaning I have thus far only had to use autotools twice in about ten years for my projects
It will be very similar to 2021.
Amazon has so many though [0] that I don't really think that's directly why that happens - I'd assume it's just laze (whether human or algorithmic!) in finding the optimal box, and going with one that's obviously big enough, to hand, or whatever.

[0] - approx 90 in Japan in 2016 - https://dailyportalz.jp/kiji/170303198940 (thought that was fun, submitted here: https://news.ycombinator.com/item?id=29746745)
Yes, he's talking about them at the level of abstraction that is 'things that persist data'

You wouldn't compare a file to a database to make a point, would you?

If the comparison fitted the abstraction level the conversation was at, absolutely.

For most purposes that have ever been implemented on a blockchain, a database of some kind would just be a far superior persistance backend.

The mistake is thinking that interesting underlying technology gives something de facto justification for existing in 'user' space when it does not.
> So I decided to use the native macOS window management instead and try to get used to it instead of actively fighting against it.

That’s something I wouldn’t have expected to read here, as I myself find it quite hard to change paradigms. I learned that the hard way when I had to use a Mac for the first time after using Windows and Linux my whole life, and tried to use it as I wanted instead of how it’s intended to be used. Once you know how the paradigm works, you can try to adapt it to your workflow, but not before or you’ll be frustrated quickly.
- After the second winter with covid, countries successfully implement a playbook that restricts freedom as little as possible while containting the virus. Some cultural habbits die off (huge events inside in winter), while new events emerge (a culture of doing things outside with others)

- Elon says something so incredibily stupid that this time it affects his company's performance.

- The social media attention contest continues to be won by fakers, ex-addicts and felons. More non-family friendly content is being accepted from the overlords at FAANG. This has profound effects on society.

- More people from the left start identifying as intellectual right. There's a phaseshift happening and one day it's woke to be right and reactionary to be left.
Ok piece, but clickbait title. I read through the whole thing and couldn’t find any dark side. The only person trying to make him look bad is his girlfriend, and all the reasons seem to be due to their private relationship. I don’t see why they’re any different or special compared to most other relationships. All I saw in this was the description of a human being who was remarkable in some ways, flawed in others, and deeply normal in the rest. Like basically almost everyone else.
(blows on dice)

- Canadian team (prob Calgary) gets close to but does not win Stanley cup

Covid regulations increasingly flaunted, exemplified by pernicious flashing of the nostrils in public. A new type of streaking known as unmasking will take place somewhere and be a brief meme

- Biden popularity decreases leading to more fracturing of the usual fault lines as sides dig in. But because Democrats in power not as much civil unrest

- more real AI advances, along with a bunch of AI bullshitters acting as red herring

- web3 posting will cool down
in first half

- a hyped up application of gpt3 will become a topic of speculation

- trend of bad east west relations continues

- the economic bubble bursts?
Here, let me throw one in the true pile for the benefit of the true/false ratio: near the end of 2022, someone on HN will post a thread along the lines of "Ask HN: What are your predictions for 2023?".
"Automated audit" sounds to me like an oxymoron.