skysight-inc/HackerNews huggingface dataset:
It's a matter of not wasting each other's time and energy on futile things. If it's not going well for one reason or another, better to politely end it and let each other do something else with their day.
Sure, but I don't think just only having direct democracy is sufficient, especially in an anarchist society.

The only nation state currently that somewhat has a form of direct democracy (Major emphasis on somewhat)- Switzerland- still has absurd hierarchies, some even more so than other countries, where entire cantons can decide who can or cannot move somewhere.
Yes, it was controversial in 2017, but the dust settled and in six years since it was generally accepted to be legal. My point is that Red Hat is not trying something new. There are precedents and it is an explored territory.
> The upstream that is mostly Red Hat funded development?

Yes, RH (and others) are doing pretty significant work in the open-source space. I'm not denying that. But without the previous work that all the other non-Big Money-funded people did, RH, SuSE, Oracle MySQL and others wouldn't even be in business.

> My biggest concern is that Red Hat funds so much, so we are at the mercy of Red Hat doing well.

Agreed on that one. Open Source in general lacks decent funding mechanisms.
Side note: Who still uses PH anyway? It's now literally a "freemium OnlyFans" since it exclusively shows content from known, direct producers. That's a useless fraction of what's available, especially if you're not interested in US content.
Disappointed not to see:

6: degrees of separation, at most, between any two people.

Also, USA murder degrees: first, second, third.

Another thing: the melting point of 60/40 solder is there; but not the eutectic mixture 63/37. Geeeeez!
I‘d rather say it‘s a feeling of pity. The illusion of the American Dream has driven generations of Americans into believing it‘s their own fault, not being able to afford e.g. university or decent healthcare besides working three jobs. All because of a myth and an inexplicable fear of socialism that makes them label anything progressive exactly that.
> I wouldn’t be surprised at all if we end up needing accounts verified via government ID to participate online in a meaningful way.

This is already proposed in the UKs Online Safety Bill. Countries such as Australia will immediately follow as our e-safety commissioner froths eroding the privacy of Australian citizens.
I agree that widely available pornography has probably been a net negative for society. However:

1. I'm not convinced that it is markedly worse than other harmful content which is now widely available on the internet.

2. I don't think efficacy should be the primary consideration. For instance, mass censorship is rather effective, but clearly unconscionable. I'm not sure if you can make a cure which isn't worse than the disease.
G = G + 1;
Seconded. Whas scrolling through to see if someone posted it.
> I find it mind blowing that people refer to Twitter as "once great" now that it is known that it was essentially a disgusting totalitarian political censorship and propaganda tool for one of the 2 political flavors in the US.

You're delusional. Twitter before the acquisition was extremely politically neutral and gave extremist right wing voices way more leeway than should be socially acceptable. Post-acquisition has turned it into the 'totalitarian political censorship and propaganda tool' that you're describing, for Musk's personal and political interests, which at the time seem to be ultra-far right.
> scammer presidential candidates who are all antivaxxers

Uhu, borderline hysterical. What are you talking about, actually? Sounds like you have been confused by ongoing political wars...
I enjoyed it as is. Rather than looking for specific details, I was looking for general feel and atmosphere with things like vegetation, architecture and building materials, and even colors. The photos provided were usually good enough for that.
If you’re going for GeoGuessr accuracy, these are going to disappoint. But I don’t think this site is going quite that far.
To be honest as a European I always envy the US and their $1 bills. Its a hassle to always have to carry around all these €1 and €2 coins which one invariably receives by the end of the day.
Which is especially relevant given what happened next.

