skysight-inc/HackerNews huggingface dataset:
Something painful I just learned today is that even Postgres >= 12 isn't that great with planning CTEs. Querying the same CTE twice seems to force it into materializing the CTE just like Postgres <12 used to do.

Fortunately there's a workaround - using the `with .. as not materialized ()` hint sped up my query 100x.
This is fairly normal for certain "glamour" industries. Back in the day when it was relevant, MTV was infamous for paying people almost nothing, for no other reason than they could because MTV had a coolness factor associated with it that people sought. Same is generally true for a lot of the entertainment industry.
It’s not a two way street.

The Californian defense minister doesn’t exist, and didn’t proclaim last November that “illusions of US strategic autonomy must come to an end” in response to criticism from the Texan president, citing sobering facts like “without the nuclear and conventional capabilities of the E.U., California and America cannot protect themselves.”

https://www.politico.eu/article/german-minister-to-macron-eu...
I love postgres and my business relies on it. However, at the scale the author is talking about (~100m rows), throwing all the data into BigQuery is very likely to be a better option for many people.

If rows are around 1kB, then full-dataset queries over 100m rows will cost less than $0.5 each on BQ -- less if only a few columns have to be scanned. Storage costs will be negligible and, unlike pg, setup time will be pretty much nil.
Microsoft is really being bold about adopting open tech to improve either it’s bottom line (Azure now runs more Linux VMs than Windows ones) and now with eBPF. Truly a new and different Microsoft.
There are already manufacturers who do in-body correction alongside their lens design to get results that would require a ton more glass; Olympus are one. Sites like DPReview use it as a relentless talking point that those manufacturers are sub-par compared to the big advertisers.

It's the photography equivalent of "if you were a real audiophile you'd only use pure analogue signals, digital destroys the sound".
NASA craft carrying 4.5bn-year-old asteroid dust begins long trek home
I don't believe progress is automatic, that's why I like hearing perspectives from people who have been around longer. When I hear the narrative from lots of older people that everything has gotten worse since their youth though, I think you can understand my skepticism. Especially given as your opinions are not universal among people who have a lot of experience.

Anybody today can, in seconds, download dozens of production-ready language runtimes and get started writing programs with a great IDE experience, for free! No cost at all. And this is now a fundamental assumption of software development.

I don't take it for granted because I have some idea of how far we've come, but I read people like you complaining about not being able to work with new build tools and I'll be honest, I assume that you've been left behind technologically and haven't kept up. I'm sure that's unfair, but you don't give these tools credit for their upsides (using new languages is much easier than it used to be, and development with them also scales much better), and you still haven't really explained the downsides fully. Even the C and C++ community is slowly moving in the direction of package managers and integrated tooling.
3DS is a type of 2FA that makes stolen card credentials harder to use. It does not replace but augments existing antifraud techniques.

3DS is merely a positive marker for antifraud system.
This means a 3ds transaction is less likely to trigger antifraud rejection, and antifraud declines are the reason for user abandonment - you can't simply retry a payment attempt in that case.
In the original Terminator some 6502 assembly shows up in some of the "what the Terminator sees" scenes:

https://www.pagetable.com/?p=64
When paging the old magazines, I noticed that until about the mid-eighties the focus of an ad was on a product. An ad would even boast of the technical specs of a car or an audio system.

A prominent display of people in the process of consuming, or even just people, puts the marketing focus on lifestyle, brand identity and the alignment with some values.

I hate Corporate Memphis the same way I hate the other attempts to hack my reptilian brain and build an emotional connection with a brand.
If you're thinking in EEE terms, this is Embrace. Extend and Extinguish come later, once you've got a preponderance of developers on your platform.
Culture fetishization.
I'm curious what people think of Swarm64 and/or TimescaleDB on that front
No it isn't. It's a crutch, but also one of the most centralized, manipulable levers for controlling what is and isn't discoverable on the Net.

Think about it. Domain names are seizable. IP's aren't. You can't stop someone with an IP from existing.

