skysight-inc/HackerNews huggingface dataset:
SQL Server forces determinism here: anything projected when there is a GROUP BY must be one of the grouping properties, an aggregate, or a constant.

mySql does allow other columns to be projected, which has always felt wrong to me as I like my results from the DB to be dertemanistic. I wasn't aware sqlite allowed it too, though I've not directly used sqlite much. It is something that causes issues migrating to other DBs (or when trying to be cross-DB compatible). Often it is used accidentally and by chance gives good results, where is is used deliberately IME it is where the same value will always return due to properties of the that data being queried (in which case the "fix" for other DBs is to use an aggregate like MIN or MAX). Sometimes accidentally use leads to subtle bugs which, as you say, can be rather dangerous.

Note though that these days this can only be used dangerously if the ONLY_FULL_GROUP_BY option is on, and it is off by default. Allowing it in safe circumstances actual makes modern mySql more standards compliant in this respect, see https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.ht... for more detail.
> macOS seems to be considerably worse

Most users will just take their machine in to the Apple Store when this kind of thing happens, rather than try to fix it themselves.
I have been looking at OpenSCAD for some things I want to build / 3d print.

It is better suited for programmers I think. In my case I wrote a wrapper in Python (did the general design) and had chat-gpt generate some subclasses using a template I provided. Now to try and use it. (Yak shaving first haha)
> Conversely windows, just got a USB stick in the drawer I can boot off.

Linux as well. Will probably work better than windows on older hardware
Because they're not actually much more dysfunctional than smaller companies, you just hear more stories because they're bigger. Bigger means more employees for things to go wrong around, bigger means that people are more likely to be interested in hearing stories and thus other people are more likely to tell, remember, and repeat said stories.

A story about some idiot doing an idiotic thing at Google is vastly more likely to be passed around forever than a story at a random mom and pop company*. People love hearing about morons at big tech giants, and the storytellers oblige.

That, plus sufficient economies of scale or complementary tech products.

* unless that story is REALLY incredible, like that guy who went to an interview and accidentally killed the CEO's dog
Thanks for suggestions. I will add @Transactional(readOnly = true) annotation. I will mention in the README the possibility of using two data sources.
I deleted the MacOS installation on my (older) Mac. Linux works well enough
>There is a high likelihood that many other people in the org were lightyears ahead of the author. It's even more likely that an engineer or manager in their group was "Banking" the inefficiencies to use during a cost-cutting period - and the author ruined that chance... which will inevitably cause massive suffering and possibly poor performance reviews when there is nothing to trim."

That's crazy, how it isn't pure sabotage? career oriented people, jezz christ.

That's instant fire by me if somebody considered such a thing
Why do you compare a self-built desktop PC with a Mac notebook? I fail to see anything they have in common.
Back in the days people used to shoot any predator in sight, a leash is just a civilized measure that makes everyone happy, but the old way is fine too with me :)
LCD's are crap when it comes to colors. The new HDR monitors seem to be better, but playing old DOS and Windows games on an (non HDR) monitor is a pain.

I am very courious how many colors from those 16 milion of 24 bits are LCDs able to reproduce. My LCD seems to be able sometimg less than 16 bits (65535).
OK, but tell us how you really feel.
AI safety regulation threatens our digital freedoms
It will sometimes work. Eventually it’ll get hopelessly corrupted because that’s what network filesystems do to shared files.
Thanks, makes total sense. If the first counter is free running then it should look pretty random if sampled when there are collisions as those would be random themselves. Love how simple the solutions are when transistors were expensive.
Hi, is there any plant to improve the UI? About 1/3rd of vertical space is used by phind logo and the search box below it.
I sincerely believe it needs some professional/business touch on its UI.
Should AI Be Held Liable When Things Go Wrong?
> performs within 1% WER

From the paper, for short-form audio:

> the distil-large-v2 model achieves the lowest overall average WER of 10.1%. It is one percentage point higher than the large-v2 baseline, with 5.8 times faster inference speed and fewer than half the parameters.