> On December 13, 2011, Vice President Joe Biden and Treasury Secretary Timothy Geithner announced that the minting of Presidential $1 coins for circulation would be suspended.[21] Future entries in the program, beginning with those of Chester A. Arthur, would be issued in reduced quantities, only for collectors. [Wikipedia](https://en.wikipedia.org/wiki/Presidential_dollar_coins)

The mintage was literally cut from something like 75 million to 10 million.
CentOS existed before it was bought and shutdown. (There is something called CentOS Stream today, but it’s a completely different product with completely different purpose)

All the “rebuilders” redhat is complaining are just CentOS folks continuing to do their thing after their name was bought. So this is almost as old as redhat. Not “a new treat”
Twitter does allow much more free speech than before the acquisition.
The mythological strength of the ancients.
That's a great question. And if we ever develop AGI (unlikely), we may well find out.
This will not benefit Mastodon/Fediverse, but it will benefit Meta because of the already available content. It's basically solving their chicken-or-egg problem for them.

I'm not at all sure this will be good for the Fediverse. I already see Meta "improving" upon ActivityPub in incompatible ways, urging people to just use their app (potential quote: "you can see all of the Fediverse anyways") and in the long run (when their own "instance" is big enough) will pull the plug again and be on its own.
Generally, this is a specialist topic, so you're unlikely to find e.g. good textbooks. It depends a bit on how deep you want to go and what specific parts you're interested in, though. (Query execution is pretty much entirely separate from planning, for one.)

The best join optimizer paper I know of is still the original Selinger paper (https://courses.cs.duke.edu/compsci516/cps216/spring03/paper...). It doesn't support outer joins and there are more efficient techniques by now, but anyone looking at a System R-like optimizer can read this and feel right at home. (There is also the Volcano/Cascades school of optimizers, which is rather different from System R, but I've found even less information on it.)

As others have said, Postgres' source and documentation is good. In particular, src/backend/optimizer/README contains a number of interesting things that you won't find a lot of other places. (The Postgres optimizer doesn't always use the latest fancy designs, but it's generally very polished and pretty easy to read.)

I can also echo Andy Pavlo's courses (at CMU), they're pretty much the only ones who will explain this stuff to you online. The “Building Query Compilers” PDF is rather incomplete and there's a lot of stuff I never cared for in there, but it contains several key papers from Moerkotte et al if you actually want to implement the modern stuff (DPhyp etc.). In general, most of the modern System R-like stuff (how to efficiently deal with outer joins, how to deal with interesting orders, how to deal with large queries) comes from the groups of Moerkotte and/or Neumann; all of these things had solutions before them, but less efficient and/or powerful and/or elegant.

Finding an applicable index isn't hard (you generally just try to see if it hits a predicate—a so-called “sargable predicate”, for SARG = Search ARGument). Estimating selectivity is hard. Estimating selectivity through joins is perhaps the hardest problem in optimizers, and nobody has truly solved it. This was one of the things I never really got to; there are so many hard subproblems. Like, for something that sounds really simple but isn't, what do you do if you have predicates A=x AND B=y AND C=z and you happen to have indexes on (A,B) and (B,C) (with selectivity/cardinality information) and want a selectivity for all three combined? There are papers that literally require you to build a “second-order cone programming” solver to solve this problem :-)
I call bs on that.
> where the student takes things they have heard, seen, or experienced and attempts to transform some part of the world using them

That's probably why some school subjects that lack this component largely or entirely like history, geography or literature are so hard to learn.
> I can see the rainbow effects of antialiasing on my 4k 32" monitor

Are you talking about subpixel rendering?

Leveraging individual R G and B dots needs knowledge of the layout to achieve increased resolution, and the algorithm should be adjusting (best effort) to compensate for human colour perception with knowledge of the subpixel layout + subpixel size.

But usually it might be that the screen has a different layout than the OS picked, e.g RGB vs BGR, vertical vs horizontal, or it has a peculiar layout like RGBG. See down the page for an example when it doesn't match, which usually gives the perceptual effect you described https://www.grc.com/ctwhat.htm

At some point though I found with increasing DPI there's diminishing returns to go subpixel and it's simply easier and just as good to go grayscale AA and be done with it.
Spaced repetition takes effort, and causes pain. It is tedious. So it still fits in with the idea proposed.

I believe you need to be conscious of what you are trying to learn and if it is tedious, then you are conscious of it because tedious means you experience some strain.

You will remember it better because it was painful. Just speculating but it makes sense to my layman brain.
I've been waiting for canned lettuce, because I never have fresh when I need it, and plus they can eat it on the moon.
The app name is bad. It won't be succesful.
I thought one of the main attractions of SQLite was that it was embedded, so specifically didn't need an HTTP round trip to query the DB.

It seems like this project removes that benefit, so what is it solving for or adding instead? What's the upside?
"She said it was 95 degrees outside. I asked if she was being deliberately obtuse."
I asked the following question - “What should I build to help consultants who know AWS to people who are willing to pay to dollar”.

How is the answer I got from your service different than the answer I got from ChatGPT?

Since anyone can enter the same question for both, I won’t bother posting the replies.
I always read hints and in-build help. This is not the case in this game. It explicitly went against the "common convention" so to say. In all location guessing games you get one try per location, and most times you don't need to read instructions if you see a different guessing site. Number 5 is also a tell and different pictures. If it was say 2 tries with different pictures, people would have suspected that something wrong. If it was 5 tries but with the same picture, also suspicious. But it literally had the same game flow from as other guessing games.

And about the instructions. Sure, it is useful to read them, but even more useful, for all humans, is to rely on the training. We don't carry around dictionaries to talk, we don't read "Introduction to Javascript" daily, we don't use UX designer guideline book to open a faucet in the bathroom. And re-training is not free, that's why so many people jumped in based on their old skill. Not based on their ignorance, but on the skill, and that's important distinction. People actually knew how to play such games, that's why they subconsciously omitted instructions.
It's not just nice for that reason, that's the reason the scale exists.
The SQLite optimizer is really primitive. You generally don't want to be using it as a template if you can avoid it; it's good for OLTP but can't handle many-way joins well.
> "transformation" stage of learning -- where the student takes things they have heard, seen, or experienced and attempts to transform some part of the world using them.

Hear and forget, see and remember, do and understand.
Try landscape orientation.
It's not Facebook, it's Instagram. And you don't need any of them to use Threads.
Surprisingly, no... I thought I would, but somehow I've avoided this particular transpositional mistake (probably also due to my habit of setting up a ll or la macro for ls -l and ls -a).

That said, I also don't actually put "." in my path, though this is mainly so I can avoid heisenbugs rather than a security concern...
It does not. The decay is for the arr[size] form.

> using the int array1[2]; like this: arraytest(array1); causes array1 to automatically decay into an int .

> HOWEVER, if you take the address of array1 instead and call arraytest(&array1), you get completely different behavior!

> Now, it does NOT decay into an int
The logo looks like the letters C and a. I wonder whether this is intentional.
A lot of sites just implement the paywall client-side with some JavaScript and CSS, so any kind of search indexer would still see the full text regardless of the user agent or source IP.
i think the two of you should list why they make either terrible or fantastic documentaries.
No Pain, No Gain (William Davies on the changing political economy)
I already don’t trust Meta. I’m not giving them more angles to accumulate personal data.
That's enough of a goal.

> I don't want people to use this as an actual compass

Hence the educational route option should you so choose.

Of course anybody running this on a mobile device will have full GPS and maps available.

Learning about reality is for those that want to navigate by actual compass and|or stars.
They don't have a diverse content-base yet. The Fediverse "shall provide it" to them if it goes according to their plans. Once this deed is done, the Fediverse is no longer valuable to them.
Redhat is profitable in such environment. This environment is not new, see CentOS.

> Making Red Hats business model untenable.

Uber business is untenable. Redhat is very profitable.

> The rabid the attacks of freeloaders

The rabid attacks of people and customers that got their promises broken. Even Dante claimed that the last circle of hell is for the ones that break trust. So, nothing really unexpected is happening here.
Right because applying it to a real problem means you have to go though the effort of solving that problem. Solving a problem always takes effort, else it would not be a "problem". Again the effort seems to be the key here.
They mention replication and optimistic concurrency to allow multiple writers to work in parallel.
> And why do you think countries were distributed to people by some sort of collective decision?
Countries were not "distributed

I obviously don't think that, hence what I wrote. I think they were in many cases fought for and the strong got the best land for the most part. There was no collective decision making. And I'm hinting that maybe the current situation doesn't make much sense for team humans.
> What's great is I can easily swap to an instance that is federating!

Define swap. I'm hearing instances which federate with FB will be defederated as well. If instances need to be federated to "swap", it likely won't be easy.
First only IMDb TV shows hover around 8, films hover around 6.

And it is still useful. For example, from my perspective I can quickly judge a movie from an imdb score.

Anything less than 6.1 is bad. 6.1-6.3, ok, 6.3-6.8 good, 6.8+ excellent.

Apart from movies starring star trek characters, add one to all those scores.

Goodreads is similar but tighter, anything less than 3.9 is a red flag, over 4.2 and you start getting into excellent.

Though in my opinion steam seems to have got it done best with "overwhelminly positive", "very positive", "positive", "mixed", "mostly negative", etc. but occasionally gets review bombed.
With _Generic, the original library implementor has to accommodate your type. If it's a “template”, the user can insert their type. Also a type that's created long after the original library author has finished their work.
Why would Australia be doing that? What's the threat? That the foreign mining companies leave? Wouldn't that be a neutral outcome to Australia? Then the mines could be seized for non-operation somehow, and given to domestic companies with a 78% tax?
Not sure they want that. That would copy over content from their server to the outside and this will be a nightmare for their lawyers. :)
Repeat of rare earth metals. The only reason we buy those from China is because its cheaper than running production in environmentally conscious countries.
Self interests have externalities. The pleasure you gain from improving someone's life is in no way comparable to the pleasure you gain from making other people suffer. It's a fallacy to say "everyone operates in their own self-interest". It's usually parroted by anti-social people in order to justify anti-social behaviour.

