skysight-inc/HackerNews huggingface dataset:
> So the way that we enforce it, is that we only generate SELECT queries, and do a post process verification to make sure that the result is actually only a read-only query.

So it will select from functions?

CREATE OR REPLACE FUNCTION delete_all_from_table(_tbl regclass)
RETURNS integer AS
$func$
DECLARE
_r record;
_count integer = 0;
BEGIN
FOR _r IN
EXECUTE format('DELETE FROM %s RETURNING *', _tbl)
LOOP
_count := _count + 1;
END LOOP;

RETURN _count;
END
$func$ LANGUAGE plpgsql;

SELECT delete_all_from_table('users');
Can relate. I was in a dating app and there were so many of them pretending “nice looking girl looking for husband” that then tried to befriend you and tried crypto scam. It’s so smooth that even as someone who is relatively well versed in the crypto world and associated scams I couldn’t tell at least in first two or three attempts.
Their first few messages leading upto this would be “do you believe in financial freedom as for a happy life?” I would play along just to see what their strategy is and it would almost always end up trying to lure you into yield farming asking to deposit in some random wallet address promising 15% monthly yield.

It was so frustrating at some point, my first questions to someone matching me would be are you a crypto or onlyfan scam? Man the online dating world has turned completely shameless.
A (Game) Dialogue Pipeline
-> "When I start at a studio, I almost always find myself building or rebuilding a pipeline for game dialogue.

I wanted to write down here some things I’ve learned about that, my reasoning behind it, and where it bridges the gap between other pieces of gamedev. I hope there’s something here you’ll find useful."
With computers like framework and system76, the community for hardware support is solid too now. Seriously considering a switch from M1. I feel like macOS is half baked development environment. I only stay because I never bought a Linux supported computer and I got the M1 air very cheap. But I am considering getting a framework as I just damaged a usb-c port and I am not entering apple’s repairability problem.
Aside from some some odd duplication in the system UI (they have like three different "control panels" with overlapping functionality), Windows 10/11 are not such a bad UX. As long as you actively op-out of all the BS they keep adding on daily basis, of course.
I haven't tried Ada yet, but do have experience with VHDL. It's the most modular language I've encountered. It's easy to work with big teams in VHDL. Choose everyone's responsibility, design the interfaces (entities) and have a brief discussion on it. Then go separate ways and implement your parts (architecture). They all finally fit together like magic without needing too much coordination or interaction between the team members. I'm pretty sure that's what's great about Ada too. However, I still don't understand what it is about the language's design that makes this possible.
"The most sustainable phone is the one you already have".

That's what they said in an email reply to me. Not sure what question I was asking, but they were very upfront about it.

Sure, you can get second hand phones, but:
1. You won't get any security patches (or not for long)
2. I don't think I can trust a 2nd hand device to not be modified in some way. Feels like an easy way to get valuable data.

So if security is a concern at all, I think new phones are sadly the only way to go.
Deno is one of those things that makes it to the front page regularly (I’ve seen it here at least once every two months since it’s release) but if you aren’t on here every day or only started frequenting here recently I could easily see it being missed
2G is what Teams uses idle on my client PC which is much more constrained on memory than my server(s) that have in the order of 64-512G.

If you're hosting things for internal consumption it's a generally good rule to put the memory burden on the server if you can.
If a user can't switch to another OS, you can run Windows Server. I run that in my home lab when I have to use a Windows based OS for certain scenarios.
That's still a local privilege escalation type of vulnerability, isn't it?
I disagree with the idea of leaving negative reviews just because a game doesn’t support a specific platform. It’s the same toxic fanboy wars we see if a game doesn’t come out on a specific console or available on a specific store.

Doing so costs money for a small portion of the community. Ultimately these studios are businesses and have to make financial choices.

I do fully recognize that this is a chicken and the egg problem. But proton is not a perfect solution and I even had to install Windows on my steam deck to play some of the games I want to play.

