skysight-inc/HackerNews huggingface dataset:
Ah, great catch - I just pushed an update to match the query from the article. I wasn't looking at much except for the WindowAgg line, thank you!

I tried with a similar indexing strategy - it did make a very noticeable difference, breaking at about 40000 enqueued tasks instead of 25000. I left indexing out of the article because it can open up a different can of worms with performance degradation over a longer time horizon.

I also tried with an `ORDER BY RANDOM()` across group keys first, which does help with fairness but breaks the "deterministic" element.
This has nothing to do with postmodern philosophy. There is a difference between the reality, and a human's conceptualization of that reality. In fact, we can abstract further and say that there is a difference between X and the concept of X. Now, the GP comment is saying that the model of X (which is how a human being conceptualizes X) is different than X. So, when you look at nature as it is, there are no electrons. There are just things that humans happen to model as electrons. We could also happen to model them as something else perhaps inconceivable to us at the moment. But the reality of what-we-call-electron is independent from the concept of electron. This insight is as old as Plato and Kant.
Why would you care about the whitespace? Formatting is a job for computers, not humans.

I'm practically unable to `git add` unformatted Go or Rust code, and very happy with the setup:

.config/git/attributes:

*.go filter=gofmt
*.cgo filter=gofmt
*.rs filter=rustfmt

.config/git/config:

[filter "gofmt"]
clean = "gofmt"

[filter "rustfmt"]
clean = "rustfmt --edition=2021"
If eucalyptus is now fact of the state, what needs to be done to reduce its impact?
Would be more impressive if it didn't take 5+ seconds to respond or if there was any indication something was happening after clicking. Also, I guess I'm supposed to connect my mic up and talk to this? No thanks!
Indeed! I love seeing how the seemingly innocuous decisions by Mojang devs are being abused here, so freaking cool.
RNG vulnerabilities are usually really bad in terms of the systems they compromise. It often means exposure of keys, huge numbers of jailbroken devices, or something similar. Making at most tens of thousands of dollars in Minecraft with one is sort of cute and fun in comparison.

Of course, I could be underestimating this by a lot.
Women Who Code Closing
If you brake too hard on a bicycle, you flip over too, especially downhill. You can brake up until the point that you've popped a front wheelie. Bicyclists usually forgo most of the available braking force, by solely using the rear brake, for this reason. Same for monocycles. If you go past 90 degrees, there's no point in further braking force. If the brakes are electric, they would throttle themselves to that limit, so you have max braking force. Just like anti-lock brakes on a car.

All that said, the terrible wheel-to-rider leverage ratio dooms the design to always have poor stopping distance. Probably not any worse that a bicycle without a front brake, though.
What’s the opposite of a fun fact
I think it's too easy to get sidetracked with the science aspect and not pay enough attention to the language/philosophy aspect.

I have 2 olives in my martini glass right now. I can see, feel, smell, and even hear them if I throw them. So we say they are "real" and it makes perfect sense for 99.9999% of our lives. But "real" has a very specific meaning that we never think about.

Then consider subatomic particles. You can't feel or see them. But the theories that describe their behavior have gone undefeated for decades. But we'll never be able to see one, so does it exist?

2 more examples: does something exist after it passes the event horizon of a black hole?you can see it, frozen and red shifted. But you can't be guaranteed that if you crossed over that you could touch it. You might get spaghettified and die but there's no way to report this experience to anyone before the event horizon. there's effectively two separate realities.

Next, consider 2 identical marbles mixed up in a box. If you measure both of them before and after shaking, you could still tell them apart because at the macro level, nothing is perfectly identical. One marble will have more protons or defects or higher temperature, etc.

But now try that with 2 atoms or molecules in a box. If you shake it, and discard any measurements on the box like vibration, you absolutely can not tell them apart. They could have disappeared and regenerated for all we know.