Long-form is similar, except Distil-Whisper does slightly better than Whisper (fewer hallucinations, apparently).

10% WER seems awfully high, and doesn't match my experience with Whisper. Maybe my audio is nice and clean relative to their test set?
> Soldered CPU/memory makes sense for performance.

And I have talked about storage.
plpgsql is good language. But in my experience Java and .NET developers tend to choose solutions that do not use plpgsql, PL/SQL, T-SQL. And these developers is the main audience for the project.
Challenges for Making Automation a "Team Player" in Joint Human-Agent Activity
I'm a bit envious of authors in that respect. Once their work is complete and sent off into the world they can stop thinking about it and move on to the next thing.
I listened from the start to the most recent main series, all of the Indian series, and am a quarter of the way through the African philosophy section. I concur and recommend the rest :)

I’ll add a caveat: listening to a podcast is a very passive form of learning. Most people won’t remember the majority of the content. But that’s ok, the enjoyment comes from how intellectually stimulating the podcast is as your wrestle with the new ideas.
To be fair -- it's been a couple of years since I played Valve multiplayer games regularly. Has cheating increased at a high rate in the past, say, 3-4 years?

I will say, I think the biggest problem contributing to high levels of cheating is the move away from dedicated servers. I actually find that VAC is historically very effective at catching cheaters, but with a necessary lag between detection and bans -- and that lag used to be handled by server admins.
For a person motivated by competition, opponents aim assists just kills the whole point of playing. That is not elitist, that is just being a person.

His enjoyment is for him as important as yours for you. He is in fact entitled to play only games he likes to play is setup he finds fair.

And he is fully entitled to express it out loud so that similarly minded people can bond or argue for existence of games they like.
These giant facilities are in a sense humanity's artificial "exo-sensors", an augmentation of our ability to perceive and understand the Universe. They are costly in comparison to resources accessible to an indvidual but still manageable when done collectively by large countries or country coalitions. Its not clear when and how competition can be a plus in this space. If the core technology is similar/known it may make sense to just pool the widest possible international resources and build the largest possible thing. But there is also something to be said about competing teams taking calculated risks with exploring new directions.
>Graphics don't matter, let sprites be colored rectangles.

Why? Are the sprites and backgrounds too easy to recreate with MJ and Dall-e after you realized that the author actually provided the prompts for them?
The bigness itself causes dysfunction, apart from just having more employees and more chances to have a disaster. It's the whole Dunbar's number thing, we really haven't figured out a great way to work effectively in huge groups yet.

But... some things can only be done with huge groups, so even working ineffectively can be worth it. And in a competitive setting, your competition also has these problems, so you can win in the market despite them.
The number of deaths is not how to keep the tally on who is more moral and who isn’t.

Hamas deliberately went out of their way to murder, mutilate and rape innocent civilians, while also hiding amongst their own civilians.

Meanwhile, IDF are targeting Hamas and civilians are stuck in the crossfire.

They have also developed advanced countermeasures to negate the effects of Hamas rocket artillery (the iron dome).
Your poll is asking a different question. You said people expected to know this. Implying that there is a minimum level of knowledge required to participate in hacker news.

Your poll is asking do they know what a TCP IP stack is. Even if 100 percent of respondents know, it doesn't validate your claim that hacker news requires this knowledge.

Btw I got really good responses to my questions about networking recently. Should I not be asking these types of questions?

https://news.ycombinator.com/item?id=37842863
If there is nothing then by default the full copyright laws apply so they actually needed to write something, even if only to state that they want the code to be in the public domain, to protect users.
I loath Spiegel just as much as any other online privacy advocate, but I'd always assumed they were simply in violation of the GDPR. Can you provide any references indicating that this is the result of a special exemption due to successful lobbying?
"Deploy anything in six keystrokes"

https://surge.sh/
It happens that schools will provide updates only on Facebook, and ISPs only provide support on Twitter, so the there is not always a third option.
Username checks out. Antarctica airport let’s go!
> The whole adtech vs. hand-crafted ad systems is a big question for small site owners who can't be asked to sell their own ad space etc.

