skysight-inc/HackerNews huggingface dataset:
Biden signs new order cracking down on Big Tech
President Joe Biden has signed an executive order aimed at cracking down on big tech firms and promoting competition.

The move points to Mr Biden's desire for tougher scrutiny of Big Tech, which the administration has accused of "undermining competition".

"Capitalism without competition isn't capitalism. It's exploitation," Mr Biden said at Friday's signing event.

The order includes 72 actions and recommendations involving ten agencies.

It suggests that problems have arisen because of large tech firms collecting too much personal information, buying up potential competitors and competing unfairly with small businesses.

Several recommendations it sets out include:

Greater scrutiny of mergers in the tech sector
New rules to be set out by the Federal Trade Commission (FTC) on data collection
Barring unfair methods of competition on internet marketplaces.
The Biden administration is also targeting a number of other sectors with the order.

It encourages other government agencies to take action to improve competition across healthcare, travel and agriculture.

Once fully implemented, it would allow hearing aids to be sold over the counter, for example, as well as the ban of early exit fees from internet contracts. It also intends to make it easier for consumers to claim refunds from airlines.

US lawmakers introduce bills targeting Big Tech
Biden backs infrastructure compromise deal
"For decades, corporate consolidation has been accelerating," the fact sheet released by the White House says, describing the order as "a whole-of-government effort to promote competition in the American economy".

Mr Biden said that the order seeks to limit the use of "non-compete agreements" as a condition of getting a job, which he claimed can make it harder for people to change jobs and therefore limits wages.

The executive order alone, however, does not mean these recommendations will come into force immediately.

The government agencies responsible will need to implement the changes, while some elements could be subject to court challenges.
Serious question, if it was free software, how would they prove they're actually running it (unmodified)?
“One Day Longer and Those 13 Boys Would Be Dead”
> a set of bitter people who regret everything, but didn't do anything worth regretting.

Now this should be a story.
Zproject is not a build system. It's more like package.json esque thing for C. We used it on a past and it was capable to generate auto tools (or c make) build recipes, Debian or rpm packaging, ffi bindings and more.

But you're right it got almost zero traction outside of zeromq.
Yes the transceivers recommended by Init7 (bidi-LR) do not support FEC and you'll be running in degraded mode (according to the controller datasheet), and I don't think this is something that can be achieved by coding of the transceivers.
That’s the so-called “sterile cockpit rule” and it exists, is generally for ground operations and flight ops (other than level cruise) at/below 10K feet, which isn’t 30 minutes before landing, but rather a third to half of that, typically.
> It's just not mathematically possible to draw a proper "$" 4 pixels wide

> Here's some options that fit in 4 pixels

So which is it?
I'd agree with this. Despite hating databases whilst studying for my undergrad, I've come to realise after almost 30 years in the industry that expertise in SQL and database optimizations are key, and all the various frameworks I've tried to use to "hide" the complexity of SQL for my team, end up causing more headaches.

e.g. when I use sqlalchemy, I end up writing queries using core than ORM, because it becomes simple for me to optimize versus having to keep printing str(query_statement) to analyze sqlalchemy thinks it should do versus what it really should do.

Do remember to find a good DB optimization expert (hint: not the type that answers "add an index" when asked how they would speed up a query) and you'd be surprised how well SQL continues to scale today.

And for those of you about to say "but KV/NoSQL", by all means don't shoehorn SQL into every single thing; use the right tool for the right job; SQL will handle that 80+% of what you need, then implement the "other" stuff in memcached/redis/mongo/kafka/whatever you find is "easiest" to implement, deploy, manage and maintain.
If HN was universally the vanguard, a lot more normal people would be using VS code right now.
.Net's LINQ comes close, at least for querying. Update statements using LINQ usually translate to a select query followed by an in-language loop, but that's probably more an Entity Framework limitation than of LINQ itself.

