skysight-inc/HackerNews huggingface dataset:
Given that the author also wrote https://scattered-thoughts.net/writing/select-wat-from-sql/, I don't think he knows nothing about inner joins. I think he was just using that equivalent form to compare it with the terser `foo.bar.quux`. It is pretty strange to compare it with `fk_join(foo, 'bar_id', bar, 'quux_id', quux)` though, because SQL already has the equivalent `foo JOIN bar USING bar_id JOIN quux USING quux_id`.
Before 1902 the name of the parish was written Elfdalen so I'm not sure it's just a translation thing.

Edit: Ok, never mind. It's definitely a translation thing: "The English name of the vernacular was introduced in Dahl & Koptjevskaja-Tamm (2005)."

Very recent too.
maybe because its nice? where does that conservatism come from?
No, of course not. On a small website, the bots are such a huge part of the logs that the whole exercise becomes an attempt at extracting understanding from random noise. It's why those visitor count widgets died out years ago.
I think SQL is amazing. There are few technologies within IT that has held up as well as it has. Skills you could gave learned 40 years ago still useful today. I think learning SQL well is one of the best investments you can do in yourself.
I have 4 simple advices for you:

1. Learn to write tests. You will increase your productivity, the fiability of your code and decouple things. Either you go into functionnal programing, either OOP. But write tests.

2. Read other people code. Pick a robust OSS and go through the code.

3. Work in a team, preferably with people better than you. But even juniors can challenge you during peer reviews. If they don't understand your code, maybe it's not clear enough. It will also force you to explain what you do, and thus, find where it could have been simpler.

4. Paper code before writing.
Usually I:
A. Paper code

B. Write functionnal tests

C. Write pseudo code

D. Write unit test

E. Write code

This way, I'm almost never struggle on bugs.
but what if you feel great after drinking?
And then a user sends a support request with a screenshot showing an in browser error and demands you fix it but your server logs show nothing because this was a JS issue.

While people who use frontend logging/tracking just search the user ID and see what went wrong.
>spending some time with one vendor will give you some habits that are sure to not work as well with another

It seems like having multiple vendors is only valuable if their products are to some degree differentiated, no?
Yeah, it reads like going down the path to write some SQL like parser without actually having used SQL in anger.
Who needs infantrymen when you have suicide drone swarms, bunker busters, MIRV's, thermobaric weapons (vacuum bombs), instant retina frying laser disco drones...

Infantry are going to be a thing of the past for anything more than proxy wars. Maybe frogmen will have their day or something.

The future of human violence at scale is fucking terrifying.

Edit:

Oh, and how could I forget. Our lovely fucking sword deploying hellfire missiles

https://www.sandboxx.us/blog/the-story-of-americas-hellfire-...

This is where you insert the joke about studying the blade I think.
and if you mix it with coke, its called a 'Neger' (negro in english). at least in bavaria and parts of Austria.
And it also breaks if two non-key columns are named the same.

This makes naming key columns differently a defence technique, so you stop people from using natural joins.
Shorter? No use of modifier keys? Just to name two. I think to do a meaningful comparison, more complex expressions should be used, that include joins, group by, order by etc...
That's highly unlikely. Data brokers that lend out data to you from exchanges make sure end users are just retail and make you sign a bunch of forms just to access basic lit pool data.
It is never the right time to buy and few years later, after the market took 25%, you are like "We did a good move back in the day!".

Bought my house 2 years ago (Auckland) and it is pretty good conditions (for NZ) with (almost) no isolation, windows that I have never seen in France, and a door which giant gaps at the bottom! And yeah, 1m+ $NZD... Hopefully the "prices double every 10 years in Auckland" trend will continue (we have some room for the interest rates to be lower...).

Good luck for Wellington mate !
A natural join selects all matching names which is not the same as what the article is saying. The database already knows about foreign keys. Why do I have to say

