skysight-inc/HackerNews huggingface dataset:
> and after GROUP, an extra BY needs to be written.

group /= groupBy.

Group just put things in groups. GroupBy allows for a function on the item to be used (think passing a custom comparator into a sort() function). In SQL's case I think this is just limited to a column id, but I could be wrong.

> The main downside of being like natural language is non procedural. Program logic is generally executed step by step

SQL has thrived on being non-procedural. It is high-level and abstract, and its various implementations make much better optimisations than would the average-idiot-programmer-in-a-hurry.

All that would go out the window if the programmer had to write how to do things. Forget 'repeatable read' or 'linearisable' or any correctness guarantees provided by a database - if it's up to the programmer to write how, not what, then your correctness guarantees are basically: "I hope every programmer who touched this codebase took the right number of locks in the right order at the right time".
I find the author to be fairly out of touch with modern programming languages based on the assertions made in the article. But more importantly, I think leaning into procedural programming is a fundamental misunderstanding of the power of declarative syntax and also does not take advantage of the RDBMS’ biggest strength: the ability to think in sets.
> This will take another ~2-3 years to be sorted out.

Lol, I almost spit my coffee all over the keyboard... That timeframe is wildly unrealistic.

It will take the best part of a decade from the time all major distros switch their defaults (i.e. RedHat, Debian, Ubuntu, SuSE) to get to a point that could be considered stable (i.e. where the average user won't encounter breakage as soon as they run an app that was not part of the default install). And even then, lots of debris will be left floating, because nobody is going to update some small app from 2005 or even old releases of QT and GTK.

The Linux desktop is currently going through its Vista moment, and it's going to go on for a very long time.
No, this is propaganda - every MSM outlets appends that biased "disclaimer" to every story they run on Gaza. Do they append "according to US-backed Israel" when parroting Israeli propaganda verbatim? No.

And still, the UN says the Hamas' numbers are realistic, and the Lancet says they are realistic[0].

Meanwhile, some parts of the IDF claim every death of a military-age male was the death of a "terrorist".

[0] https://www.thelancet.com/journals/lancet/article/PIIS0140-6...
Agreed. Thanks for the perspective. Never considered downsides of such interventions (as I have been mostly a lab rat for doctors but never experienced things like that, but it's understandable).
The trouble with the very smart people is that even when wrong, they can come up with very elaborate and convincing reasoning why they in fact are not in the wrong, and indeed convince themselves (and then others in the process) that what they are preaching indeed is the correct solution or answer to a problem.
How about when the occupier does morally reprehensible things? how should you react? turn the other cheek? Thank you sir, may I have another...

(https://www.icrc.org/en/doc/resources/documents/misc/634kfc....)

Notably:

The main rules o f the law applicable in case of occupation state that:

The occupant does not acquire sovereignty over the territory.

Occupation is only a temporary situation, and the rights of the occupant are limited to the extent of that period.

The occupying power must respect the laws in force in the occupied territory, unless they constitute a threat to its security or an obstacle to the application of the international law of occupation.

The occupying power must take measures to restore and ensure, as far as possible, public order and safety.

To the fullest extent of the means available to it, the occupying power must ensure sufficient hygiene and public health standards, as well as the provision of food and medical care to the population under occupation.

The population in occupied territory cannot be forced to enlist in the occupier's armed forces.

Collective or individual forcible transfers of population from and within the occupied territory are prohibited.

Transfers of the civilian population of the occupying power into the occupied territory, regardless whether forcible or voluntary, are prohibited.

Collective punishment is prohibited.

The taking of hostages is prohibited.

Reprisals against protected persons or their property are prohibited.

The confiscation of private property by the occupant is prohibited.

The destruction or seizure of enemy property is prohibited, unless absolutely required by military necessity during the conduct of hostilities.

Cultural property must be respected.

People accused of criminal offences shall be provided with proceedings respecting internationally recognized judicial guarantees (for example, they must be informed of the reason for their arrest, charg ed with a specific offence and given a fair trial as quickly as possible).

Personnel of the International Red Cross/Red Crescent Movement must be allowed to carry out their humanitarian activities. The ICRC, in particular, must be given access to all protected persons, wherever they are, whether or not they are deprived of their liberty.

None of which are being respected.... so I ask again, who is morally reprehensible? and if you are referring to the debunked lies about october 7th, I urge you to read up
Show HN: Open-source, multi-browser visual review and testing platform
Ask HN: How can I grow my mindset and technical skill as senior engineer
I saw a post in HN. (Falsehoods junior developers believe about becoming senior)https://news.ycombinator.com/item?id=39502515

So as a software engineer who was recently promoted to Senior and working on various technologies over 5 years mainly focusing in java, mysql and js in small to medium size local companies how can I grow my mind and technical skill to be a senior swe
In user dialogs, Windows does/used to do that, too. https://learn.microsoft.com/en-us/windows/win32/api/winuser/...:

“The horizontal base unit returned by GetDialogBaseUnits is equal to the average width, in pixels, of the characters in the system font; the vertical base unit is equal to the height, in pixels, of the font.

The system font is used only if the dialog box template fails to specify a font. Most dialog box templates specify a font; as a result, this function is not useful for most dialog boxes.

For a dialog box that does not use the system font, the base units are the average width and height, in pixels, of the characters in the dialog's font. You can use the GetTextMetrics and GetTextExtentPoint32 functions to calculate these values for a selected font. However, by using the MapDialogRect function, you can avoid errors that might result if your calculations differ from those performed by the system.”
Proven Complexity and Technology Choice
I think very few developers wish to be customers of Apple. But Apple gatekeeps the platform developers need to publish on.

It is this relations that is the core of DMA, and which DMA seeks to change.
Improving API Development UX: Organizing APIs into Folders
Hey HN community,

I've been diving into API development and wanted to share a game-changer in the space—organizing APIs into folders for a seamless user experience.

I recently discovered https://mock-API.net, a tool that not only simplifies API mocking but takes it a step further. The ability to organize mock APIs into folders is a UX boon. Here's why it matters:

Effortless Management: Grouping APIs into folders makes it a breeze to manage and locate specific mocks. No more endless scrolling or hunting for that one endpoint.

Logical Structure: For projects with numerous APIs, a structured folder system provides a logical hierarchy, mirroring your project's architecture. It's like having a well-organized file system but for APIs.

Enhanced Collaboration: When multiple team members are working on different parts of an application, having a neatly organized API structure ensures everyone stays on the same page. Easy collaboration fosters efficiency.

Streamlined Testing: During development, testing various endpoints becomes more efficient when they're neatly categorized. It's about optimizing every stage of the development process.

Give https://mock-API.net a spin and see how the simple act of organizing APIs into folders can transform your API development experience.

Happy coding!
Through security enhancing features in the operating system, like not allowing processes to access other's memory spaces. Or prompting users to allow an application to use potentially harmful api's. What do you think is the role of an operating system?
Remote connections are dead, Netcraft confirms.
If the manager is responsible for hiring and managing the driver and the navigator, then obviously they can also be under stress, and will be held responsible for the outcome.
Most people don't get a choice of which legislation/regulations to comply with.
His detractors do the same.
For another opinion on this topic https://jericho.blog/2024/02/26/the-linux-cna-red-flags-sinc...

Having a large number of new, unscored, CVEs in the Linux kernel is going to make things... interesting. From their lists https://lore.kernel.org/linux-cve-announce/ these just have a CVE and not really enough detail for anyone to assign a score without a lot of additional analysis, which reduces their usefulness.

To an extent it could be suggested they're just exposing an existing flaw in the system (CVSS scores which may be taken to be scientifically applied, are actually just matters of opinion in many cases), but it will cause a lot of problems with automated tooling and compliance.
I use the API + playground which is essentially the chat interface. The API charges per-token and is then cheap. Unless you're a heavy user, it's tough to get to even a few dollars. Just don't use GPT4 and paste oodles of text, and you'll be fine.
True, but my gut says that there is a selection bias of people reading comments on such an article and being in that 1%

Might just be in my head though.
Google and Facebook are killing South Africa's local news
I'm the co-author of this article and the editor and founder of GroundUp News (a 12-year-old non-profit news publication whose website I developed in Django).

The rise of plagiarised news sites using chatbots is a real problem for local publications that are dealing with declining income and shrunken newsrooms.
For fiber you can make your own. The modem transforms the light signal into electric, the protocols are open, routing is also an solved problem.the biggest problem are the isps themself that hide credentials and any self serving method away.
Really interesting to see how hard Apple is fighting with everything they have to keep their profits and not open up. This is a fight Apple can't win because the EU will strike back again and again. It's Apple trying to win time and thus bank profits. But I believe the strategy will fail hard: high fines and even tighter regulations that will break up Apple's monopoly completely, much broader than intented before. The more actions like this one Apple takes to squash competition, the stronger the rules will be that will be forced upon them.
>they can come up with very elaborate and convincing reasoning why they in fact are not in the wrong

Like Elon?
i like the story, but i cant help but notice that the "cassette" is solving a non-existent problem

who the fuck has to measure a dishwasher tablet?
Are you a manager by any chance?
Designated gatekeepers must now comply with all Digital Markets Act obligations
Time for the fines to start accumulating. I am all for making an example out of Apple. Monopolistic behavior needs to be punished.
the story is fun, but i can't help but notice the justification for the cassette to being with is nonsense - solving a problem nobody ever had.

who the fuck has to measure out a dishwasher tablet? nobody is who
Exactly this - US law applies to the US only. In order for Apple and Epic to operate in the EU, they must abide by EU laws.
Reddit's offering marks return of 'junk stock IPO,' New Constructs says
Rate your help docs and learn what you can improve
We have built-in integrations with Storybook, Cypress, Playwright & Puppeteer.

We capture your UI's across different browsers & screen sizes

You can self-host or use our cloud offering.

If you use Github, we can sync our roles with your team's permissions.
Since you're early in your career, a startup is the best place to learn and it seems you're doing really interesting work.

Big tech is the opposite of interesting. You'll drown in office politics, something you probably don't experience that much at the startup. Scalability challenges are better but landing on such teams is tricky.

Considering there is no evidence for the need for ML engineers to ever go down, I'd say you be fine if this startup goes belly up.

I've done my tour at big corp and, personally, I'd like to avoid them for the time being. My very first job was at a startup, first employee. Still one of the best experiences I ever had.
I want to be sympathetic but the fundamental premise here seems to be flawed:

In recent years, the number of apps that users
have been installing on their handsets has
declined. This is the case despite the increasing
number of applications of all kinds that make a
handset more useful.

But I’d propose a counter-narrative: Users have slowed down installing apps because they’ve learned the lessons of the past 15 years that most dedicated apps are intrusive and counterproductive trash that track you, spam you, burn through your battery, and don’t actually provide any useful functionality.

It goes on to suggest that allowing other app stores may increase “innovation in discovery and distribution”. But the only innovation that would be happening is new levels of confusion as not all apps are available in all app stores, and different stores will have conflicting policies and procedures that will make them impossible to coexist, and many app stores will inevitably be taken over by scam lookalikes.

I find no reason to believe that alternative app stores would ever provide a beneficial experience to users. If we’re unhappy with Apple’s monopolistic practices and conflicts of interest, then we need to be improving regulation of things like app store fees and user tracking; forcing divestment of problematic integrated business lines like streaming content, ad sales, and cloud services; requiring device makers to provide open specs for ports like lightning and access and tools not only for repair but for installing alternative OSes or buying hardware without anything pre-installed.

But fiddly little things like forcing alternative “app stores” just to satisfy financially abusive wannabe monopolists like the video game companies is not a solution that will help anyone.
On the other hand, the world has collectively wasted millions of hours creating and clicking on cookie prompts.
> fighting a terrorist group

If you occupy territories for decades, with notable differences in the rights of those occupied, you get an insurgency. To me, "terrorism" doesn't really describe the situation well. There have certainly been specific incidents that fit that label, but plenty that look a lot more like plain old rebellion. There have also been acts from the Israelis that could be looked at as terroristic, if you subscribe to the definition of using violence and intimidation for political gain.
> Why did they take hostages to begin with

Hamas stated their aim very clearly - to have Israeli hostages to trade for the thousands of Palestinian hostages that are held in Israeli dungeons.
I agree with you.

Changing SQL to a description of how you'll get the data would make a query incomprehensible to me.
Sure, if you want to be pedantic about it. Though this is pretty normal for EU law to give a lot of preparation time. The GDPR had 2 entire years - and I still got some emergency compliance tickets in the week before (worked at the eCommerce arm of a major German retailer).
Apple must have realised this would provide direct evidence of their control over the iOS app market, regardless of their apparent compliance with the DMA. The loss of a developer account means that epic cant even release their own app store on apple devices, undermining apples responsibility to open up to competition. Cant wait to see how big the next fine is *grabs popcorn*
I doubt that Apple would accept to be responsible and liable for the security of software from other companies. Epic would ensure the security of their software in the same or similar ways as Apple does it for their software. The operating system provides the security framework, the makers of applications are responsible for the security of their software within that framework.
> They have always said "Every bug is a security bug".

If you can't reason about your codebase to a sufficient extent to actually determine that then something is very wrong.

If everything is a CVE, nothing is. That approach just wastes a lot of time and effort making people not so familiar with the codebase (as the maintainers) do triage.

I hope they get burnt quick by this approach.
schizo mindset
No, but the article was dishing out quiet hard, so the worst offenders wouldn't have interacted further. At least that would've been my expectation
How does that seem clear? Apple should provide services and support for people using the payment system without getting any gain from that system?

You're being disingenuous to suggest that the only benefit Apple provides is a payment system.
It's not reasonable when Apple has set up artificial roadblocks whereby Epic can't compete with Apple in the iOS app store market without a developer account. As of yesterday, Apple is legally mandated to enable competition in that market, so using those roadblocks to aggressively block competition is a pretty big problem.

Apple could easily resolve this by just removing their their bogus constraints around the requirements for launching a competing app store on iOS. After that they could probably keep Epic banned all they want from the main App Store based on future ToS violations. (Though with the caveat that the ToS would need to be reasonable, and it seems clear that Apple has no intent of making a reasonable ToS unless forced).

But they're not going to do that, are they? None of Apple's restrictions were about security or user safety, they were always intended as an exclusionary measures, to make sure nobody can launch a viable competing store. When it looked like Epic was going to do it despite the ridiculous business terms, Apple reached for the next excuse in their toolbox.
> Setting aside the fact that these are numbers provided by Hamas […]

This is an unserious argument.

1. The numbers come from Gaza’s Ministry of Health, which is indeed “controlled” by Hamas since Hamas is their governing entity.

2. The Ministry has no verifiable history of being wrong on the civilian casualty numbers. In fact, it’s quite the opposite: The Ministry’s numbers have held up to scrutiny in ALL of the previous wars (including scrutiny from Israel) [0].

3. The Biden Administration has corroborated the numbers.

4. Israel hasn’t denied the numbers. In fact, in one report from the IDF a couple months ago, they corroborated the Ministry’s numbers at the time.

5. The same silly argument could be made to dismiss just about anything coming from Israel given their documented history of lying and even manipulating our (American) media, from lies about beheaded babies [1] to pushing propaganda via U.S. media outlets like the New York Times [2].

> The United States killed many more Japanese civilians than American civilians who died during the war, that doesn’t make them right. […]

This is just a whataboutism and another unserious argument.

One evil act doesn’t justify another evil act. This is as serious of an argument as someone trying to justify slavery in 2024 by pointing to America’s history with slavery.

[0]: https://apnews.com/article/israel-hamas-war-gaza-health-mini...

[1]: https://theintercept.com/2023/12/14/israel-biden-beheaded-ba...

[2]: https://theintercept.com/2024/02/28/new-york-times-anat-schw...
I think a lot of people do actually care, but you'll never be able to determine that from the internet because on every social platform the discourse on every controversial issue is 1000 bot comments for every real comment.

The vibe on today's internet when it comes to weird tech bros is 'we made this space, applaud us on it or leave it.'

Many people have chosen option 2.
SD Express cards from Samsung promise faster-than-SATA speeds for microSD
> laws aren’t hard constraints, they’re human constructs

As is Apple, the company. It only exists on paper. It can be barred from existing in a jurisdiction by another human construct, a court ruling. It can choose to ignore EU laws, but there would be consequences.
The CEO and Co-CEO appear to have Chinese names, same with the parent company listed in your wiki link.
Well spotted. Following this, I found opening each image in a new tab and switching between them worked as a nice way to compare.

For convenience (second is hinted)

+ https://blog.gtk.org/files/2024/03/Screenshot-from-2024-03-0...

+ https://blog.gtk.org/files/2024/03/hinting-125.png

You can really spot the difference.
Do you have any suggestions on prompts to use here?
Some Yedlin links. I found his process to be methodical, precise, thorough and definitive. The question as to whether there is any perceptible visual difference between film and video that has been post-produced by an expert was definitively answered for me.

Resolution Demos: https://www.yedlin.net/ResDemo/index.html

On Color Science for Filmmakers: https://www.yedlin.net/OnColorScience/index.html
For the technical issues you mentioned, please consult our guide here: https://learn.netdata.cloud/docs/netdata-agent/sizing-netdat...

As for our subscription plans, if you're managing fewer than 6 nodes, you can always be on our Community plan. Should you have more nodes and prefer not to choose one of our Netdata Cloud plans, you can utilize our agent dashboard.
United Airlines?

But The Honest Company is the funniest one:

> Jessica Alba's The Honest Co. has submitted a settlement offer in NY for a second false marketing lawsuit stemming from the brand having sold products labeled as all natural when in fact they were not.

https://ww.fashionnetwork.com/news/Honest-co-proposes-7-35m-...
I think I would too (or Boulder). But SLC is very close to probably better world-class skiing.
Israel has distracted the entire West from Ukraine and is mostly being driven by someone who seems to be more self-interested than anything else. The West has been played like a total fool and this is what Hamas wanted, to follow Israel into creating an unstable environment where we are now even bombing Yemen all while other countries like China continue to grow.

The fact that the attack happened right as relations were about to normalise with both Turkey and Saudi Arabia is all you need as evidence.