> Cut the fascist bullshit. Everyone can comment about how society should be run, even people that are very successful financially.

It's not financial success that precludes someone from commenting on how society is run, it's blatant, deliberate anti-social actions. This is the foundation of a social contract. It's the same reason you'll get locked up if you go around punching people in the face.

Also, I don't think you know what "fascist" means.
I suspect that nobody accepts risks until they are realized in some way.

Nobody really did anything about air pollution until you could see smog, and then catalytic converters were mandated.

Lots of people complained about privacy, but because for practical purposes nobody can "see" a loss of privacy, very little progress has been made.

Not many self-driving car fatalities, so the loud pundit proclamations have not gotten much traction.

Now AI... will this take the path of privacy, where nobody can see it, so nothing happens?
Location: London, UK

Remote: Yes

Willing to relocate: No

Technologies: React, TypeScript, Next.he, Redux, Vite

Résumé/CV: evgeny.dev/cv.pdf

Email: me (at) evgeny.dev

Almost 7 years of experience Front End engineer. Currently working at JPMorgan. My experience is mostly in Fintech industries but open to new remote opportunities. Also writing blog at evgeny.dev/blog and started doing YouTube at https://youtube.com/@EvgenyDev
People like or dislike other people based on how we behave. Does he consider it might just be him? Genuine question because I couldn't bring myself to watch the whole thing!
I still like to have a unique id field per table. It helps logging and it doesn't care about multi fields "real" key.