Whenever someone talks about regulating DNS, it should translate to "We want to take control of Namespace management.
Maybe I missed it but there's no mention of denormalizing strategies or data cubes, fact tables and dimension tables. Structuring your data closer to how its going to be analyzed us vital for performance. It also gives you the opportunity to cleanse, standardize, and conform your data.

I ran a pg data warehouse in the 8.x and 9.x days with about 20TB of data and it performed great.
There likely is an unpatched exploit that Mozilla is aware of but isn't disclosing (to the public). I'd hazard a guess it's more related to blindly parsing the root store and trusting the certs that Mozilla has in there specifically for the purpose of not trusting them (DigiNotar, et. al).
Ideally you stream logs and try not to rely on local storage. Rsyslog is quite the work beast and has a multitude of useful features (e.g. tcp+round-robin-multipath transfer mechanisms, disk-backed queues, rate limitation) and if you're feeling it, writing extensions is not that hard. Just reading all the docs is mind-boggling...
I bet they're not making their own thread, cloth, clothes, and a lot of the other things provided by an industrialized world. Doing those things the old way is very, very labor intensive.
The Sparc/Arc project in the US

https://www.youtube.com/results?search_query=mit+sparc+denni...

https://en.wikipedia.org/wiki/SPARC_(tokamak)

and the STEP project in the UK

https://en.wikipedia.org/wiki/Spherical_Tokamak_for_Energy_P...

Both are very promising, and unlike all previous experiments, if their core design goals are met they would quickly lead to commercialization, quite plausibly within 20 years.
Up until recently the Swedish tax office only permitted you to login during extended office hours.
Absolutely. I'm a naturally anxious person which translates into observing the situation as much as possible before interacting, and I also have significant training in the OP material. Sometimes (often) this is a hindrance to enjoyment. I have to practice a lot of mindfulness to not get unreasonably upset/concerned at some behaviors.

The number one behavior that upsets me is in grocery stores: people who do not realize that their shopping cart placement is causing a noticeable blockade and others are squeaking by or (im)patiently waiting for them to move, or avoiding the aisle entirely. This is not restricted to any type of person either; just today I witnessed a young man in scrubs park his cart sideways in the center bread aisle, halfway through turning around, and then abandon it to walk to the aisle cap to grab something (which he analyzed for some time before deciding upon taking). My mom used to do this same thing and it always bothered me, except now I view it as not just an annoyance but an evacuation and movement hazard.

The other one that bugs me is when I see people stopping at an entrance/top of escalator/exit of elevator or similar choke point. Please, I know it's overwhelming to decide what to do/where to go next, but be aware of your immediate surroundings and move to the side as you figure out the rest.
That was an excellent TedX talk. Thank you for sharing it.
Sounds more like an entry in `5 useless RedHat articles` to me.

Unix philosophy of 'do one thing well' is why things like `arch` exist. And I've used `arch` in plenty of scripts. Same with `uname`.

I'll admit that `arch` was more important during the early days of x64 introduction than now, but anyone who deals with legacy hw or embedded platforms is more likely to see it.
Boeing 787s must be turned off and on every 51 days
> Sure we're not pushing to “big data” levels, max a few 100k records, but in reality I believe that's the average size of the majority of business datasets (Just an estimate, I have nothing to back this up)

Excel on a laptop is also a viable option at that scale
You can hire a property manager who will take a percent and turn it into almost entirely passive income. This is what I do with my properties, and all I do is approve expenses over a certain level and forward tax docs to my CPA at the beginning of the year.
And I'd equally welcome the browser extension that bypasses this sort of thing. :)

It's good in theory, but thankfully lacks the contextual information it would need to be appropriately enabled for a given user's sleep schedule.
But... many movies and TV shows from 30 years are also still immensely enjoyable today. Or heck, from 70 years ago.

Why do you think movies and TV somehow age more than books?
Put () after the stderr and it'll compile.
> I agree with you that the benefits of static typing are sometimes greatly exaggerated.