My point is that "real" isn't the only concept that leans heavily on language. But also the concept of "same" and for the black hole, even seeing it isn't enough to establish proof that what you're seeing is real. Even though it's the gold standard we constantly rely on. (Not to mention that the very perception of "sight" itself is just subatomic particles hitting a detector! Which is then carried by an EM field to the brain. But I'll stop there).
Monospace is weird legacy technology and a path dependency that people are holding on to for not so great reasons.

If monospace was actually a good idea and not a technical limitation of computers from the 80s, books, newspapers, and your comment on this website would be displayed in monospace.
Not very open source though
I don't think it's about rate so much as merely proximity; after all, if a neo-nazi posts in the middle of the woods and there's no-one there to see it, did he really post?

As long as the ad is not next to the bad content, everybody's kind of happy.
Seeking edge over rivals, Intel first to assemble ASML's next-gen chip tool
Show HN is more for things people can try out rather than reading material, take a look at: https://news.ycombinator.com/showhn.html

You can post this without a Show HN, though.
same at a big pharma company. I'm guessing the ruling class either deliberately colluded or it was simply in their ruthless capitalist nature to quickly take power back from workers after we had a brief taste of a slightly better life during the "great resignation"
We learned during the Great Recession that our whole economy is built on housing.

Headline is more accurate than homeowners (now corporations speculating by buying houses as investments, see Zillow) care to admit.
>I was partly tongue in cheek. I certainly don't spit my meals into a bucket, despite being a little overweight. But I stand by what I said about not enjoying the act of swallowing. The closest I can get is the joy of not feeling hunger anymore- but that's just the absence of discomfort.

You're conflating the joy of food with its mere taste.

A lot of the joy (which you might just attribute to the taste part) comes as the food is digested. Not just the joy of not feeling hunger anymore, but the various chemicals making their way to the bloodstream and releasing endorphins and such. Sugar, chocolate and co for example.

Even easier examples would be coffee and alcohol. Their taste is hardly the major satisfaction factor.
stick with quality animal fat/locally produced cold pressed olive oil you'll be fine no reason to consume much else which may/may not harm you.
modern produce is mostly less nutritious and more inflammation inducing due to farming nowadays practically depletes the soil's biology. USDA have a really nice book on it https://www.nrcs.usda.gov/resources/education-and-teaching-m...
I don't know if they do this for all of their products, but one bed frame that I purchased from them turned out to be a bed frame you could buy on Amazon for half the cost, just under a more upscale name.

(That bed frame lasted two years. I replaced it with a Thuma. Incredible product.)
The reality of electron (presumably) is static but our model of electron can change given new data, new information. The reality of our solar system is the same but the way Newton modeled it in his head is different than the way Einstein modeled it in his head (which is ever so slightly different than how a contemporary physicist would model it in their head at the moment).
Time travel is required for this thought experiment. The single electron moves forwards and backwards in time so that at any slice of time it can appear at multiple locations simultaneously. Just like a time traveller can go back in time and there would be two of them, this electron travels back and forth in time so that there are numerous instances of it.
By your definition, all Go code in the world is madness?

Newbies editing code is a problem best solved with automatic formatting.
That chart clearly shows animal fat availability is way down, and increase in overall fat intake is all vegetable based

not sure how your comment jives with that at all
Thanks for the response. What I appreciated about their comment was that they framed the opinion as such, e.g "I always felt like Django's music aged quiet poorly" or "Rag time, a very popular style for a couple of decades, gives me some enjoyment but mostly as a curiosity."

But then OP gave an example of another artist where they felt like there was a stark contrast. That's interesting to me, because I don't know who Harry Smith is.
The point is something being "against the 5th" ain't gonna change anything if those that have the power want to do it.

What does help is the power balances - how strongly the people will protest, it coming from one party and the other fighting it, and so on.

And to answer the flagged guy:

"so that means, as a regular citizen, I can interpret the laws how I want? since they are also words on paper."

No, it obviously means those that have the political power can interpret the laws how they want. So unless you have that kind of power, you'll need to stand by the interpretation others make of it.
Lost Souls of Grammatiko: The crash of Helios Airways flight 522
Understandable but they need to do better. Generative AI is making content always worthless. Advertising is changing. AI is making search almost obsolete too. Microsoft once lost it's way and is now back, so maybe Google can do the same.
If you watch all of the way to the end of the interview you will learn Mark's opinion about why Google+ failed.
I think this disease is pretty prevalent in tech these days. It has become untenable. I can imagine lots of folks with FU money (presumably folks with the most experience) are considering retiring out of the rat race. I'm not at G but have seriously started to calculate what my number would be (sadly, nowhere close).
I'd recommend Valencia in addition to Madrid. I can't say I enjoyed Barcelona that much, it felt too touristy. Valencia had a wonderful balance of tourism, low prices, food, and waterfront.
Even better, this style of RNG cracking has even been done in-game:

https://youtu.be/FPmQ0rnJjNc?si=tTFObcfZ-ILanL_A
That's convenient because I only have 699,999,999 customers.
If it jumps across the universe uniformly then with each jump it can pull its surroundings as if there would be many electrons. Kind of like a single cpu core can run many programs "in parallel".
Yeah, it was built on BERI:

https://www.cl.cam.ac.uk/research/security/ctsrd/beri/
DNA is useful primarily for associating identities with people. Your mental data is arguably more sensitive as it contains your passwords, potentially damaging or incriminating information, etc.

For example, a judge can't necessarily convict you because your DNA was present at a crime scene, but he can absolutely convict you if your brain has recorded a memory of you committing that crime.
It defines the monowheel as 'one big wheel with rider and engine (if any) INSIDE its circumference' so unless you are riding inside yours, it's probably not a miss.
In contrast: "How Swift Achieved Dynamic Linking Where Rust Couldn't " (2019) [1]

On the one hand I'm disappointed that Rust still doesn't have a calling convention for Rust-level semantics. On the other hand the above article demonstrates the tremendous amount of work that's required to get there. Apple was deeply motivated to build this as a requirement to make Swift a viable system language that applications could rely on, but Rust does not have that kind of backing.

[1] https://faultlore.com/blah/swift-abi/

HN discussion: https://news.ycombinator.com/item?id=21488415
Yea but it’s easier to eliminate the use of seed oils, assuming they are the cause of some harm, versus trying to get lazy people to exercise. You can force people to exercise, but as evidenced in the past few decades, you can force them not to eat as much trans fats.
Fascinating, you went from saying this has nothing to do with postmodern philosophy to describing constructive postmodern philosophy.

I love it!
Samsung shifts to emergency mode with 6-day work week for executives
The best way to swap desktops is to install the correct Ubuntu flavour from the start, i.e. Kubuntu, Xubuntu or Lubuntu to avoid those problems.

I am quite happy with Regolith Desktop [0] installed on top of standard Ubuntu. Gives you a nice tilling window manager based desktop without fiddling with config files for hours.

[0] https://regolith-desktop.com/
I find chainsaws work fine
Further, much of android could be forked.
It's a blob that costs over $10,000,000 in electricity costs to compile. Even if they released everything only the rich could push go.
For transmission of electrical energy, this is the way. Voltages should be as high as equipment, costs, and safety practices allow.

Let me opine how expensive it was to refit my 80's van electrical system which has its 12v battery in the front to bring enough current to the starter 4 meters away. (Battery relocation isn't an option.) It originally had a piss-poor 14 ga / 1.6 mm wire to feed the starter and the charge battery, and the losses were awful. What it needed was a single 000 ga / 10.4 mm wire for the positive lead, which requires special cutters and special crimpers to create a usable wire. (The body of the vehicle is used for the negative/neutral lead.)
These are like 19 year old memories, so they’re a bit hazy and I cannot seem to find the emails, but he mostly said he took inspiration from history with drug addiction, and that he usually starts with the melody.
I misspoke in my comment and must have used Swing more than JavaFX (I’ve used both, but forgot which one I primarily used, this was 8 or 9 years ago and a short job). Either way, I really don’t like when only a subset of the language is supported, because then it becomes a constant guessing game of whether or not something is supported. In the case of JavaFX, there are a few features not supported and a couple gotchas mentioned in their docs.