select * from A a join B b on b.Id = A.OtherId

SQL IDEs will auto-suggest that "on b.Id = A.OtherId" because it's the foreign key and could be inferred. That's what you need 99% of the time.
Perhaps you are already aware, but if not: one of the tricks in the Russian playbook is to build an ethnic group within their neighbours, as a way of annexing parts.

Krimea for example was 'liberated' in 2014 from the yoke of Ukrainian oppression by Russian-ethnic groups, and 'spontaneously attached itself to Russia'. The 'rebels' all had uniforms, no insignias but SIGINT has analysed the names of the people talking over the radio and many were Russian army officers.

Imagine Mexico organizing radio talkshows and political groups for Mexicans to liberate themselves from the Gringo oppression. They demand that the official language be Mexican. That Mexican history be thought in school. More and more the mexicans in California are unhappy. Until one day there is a 'rebellion'. And the Mexican state 'generously comes to the aid of their poor opressed brethern'

Seen in that light, does the POV of GP make more sense?
This is a very slippery slope. Writers imbibe all kinds of details from life, from gossip, from their families....writers are interested in people's lives. The only difference here is the apparently stark difference of her using social media as her source of detail. But it's really no different than if she read a newspaper article about someone online and borrowed detail from that.

Perhaps the only crime here, if crime there be, is an artistic one: the story is just a bit shallow.
One of my acquisitions bet is that MS will eventually buy Hashicorp, so they might switch back to HCL one day :)
I think this article shows the problem with Kubernetes and how it's used and sold today. The customer needs mentioned don't align with Kubernetes and how and why it is created and managed. Like the article says, people just want to run services easily, they really don't care about all the complex technical details of Kubernetes (which was born out of a highly specific technical need at Google).

I think we should solve these customer needs in a simpler and more natural way.

(I'm actually developing a product to do just that. Feel free to reach out to me if you feel strongly about this area).
I vaguely remember there's a science fiction story about an underwater civilization where the buoyant force servers like gravity for us. Since the force points outwards, for that civilization, the planet is "up above" their head and the space is "down below".
My guess would be he felt depleted emotionally and psychologically after spending too much time working.

Like when you need to spend some time in a dark silent room before filling like having fun or do house chores or do the cooking.
I feel the pain.

As someone who only uses SQL a couple of times a year, I feel that SQL shares the same fate as everything in IT: invented almost 50 years ago, not with today's world in mind, it has been blown up somewhat. Reminds me a bit of JavaScript: everything that can be done in JavaScript, will be done in JavaScript.

Like after C followed C++ and here Java and others there will be new DSL and techniques on top of SQL.

The article has its merits. Better abstractions for different use cases.
I would guess because bitterness is what makes it taste like an "adult" drink.

A lot of non-alcoholic options tend to be sweet: soft drinks, fruit juices, mocktails being the first that come to mind.

The newer trend with companies like seedlip, or with actually good non-alcoholic beers means you can having something "adult" to drink without rotting your teeth
America’s Hellfire missile full of swords
While you studied the explosives, others studied the blade...
> It would be really cool if databases had an Option<T> type. Then you could remove all the NULLs.

A nullable T column _is_ an Option<T> column, with NULL representing "Empty" or "No Value".
A few hours ago, the National Weather Service Las Vegas bureau reported a new high temperature record for Death Valley (although not yet verified by NWS): 130 F/54.4 C [1]. They project it will be even hotter over the next 48 hours.

[1]: https://twitter.com/nwsvegas/status/1413659717126160390?s=21
> adding a column to a table might accidentally break existing queries

Just a column, no. Adding a new foreign key might, but that's something that a type-checker/compiler can let you know about.

> They should Use NATURAL JOIN

NATURAL JOINs are better than nothing, but they're flawed too. Column names are supposed to convey meaning or intention, not just the type of data that they contain.
> are not destroying competition because competitors exist.

This is absolutist fallacy.
> But that's not how assimilation happens these days right?

That is exactly how it happens today. The process your parent describes is a currently ongoing one in France.
I don't understand what you're talking about, I'm talking about the non-commercial parts of the monopoly rights that are copyrights and patents, the non-commercial parts arguably aren't going to restrict the users much, and their commercial parts are temporary by design.

(Copyright has went IMHO overboard with its duration, we should scale to back to the original 14 years renewable once, just like patents, but copyright doesn't apply to processes anyway, and so arguably it shouldn't apply to software that can't claim to have any artistic merit.)
When you find it look hard at who made this "study", and check if they counted in the same way. For example counting the animals killed during the production of the food used to feed the animals raised for their meat.
Children will rarely know comfortable summers.
This is very important. I personally like old technologies and languages where the designers considered users who had limited technical skills, and most importantly, assumed that those users had no interest or need to improve their technical skills. Removing the assumption that users are willing to increase their technical sophistication forces a designer to think more about what they're designing. Looking at older languages is interesting - for all their warts, they do feel more intentional in their design than modern things that have a clear developer-centric mindset baked in.
I would assume it comes from disliking the taste of hops. I find hoppy beers taste like soap, personally but IPAs and other hoppy beers have become incredibly popular, so navigating the craft brew landscape can be a minefield for people that dislike it.

Still, it's not like there's exactly a shortage of beers for people that don't really like hops so while it makes it kind of difficult sometimes (especially when all you're given is a name of a beer) it isn't something to get that upset over.
I know, it's an hypothetical.
Since you mentioned movie, my favourite one is No Country for Old Men :-). If that movie doesn't put the fear of a bag full of cash, I don't know what will!
> Textile terminology proliferates throughout the English language.

