skysight-inc/HackerNews huggingface dataset:
Practically everyone accepts them where there is no better solution.

And usually there is no better solution because third party integrations to online services (think Stack, Discord, etc.) are limited or aren’t kept up-to-date with official apps.

Or, in Discord’s case, are outright against the ToS and not worth people’s bother.
Bill Gates Can Remove Melinda French Gates from Foundation in Two Years
>Also, as other have said, the author's definition of "distributed system" (here, basically a "multithreaded" , concurrent system)

What gives you that impression? The article talks multiple times about using libraries to manage distributed execution, and shows those libraries in use.
> I wonder how much of the limitation are necessary in order for the query optimizer to have any chance at finding a good execution plan.

Probably in exactly the opposite way: the limitations of SQL put a lot of work on the back of the query optimiser without allowing for said optimiser to easily reason about the queries, or for the writer to easily feed the optimiser (short of dedicated extensions e.g. Oracle's optimizer hints).

Or so I would think, I've never heard of SQL being praised for its optimisability.
I think your reading of both the original text and this follow-up are deeply flawed.

Foremost, original text was a story, a work of fiction (not an "article") -- of course it was made up! The fictional character of Robert is not the real life person Charles.

It is strange then, to claim that "Women will make up horrible things about guys online". Is the creation of any unpleasant fictional character a bigoted swipe at large sections of the populace? (There's an additional irony of you generalising this to _women_ and not the author.)
> Because old people are generally gross?

No, because a relationship between a teenager and someone in their 30s is seen as 'more likely than not to be exploitative'.

I've only known two people who fit that bill, and as a third-party observer, both of them seemed incredibly sleazy and manipulative. I'm sure that there are exceptions, but most people would correctly see that kind of age gap as a huge red flag.
Why are you repeating what linked twitter thread states, too?
> Isn't a union type essentially a de-normalized field?

No? You have to denormalize to emulate unions when they're missing. Sum types are a fundamental category of types, that SQL only supports product types is a problem you have to work around.
Nope, that are just some samples that show the usage of the fonts.
Cisco BPA, WSA Bugs Allow Remote Cyberattacks
I think it says something bad about contemporary writing that "comes accross as true" is exceptional.
That was funny
A language is a dialect with an army and navy (navy optional)
"CMake, you say? Yeah, CMake is like smashing your face on high quality pavement. You can admire the stonework while the blood pours down your face."

Pieter Hintjens, http://hintjens.com/blog:79
One alternative to SQL (type of thinking) is Column-SQL [1] which is based on a new data model. This model is relies on two equal constructs: sets (tables) and functions (columns). It is opposed to the relational algebra which is based on only sets and set operations. One benefit of Column-SQL is that it does not use joins and group-by for connectivity and aggregation, respectively, which are known to be quite difficult to understand and error prone in use. Instead, many typical data processing patterns are implemented by defining new columns: link columns instead of join, and aggregate columns instead of group-by.

More details about "Why functions and column-orientation" (as opposed to sets) can be found in [2]. Shortly, problems with set-orientation and SQL are because producing sets is not what we frequently need - we need new columns and not new table. And hence applying set operations is a kind of workaround due the absence of column operations.

This approach is implemented in the Prosto data processing toolkit [0] and Column-SQL[1] is a syntactic way to define its operations.

[0] https://github.com/asavinov/prosto Prosto is a data processing toolkit - an alternative to map-reduce and join-groupby

[1] https://prosto.readthedocs.io/en/latest/text/column-sql.html Column-SQL (work in progress)

[2] https://prosto.readthedocs.io/en/latest/text/why.html Why functions and column-orientation?
But if I have a circle relation and a triangle relation, how do I create a foreign key for the favourite_shape column in my user relation?
We support dependencies in a number of ways, but are a bit different than make dependencies, because the file system of each step is separate unless you explicitly copy in or depend on other targets. This helps us do things in parallel because you are being explicit about the DAG of the build.

Copying or using file from a step causes your step to depend on it. Similarly for a `from +target`.

We also have variables, user defined commands and conditional logic. User defined commands are our way to composition.

https://docs.earthly.dev/docs/guides/udc
https://docs.earthly.dev/docs/earthfile#copy
Knowing four languages isn't the same as thinking in them. It took me quite a while after becoming fluent in English to having errant thoughts in English. Both languages can influence my thinking - sometimes I'll think of half of a concept in English and finish off the thought in my native language. This is most common when I'm dealing with math or numbers.
So rule of law has completely broken down in the US?
You don't unit test private methods, the "unit" is the exposed surface of the class.
Dumb or Smart Contracts?
Netlify offers an add-on for server-side analytics: https://www.netlify.com/products/analytics/
The first part of your comment is based on what? It sounds more like a theory that you find in certain circles around the web, which are in my opinion mostly toxic.

And the 2nd part also needs a citation especially the villify part. While I am aware of the studies that you are referencing, they usually focus on sexual attraction. But relationships are not only based on sexual attraction.
We do have plans for podman and other container runtime support. Here is our roadmap:

https://github.com/earthly/earthly/projects/1
Sure, if you like the way it works then that's great for you, but I think it is worth noting that despite the stated desire of many in the Linux Desktop community to see the fabled "Year of the Linux Desktop", it still languishes in a distant 3rd place. I personally think that's because it has deeply rooted systemic problems that it has refused to address in any meaningful way for the past 20 years, which is incredibly frustrating for those of us who'd like a real alternative to Windows for what we do.
Cleaning Suggestions That Are Vital to Follow for All Places
Carpet cleaning in Surrey is not tough as you can dry it without using machines or dryers due to the long sunny days. Meanwhile, the use of a wiper is also good to wipe out the greasy water from the carpet.
Thanks for checking it out. This is something we have plans for.
Zipline Recruitment
The Zipline Recruitment 2021 application form portal has commence. And we are here to help you get the necessary information you need and also guard you on what to do. In this very package, you will get to learn a lot and get informed as well.
Still a good chance it'll come to nothing and your efforts to help reform the borg if you stayed (even by a tiny amount) would have been more effective in making the world a better place.

It's definitely a trade off thats quite personal.

Unlike other personal trade offs people seem quite comfortable making this one on your behalf.
Nice music backgroud
Wow, I didn't think people still use this. I have a copy on my PC, and wheel it out every so often, when I find a great small site that quite obviously has been abandoned by it's owner so could vanish any moment, and Wayback doesn't have a full copy. I could switch to something better, but I know how HTTrack works, and it works well enough for me.
The most obvious reason is that they're private and not normally reachable from your test code.

But even conceptually there are problems with testing private methods. For example they likely expect to be called only while the class is in some specific state or in the middle of some atomic operation. Otherwise they could have just been made public.
Coworker!
Honestly yes; but I could not find changelog for the release :(
This is one of the lowest mutual intelligibility pairs if you don't count Icelandic/Faroese, so different languages. Very similar, of course, but different (especially since Danish had more outside influence) - one source https://www.researchgate.net/figure/Percentages-of-correct-a...

Now is Elfdalic more or less similar than Danish to Swedish? Based on the article video it seems there's some marked difference but probably more understandable than Danish.
The performance problems might be related to the graphical card - there is a heavy WebGL use.
Thanks for checking it out. We do get a lot of requests for podmad support and have it on our roadmap here:
https://github.com/earthly/earthly/projects/1
> It's been almost 15 years since the original iPhone and we're only now seeing ARM based processors in computers.

Are we just ignoring the Acorn Archimedes series of computers which gave rise to the ARM processors in the first place, fully 20 years before the first iPhone was launched?
We need to go back to fixed width all caps green text on black background for everything.

Eventually blue text on black background, but that's as far as I want to go.
flat-share with a couple

That's not what was going on. She was making separate living arrangements from him and had already moved out of her parental home and was living in a dorm and going to college.

Their choice could have helped push her into living with him as the easy answer in the face of prejudice making other choices harder for her. This could have helped make her into a victim instead of someone who once dated an older man and broke up with him and apparently had a better-than-average early relationship according to the description she has given.
Only if you're rich.
https://www.youtube.com/watch?v=VIs00QjiJZQ
Nix Camp – A small Hangout/Unconference for Nix, in Wales
If you're enthusiastic about Nix, are able to travel to the UK in short notice (in 2 months) and want people to hang out with over September that can teach you Nix, this event might be for you.

https://nix.camp
In Perforce you can do that. Indeed, often you have to, as you will have permissions to see only certain paths. One can assume g4 is similar.

Paths are also how one does tags and branches on old school tools like Subversion (just copy your branches/master to tags/releaseX and then never change it)
> fork and add stuff that I find useful or want

this is the whole premise of open-source originally. If the "fork" is good, either the up-stream takes the changes, or the fork becomes the official one. This will be determined by the users of the program.
In the UK most new cards don't have raised numbers on them anymore, and many banks won't process 'card not present' transactions, unless they're online and go through additional authentication (like SMS or app with, or additional security questions)
Ask HN: Are there any UX/UI public user feedback websites?
I'm looking for a place where publicly share design and give/receive feedbacks. Can't find any so far.
It's me, at home, alone...
Yup, and you can be very grateful for their decisions in that period as well. The most hairy flight I’ve been on involved trying to land in Kampala in the midst of a terrible thunderstorm. Turbulence like I’d never felt before (after hundreds of flights). A hushed stillness in the cabin, people grabbing their loved ones. From the amount of time you’ve been descending and the feeling of the flight you know you’re on final approach. Then wham, it feels like the plane fell out of the sky, and it’s still black out the window. A moment more calm. You look around; you thought what you felt before was the worst turbulence ever but now you’re surprised the plane is in one piece still. Then the pilot aborts approach at full throttle and you’re pushed back in your seat with unusual force.

A couple of minutes pass. You’re still ascending. The pilot announces you’ll circle for another 20 minutes waiting for the storm to pass, and if not they will have to return to the port of departure.
There's some truth to that, but at the same time it's undeniable that there was a dramatic decrease in political organization, stability, and economic complexity in the Western Empire. Only for brief periods would there be anything like imperial control of Western Europe, but never with the inclusion of Britain and Spain again, and never with the economic engine of Rome. The multi-centric world of Western and Central Europe didn't come close to matching the Roman economy until the Renaissance, and wouldn't surpass it in engineering achievement until the Enlightenment.
Sorry to be kinda of a "d*ck" here, but looking at the prices: For a 3-bedroom, you charge $363/month but that's for a 4 year duration. For a single year duration, you charge $1219/month. This comes out as $17.4k vs. $14.6k. Not very far off or ie: It costs almost the same to rent 1 year or 4 years. It doesn't seem you have shorter periods, either.

Basically, you are selling the furniture on credit the very same day they leave your warehouse.
The way I was taught it is against your interest to distract people during the checkout process; if they see an ad or otherwise go on a wild goose chase they might fail to finish and it costs you $$$.

Also shoppers like a bargain but discounting is the worst of all sales tactics because it comes straight off your bottom line.
My Naughty Little Sister
How a naughty little girl inspired me and a nation to read
This is really amazing! Has huge potential.
Inventing a new language and a new query engine and a new storage engine at the same time, competitive with the state of the art, is maybe just too much to be feasible.

There were multiple optimizing compilers which can do a lot of these asks, allowing composable queries that return nested types, but produce SQL queries. I think the pathfinder compiler had the most real-world use, it was meant to efficiently mix SQL and xquery to query SQL+XML documents stored in postgres. It had a c# linq frontend, but also fairly hefty compile times.
Here is an SBT example[1]. Earthly is starting up the database dependencies, running the integration tests, tearing them down and other glue type things that need to happen when a complex build pipeline has dependencies and several steps.

https://github.com/earthly/earthly/blob/main/examples/integr...
yeah there's a few
"I'm all for studying dead and dying languages in all ways possible.
What I'm strongly against is forcing kids to learn an impractical language because old people can't let go of the past and/or want to win political battles."

You are basically "strongly against" new generations inheriting most of their parents' identity. That is not OK, however you spin it.
Depends on the usecase. For example, if you profit via ads then the people you see on GA are the main ones you care about anyway.
The complexity of the SQL spec is a fair point. Inconsistencies between implementations has some merit but in practice doesn't really matter (eg how often do you really replace your database?).

A lot of the rest of it reads like the author started with this conclusion and then went looking for justification.

Example: the author states it's hard to return more than one column with a correlated subquery. That's what with clauses or join with queries are for. The author later mentions with statements so is aware of them.

As for JSON, I honestly don't think anybody needs that. Either return a JSON blob (generally bad idea IMHO) or you need to construct it in code.

The example of join verbosity has issues too. First, abbreviated syntax would need to express what kind of join to do (eg inner vs outer). Second, I find this fairly natural:

SELECT ...
FROM a
JOIN b ON a.id = b.a_id
LEFT OUTER JOIN c ON b.id = c.b_id

The author instead used this syntax:

SELECT
FROM a, b, c
WHERE a.id = b.a_id
AND b.id = c.b_id

The also leaves the join type unexpressed. In some SQLs you say:

AND b.id = c.b_id (+)

But that's kind of ugly and old-fashioned. The first syntax is preferable and clear.

On "compressability", SQL has this. They're called views. GraphQL has a notion called fragments that SQL doesn't. This is one of those things that sounds like a good idea but probably isn't. It makes queries much harder to read and I've seen this reach the point where a fragment is so widely used changing it is expensive (eg generated code) and removing anything is impossible. Plus a lot of users end up querying things they don't need.

Poor optimization and error messages of with clauses aren't really an argument against SQL. They're an argument against particular implementations. Extracting an anonymous query into a WITH clause should be a no-op to performance for any half-decent query optimizer/executor.

Writing extensions (eg functions) should be discouraged. It's harder to deploy and debug and the last thing you want is a badly written C function crashing your database.

Years ago we also had stored procedures (eg Oracle PL/SQL) and nobody does that anymore because it's terrible. You don't want that.

There's a lot in there about pathological corner cases that I honestly don't really care about.

I do agree that ORMs are generally a disaster.

Lastly, it's worth noting that SQL unless a lot of alternatives has a solid theoretical basis and that is relational algebra. SQL wasn't created in a vacuum. SQL is just a way to express those constructs.

I will say that SQL got the order of clauses wrong whereas LINQ got this right. SQL should actually look more like this:

FROM a
WHERE a.foo = 'bar'
SELECT id, col1, col2

Honestly though, SQL just isn't "broken". That's why it's endured so long despite the NoSQL fad and various efforts to replace it.
I think you're kind of right in terms of the actual content of the article, but what it speaks to is a system capable of producing flour on an industrial scale. I was quite surprised to learn that there were many ways in which the Romans operated legitimate industries, in the sense of producing far more goods at single sites than the local demand. They had massive mining operations, pottery factories, and mill complexes.
Those get you two countries, finland and germany. Most VPN countries advertise dozens or up to a hundred countries. Add in OVH who also have unmetered and you also get canada, france, UK and poland. A good start, but I don't think that is what these VPN providers are doing.

Those ranges are also often blocked by sites like netflix, which wouldn't play well with the VPN customers.
This is one of the things scrum is meant to help fix. In your daily scrum, tell your team you need X hours that day w/out interruptions and explain why. If your Scrum Master doesn’t protect you from interruptions by others, they’re not mastering their Scrum effectively. Ideally knowledge of the codebase would be spread around your team already such that other people can handle the interruptions I think it would be fair not to request this “no interruptions” every day.
SQL isn't immutable, it's always evolving. I find it awkward some of the arguments in the article read like "you couldn't do that before CTE was added". But it WAS added, so?

If you want to fix SQL, contribute to the next version of the standard, or provide example by implementing what you want to see out there.
When I was in Thailand, drivers often simply refused to turn on the meter, insisting on a (higher) lump sum payment, or get out of the car.

One time after I begrudgingly accepted the lump sum, our cab got stuck in bad traffic and the supposedly 20 minute ride turned into a one and a half hour ride. At some point the driver half-jokingly suggested that maybe we should go by the meter after all.
Associations Without Members (2001)
How safe is Colin Furze's tunnel?
Correct, I just continued to use the term of OP. Sum types r coproducts are what I mean.
If you use both SBT and npm, for example, to build your full project, then having something to wrap them could be nice. That could be make or earthly or a random script.

Also if you’re using SBT and you do like it, but you want something it doesn’t do, say shared caching. In that case Earthly could provide that but you can keep your existing build config intact. At the cost of added complexity, though.
That's certainly a tweet-sized sentiment!

I'll point out that the article was written "2430 days ago" and uses a CMakeLists.txt example that looks like it.

The article then goes on to announce Yet Another Build System that doesn't seem to have gotten any traction.
Not sure - because in the end, a programming language also has to store this concept in memory. I don't think there is a fundamental difference.
Startup Valuation Methods Explained
1. Become a Twitch-Streamer, find your superrich sugar-daddy.

2. Start with Onlyfans, for Billionars.

3. Make your own Currency, call it Euro.

4. Make instagram-ads with "Send me 1 Dollar for happiness" and a cat-picture.

But realistically spoken, besides gambling and donations, there is no legal way to make this much money in such a short time. Any real business would take far longer to just start till it make actual money. And Illegal ways are, well, illegal and problematic on their own.
I know less about Bazel then Vlad does so he may have a better answer. But Earthly lets you use your languages build tool and expects but does not enforce that the individual steps you call are reproducible.

So it is a less granular approach than Bazel which we think offers a lot of same benefits but without guaranteed bit for bit reproducibility. You can do non-repeatable things in a `RUN` but if you don't then it works well and you get to use all your existing tooling rather than having to replace them.
For context, British Youtuber/celebrity engineer Colin Furze[1] is digging a tunnel at a depth of 3.5 meters under his garden using hand and hydraulic tools. He previously built an underground bunker.

[1] https://www.youtube.com/c/colinfurze/videos
I used to use an app that had both a timer and a notepad. It was helpful for sketching out pointers to where I’d reached. A quick scan before restarting the next 25min, especially after a meeting or lunch, was very helpful. Being in the same app helped connect it to each session.
As it happens, the first time this came up in #lad I was like "another name is sensible!" ("how about osm? like, One Session Manager!" (that being, at least, British humour)), but, by the second time, I was resigned to the fact that renaming what would be the same (but more robust protocol) to another acronym would be pointlessly confusing to users (and devs). NSM was a hopelessly overloaded term already.

It's interesting to see the instance of HN groupthink speculation (and lack of google fu) there has been in this comment section. Folk should come idle/chat in #lad. It's available via Matrix.
Many things that are hard to prevent are still dangerous and wrong.
Apple Maps vs. Google Maps
Chinese antitrust regulator blocks Tencent’s $5.3B video games merger
I think you're right. I hope your name isn't though!
A prerequisite for privacy and trust would be transparency of the software. No word in the document that this is going to be free software.
So it can not be proven that this really respects your privacy. Therefore, it is not trustworthy.
I'd like to see some research to back that claim that over 50% relationships with significant age gap are exploitative.

Unless by more likely that not you mean a bit more likely than average relationship between a doctor and a waitress.

EDIT:

I'm sorry. While rephrasing the claim I changed its meaning. Please disregard my comment.
I did not know that kohlrabi is also part of the same species. Seems a lot more dense than the others.
(d) just means that enforcement is handled by the Justice Department, as it should. This new council is for policy.