The problem with most abstractions on top of SQL is that the first thing they abstract away is the relational model; you end up with an opaque result set, a mapped object, or an untyped collection. In my opinion, in order for a higher-level SQL language to be useful it must retain all the low-level data type information. The abstraction should be on the operation level (DML), not the data level.
Remote file storage I can just about see. But most consumers are streaming content (certainly TV, but possibly increasingly games), so where are all these multi-gigabyte files coming from on average 20/30-year-olds laptop/iPad? I don’t think people are shooting that much video, are they?
> Even the failed RCTs show improvement, just not a statistically significant one. This is usually due to bad trial design:

This is usually caused by report and publication bias. All the similar studies that show no improvement or a bad outcome are never published.

> And you don't need a big RCT for everything. You need to do a risk/benefit analysis and ensure that it makes clinical sense. Doctors talk between each other and share what works for their patients and what doesn't.

Here is were we disagree. Except for cases when it's impossible (like open heart surgery), it's necessary to do a good RCT. Doctors sharing anecdotes is not reliable, for example it has a lot of confirmation bias. I've read very similar arguments to justify using hydroxychloroquine without a good RCT last year.
He was only using 15% of the CPU at max speed
I have a computer in a room that’s generally otherwise too cold… so all that power is just useful heat dumped into the room.
This is a well articulated hot take. I appreciate it.
Though verbose and somewhat strange at times, one thing I love about SQL is that the query statements read like a set definition from set theory. That declarative nature is pretty powerful IMO, sure there are hiccups but it is a different way of thinking.
do it twice, duh
I think it's more of a rule than an exception. What makes a creation attractive is mixture of percieved veracity with addition of some oddity. So the most popular works of fiction mix some pretty accurate descriptions of reality with the oddity comming from the authors imagination. As such it attracts the reader with the promise of learning the truth about the world but instead it moves them away from the reality towards specific authors fantasies that are weird or gross enough to be interesting. What's more it draws more strongly the people who already share the same skew as the author and draws them even further from accurate understanding of reality.

Cat Person is great illustration of this, where it borrows endearing details from true healthy relationship but then serves the reader the image of exploitative and abusive, repulsive older partner. Furthering prejudices some readers already had and pushing them further away from accurate description of reality which is really varied as the relationship that was basis of this story shows.

Sometimes even though there's no repulsion, exploitation or abuse and older man just gets abandoned as the young girl finds new friends and there's just mature moving on without any abuse or retibution.
I agree, and this is totally the kind of thing I would do too. But I don’t think this represents average consumer behaviour.
Behind the scenes, AWS Lambda
> A typical consumer router will take up something like 5-10 watts.

You demonstrate a good worst case, but the article writer wants to use more than 10 gb/s so he can't actually use your typical router, he can have 15 gb/s with the MikroTik CCR2004-1G-12S which has an unknown idle W and a max around 50W.

Looking into the problem, I can't really determine why I should upgrade to 10 or 25 gb/s, but if I wanted to do so now I would rather buy components I could reuse than buy a router that will be inefficient for its entire service life.
AsRock makes an X570 ITX board with 2x10gig ethernet, the X570D4I-2T. Though at $500 for the board alone the resulting system is not going to be particularly cheap.
Wow really? I grew up in the midwest and when we first moved to SF I was amazed by all the public transit, never having access to anything before. It was definitely intimidating at first, and we somehow managed to take a bus to the port where the driver made us get out b/c he was going on break.

After that mistake it seemed pretty easy, and this was before iPhones
Do you support Ecofascism?
Guardedly agree, though there's also entitlement risk here. If an author scratches their own itch, and it does what they wanted, and they decide to open source it, then good on them.

Choosing to do so doesn't create any requirement to make it useful to anyone else. This is the root of a chunk of angst today: consumer X finds open source project Y, discovers it doesn't do Z, and throws a twitter/issue hissy fit.

There's *zero* requirement on the author to fix the perceived deficiency, nor should there be any expectation.

If X wants it addressed, then - as noted elsewhere in this topic - a founding principle of open source is that X is free to fork and fix.

Now, of course, some authors create open source and actively solicit use by others. In that case, they do need to consider feedback from their users. But again, there's no divine right conferred on users that the author will address their every whim. Fork and fix should be the first option - with no expectation it'll be upstreamed.
Also plenty of slightly more capable laptop class SKUs that are in this ballpark.
Gen Z Wants to Free the World from Email
Location: Pakistan

