skysight-inc/HackerNews huggingface dataset:
The difference is when you type "select (here)" then your tool cannot really give you hints about column names in table

because you haven't specified the table yet.

Meanwhile LINQ starts with table name.

Ofc you can always go ahead and write queries in "different order"
With an Electron client, you also have to trust all the JavaScript libraries that NPM brings in (and this can be a huge number).

Electron is pretty cool, but it doesn’t seem compatible with anything related to security or encryption.
meta meta observation: You commented rather early in the posts history. Currently garbagetime's posts is near the bottom, while 3pt14159's is at the top.

How many posts were there at the time of writing? Did your comment influence the subsequent voting? Would garbagetime have been naturally downvoted if given enough time? Is hacker news actually declining in quality, or is it just tendency to favor good things when remembering the past?

Does any of this matter at all?
> feel the pain when it doesn’t work

If I have to FEEL THE PAIN when software I work on contains bugs, I need to be paid a whole of lot more than what you are offering.
>think long and hard before writing your first line of code.

Which is no longer allowed in Modern software development influenced by Silicon Valley.
A basic approach(probably what they are going for in a basics study) would be something like this off the top of my head

select c.cid, c2.cid
from customer as c
inner join customer as c2 on c.street = c2.street
where c.city <> c2.city

though that has reflective duplicates say (1, 5) would also have (5, 1) in the output. So I'm not sure if that's "allowed"
“ Drawing on their sample, Justice Department researchers estimate that 1,390 juveniles in the facilities they examined have experienced sex abuse at the hands of the staff supervising them, a rate of nearly 8 percent. Twenty percent who said they were victimized by staff said it happened on more than 10 occasions. Nine out of 10 victims were males abused by female staff.”

It also puts the famous kickbacks for jailing kids in a whole other, revolting light.
There is winevdm, but I don't know how that works, just that it does seem to mostly work.
In my experience of these things the environment at many banks greatly reduced the effectiveness of technical software staff. For example when I went to do some workshops for a bank a while back on data science, half the room didn't have their access approved to get the data and a third of the room didn't have access to the big data platform and many couldn't install any analysis software on their work laptops and it had been over 8 weeks since their project started. People who are really passionate about technology will find this sort of situation quite annoying.
Leave kids, and animals, out of your narcisstic filthy Lucre videos.

I was glad when that aussie was stabbed in the heart by a Batray.

And yes--I know it's complicated in his case.

Sorry, but any exploitation of animals bother me, along with phony nonprofits.
I'd love to know a school in the US where I could get a graduate degree without having to waste 2+ years on mandatory pre-req classes that have nothing to do with the education and degree that I want.
How do you access your NAS remotely? Does it end up creating some kind of backdoor into your network with cloud support? That makes me nervous…
Why are train wheels connected with an axle? Is it structural?