At the end of the day I’m a gamer first and a fanboy second. I want to play the games.
> They are falsely promised for "entrepreneurial opportunities"

From what I heard, which I cannot verify, it's more sinister then that. People take completely normal-sounding jobs in normal-looking and functioning offices. After several months of being paid normally for normal work, they're invited to a team-building event in SE Asia. There, they lose their passports, are interned in huge camps and are press-ganged into being scammers, and tortured or killed if they refuse.

This isn't your usual "can't cheat an honest man" tale where you sucker in greedy rubes with a promised free lunch.
https://archive.is/xPULP

Previous Discussions on HN: (4-comments - 2023-08-29) : https://news.ycombinator.com/item?id=37307619
“Man-made”: What exactly does that mean?
Creation of a virus de novo?
A natural isolate passaged a couple of times?
Somewhere in between?
I think the password crackdown accelerated people to evaluate if Netflix was worth paying for. For a lot of people that was no.
A concept of thin clients is of course completely unthinkable in this context.
> . . . Ben Carson was one of the most skilled (if not the most skilled) neurosurgeons in the world . . . and is also a creationist who believes that the Egyptian pyramids were biblical grain silos.

There is something to be said about applying Gell-Mann amnesia more broadly than journalism alone.

In a speech in 2002, Crichton coined the term "Gell-Mann amnesia effect", after physicist Murray Gell-Mann. He used this term to describe the phenomenon of experts believing news articles written on topics outside of their fields of expertise, yet acknowledging that articles written in the same publication within their fields of expertise are error-ridden and full of misunderstanding. . .

https://en.wikipedia.org/wiki/Michael_Crichton#GellMannAmnes...
At IBM someone made something called fetchnotes that worked like fetchmail, but worked with mail and calendar, made me able to get away with minimal usage of notes.
It's hard to compare nuclear v/ solar because of availability. A well-run NPP can have much better than 80% uptime. A solar farm depends on the sun. So 1GW of nuclear capacity is worth more than 1GW of solar. Thus the very low prices being quoted for solar systems today are not entirely honest.
Ever since Windows 8, Windows has opened the floodgates of shitty 3rd parties to come into your machines.

My sound menu changed the offered me 3rd party apps to buy from the store for audio codecs. My start menu aggressively searches the internet for nothing I'll ever want. My computer came pre-loaded with a ton of garbage I never wanted. My iPhone images in HEIC codec require a microsoft store transaction to view.

They are making money after the fact when they sell you the OS. Marketing the hell out of every single click, phoning shady telemetry back home.

It's not really my computer anymore. And it's been 20 years since I first used linux, and it's not taking-over fast enough. Shitty game developers like Blizzard and Bethesda (Both now owned by Microsoft BTW) are keeping people on Windows.
The current state of the debate is that there are credible, lauded experts arguing both positions. If it was a straw-vote among the most respected figures in the field, it it would still lean towards a zoonic origin, I suspect. But almost all of them believe the data is incomplete.