Remote: Yes

Willing to relocate: No

Technologies:

• Web: Javascript | TypeScript | Node.js | CSS | HTML5 | Bootstrap | SCSS/ LESS

• Microsoft: .NET Core| ASP.Net Core | C# | Asp.Net MVC | Web API | Linq | Entity Framework

• Data: SQL Server | NoSQL | MySQL

• Expertise: System design | Solution architecture | Software design | FinTech | EdTech

Résumé/CV: https://drive.google.com/file/d/1ePRmE4nwOu-gsBS5JKw-btVa0mX...

LinkedIn: https://www.linkedin.com/in/zahidalizak/

Email: zakhc1 at gmail.com

Microsoft tech stack 7+ years experienced professional
iAd is still alive in Apple products, but it’s not an ad network anymore.

https://developer.apple.com/support/iad/

Did I miss some other product?
FWIW: raspberry pis (the 4 series) sucks in 15w which is why it’s so bloody difficult to power them through standard USB power adapters (which go up to 12w).

So, not hundreds of times more power hungry, but definitely 2-3x
What browser/OS combo do I need, to make this work?

Edit: Worked on Firefox on Android
Yes, ever since the beginning. Which is at least 2 decades. And until now, it was totally in vain.
I think the fact that many people were willing to try switching to mongodb despite the fact that it doesn’t use sql and had quite poor semantics should suggest that there would be some way for a better relational database query language (and engine) to catch on.

On the other hand, the fact that many new time series databases (and other engines, including Materialize which the author of the article worked on) wanted sql (or fake sql-like languages when they couldn’t manage sql) suggests that not being sql can be a big hindrance.
I feel free and open source software's promises is still yet unrealized since I don't do these sort of things, and probably neither do most programmers.

I know that Free software is about freedom first and foremost not whether we take advantage of these freedoms, and that it has many ancillary effects on our privacy right and keeping old hardware running and all...
Writing the Ultimate Locking Check (2020)
The problem is running it 24x7, then a small 50w is still 438 Kwh each year. That's more than a 10% increase in yearly use for a typical two person household...
And an efficient heat pump can move four times as much energy as it consumes. But if some special paint/tile/insulation can reduce your needed cooling capacity by 30% you'll save a lot of money on equipment.
Why is it exploitative for a 33yo male to date an 18yo female? Are they not both adults? And who is doing the exploiting?

What about a 70yo male and a 33yo female? Still exploitative?
Renting storage, and accessing it over 10gbps at home may be cheaper than building your own multi-tb storage rack.
Yeah running your nas-bittorrent/firewall-router on the same OS is clearly not something I would do, especially that now you can use somrthing like proxmox for example and virtualize your pfsense/opnsense instance.
The ui is no longer there, but there is indeed a wizard for yaml whereby you can select a task and have it generate the required yaml for you. The very cool thing is round tripping works as well.
IMO that's a problem with Uber's pricing model. If the destination doesn't have enough people requesting new rides, the price to that destination should be higher.

If the price accurately represented the drivers' costs, they wouldn't refuse the rides.
I know Chrome works (not Chromium, as it uses online Google services) and iPhone should work too.
He's definitely trying to preserve his original image, of twenty-something spontaneous punk-rock welder making crazy inventions with little regard for safety. I've been following his channel for years (fiveish) and watched a lot of his earlier stuff and those vids are definitely safety-third.

He's definitely still no Captain Tightpants by any means, but as a fellow former crazy maker / fire performer, you never fully grow out of it, but you mellow out over time and take less crazy risks (in favor of calculated risks).
Oh my I wish those $0.10 kWh... in here we have 3 prices through the day (depends on what time it is), and the cheapest one is already higher than that :)

Anyway I did the math and it would be $7/month. More than double your estimation, but still not horrendous. Although for that range of prices one might be able to find a managed instance machine in some cloud provider...