If the wheel pairs were independent then it wouldn't matter how fast each wheel in a pair rotates.
Since the problem usually isn't with the software design advice, but "people read software design books and then try to force whatever they read into their projects", I guess what would make a book "good" for that is "the author isn't popular enough to cause something to be trendy". IMHO Fowlers writing is just fine as "these are things people have done and you might consider" (and what I've read mostly seemed to be written that way, not overly pushy), but its so popular that if he writes about a new thing, too many people then jump onto it as the next big thing, if it matches their problems or not, and that gets painful to work with. Although for Fowler to write about something, I think it already has some trendiness going on and he's not usually on the forefront of new ideas?
What? Where did that come from?
When I first tried out TikTok a while back, the initial set of videos I was 'seeded' with included a great deal of really shocking animal abuse videos (dogs that had been buried in mud or concrete and are 'rescued', lots of animals being cooked or eaten alive, etc). I didn't interact with anything in the app but as these made me pause in shock, it lead me down a rabbit hole of them. Just another example of how optimising for attention is a horrible idea.
Perl 5.000 was released in 1994 (see https://perl.bot/p/kw3gbl for a demonstration that had the syntax)

Edit: That bot is far too easy to be curious with, and unless I got my testing wrong, perl 2 (from 1988) seems to have been where it was added: https://perl.bot/p/jzyi91

All assistance convincing the rest of the world they should also adopt the feature is very much welcome though :D
- Transistor on chip

- CPU on chip

- System on chip

- Network on chip

I'm looking forward to the next X on chip which I'm not aware of.
Ruby pry brings a lot of those conveniences that I think really hard to live without. There is a presentation[1] when Conrad Irwin shows what is possible.

[1]: https://youtu.be/D9j_Mf91M0I?t=1238
Also... is it possible for you to add nodes? Ie split a N>40 node into two nodes.
I have never understood the opposition to the law of physics you seem to hold.

What is the alternative? That we merely observe rigid patterns that are baked into physical reality? Isn't whatever is 'baked in' more or less a 'law of physics'?

If these are just 'brute facts' are they not then 'laws'? Maybe governance is too strong an word for the correspondence but what is the alternative?
Very true. I'm a survivor of woman-on-boy sexual assault, and it's hard to talk about with people because the typical response to it is this: https://www.youtube.com/watch?v=8hdbns1Xdk0

I assure you, it's not nice.
Synology boxes phone home, to Chinese IP space no less.
The name and terminology is unfortunately too close to the other helm. [helm.sh]
Weirder than 'numbers are physical objects'? Can you suggest a more suitable interpretation of the OPs intent?
How likely is that there are multiple smaller planets instead of one 9th, on the same side working as offset?
Disagree. We pay for convenience all the time. I just did in buying a synology NAS even though I could have pieces together my own solution (and have in the past). Having a working, maintained, stable, full featured email server that interops with the world isn’t something you can do quickly on your own even if you have the skills.
There is only one custom macro definition in this code, 10 lines of code without docstring. Builtin macros are not an issue, why would that be an issue ? Those are just part of the language standard library. It's the same as when you use reserved words in other languages, like *import* statement in golang or *ns* macro in Clojure, it's just part of the language and you learn how to use it. I was talking about custom macros.
Disclamer: My goto lisps are Clojure and Janet, so I am not very familiar with CL.
Shinkansen use cylindrical wheels, but the tracks and wheels are kept maintained to an unusually high standard.
In a very boring and traditional way: you buy a domain name, configure dynamic DNS, and then use port forwarding in your home firewall. No 3rd party proxies.
I see they mentioned previous course knowledge - this is something you see in many (programming) classes.

Students that have zero prior knowledge in programming, are able to pick up functional programming pretty easy. Students that have studied and used paradigms like OOP, seem to have a hard time grokking functional programming - as they see everything through the lens of OOP (and the languages they've used).
The memory of what happened with kext's always makes me leery of relying on anything that reaches too deeply into macOS's guts, so I've always shied away from Karabiner, probably unreasonably.

Old-style OS X believed in customisation—even now, you can set per-app keyboard shortcuts; it doesn't seem possible to bind Cmd-Q to Caps Lock, but, after slipping from Cmd-W to Cmd-Q and so quitting rather than closing a tab one too many times, I do have Cmd-Q bound to Cmd-Opt-Q for Safari only—and yet there's no Apple-blessed way of changing _those_ shortcuts, when it clearly had the architecture in place to allow it. That always irritated me.
Approvals take 6 to 8 months
YouTube only ever recommends to me videos about debunking fake videos instead of the fake videos themselves. Does this mean I'm savvy?
Rights show us when the mighty are wrong.

An all powerful despot can still be a rapist and murderer.
Programming is for all kinds of people.

If you felt despair when you read the metaphor of totalitarianism and just want to get away from languages that want to grind an axe on you, and Lisp is not your cup of tea, then Raku and Perl welcome you.
Yes, but GP's assertion is that it's sexual abuse when a third party interferes to prevent consenting individuals from participating in sexual activity.
If it's a one-time thing, then even it taking weeks is quite acceptable.
It isn’t sexual abuse for a jailer to not fuck the people they’re jailing. Describing it as abuse because of the logic that people who are in prison can’t reasonably non-coercively consent to sex with the people who are controlling every aspect of their life doesn’t make sense in the context that it isn’t abuse to not have sex.
Missing the Keyword here "operating margin".
Would you pay 100x as much for a service that is protected by that level of award?
Thank you! Indeed, the upvote button on those item-based recommendations didn't work. It is fixed now.
The Python 2 to Python 3 migration was such a disaster that Python 3 is now used by both more programmers, and a higher proportion of programmers, than Python 2 ever managed.

This is not to minimize the pain of switching. But it does not seem to ahve limited the success of the language.
> Truly private email.

The marketing is heavy on this site.
Not really. I used to teach SQL not a long time ago and about 1/4 of the trainees were getting up to speed fast, about half in a reasonable time, the rest were there only because they were sent there by their managers.

I found that the most important success factors in learning SQL is the analytical thinking of the trainee and the way the trainer is explaining the concepts, in what order and what examples are used (the best examples are the ones the trainees meet in their regular work).

The functions are simple, the only difficulty is to remember the ones that are not used often enough (ex: some window functions). Even in that case, a quick check in the documentation is enough to get up to speed. The major difficulty with SQL is to write efficient queries on large data volumes, covered by the right indexes. This is very specific to each RDBMS, especially because of the tools helping with the work are specific (ex: SSMS, SQL Sentry Plan Explorer, statistics parser etc).
Statistically, they're more likely to have a television than a computer.
It still isn’t sexual abuse to prevent someone from having sex with someone else either.
People have been chanting cattle not pets since before Ansible existed, so if people cargo cult it without using it in the way it's useful, there's not a tool out there that's going to really protect people from lack of due diligence. We don't judge a kitchen knife according to the people who try to grip it by the blade. Dependencies outside of an app's git repo will always exist for anything beyond the most trivial application.

Tooling can assist process, provide guard rails and reminders, but it's never going to replace remembering some important things. Having layers of process that mean that a single person forgetting is not going to cause disaster are necessary no matter what. Maybe when general AI exists we won't have to worry about remembering things, but then at best most of us will be out of jobs, at worst we'll be running from kill bots.

Don't get me wrong, there are plenty of design decisions in Ansible that regularly annoy me, but I've never expected it to make me less forgetful or substitute for people cooperating and communicating, and I think expecting any tool to do that is a road to disappointment.
>I always wonder if every first world, white collar worker who thinks these things realizes that the exact same thing applies to themselves.

Pretty much sums up Silicon Valley. Saying $200K Fresh Grad job to FAANG is barely enough while claiming the company that employed them are making too much profits.
Pig Rescues Baby Goat

https://youtube.com/watch?v=g7WjrvG1GMk
> You can inform the slave that he has a right to no longer live under subjugation, but if he has no mechanism by which to escape his slavery without loss of life his material conditions do not change.

There is value in people knowing a slave has intrinsic worth and deserves freedom. People deserve justice especially when it is out of reach.
Imho, software people should study foundations (particularly proof theory) much more than they do. That is how you ensure correct code, after all. The people deeply involved in software verification are basically logicians. Also, the test suite for the HOL Light proof assistant (used in software verification) uses a large cardinal axiom, sort of. It uses a version of itself with the large cardinal added, to prove the consistency of the normal version without the large cardinal. Neither version can prove itself consistent, because of Gödel's theorem, but the one with the large cardinal can prove the consistency of the one without it.

One can say that if either is inconsistent then they can prove everything, but that makes it even sharper: the large cardinal is used purely to give engineering assurance of software correctness and not real mathematical rigor. So it's a pure engineering use of one of the most "out there" mathematical objects. It doesn't seem worse than using IEEE floating point arithmetic to design airplanes....
Overgeneralising as usual, but I tend to group engineers into 2 camps: builders and optimisers.

Builders build product, they can ship something from scratch, doing whatever it takes to take the product over the finish line and in the hands of customers.

Optimisers are the people who like to come to already built products and iteratively solve one bottleneck after the other that builders made while getting from 0 to 1.

Both camps are valuable and both are needed, albeit at different stages of a company life. I tend to think I belong to the first camp.

I think being purely code-first is a temporary phase and you tend to get into the first or the second camp at some point.
The western world is better off by almost all socio-economic metrics than a half century ago. And hugely better off than a century ago. You actually are basing your predictions on doomsayers.

Oh, and debt levels are high because rates and inflation is low.
Link? I'm not certain that there's a way to objectively measure that on a scale that matters.
That's not at all what the original comment said. It said, to paraphrase, that denying teenage boys their sexual agency is itself a form of abuse. I have no idea where you even got your original idea.
Remembering which join does what is easy: inner joins strictly joins the tables, left takes all on left (first table), right takes all on right (second table), outer (or cross) join are so rarely used you don't need to memorize.
My wife and I just came to this same realization. There's just too many of these polished rescue videos to be real.
Source... the only full audit is the one still in progress in AZ.

Some (very very few) did "Risk Limiting" Audits, that audit a random sampling (some times as low as 2%) of ballots.

I am unaware of any full, hand recount not using any electronic machines audits that took place anywhere in the US outside of AZ.
Yes, but I'd say that's true for everything on the web. Advertisement is like a reverse Midas touch. Everything relying on it is on a race to the bottom.
> “I am very aware of [Waymos] when I'm running on the road or riding my bike,” Stacy, the Chandler resident, told us. “When I was on my bike, I had one creep up on me. I chose to stop and wait for it to pass because it would not go around me as I was moving.”

That's something underdiscussed. A lot of driving is predicting other driver's behaviours. After a while you get a sense of what people will do, and in which broad category they fall under.

With self-driving cars, now we have new actors on the road that don't act naturally. And each software update might change these behaviours. This has some interesting feedback implications. As we get more of those on the streets, we might see more accidents after software upgrades. Not because of the software, but because people got used to the old behaviour and didn't anticipate the new one.
By failed, I think they mean “spectacularly wide usage, with some drawbacks”.
Though one might also wonder if there is some source of artificial click views which could be employed by some channels.
You call it fear and lack, I call it being prepared for when life gets harder.
Functional and OOP techniques do not seem to be best friends.

http://steve-yegge.blogspot.com/2006/03/execution-in-kingdom... uses Java to discuss what this can look like in an extreme case.
Shouldn'ta sold it!
Of course, I agree with that. But this is, at least in my opinion, a very niche product. People who even understand what the product is would probably not be willing to pay a subscription for something they could setup on their own. Of course I could be completely wrong :)
This is a terrific answer. Especially "more than just 'not there'."
You really didn't get my point, did you? For new research, protein folding was a random example, you need new terminology which everyone just accepts and uses, it becomes standard.

Emacs sort of tried to do that, failed, and now it's like Australian animals faced with animals from the rest of the world. It will never win, it should adapt.
Good programmers know when to cut corners. Not having tests is always a contentious topic, but it's also hard to justify when you don't have a product market fit yet.

But then again, you might be building reusable components that you will reuse when rebuilding or relaunching. So it's better to get test coverage on at least those.
Okay, THAT would be hard to stage.
I can relate. Around the time I got this tour of the museum, I was working on a rendering algorithm that was slow and could occupy the GPU for seconds at a time. For some reason- whether it was a poorly stabilized power supply or EM radiation I do not know - I could hear pretty loud chirping noises when I had my headphones plugged into the onboard analog jack. It went so far that I could easily tell which part of the algorithm was currently running on the GPU and I could sometimes even count single iterations. This was very helpful because the screen was of course frozen. while the GPU was busy with my program.

This computer finally made me buy an external audio interface out of frustration. I went on to do some acoustics projects and I really needed cleaner audio for them.
You’re saying that security isn‘t black and white, but trust somehow is, which I find a bit weird, since they‘re intimately related.

Backblaze could easily reduce the trust required, which they‘re not doing, but have been promising to do for years, with nothing happening.

Also, given your threat model, I‘d say the risk-mitigation is not applicable. Attackers lying low and continuously collecting and exfiltrating data is nothing new. Especially if this data includes passwords, private keys and data „zipping-by“.

Or does your threat model include specifically only an attacker being advanced enough to compromise Backblaze, but somehow not being able to persist for a while?

No, it‘s Backblaze‘s job of keeping data safe the best way possible, it shouldn‘t be necessary for customers to find excuses for their bad encryption scheme or to add another layer of encryption, especially if the fix is quite obvious and has been promised for years.
> The reason leftists like the authors of this article want more justices now is because Biden would appoint leftist justices and the 51/50 split in the Senate would confirm them.

Most serious proposals for expanding the court address this. They generally propose adding and filling the new seats gradually in the 5-20 years after the expansion passes. That way, no one knows the executive or legislative makeup at the time of each new vacancy.

That said, the most serious proposals are for staggered 18-year term limits, so each president would have 2 vacancies (unless a justice dies on the bench), not more seats.
Animals being eaten is not unethical. If anything killing strays and eating them is actually better since the animal is not just being killed for pest control. We westerners just like to think eating dogs is somehow evil when you look at the last hundred years because of war, it was way more common than you'd think. I personally wouldn't advocate eating them, but, there is absolutely nothing wrong with it.
looks at vote count

I see I have enraged the C programmers.

My apologies for being terrible at C memory management, though in my defense I am sufficiently self aware of this to realise that means it's safer for me to stick to perl as a weapon of choice.
No, I’m basing my predictions on a thorough study of history and the phases of civilizations. There are several deep cultural and structural problems with both the US and the EU, and I find it difficult to not see this continuing.

And as far as I know, millennials are economically worse off than their boomer parents.
FOMO. This is what causes bubbles. Of course it isn't any consolation that people can keep getting rich off of overpriced assets for a long time. As the saying goes, "The stock market can remain irrational longer than you can remain solvent." In this case however, you aren't going insolvent, just suffering jealousy.

I'm not saying to jump in - the crash my come tomorrow. Or I'm not saying don't jump in - the asset prices may melt up with inflation and people who were out are left poorer. There are risks either way.

This doesn't apply to the high paying jobs I think. There you just have to decide what you really want and be happy with what you can get. As many other comments say, money doesn't equal happiness.
I'm a fan of this project, but flexures are antithetical to an STM assembly. And STM needs very rigid components, the smallest vibration can interact with the height adjustment and push the tip into the sample.

But it's a great assembly for anything that doesn't have a feedback on the positioning.
And the Dave Kleiman who is second author on this paper is that Dave Kleiman, the one who most likely invented bitcoin.

Wright has claimed to be Satoshi Nakamoto but has proven himself to be a liar on this topic; by his actions he clearly believes that Kleiman controlled the Satoshi bitcoin fortune before his untimely death.
According to their blog post How Helm Works - Part 1: Networking [0], on the AWS side of things, for each Helm unit, they are provisioning an EC2 instance, an Elastic IP, and a Route 53 config. I suppose the 128GB backup is also part of this. From my perspective, $99/yr is not a bad deal for all this to be automatically managed.

[0] https://blog.thehelm.com/post/how-helm-works-part-1-networki...
Not quite trying to match TSMCs leading edge - as a back of the envelope calculation based on dimensions given in nature paper, a GTX 3080 in this node would be getting on for the size of a billboard!
That’s at least a pretty honest response.
> and, to a lesser extent, your syntax

That was a fantasy syntax I just made up. How can I expose implementation details of a compiler that doesn't exist?