I questioned the faith of the post because your post implies pretty clearly that there is all of the evidence on one side, and all of the charlatans, liars and fake data is on the other. That seems...unlikely. But you see it because you chose a position and everything then fits that position. Eh.
Yep, the United States spends an outsized portion on it, but has some of the worst outcomes of any developed country.
Ah yes, make the insured pay out of pocket first. Brilliant. Too poor to buy a new car to replace the one that just got legitimately totaled? Gotcha!
I don’t anyone here is arguing that leaving the single market was a great idea. Rather that it doesn’t make much sense to stay in it if you want to leave the EU.
Ask HN: How do you organize the files on your computer?
I wonder which competitor lobbied for this and will now be doing the same thing.
I don't think "Even the US" is a valid way to justify slavery. I mean, even the US had slavery at one point right?
Suppose you are an insurer. You model the risk for your insurance product (suppose it's car insurance) and realize you need to charge $100/mo to make money after paying out all the claims. However, you have a competitor that is bad at modeling risk. They are charging $50/mo for their car insurance, and customers are flocking to them. Should you attempt to stay in this market? If you lower your prices, you will eventually get knocked out; if you keep them high, you will not get any customers.

Alternatively, suppose cars become super risky and you need to charge $10,000 a month to insure the car, and reasonably conclude that no one is going to pay that, and after you pay for marketing and overhead and payroll, you will still lose money if you try to sell the insurance product. Do you stay in the market?

It's especially funny to see everyone in the comments complaining that the insurance company is "only thinking about the short term".
Apple isn’t doing itself any favors, but the status quo has been the same for years now.

I consider myself a big old Apple fan boy, have various flavors of Mac machines around the house, etc.

But my Steam Deck has been an absolute revelation. Makes it so easy to pick up games really quick, game in random places, and use my existing library of games whenever I want.

I also have a gaming PC… which I hardly boot up anymore.

The Steam Deck is easily my favorite consumer electronics device, in years. Probably since the original iPhone came out.

The delta between MacOS gaming market share and Linux gaming market share on Steam is exclusively due to the Steam Deck.
> there's a lot of software people need and want to use

This is mostly a mindset issue.

A bit more than 2 decades ago I would have said you would have pried photoshop from my cold dead hands.

Then I got fed up by a lot of things in this ecosystem, and I left it completely. I may not have access to the same applications, but I have access to decent applications that allows me to get the job done. And it applies to a very broad range of domains.

There are a few exceptions of course, but rarely ones you encounter in a non professionnal setting. In these very few and rare use cases there are options:

1. wine if it works would be the preferred one
2. accessing an app running on a windows through rdp, either as a full desktop or as a standalone window.[1] OK granted you are still using windows in that case, in the background, but you can do that only sporadically by launching a cloud windows vm instance for the small amount of time in a year you definitely need that dirty OS for personnal use.

Obviously YMMV but the barrier is mostly psychological imho.

[1] I think there was a project to facilitate that for office, adobe applications called winapps, see the different active forks here:

https://techgaun.github.io/active-forks/index.html#Fmstrat/w...

there is also this:
https://github.com/ne0YT/Linux-Subsystem-for-Windows_Seamles...
In case anyone else is confused by what this is, it appears to be a web framework built with the Rust programming language.
I'm guessing it's this video: https://www.youtube.com/watch?v=n-EtdC4zQso
Or on yours?
I relate a lot to these, plus weight lifting in the first half of the day works wonders.
My elementary school responded to the swing jumping threat by putting a fence in the way. But they put it just close enough that you could jump over it if you were really ambitious and get hurt pretty bad if you hesitated.

I still wonder if the move was 100% oversight or if somebody on staff recognized the lesson in it: be good or be good at it.
They are incredible learning exercises, often taught in higher level CS degrees at universities. If you want to understand how Linux (for example) works, it's really helpful to understand the problems that it's solving; one of the best ways to do that is to build it yourself.
This hits the nail on the head. The issue is that the system is shitty - the entities within the system practically have to act shitty, otherwise the other one that does goes ahead and takes the profit. Doing the right thing is often not just orthogonal to business, but is actually hurting it directly. So not only is there no incentive to do the right thing, there's direct incentive to do the opposite.
I don't understand that people use Microsoft products and are surprised Microsoft does Microsoft things?
When I don't know about the subject matter in a post, my first instinct is to research it myself for a bit to see if I can figure it out. I would recommend you to do the same.
I'm not sure a comparison between Netscape & Google works
It's not meant to replace the FP4 for people who already use it. The entire point of Fairphone is you can continue to use your phone for 5-7 years because you don't want to upgrade every year.

The FP5 is intended to keep their product modern to bring in new users.

Consider that the FP4 came out in 2021 and is supported through 2027. It's 2 years old now, which is fine for people who want to use it. They still have 5 years of life on it.

But if someone is considering ditching their old Pixel 4 which is no longer receiving updates, are they going to want to buy a phone which is already 2 years old? Probably not.

If Fairphone didn't release a new phone until the release cycle of the current one ended then the only option people would have is buying 6 year old phones.

They still have to make regular updates in order to attract new customers. They are banking on a customer base that does not feel the need to upgrade to the latest and greatest every 1-2 years.
My first thought was, "Yep, the impetus for this was 100% about someone trying to see something about penis sizes."
Just north of the station is a beautiful natural area

https://en.wikipedia.org/wiki/Monta%C3%B1a_de_Oro_State_Park

The name means "Mountains of Gold" and at a certain time of year there are these "Gold" flowers all over the place

https://www.onlyinyourstate.com/usa/unspoiled-beach-montana-...
> No more "I hurt my back" type claims weeks later - unless you said your back hurt at the time, it isn't going to be covered.

This would likely lead to an overwhelming wave of lawsuits. Soft tissue injuries can often have a delayed onset.

Please don't take this the wrong way, but your advice comes across as that of someone who may not have experienced either side of an insurance claim.
>Take the video of the damage immediately and through your own app. Now you can confirm with decent certainty the where/when of the incident and stop double-claims. You can also refuse to pay for any damage unseen in the video. No more "I hurt my back" type claims weeks later - unless you said your back hurt at the time, it isn't going to be covered.

This noticeably doesn't stop you from purposefully damaging your home for an insurance payout. If I take a video of the damage to my roof right after I knock a tree over onto it, I would get a new roof paid for by an insurance company.

>Next, you require the user upload all the receipts they are claiming before you'll pay them a cent. This means that users will typically repair stuff 'on the cheap', rather than using very expensive repair/rebuild services that they'd use if they knew for sure insurance would be paying.

Seems like a recipe for builders to overcharge the insurance company. Unless you're suggesting that homeowners physically pay for the repairs before submitting the claim, which (for obvious reasons) is prohibitively unaffordable in most cases where you'd want to use insurance.

>Third, you either pay avery claim in full, or not at all. If you find any evidence of fraud, you don't do a partial payout.

You better have a great legal team, because you'll be getting sued a lot. In addition, you'll have very limited evidence to prove fraud (as you didn't have anyone visit the site of the damage, didn't have anyone negotiating the price with the construction company, etc.)

Combine it all together and you'll be paying out a lot of fraudulent claims. You'll also be losing a lot of lawsuits where you don't have enough evidence of fraud.
My guess is that Nvidia will get into a partnership with some distro to use a patched kernel that removes the relevant parts.

In fact I will expect that one (cough Ubuntu cough) may do it on their own just to get a bigger slice of people working with Cuda
If it's not automated, it could easily be some sort of pre-defined script. I don't get many anymore, but I've definitely had mysterious text messages from different numbers supposedly across the country that were nearly identical. Usually it was "hey is this [random name], where were you last night?" I assume this was meant to draw me into some sort of dialogue. It happened enough that I can't really believe it was just a misdial.
I'm not an OS dev either but I think core count makes a difference here. In that a while(true) loop brings down your single core system but doesn't for a multi-core system. Could see the tradeoffs being different today than back when the fundamentals of the OSes we use today were built.
> Ride-hailing apps like Uber and Lyft have increased the number and intensity of traffic jams, Airbnb and other home-sharing apps are accused of breaking down neighborhoods’ social fabric, and self-driving cars are causing all kinds of trouble [...]

If one accident is "a lot of trouble" then humans are way more troublesome... this whole statement seems like a real stretch. Airbnb may be driving housing crisis in some states and countries, for sure. But Uber causing traffic jams ? I don't really see where it's coming from.
> It’s a long term thing that takes a ton of work…I have no idea how the scammers even pull it off at scale.

When cost of living is a few hundred dollars a month at best, looting 10k from a single mark is going to last quite the time.
Any of the thousands of contributors to the Linux kernel can make this claim. Linus doesn't have any special authority here.
I'm reminded of the Terry Gilliam film Brazil.
This is absolutely the best thing I’ve read all month. I love inconsequential mysteries like this. Kudos to the author for noticing an oddity in plain site, asking the question and doing the research!

It both amazes me that we as a species maintain such complete records that we can peer into the mists of history and discern what specific individuals were thinking at a particular time, and sobers me to think about just how incomplete those records are and how many facets of our world today are the way they are and we have no idea why.
No, I don't think they can really fork it. How are they going to get support for new hardware in their fork?
I think that protests where one of the factors that stopped the war with Vietnam.
Thin clients with 2007-era javascript interpreters as the only code execution framework (vs local MACH-O binaries) does seem to be a bit of a weird choice if "slow" was the problem and you intended to have thin clients.
I'd argue taking things out of context and deliberately painting the commenter in a bad light is not a nice forum discourse.

I said, very plainly and visibly, that my parent commenter's unwillingness to back up negative claims COMES ACROSS as biased and ARGUING (NOT "acting") in bad faith.

Come on now, this stuff is not hard, the message is literally up there. Not sure why you had to editorialize it and thus misconstrue it?
My Pixel 5a has one and I think every single phone by Sony still has one. How is wanting to use audio equipment a niche? And even if so, you would expect the people buying a phone like this to want such a feature.
A Future Forward Approach to Brewery Supply Chain Optimization
And yet the experience of Safari on iOS is overall pretty good. I think I would not hate the Edge experience quite so much if it did not shove MSN content in my face, display a garish bing search page, and aghressively promote their browser. Also it does not help that I have 25 years of experience avoiding MS browsers for various other reasons. I’m not saying it’s great that Apple does this, but I do think Microsoft could make fewer technically minded people (and legislators) complain about it if they were less aggressive with their tactics.
Their current approach to Windows seems to be to milk it as much as possible before the desktop dies out.
Yes.

I see a lot of speculation about the possibility that our universe is a simulation. But our experience with inadvertently building Turing-complete systems makes me wonder if our universe is running on something that is just a side-effect of some other computation and not something deliberately constructed.

Someone in the enclosing universe could fix a bug and suspend or destroy our universe.

Or the computational substrate on which our universe executes is just some natural process in the enclosing universe, like sea foam or solar flares.
> (there was actually an earlier HN post today about "little known Postgres features" that mentioned it)

"Lesser Known Postgres Features (2021)":

https://news.ycombinator.com/item?id=37309309
> With be the popularity of Rust, it makes me kind of wonder why Ada isn't more popular.

It looks like Ada is having a resurgence due to Rust. I see Ada being pushed alongside Rust in a lot of places that emphasize safety.
It is widely believed that GPT-3.5 is a MoE model, which means it could have 175B parameters but still be much lower latency than GPT-3
GPT-Pilot: a scalable dev tool that writes entire apps from scratch
Can I please ask how technical they are, and what distro are you using? And that what are they using the OS for? I'm looking into this passively for years now, and I'm really interested in actual people's experiences.
> In the European Economic Area (EEA), Windows system components use the default browser to open links.

That shows such complete and utter contempt for the wishes of their users. The user has actively selected a browser as the one they want to use by default, but windows only uses it in the EEA because they were forced to.

As it will be used by EEA system components, there's presumably no technical/compatibility issues that would stop the rest of the world using it to.
Why is it better one way or the other depending on the focus of society? I don't see the connection. I'd equally lose faith in the system either way. Maybe moreso if I see my neighbor going to jail unjustly rather than some random individual.

As for the other way around, seeing a guilty man go free, the standard for imprisoning someone being evidence beyond reasonable doubt seems reasonable.

Granted, there is a two tier justice system and if you are unreasonably wealthy, you have more leeway, but I think that's a different discussion.
I don't think you get what this change is. You can disable nonfree drivers on the kernel level, and it will make sure they aren't loaded. You can also allow them, as many distros do. Nvidia took their driver and had it lie to the Linux kernel and pretend it was a free driver when it isn't. Linux is making sure they can't do that again, because if you don't want nonfree drivers, you don't want nonfree drivers. Nvidia is working against their users, not Linux.