Could the ad networks scan the site instead and use the content on the pages to determine likely target audiences? You could still do ad networks, and target audience, based on the site that they are currently on.

The current version of adtech is pretty damaging to society as a whole and it's getting increasingly worse. Apparently nothing online or content related is able to generate enough revenue to keep itself afloat without ads. Manufactures of TVs and cars are collecting and selling data to increase profit, but are themselves buying ads, making it akin to a pyramid scheme. Maybe we need to start taking a look at the industries that are heavily depending on selling ad space to survive and question if they need to exist, or should be transformed into actual products.
This should be the top comment of the thread. I wouldn’t have had any idea what was going on otherwise.
There are many companies that are so wealthy that they could just stop all revenue completely and coast no for decades while management continues to skim out their fat paychecks. Some theorize that this has already occurred.

Besides, -- if you think how some companies work is fugly, go take a look at biology or politics. Companies are evolved systems. Once they're old enough they're almost always messy even when they aren't especially dysfunctional.

The human body is full of almost vestigial parts and dead end metabolic pathways... huge chunks of our DNA are just self replicating repeating sequences.

In reality the cruft in companies is often not even non-functional, but sometimes it serves some more complex purpose. Lots of large companies, for example, have some useless figurehead security position that exists for the actual purpose of having someone to fire when there the inevitable serious security issue occurs, without putting anyone actually productive at risk.

Companies are built out of and owned by people. Like anything else they have to respect the the limitations of the building material and the needs of their owners. The resulting requirements are no less real even though they might not exist in a world populated by homoeconomicus instead of man kind. If man kind wants a blood sacrifice for security incidents then it's reasonable and good for a company to have one.
> The Norwegian Privacy Council's decision is an instruction to the Irish Data Protection Authority to place a permanent ban on Meta's European head office in Ireland

Isn't this going to be a problem? The Irish DPA has been known to be in bed with big tech in the past, considering Ireland's entire economy is based around being a tax haven for Big Tech, and importing tech workers with the highest EU salaries taxed at 52% for the highest bracket

https://web.archive.org/web/20230609051152/https://www.irish...
There was a period in my life in my early 20s when I dabbled heavily in taoism. The book was a staple read for me and I tried to adjust my Outlook accordingly for a long time.

Finally though, i dropped it and went back to who I was. Your comment makes me wonder if the specific translation of the book I read was a big factor.
He's being sued for his actions not because of his position - he was responsible for acknowledging the issues internally and not acting on them, he was responsible for the language of statements made to shareholders that misled them about the state of security.

If he had sent an email to the CEO saying "we have a problem, we need to do something about this" and the CEO had overruled him, the CEO would be being sued directly.

It doesn't really matter what his role or how high up he was - he was found standing over the body holding the smoking gun.
> I wasn’t allowed to touch it, the man with gloves was very serious about that. I really wanted to touch it.

It’s basically asbestos. Vantablack is the posterboy for nanotoxicity thanks to the carbon nanotubes.

That’s why the manufacturer licensed it to a single artist in the beginning - it has to be used in a lab environment with proper handling and ventilation.
Agreed, I love it for things like this. Someone puts a big bright yellow and red banner on the top of confluence or Jira weeks in advance to notify about upcoming outages. I really couldn't care less about those and it's perfect to get rid of them.
Ask HN: How to bootstrap without significant money?
But as no one (yet) needs private health insurance, and very few people have it, it is not (yet) a societal worry that the data will be used to "offer a choice" to people based on genetic misfortune (the choice is bankruptcy or death).

> NHS is also chronically underfunded.

That's very much by ideological design. A recent ex-health minister even co-wrote a book which contained this:

> Our ambition should be to break down the barriers between private & public provision, in effect denationalising the provision of health care in Britain.

Notably he became health minister after this, not before, so the appointment says a lot about what the Party has in mind.