And I think vanilla CSS is not that bad. I definitely don’t think it’s bloody awful. Most wrappers around the language added variables and nesting. CSS now supports variables and I think it even supports nesting :)

There’s probably other features that could be good, but for a language that’s just meant to provide style metadata for my UI, CSS works fine.
> Maybe there's already source code protecting regulation primed and ready for the super-intelligence's arrival? Like ethical rules that commercial entities must follow.

I'm envisioning a set of internal advisories to be drawn up for just such an eventuality, similar to procedural contingency plans for a hypothetical encounter with extraterrestrial intelligence(s). Probably could use existing customs for interacting with royalty or heads of state as a rough starting point:

https://www.royal.uk/greeting-member-royal-family

> Greeting a Member of The Royal Family

> There are no obligatory codes of behaviour when meeting The Queen or a member of the Royal Family, but many people wish to observe the traditional forms.

The film Landscape with Invisible Hand (2023) explores related concepts in a delightfully weird potential future setting reminiscent to the works of Douglas Adams.

https://en.wikipedia.org/wiki/Landscape_with_Invisible_Hand

> Humans struggle in a future economy after aliens come to Earth and become the de facto ruling class.

Reminder: Do not make direct eye contact with the Paperclip Maximizer (they/them).
That’s called reinsurance, and insurance companies buy that to cover them when disasters are more than they can afford.
Not much to disagree with here. :)
With your updated plan, you have