I think "seam" ("a place where two parts of the code meet and where something else can be injected") is a felicitous metaphor.

"thread" as well. Wikipedia credits the term to Victor A. Vyssotsky
https://en.wikipedia.org/wiki/Thread_(computing)#History

> (1) Dennis and Van Horn [11] have used the words "locus of control within an instruction sequence." to describe a process; the alternative term "thread" (suggested by V. Vyssotsky) is suggestive of the abstract concept embodied in the term "process."

Was it chosen because it suggests a linear sequence of executing instructions, or perhaps because a thread that appears and disappears in the fabric with every stitch resembles a process getting and losing hold of the CPU?

I wish programming had more sewing and textile metaphors and less architecture-related ones.

We could begin with associating the idea of "patterns" in programming with sewing patterns rather than with architectural ones. They actually fit the former better.
Thank you, you sound like an adult.
You can set the user agent, randomize link retrieval order and set a longer delay between requests to avoid detection.
a gaming system is much more expensive than a dvd player so i can't ever see it becoming the norm. there's also the problem of having to upgrade your system every 10 or so years and your old games possibly not working on the new system
It means a secondary language, not a primary one.
Yes, but that's only automagic and brittle because it's not an actual join on the foreign key.

It's a join on whatever happens to have the same name! Which sometimes happens to be the foreign key.

The point here is that SQL doesn't have a way of specifying "join on whatever the foreign key is, and nothing else".
Show HN: A 24-hour "movie" played 1FPS for every second of the day
In the long term you could develop some best practices around killing pests.

I always thought something like Pabio for used mattresses would be great, so people could easily try lots of mattresses and find one which really helps them sleep.

To do that you'd need a nontoxic process for ensuring the mattress is free of bedbugs (e.g. put it in an airtight bag, then fill the bag with an oxygen-free mix of nitrogen+CO2 for long enough that any bugs will suffocate)
I remember you made some pretty awesome .io games in this style. Are they still online?
There is a tension there. Your ideal candidate is by definition not a candidate, or rarely a candidate.