If you look at the graph of waiting times, his tenure is from 2012-2018, and the party is in place from 2010 and quickly has the knives out to ruin the then-recent improvement. https://www.statista.com/chart/27447/nhs-hospital-waiting-ti...

The latest squeeze on "efficiency" (dragging this back into technology) is throwing AI (read: more consultancy contracts) at it.
Have you tried custom instructions ? I use this:

My dad always used to say: Everything that can be said, can be said simply. I prefer top-down structured, short and thoughtful responses.
Laws may not be enough but it would be a good start at least. If that doesn’t work we’ll try something else.
Imagine how much quicker he would be with the latest AI extensions to Word.
FYI the Asahi Linux installer says “please upgrade that should help” but bumping 13.6 -> Sonoma 14.1 did not help, the SystemRecovery still shows up as 13.5

Or does that mean wait for 14.2?
All of these (apart from abortion as birth control which is IMHO complicated) are very black & white issues.

But I don't see a problem when people change their opinions during their lifetime, with new experiences and better understanding. Much better than blindly following some specific dogma.
Difficult to explain. As far as I remember it always showed the CN subtitles and you could with your mouse always see the translation and the meaning of the single characters.

viki and iq are around 5 USD a months so it could still be worth it.

This plug in is supposed to work well with Netflix:
https://www.languagereactor.com/

Netflix is 12 USD or something. I am just out of prison and I have zero money and currently this is out of my reach. But it may work well for you.

BTW, try this movie: https://www.imdb.com/title/tt7180392/
Do you think this worked so cleanly because there is a tutorial similar to this and its in the dataset?

https://github.com/liabru/matter-js/wiki/Tutorials
i'm pretty sure there's an setting/option to disable battery optimization for firefox
Haha, that model is ancient. I doubt that anyone is using it now. Can they reproduce that problem in any recent model?
Why does the demo require an account, isn't the whole point it the demo to convince people to register?

I'm not going to give away my email address without knowing more than "clone someone with ChatGPT" on a website with no more information than four names and a title.

I'm guessing this is another character.ai then?
It's quite funny to think that back in the eighties ordinary (ie not technical) people were navigating the command line on their PC's.
I find it extremely valuable that there are so many translations available to begin with.
With this type of subject matter, where words are but crude pointers to insight, having different phrasing helps to reclaim the insights when words become too familiar.
One overlooked reason is the government intervening to save these companies. Either by bailout, lowering rate, special loans, etc… This prevents these companies from going into bankruptcy and restructuring and keeps the status quo as is.

It’s kind of a disguised communism and the longer the government keeps proping the economy (and making it difficult to start new companies), the worse this will get.
I anlway prefer using OG .com and .net for business/apps, and .org for personal.

These are all general purpose and open for anything. You gotta get creative with the naming though!
Sassoon: After FTX declared bankruptcy, isn't it true that one of the first things you did was try to restore your administrative access to [FTX's Amazon Web
Services] database?

SBF: That's not how I would put it.

Sassoon: Isn't it true that in the weeks following the bankruptcy, you asked to have your access to the AWS database restored?

SBF: I was not specifically looking for my personal access to the AWS database.

Sasson: Isn't it true you were requesting AWS access?

SBF: I was requesting it on behalf of the joint provisional liquidators in the Bahamas.

Sassoon: So, yes or no: You made requests to restore access to the AWS database?

SBF: I'm not sure exactly what you're referring to here.

Judge Lewis Kaplan: Look, could you just answer the question instead of trying to ask the questioner what she's referring to?

Later, Kaplan again: "Mr. Bankman-Fried, the issue is not what she is referring to. Please answer the question."

For another moment, when Bankman-Fried gave a stiff "mhmm" as an answer to a spot margin-related query, Kaplan told him, "We need a word," extracting from SBF an apology and a "yes."

I suspect that Kaplan was most infuriated, however, by another back-and-forth in which Sassoon questioned the witness over his attempt to access his shares of Robinhood, the online trading platform, following FTX's bankruptcy-specifically, through a form signed by SBF proffering "unanimous consent" of Alameda's board of directors to a stock transfer from the hedge fund to ... FTX.