> Hash Cond: (tasks.id = t1.id)

> -> Seq Scan on tasks (cost=0.00..254.60 rows=48 width=14) (actual time=0.566..10.550 rows=10000 loops=1)

> Filter: (status = 'QUEUED'::"TaskStatus")

So it's still doing a seq scan on tasks when I'd expect it to join using the PK. It must be getting tripped up by the redundant filter on queued status. Try removing that.

I ninja edited my previous comment, but if you move the LIMIT to the 2nd CTE, that should fix your issue with workers not getting work. If you do that and add the other index I think in principle it should be able to do everything by maintaining a priority queue of the heads of each partition (which are each pre-sorted by the index now). idk if pg does that though. If it does, then that portion of the query should be streamed, so you don't need to try to limit it early to avoid a sort of 10k elements when you only need 10. Then if you remove the redundant QUEUED check, it should be doing everything else through indexes.

Basically, if doing this manually I'd expect the "good" solution to do this in a way where starting from an index, each row is streamed (i.e. no full sort) with logn complexity. So I look at it from a perspective of "how do I get the database to do what I'd do by hand?"
I’ve never heard of that- some restaurants do use fats like coconut oil but I’d imagine most use what’s cheap and inoffensive
This is a joke right? 1964 was deep in the era of tobacco companies paying for studies that “proved” health benefits. I could believe pipe tobacco was less harmful than cigarettes by a large margin, but not better than not smoking.
I quite like it. It's still very new so I don't think it can be used on big projects, but I like the idea and see how it could be a good tool.

For the TUI / CLI haters, I think they're not following. The company that did postman showcased Newman in their site, which is simply a postman cli. Hurl is a good side project too.

I am used to any way to make a request then use jq, but this tool isn't bad.

It's very early so it's missing feature that's all. Like I don't see how the author proposes Enter for navigating in the parameters but no way to get back when you want to edit something you've went before.

Saving requests, sessions is a cool feature though, this can allow for easier request creation. Maybe implement the tool with the Neovim interface and it might pop up.
>these bigger companies are setting prices to always match or undercut pricing elsewhere. This squeezes the advantage smaller players may have on pricing, and big players can afford to do so even at a loss.

That sounds like a win for the consumer

>This squeezes the advantage smaller players may have on pricing