It’s an interesting situation. Companies are trying to make their founders billionaires, but we must begrudge and judge the workers for a chance of becoming a millionaire by playing it like business.
Partly for persistence, I would imagine. The query you write today should function the same tomorrow and a year from now. If you want this implicit behavior, you may use natural joins
I've been cutting down on alcohol recently and have been pleasantly surprised by what's available here in the UK. Last time I did this is was mainly Becks Blue and precious little else. Mostly from specialist retailers like Dry Drinker and Wise Bartender, but there's usually something available in supermarkets.

I don't reckon much on some of the offerings from UK brewers: things like Doom Bar, Adnams Ghost Ship and Brewdog's Punk AF just seem thin and with no body.

In the supermarkets, Brooklyn Special Effects is pretty good, and if you like lager then FreeDamm works.

Current online favourites include St.Peter's Without and Harviestoun Wheest from the UK; Force Majeure Tripel and Brugse Zot from Belgium; anything from Insel Brauerei and Nittenau in Germany and Nogne O in Norway.

It’s great to be able to grab a decent beer knowing that I’ll have to drive later.
How do you find guests for your show?

I've been enjoying talking about my experience in the industry too. Here's the most recent chat: https://juniortosenior.io/50
I get the hate for increasingly invasive ads (screw the little car that carries the ball), but I chuckled at the last sentence: we've had sponsors on football jersey for 50 years :)
Here in the midwest USA I'm enjoying an unseasonably cool 63 degrees F right now. Windows open, about to go to bed. Haven't run the AC in over a week.
It's not abuse, it didn't even registered to me as something special, and I'm an ESL speaker. Some people, by dint of having read many books, have a rich vocabulary and use it without giving any thought to how well-read (or not) are their interlocutors.
Admit have not read the article but has of my personal experience I think the hostility of developers vs SQL came from lack of fundamental formation and experience in declarative programming and full constant every day immersion in imperative programming.
Children won't know a life with privacy. They won't be able to decide if they are going to vaccinate or not either.
After iOS added Adblock capability I fully expected them to either add one enabled by default, or ask the user a yes/no question of whether they wanted one. This would make Adblock on mobile easily 25% very quickly, and Android would be forced to follow too.
This is all really interesting! We’ll definitely think about this as we come close to refurbishing items (could be a few years away, hopefully!).
Happened to my mom too and a friend of mine.

Tenant said "he moves back, of family"

But that never happened, just rented out to the next person for a higher rent.
> I will cut corners and do a terraform plan on just one of these environments and then terraform apply on all of the others.

We don't do this because preproduction is being used by the business actively. It is treated like production environment. But it depends on companies.
Facebook already has access to your brain, just not in the same way.
Some tech people want to skip the latency lag when doing things and instead want to interact with the brain directly. I don't think this stems from a surveillance or control need.
But the world just works like that. There are unions everywhere. No matter how it's implemented under the hood, it should really be a first class concept in any language, including SQL.
Thanks, what about getting historical values from the API? It’d be very nice to get more historical data from the fianancial statements
> A natural join selects all matching names

Yes, which is why I called it "brittle". It can easily break if you aren't careful with column names. However, if someone really wanted (unwisely, in my opinion) to have the DB automatically handle their inner joins, they could use NATURAL JOIN. This would require being very careful with you column names, which is why I (strongly) recommend doing it the usual way with INNER JOIN.

> the foreign key and could be inferred

Only in simple cases. If there are multiple foreign keys referencing the same table, automagically inferring joins will probably do the wrong thing, just like NATURAL JOIN.

> IDEs will auto-suggest

The editor/IDE is where this type of automagic inference should be done! You have the opportunity to inspect the suggestion and fix it if necessary, instead of hoping the DB does the right thing at runtime.
> maybe even all relationships are the result of power dynamics.

Male here.

I think OP is referring to "romantic" relationships; I don't think it's true that they necessarily result from power dynamics. But I do think that all relationships, including friendships, work relations, and family relationships, have power dynamics swirling around them. I dispute that relationships are generally, or always, "the result" of power dynamics. I have a tendency to pedantry, so I may be in full agreement with OP.