Sassoon: Looking at the bottom, you were the only member of the board, correct?

SBF: It looks like it.

Sassoon: Well, were you in fact the only member of the board?

SBF: I'm not sure which board of directors this is referring to. ...

Sassoon: Do you see at the top where it says "Alameda Research, Unanimous Consent of Board of Directors, Stock Transfer"?

SBF: Yup.

Sassoon: And this is transferring the Robinhood stock to yourself, right?

SBF: Transferring it from one company that I was a partial owner of to another company I was a partial owner of. Sorry. I'm not sure it says it's transferred to
me.

Sassoon: This says, "Unanimous Consent of Board of Directors." Looking at the bottom, you were the only member of the board, correct?

SBF: It looks like it.

Sassoon: Well, were you in fact the only member of the board?

SBF: I'm not sure which board of directors this is referring to.

...

Sassoon: So, the entity here, Alameda Research Ltd., you were the sole member of the board of directors, correct?

SBF: This makes it seem like I was, as of then. I probably was, as of then. It wasn't my intention to be.

Sassoon: You said it wasn't your intention to be. You signed this document, right?

SBF: Yes.

Sassoon: And this document says you were the chairman and sole member of the board of Alameda Research Ltd., correct?

SBF: Yup.

Kaplan: So, did you become director by mistake or accident or something else?
Immigrants Are Leaving Canada at Faster Pace, Study Shows
The pre-roll has basically stopped me using Twitch entirely now. Just last week I checked out an sub I used to subscribe to, immediate pre-roll for 1 minute and I was out.
https://archive.is/lf8Ug
Towards Responsible Publishing
> >> Laws generally don't allow you to sell or otherwise relinquish your rights,

> Ahh, we are not asking you to sell. We are asking you to give them in exchange for services.

That's covered in the "or otherwise relinquish your rights" part. Privacy is a right, you can't sell or relinquish it, in exchange or donated, doesn't matter.
CreepJS
You're talking about ARM, right?

As within 3 years, I expect most Android devices to be RISC-V.
Sometimes I'd like to pick a non-aggregated, non-grouped column that I know will be the same for the whole group. (I often write SQL in GCP's BigQuery that forbids indeterminate results in group bys) I'd like to have an aggregate function something like assert_same(), that picks the value, and errors when some of the values in the group are unexpectedly different.
Re: docs - oops. We were frantically putting stuff together and linking before the docs were in that location - the link is supposed to be https://docs.streamdal.com/en/core-components/sdk/ . Fixed it in the readme.

re: libs vs sdk - we named it that in anticipation of exactly having to do some funky stuff. As it stands, we are already doing grpc, Protobuf, wasm and having it all interop across all languages is not easy - so having to introduce some sort of a “helper” binding/lib is not at all unlikely.

Besides that, the “tail” part is really a small part of the functionality - the overall idea is that the sdk/lib has access to most/all I/O of the app and is able to interact with the payload that the caller provides before it is sent on its way.

Traditional pipes aren’t really in the equation.

We went with calling it “tail” because it’s easier to explain instead of “it’s a lib that an app owner can wrap their i/o calls with to enable calling dynamic wasm”… and that’s still not the whole thing haha

Last, here’s a diagram depicting the flow: https://docs.streamdal.com/_astro/StreamdalSdk.cd7c8d45.png
https://archive.ph/a6C5H
Seems like a normal day in a corporation? Bean counters who decide your salary use beyond-stupid metrics. For instance, fighting fires is often rewarded disproportionately, so it’s good to be “visible” during many, recurring fires. Of course people game that, intentionally or unintentionally. You don’t get the behavior you say you want, you get what you incentivize.

Even at pure tech companies with somewhat technically competent leadership the incentives are whack, and often the people at the very top are still replicating some MBA doctrine that will be debunked as horse manure within a decade.

Just because our computers get exponentially better doesn’t mean people do, particularly groups of people.