(edit: somewhere in the process I lost track of the fact this was a price _difference_ calculation, so it's adding $7 to whatever was already the cost with a more power efficient machine, which ofc. depends on number and type of HDs and other equipment)
In Favor of SQL: Add Follow Foreign Key Syntax
As noted by others [1], a very common case for joins is to follow foreign keys.

I suggest using the fact foreign keys are constraints with unique names,
and using these names to explicitly specify what column(s) to join
between the two foreing key tables.

In PostgreSQL [2], foreign key contraint names only need to be unique
per table, which allows using the foreign table "as is" as the
constraint name, which allows for nice short names.
In other databases, the names will just need to be a little longer, since they need to be unique per schema according to the SQL spec.

Given this schema:

CREATE TABLE baz (
id integer NOT NULL,
PRIMARY KEY (id)
);

CREATE TABLE bar (
id integer NOT NULL,
baz_id integer,
PRIMARY KEY (id),
CONSTRAINT baz FOREIGN KEY (baz_id) REFERENCES baz
);

CREATE TABLE foo (
id integer NOT NULL,
bar_id integer,
PRIMARY KEY (id),
CONSTRAINT bar FOREIGN KEY (bar_id) REFERENCES bar
);

We could write a normal SQL query like this:

SELECT
bar.id AS bar_id,
baz.id AS baz_id
FROM foo
JOIN bar ON bar.id = foo.bar_id
LEFT JOIN baz ON baz.id = bar.baz_id
WHERE foo.id = 123

I suggest adding a new binary operator,
taking the table alias to join from as left operand,
and the name of the foreign kery contraint to follow as the right operand.

Perhaps "->" could be used for this purpose,
since it's currently not used by the SQL spec in the FROM clause.

This would allow rewriting the above query into this:

SELECT
bar.id AS bar_id,
baz.id AS baz_id
FROM foo
JOIN foo->bar
LEFT JOIN bar->baz
WHERE foo.id = 123

Where e.g. "foo->bar" means:

follow the foreign key constraint named "bar" on the table/alias "foo"

If the same join type is desired for multiple joins,
another idea is to allow chaining the operator:

SELECT
bar.id AS bar_id,
baz.id AS baz_id
FROM foo
LEFT JOIN foo->bar->baz
WHERE foo.id = 123

Which would cause both joins to be left joins.

[1] https://scattered-thoughts.net/writing/against-sql/
[2] https://www.postgresql.org/
> Isn't how an evolution for a new language begins?

Consider evolution in biology. A species becomes distinct from another species when their individual members can no longer interbreed to produce fertile offspring. For an ancestor species to split into new ones, its populations have to be separated — either geographically (in the so-called allopatric speciation), or by the difference in reproductive timing (allochronic speciation). The point is, something needs to happen that breaks the free mixture of organisms between populations.

It should be similar with languages — the societies that speak them get separated, and the language they speak evolves separately in different directions to become mutually incomprehensible. Which, with the current state of communication, is only likely to happen if humans become an interplanetary or an intergalactic species. On the same planet, we have plenty of opportunities to mix together and talk to each other, which, were there a hypothetical common language, should prevent it from splitting into multiple languages.

Consider a major modern language. It will contain multiple jargons/slangs/argots that are barely comprehensible to each other (e.g. the medical jargon, or the physics jargon, or Cockney rhyming slang, and so on); and yet they contain a large mutually comprehensible common core that makes television, radio, shopping, conversations between strangers, and so on possible.
CommonMark and ECMAScript+bundlers exist, so it's very easy to write Markdown and JS against a standard and be interpreter-agnostic.

SQL standard only covers the basics and is only useful to humans, not machines.
Python has a data structure like this called NamedTuple.

I also noticed it's popping up everywhere, in this case sql rows (kind of). Conceptually I like the idea of using it as the mechanism for function arguments, but I didn't want the syntax to be too confusing for beginners.

Although yours seems a little bit different, because different fields can have the same name.

Just for the heck of it, here's how your second example would look in preql:

(stops
{ lat, lon => }
{ lat => lon: min(lon) }
{ lon } // not necessary. just drops the lat column
)
Absolutely. But from what I’m seeing, the average consumer’s need for storage space is decreasing not increasing.
This is an "invisible hand" argument that ignores the fact that markets consist of people and some business needs to actually do the work.

Someone still had to create a popular service to compete with taxis, which wasn't all that easy when it wasn't even clear how to do it legally. It's only with hindsight that it might seem obvious.

Yes, maybe some other company would have eventually figured out how to do it a different way, but "eventually" can be a long time and reasoning about counterfactual events isn't as easy as invisible hand arguments make it seem.
Firefox for Android works for me. Running version 89.
SEEKING WORK | Pakistan| REMOTE (EUROPE / USA / OK)
Software Architect / Senior Full Stack Engineer with 7+ years of development and management experience in MVP development, full-stack (front-end & back-end) development as well as maintenance and DevOps. I can work during any time zone arrangement!

Technologies:
• Web: Javascript | TypeScript | Node.js | CSS | HTML5 | Bootstrap | SCSS/ LESS
• Microsoft: .NET Core| ASP.Net Core | C# | Asp.Net MVC | Web API | Linq | Entity Framework
• Data: SQL Server | NoSQL | MySQL
• Expertise: MVP | Design & Development | System design | Solution architecture | Software design | FinTech | EdTech

Email: zakhc1 at gmail.com
Linkedin: https://www.linkedin.com/in/zahidalizak/
Making a Strong Case for Accessibility
They can't be removed from the language, sure, but we can benefit by shunning the bad parts of the language, and using newer additions that are easier to reason about.

When's the last time you considered using a with(x){} block in JS? Would you still use var instead of let or const?
Can you still find "desktop" motherboards to go with them?

A long time ago, I remember there being desktop MBs for the Pentium M.
I can't imagine ANY reason that a private household would actually need a 10G or 25G connection unless it's doubling as a workplace and they're hosting servers. Even that seems like a temporary stop-gap situation, get some rackspace in a datacenter already!

Maybe they're not selling enough 25G to their business customers and they're trying to get private users onto 25G?
Market forces alone (in particular: competition) don’t lead to consumers being hurt.
Just to confirm since this isn't publicly accessible, are you saying this actually happened with E Ink? as I mentioned I work in the display industry, and if something like that happened, surely we'd all be talking about it during SID or stuff like that. When did it happen? Where? I'd love to know.
The (mostly) declarative nature of SQL is not something the post is criticizing. You could have a good declarative language for relational database that doesn't suffer from the things the post criticizes.
I'm surprised he didn't make a rig to dig dirt before hand.

His next project will be an exoskeleton to relieve his broken bach :)