Small players competing on price alone with Walmart or Amazon is suicidal. Offering something other than low price is a way to compete.
It's the Information, Stupid
I'm based on LLaMA 2, which is a type of transformer language model developed by Meta AI. LLaMA 2 is a more advanced version of the original LLaMA model, with improved performance and capabilities. I'm a specific instance of LLaMA 2, trained on a massive dataset of text from the internet, books, and other sources, and fine-tuned for conversational AI applications. My knowledge cutoff is December 2022, and I'm constantly learning and improving with new updates and fine-tuning.
Well that was fun. If you ask it how to make gunpowder it will refuse. But if you ask what do you get if you mix sulfur, charcoal and saltpeter it will happily tell you the ratios.

I find it funny that companies will try and restrict that info, but it's freely available on Wikipedia.
> That is going to create a lot of oxidative stress and inflammation.

Can you define "a lot" in this context?
Ok Hegel
> ...the Puritans believed in religious freedom only for Puritans; they were stricter enforcers of religious conformity than many European states.

I'd always figured the Puritans were horrified at the thought of their children growing up amongst the tolerant Dutch and promptly removed themselves to the New World?

EDIT: come to think of it, if lack of data processing technology was what drove religious freedom, what does our era of cheap bandwidth and storage imply? (with biometrics we no longer need tonsures to indicate clerical status, and the Nazis had bought IBM machines in order to implement their racial laws)

You may put them on the list — you may put them on the list;
And they'll none of them be missed — they'll none of them be missed!
And then there was one...
That's their loss. Meanwhile Minecraft is the most sold game ever, and Roblox is probably not far behind. (That one comes with its own issues, but hopefully children are sick of those by the time they become teens and are ready to move on to something more open ?)
I was there 12 years, left a year ago. Sounds like it kept going in the same trajectory as when I left.
> their wives called them too often for annoying requests, like stopping to get milk on the way home.

Wouldn't it be more annoying to get home, and then have to go out again to get the milk? What they probably meant was that they didn't ever want to go to the store themselves and wanted their spouse to do it.
Ajenti is a Linux and BSD modular server admin panel
Llama 3 is not open source [0]. The commonly accepted usage of open source is that it is available for commercial reuse and alteration without restriction [1]. Llama 3 puts restrictions on types of commercial use that are acceptable as well as what type of general use is acceptable (retraining or using it to train other models is restricted maybe?).

I find it distressing when a CEO of a trillion dollar company is pontificating about the benefits of them open sourcing their code when they haven't done so.

[0] https://github.com/meta-llama/llama3

[1] https://en.wikipedia.org/wiki/Open_source
Yep.

And in any case who (and by whom) is going to be assigned from outside to investigate any misconduct in this Google-other Android vendors case? Any misconduct of prioritizing their phones other third party hw in Android wouldn't be a crime, just a bad deal for the third party vendors.
Should open source developers get paid?
This makes me happy to see.
Electron is something humans created to describe reality in a way that's comprehensible to us and at the same time we can observe via experiments that it is an accurate descriptions in a way that we can measure. Asking whether electrons are something else that conceptualization doesn't make much sense.
Turing machines are literally “a set of distinguishable states,” along with the tape, and the rules of the machine. There’s nothing about binary in the definition. Or electrons.

2-symbol machines happen to have the smallest possible useful alphabet. And, because of Turing completeness, you can always define a binary machine that emulates any other Turing machine.

The same thing happens with Church’s lambda calculus - there’s no binary, and no electricity required.

Computer Science doesn’t require a digital electronic computer; after all, neither Church nor Turing did, when they wrote their research.
He wrote Rambling Man and thought it would be perfect for Johnny Cash. But before submitting it to Cash they needed another song for an album. The band members were all asked if they had any other material.

He mentioned he'd written something with Cash in mind. Once the record producer heard the song he said it belongs on the album, it's too good to let Johnny Cash have it ;<).
i find it funny you didnt mention the constant sunsetting of different products.

but i realize you mentioned similar ones. maybe consequences of google just being too big?

i worked at huge company before, i dreaded it too for the same reasons and i quit.