For large, multi-developer projects, it is impossible to exaggerate the benefits of static typing.
Isn't it reasonable to have the option to opt-out of taking these vaccines, in the absence of more complete data and longer-term trials?
If anyone is motivated to do this for some weird reason, please self-host the code instead of exposing your users to potential hacking.
It's a problem the moment it has to interact with the outside world, especially DBs/serialization/... really any kind of I/O.
Windows for ARM has mostly-working compatibility with x86 and x86-64 Windows apps. It's not as good as Rosetta 2 on M1, but it's present and functional - so the app suite is still an advantage.
I doubt Samsung is gonna come even close to Apple in performance. But perhaps getting decent ARM processors in laptops will mean we get battery life that is actually good.

It's hard to believe that you can use a mobile phone with a high resolution screen and get 8 hours SOT with a varied workload. But browse the web in Chrome on a 2020 Intel or AMD based Windows laptop with a 1080p screen and see that your battery life doesn't even come close. Despite a much larger battery.
Virtually every DSLR and mirrorless cameras will correct for distortion in camera. On Nikon it is called Auto Distortion Control, you can turn it on and off after the fact for raw images. Lightroom and most other photo developing software supports this as well, with profiles specific to each lens and focal length. Turning it on results in the image being cropped very slightly as a result of the image being "straightened out" in camera for Nikon, or with a slightly larger overall size otherwise. Besides that very noticeable change there are physical limits on what the software can do, a lens with less distortion will have more detail as a result
I opened up a couple of those links and found tax free returns of 3 to 4.5%, so not very enticing.
Ensure you’re paying for business support or the non-free one, and make a new case with a different title (don’t reopen existing ones) to try and get through.
I second this. Pcapng is just a very simple, extensible, file format. I actually use it for anything that needs timestamping and a block-sequence format, for post-processing.
Fundamentally, if two people want to pair, and can meet their obligations as far as delivering work (produce two or more times the work than what's expected of an individual), then feel free. At the end of the day, I don't care how you do your work, any more than I'd dictate which IDE you use. The biggest concern that I'd have in a group with pair programmers is the noise from the constant talking, but most places don't care about having a quiet working environment these days.

However, with pretty much anything like this, just forcing it down everyone's throat is a recipe for disaster. Probably the most confusing thing about the original article was the statements "This was one of the best things I’ve ever done for myself, socially and emotionally, and it produced some great software", followed by "It burned me out" and "I was on short term disability due to cognitive impairment for several months of 2020, and I’m still recovering my old attention span, executive function, and emotional management". Huh?
If you particularly wanted books that "didn't make it", I don't know anything about that. But maybe you just wanted books that are like HP but better than HP.

I read the first few HP, and thought they were dreadful, and thus never read the later ones, so maybe I'm not the person you want advice from, but here are some recommendations of novels/novelists in the same genre (fantasy novels, written for children, that hold up for adults):

Nearly anything by Dianna Wynne Jones, but I particularly enjoyed The Lives of Christopher Chant, Archer's Goon, and of course Howl's Moving Castle.

Susan Cooper's famous Dark is Rising series. Half the series is more normal-kid (starting with Greenwitch), half is more special-magic-kid (starting with The Dark is Rising).

Garth Nix's Old Kingdom, starting with Sabriel.

While China Mieville is very much not a children's author (really! don't buy a random mieville book for your young niece/nephew, really don't!), Un-Lun-Dun is an amazing book in this genre.
TLDR: Don't let artificial metrics rule your life.

Chasing Hacker News points is one of them.
Code review is not enough. Especially when you're dealing with a culture of "rubber stamped reviews."

Good code reviews are a net positive but may not always be in place. Getting them on a team that isn't doing them is yet another point where you need to communicate with them.

You've got to talk, whiteboard, engage much sooner.
You could write the novel beforehand and then just release it month by month.
I'm at a loss. The claim is clearly "Former U.S. Vice President Joe Biden once said he had "no empathy" for the plight of younger people." If you read that broadly, like in the sense that any normal person would read it the first time they come across it, it reads as if Biden made some sort of blanket statement applying to all plights of all younger people, period. Like he's basically admitting to be a sociopath against younger people. I mean... that's clearly not what he said or meant.
Poor website needs a cdn :(
I, too, might be upset enough to ragequit Twitter if my most popular post was that & I believed my other posts were profound.
The clinical trials are actually the same (statistical power) as previous vaccine trials. They've simply enrolled more people faster and had a higher infection rate to evaluate safety and efficacy. It is likely in the next month that Pfizer will get a standard (non Emergency Use) Authorization.

https://www.biospace.com/article/pfizer-biontech-and-moderna...

The reason for EUA was that so many people were dying that some more limited (<1yr clinical safety) data was accepted. Now that many of the original subjects are falling past 1yr post inoculation (and variants have been evaluated) a full authorization in eminent. Previously, people worried that once one vaccine was authorized other EUA (NovaVax, AZ/ChadOx, etc) wouldn't happened, has also been resolved since the FDA realizes people want choice.
Those recent hires are also affecting how Visual Studio gets developed.

It is starting to become tiresome to get some CLI stuff instead of proper VS wizards.
We are going to have to acknowledge that the First Amendment right to free speech is not as broad as was set forth in Brandenburg v. Ohio (1969), and that it is within the government's purview, and the public interest, to curtail hate speech and radicalization with civil and criminal penalties.
A lot of government websites are Monday to Friday only. I like to joke that they don't even have one 9 of availability.

(e.g., https://www.irs.gov/payments/view-your-tax-account see the "Hours of availability" section)
Not that you're wrong necessarily, but in my own anecdotal experience the people clinging to the sorts of narratives you're describing aren't exactly the picture of precarity.

They're aging suburbanites whose TV came with a youtube app.
Reading this felt like that Apple keynote in 2016 when they said no one uses the function keys. Hmm, me? all the time?
At least the German services also need 2FA these days, though (since they access bank accounts, which require 2FA for all outgoing payments as well).
Statuses all the way down
Mali is every bit as proprietary as Nvidia.
I feel like the problem is that pip is clearly the most popular, but philosophically the pip developers do not want to build a solution to all packaging and environment management into pip.

If I were pip dictator, I would try to make pip the one tool to handle all python packaging and environment management. In particular, that means pip would handle the management of different Python versions, different Python environments, native dependencies, running tests, making builds perfectly reproducible, releasing new versions of libraries, and creating new projects.

"Creating new projects" seems like it is not a big deal, but in practice I think that if there were simply a "pip new" command that set up a new project using the best practices advocated by the pip team, it would go a long way toward standardizing the ecosystem here.
> I currently make 6 low figures in a relatively boring but non-stressful systems administration job.

For context, I was contacted by a game dev company recently. The max they could pay me was 5 figures.

Doing a gaming job for 40 hours a week for low 6 figures is fine. However, it's not the reality for many, if not most, game devs.
About enough to cover your broadband bill
Sure - but the parent didn't criticize the existence of the option. They criticized the decision making that many (not all) people use when exercising that option.
Yes, but there's also probably a mass of people who did what Dan Brown did and sold < 10k copies.
sqlite doesn't sound like a very good choice to me. journald's log format is nearly \0 separated fields, while sqlite is a good deal more complex than that. Also journald allows for append-only logs, which I don't think sqlite supports.

And personally I see the "hydra" as a benefit -- everything integrates well with everything else, because it's all designed to go well together.
No, I don't think it's about apps modifying the root store used by Firefox.

Rather, it's about well-intentioned apps using Mozilla's root store in their own https client, but doing it incorrectly so they don't get the security guarantees they think they are getting.
Bill Gates biographer lifts the lid on Microsoft founder's wild bachelor days
Well the question was more around what to count them as since there’s a wide range. In my experience people typically just mention salary and count stock options as 0 but everyone in this thread seems to disagree.
> any Tesla owner could've told you that AutoPilot cannot be switched on in roads with no lane markings

Then any Tesla owner should learn more about how their car behaves:

- https://twitter.com/LyftGyft/status/1383917552762384386

> Consumer Reports showed users how to fool AutoPilot by a set of complex pre-planned steps

It isn't complex. Any idiot can do it:

- https://jalopnik.com/another-video-shows-a-driver-abusing-te...

- https://www.thedrive.com/news/38787/mom-of-the-year-films-ki...

- https://www.thedrive.com/news/36366/morons-leave-driver-seat...

So why is it that a system which supposedly has the sophistication and situational awareness to offer "full self driving" on public roads can't even tell what's going on inside the car?
There’s some truth to this I’ll admit. But if most of the work is dull why do you need the “best” ?

I saw an explanation later in this thread that made more sense. FANGs do have a lot of good employees. And if they didn’t pay high salaries other companies would simply swoop in and free ride on all the hard work they do to find and groom talent. FANGs spend a lot of money scouring the entire globe and interviewing so many people in detail. It’s a juicy target for recruiter raiding. And just like you can’t get fired for hiring IBM you can’t get fired for hiring FANG. This attracts yet more talent. But yes the level of the engineers is not as great as the salaries would suggest.

But on the flip side for anyone doing hiring. If you want some wicked smart devs who don’t ask for as much then look at game devs.
Yeah, Sigma is clunky, 60% of my shots end up out of focus, but the best shots I get are simply unbelievable. Zooming in to a pixel level is way better than anything else I saw, including 100MP medium format ones, the pictures feel alive. Never experienced anything like that with another camera.
Don't have a mobile phone, so I guess I would count towards those numbers. A shop branch I used to buy at had 3-D Secure for years but after asking nicely, they disabled that authentification for me. However, ever since they merged with the main website earlier this year, it's no longer possible. So theoretically, it would be impossible for me to buy anything anymore...if not for the fact that they now allow you to buy "points" via PayPal with which you can then buy products in the shop. It's more complicated, takes longer and has other disadvantages (such as not buying the products directly) but for now, it works. Other websites which don't have such a workaround will simply end up with an "abandonment".
The B&H photo video website won’t accept orders or payments during Shabbat and most Jewish holidays (except for Hanukkah).
I don't know why this is limited to game developers. I'm a mgr/dir and it seems obvious to me that secrecy around salaries is consciously perpetuated because it allows corporations to get away with underpaying some people.

I can't think of any circumstance where it wouldn't be in the individual contributors' best interests to tell each other exactly what they all make. If everyone on my teams shared their salaries with each other, it would lead to two things: a) some short-term bad blood and awkwardness, and b) some underpaid people getting raises or quitting. And I think my bosses, especially the old-school ones, consciously play up a) and treat salary as a giant taboo to avoid b).
You don't get credit for being the first, you get credit for being significant. Zune and Windows Phone didn't get "people" into flatter aesthetics, Apple did.
I recognise the pattern you describe, but for example that was how my two (first) cousins ate when we were young. One cousin in particular, I swear he only ever ate either steak or burger and fries. It was a family joke that his mom would try to sneak some greens to his burger (just parsley) and he would gingerly pick it out and leave it on the side of the plate.

On the other hand, that's not at all how my side of the family ate and it's not because anyone there is remotely vegetarian. I think my cousin was more influenced by his dad's way of eating and his dad was from a different part of the country than mine, where they have more animals and fewer vegetables.

That said, we did eat lots of cured meats at home. So much so that I'm laying off them now I'm a bit older, just in case.

Still I think it's like you say, the relative consumption is on the low side by western standards.
It's not the popularity of svgs .. it's the need for resolution independent graphics.
Clearly didn't watch the talk then. He found that about 1-2% of errors in real world projects were type-related errors.
That's a good point. They could have designed the overall vision for how and what to create while under the influence, for example.