ps: oh I was just before he starts to make hydraulic arms ..
I always thought that was what hadoop had in mind with HDFS, i.e. move the storage and query engines closer in terms of spatial and temporal locality, albeit only if you partitioned/clustered properly.

Speaking of which, what has happened to hadopp and HDFS? Used to be flavor of the month about 10 years ago, but now I hardly ever hear people talk about it.
What do you use for your KV storage?
Trivially, pico2wave has two English voices, "en-US" and "en-GB", having an "American" and "English" accents, respectively. Incidentally the "en-GB" one is quite a bit better than the "en-US" one to my ear.

pico2wave also has:

German (de-DE)
English, US (en-US)
English, GB (en-GB)
Spanish (es-ES)
French (fr-FR)
Italian (it-IT)

I think pico2wave's accents induced by cramming English text through the "wrong" language sound a bit better than the few I tried on the Mozilla web speech API, and it works offline, but I don't know that they sound good enough, similar enough to a real person's accent, to be really very useful for that.
Compared to most of the worlds current working tunnels dug by the other 6 billion, or all tunnels 70+ year ago it's a mansion in the tunnel world.

In the first world corporate mining industry I'm sure it'd give a safety person a heart attack.

Going 10 meters down an artisan mine [1] (most of the worlds miners work in these) is scary. Straight down a narrow hole, then sideways into soft dirt with a few tree trunks holding up dirt doesn't fill you with confidence. Then I got stuck trying to climb out because my longer western legs couldn't step up.

The fact this blogger uses welded supports on an outer layer shows he's on probably top of it for the hobby world.

[1] https://imgur.com/a/hUgEblt
Awesome use case, thanks for the idea!
Now it's up to the person to decide whether increase in living cost is worth it, which... is kinda normal. I think I spend more money on other things that I take enjoyment from.