However I keep an unique index on the string value and more importantly point integrity constraints to it, mainly for readability. It's way easier to read a table full of meaningful strings rather than full of numerical id or uuids.
How is this literally a compass visualization and yet it has no mention of radians?
If you watch the video - made by American - it is more like Europeans dislike certain things about US but they also realize that these are stereotypes...
And they do like some American qualities at the same time...
One tidbit worth mentioning I think is that learning something even if you think you don't know why you should learn it, is that you will learn how to learn. You can then apply that learning to anything. But you are right kids should be taught to see that learning itself is the problem.
> A system with a truly negative temperature on the Kelvin scale is hotter than any system with a positive temperature. If a negative-temperature system and a positive-temperature system come in contact, heat will flow from the negative- to the positive-temperature system

Wait what?!! That feeds my daily “oh oooh” moment.
More things that can be pushed to subconsciousness the better you get. You cannot constantly map your native tongue to a target language consciously and improve.

Look at any activity, chess, music, physical sports, at top levels most of it is subconscious effort.

Imagine having to constantly look at your keyboard, consciously searching for the letters to communicate your thoughts.

How would you expect to communicate well if your conscious process includes the menial search for the individual letters? How would you be a good chess player if you didn't have an intuitive feeling for most board positions but had to evaluate every move for a long time?

The things you learned well, were things that you successfully committed to your subconsciousness. Sometimes you plateau and think there's no room to improve, but by inspecting the conscious effort, you can find things that need to be practiced to make them subconscious.
Keep in mind that when boost features are eventually adopted into the C++ standard library, it is often only after their implementation has been strictly defined in ways that diverge from the boost implementations, which are often inefficient. Boost contains a lot of full-featured but inefficient code; for example, some Boost tools allow for arbitrary memory allocation which is often undesirable and their standard library versions do not allow for it. There are other design issues as well, such as how to consistently handle exceptions in edge cases, etc. Boost versions of some of these don't as comprehensively consider those situations.
Why do you need to manually retry at all? Doesn't it end up in a queue and gets executed as soon as it can? I thought this stuff was handled by the database automatically.
Andrew Jackson is on the $20 and he’s basically the 19th century version of Trump

While we should replace him with someone who actually deserves to be on US currency I still think it’s absolutely hilarious the guy who hated having national banks is the face of one of the most widely used federal reserve notes. It would be like having a Henry Ford Jewish school

I find the same thing funny about John Wayne Airport- dude hated the airport when he was alive and lobbied tons of money to have them change the way planes take off so they wouldn’t buzz his mansion and bother him. I’m sure he rolls in his grave every time a plane doesn’t pull up sharply enough and mildly annoys a rich white person who bought a house in the takeoff path of the airport
Especially if you adjust for Dutch salaries which are on average lower than American salaries.
Please cite the relevant case laws.
The bohr.io is a platform where developers can deploy their front and backend applications most easily ever, and startups can contract those developers to reduce the costs of digital product development. Please help us be Product of the Day by testing our platform and upvoting us!
That's really interesting. But given that it makes Windows defender changes etc I'm hesitant to use it. Also, why would removing edge improve performance?