That relationships involve power dynamics is unavoidable, I think. One of the ways we learn about the person we are relating with, is to push here, poke there, and observe the response. At the same time, we learn more about ourselves.

But attempts at domination are pathological, especially in romantic situations, and I think unusual.

I haven't read the short story, just the linked Slate article, and this one from the Guardian:

https://www.theguardian.com/books/2021/jul/09/the-cat-person...
Legal threats won't necessarily result in lawsuits.

Lack of publicly accessible lawsuits doesn't input lawyers of Company X doesn't shot down every single remote competitor preemptively with threats of legal action. At that point possible competitors either won't even try bothering or they'll pay whatever asked and sign a NDA preventing then from disclosing the patents in question (as a common practice on patent litigation deals).
Recently my small home server had a disk failure. One of the BTRFS RAID0 drives started having a lot of device errors, and shortly after the second drive started having errors too - but BTRFS was able to just take the healthy bits from both disks and I lost nothing.

However, since I had to now replace 2 disks I decided an upgrade would be in order, the disks been there for 10 years and I wanted to have more that 1tb for a while.
Turns out it's two times cheaper to have a 4tb array with 3 2tb disks than a 4tb array with 2 4tb disks.
There has been intentional spying (telemetry) in Debian too, Firefox for example, as well as Cura (3D printing app, although they eventually stopped that).
It's also not obvious to me what has been gained from introducing a function which takes 5 unnamed arguments. Without looking at some separate (and therefore possibly wrong) documentation there's no way to guess what it's doing. Writing the SQL may take a bit longer but reading and understanding it is far easier.
More likely that they wanted the names to sound similar rather than being equivalent, and it's not that often one translates place names.
VistaPrint Checks
The first example, you can read it and speak it in English.
Very interesting perspective. As a early-mid stage startup, you definitely want to invest in generalists who are able to build infrastructure before hiring specialized ICs.

I honestly had flashbacks when the author mentioned the carrot dangling thing. I’ve personally experienced this and as a naive early career swe, I gave the manager the benefit of doubt for a year even though I knew there was no way they could guarantee it. This is just pure manipulation.

The worst part is that he wrote the job description himself and resorted to manipulation to cover up his mistake of hiring for the wrong job role.
> ...although some prefer to play using timenudge...

Timenudge is not cheating by any stretch. It's been a long time since I looked into Quake Live's netcode. Someone here will probably know about this, so if you know more please correct me.

The server that you're playing on has a fixed framerate (server 'tick rate'), and periodically sends packets to connected clients containing the current gamestate (player locations, scores, etc). Your client deals with the latency involved by interpolating between the last two received packets. This means that what you're seeing is always (your_ping + server_tick_rate)ms behind 'reality'. Quake Live uses 'backwards reconciliation' on the server. When you fire a hitscan weapon the server looks at the server frame (your_ping)ms back in time to see if you hit something. These two reasons are why you might have experienced being railed around corners by high ping players. You were under their crosshair on their screen, but on yours you're in the clear.

What timenudge does is adjust the client's interpolation period. A server_tick_rate of 40fps makes for a delay between packets of 25ms. Since the client is interpolating between the last two received packets, your client is working with what is effectively an artificial 25ms delay. A timenudge of -20 tells your client to reduce that interpolation frame, at the cost of some accuracy. It's not cheating. It doesn't really give people any practical advantage at all unless you've got a totally obscene ping. If anything it'll exacerbate the effects of other players warping (caused by the server not receiving their client packets in the right order, or at all).

There's some good information on how this system works here: https://web.archive.org/web/20160302024647/https://www.ra.is...
And if Visual Studio had level of ergonomics any closer to JetBrains IDEs....
OP explains why this is not the same in all the other sentences of their comment