skysight-inc/HackerNews huggingface dataset:
Data changes, so the best query plan changes with it. SQL was built to handle this data-dependent environment.

Is one column composed of mostly one or two values? Then an index lookup on that column is not very optimal, and the database can use something else.

There is more than one type of join (INNER, LEFT OUTER, etc), and more than one join algorithm (neesed loop, merge, hash, etc). All these change based on the data. Even the join order can have a huge impact on query time, and needs to adapt based on the number of rows you'll pull from each table.

A lot of SQL queries are built from templates, or built by ORMs. Optimisations are critical to turn these templates queries into something efficient.

SQL can also be very expressive, a "NOT EXISTS (SELECT 1 FROM thing WHERE foobar)" could be more readable than doing a join and where clause.

Though interestingly, you get a much more declarative query style with nosql databases and key-value stores. So there are alternatives out there.
Apps know where you were last night and theyre not keeping it secret (2018)
You could even use nginx on scratch to remove alpine as well.

https://github.com/gunjank/docker-nginx-scratch/blob/master/...
AR: Cut and paste your surroundings to Photoshop
Code can be seen on this commit https://github.com/imduffy15/esphome/commit/90c3cb62b37e9ce3... there are likely bugs :D
This my method: one account for the phone, one for Google Drive/Google Docs only used in a special purpose Firefox container. Email and calendar are with Outlook.com - they are good enough, work fine with Android, and are worth the reduction of entanglement with Google in my life.
Show HN: Share the moment of gender reveal with friends
I deeply dislike the almost lack of compile time errors in Python. I like my programming language which as long as I know what I'm doing it will likely be correct once it compiles.
Drive-In Concerts Are Now a Thing in Denmark
Stirling Engine
Let alone might get actually blocked by content-inspecting AV because signatures are only added, not removed.
Used https://m5stack.com/products/stick-c myself
'Rockers and spies' – how the CIA used culture to shred the Iron Curtain
Actually I'm wondering if you can use the GDPR for this. It gives you the right to ask for a copy of your data. This counts for places where you don't have an explicit account so presumably o could get a copy of all data from my account even if I lose access?
I notice the same thing happen with other languages on HN. What I find interesting is that Rust seems to always get some variation of the comment: “why is this interesting, this has already been done in other languages”.

I don’t know why the hate, but I would say HN is a community with a lot of developers, and if things are getting voted up, it’s because many of the folks on here might have enjoyed seeing the post/article/project.
Thanks, anonfunction! I've corrected it
NB forwarding does NOT include "spam" email... i have all my Gmail accounts funnel into one and i check the spam buckets of all, every 4 weeks (otherwise Google turfs em). i usually find a few (rather important) false positives in that monthly sweep.

Further note that gMail filters at every step, eg this includes a downstream "archive" account. So there are false positives coming from a "known" [single source] good account and of already vetted emails...

i do wish there was a way to forward everything ... where everything meant everything ... filtering optional.
We are looking for a full-time, remote developer with strong PHP skills to join our international team.

Through the VC4A.com platform, we connect high growth high impact entrepreneurs to growth opportunities and capital resources. Join our team as we build up startup ecosystems in the world’s most exciting emerging markets, tapping innovation and entrepreneurial talent from all corners of the globe.

https://vc4a.com/jobs/php-developer/
What metrics do you want to monitor? Are these things like latency, error rates etc? Or more like dyno memory usage, cpu usage and so on?
I feel we are better closing down instagram/<useless app>, and using freed up computer scientists to build something usefull.
I don't understand why people think Kubernetes is "hard" - I find it quite straightforward and the documentation is excellent. I've been running my side projects on a single k8s clusters and rarely have issues.

Yes, there is a learning curve. It's not a Heroku where you enter one command and it just works. You'll need to spend a few days to become familiar with the basics concepts. And it may take weeks grasp the advanced concepts. But it's less complexity than learning something like a new programming language.

You'll probably get back the time you invested. Things like deploying production-ready application with a single command using e.g. Helm is quite powerful and can save you money over using managed services.
Why do you hate utility-css?
I've seen it.

Most of these 'time series databases' are for processing of structured logs and metrics to be plugged into you favorite system for monitoring site latency.

Asof join is still an open issue in their issue tracker so it is not usable as a time series database.

https://github.com/timescale/timescaledb/issues/271
What would the shovel be in this case? LLVM?
Hard work? Doing a job even if the customer is not somebody you like? The root of mental health crisis in this country? Geeze.

Pretty soft life, that, if you can get it. But there're lots of jobs require you to sweat, mentally or physically. Nothing wrong with that. People can survive a shift, without total mental breakdown.

I'm generally supportive of so-called 'Millennials' because people are people, the young are not the soft fragile children people like to make them out to be.

Then somebody posts something like that comment, and I can see how the stereotype got made.
OpenSMTPd is much easier to configure, IMO.
Maybe: "Creator of Love-Bug computer virus (2000) tracked down..."
The comments of Rust programmers here also suggest that the Rust implementation is, indeed, different from the Go implementation.
It's not about the numbers. The point is being made about the metric (per seat vs per GB, etc)
The author comes down on a side of an issue for reasons that he can enumerate and reason from. That's good. However, he does say something really odd:

"In fact, one reason I consider myself a conservative is because, according to Russell Kirk, conservatism proper rejects ideological thinking."

That seems misguided. I mean, maybe it's true, but you'd have to define "ideological thinking" very carefully, and even then, all you're doing is defining the problem away. Probably nobody else will accept your very careful definition of "ideological thinking".
List of Wealthiest Animals
> You can imagine what happens when two corporations

I don’t need to imagine, I’ve done it to my apartment complex before by mistake. I have an Aruba 3200XL controller and a bunch of APs (couple 335s, couple 225s, and some older 105s, with the 105s being used as Air and Spectrum monitors). Decided to see the impact and quickly learned all my neighbors lost WiFi access.
AFAIK on Windows, the hierarchy is:

C library => kernel32.dll => ntdll.dll => system calls

You don’t have to go via the C library - calling kernel32 directly is fine (I believe this is what Go does). However, it’s very rare to call ntdll or to make system calls directly.
"because I am stuck at home and bored out of my mind" is a plausible theory to me, though really, I find myself asking the same question about why the hell a toothbrush needs to connect to anything but power in the first place. The toothbrush company's page on the virtues of their Bluetooth toothbrush is not very compelling IMHO: https://oralb.com/en-us/why-switch/
But if your domain is through GoDaddy you can just change the DNS info there and it won't point to Google anymore.
Their Twitter thread (to be found on the front page) recently announces a block-based interface, similar to Scratch, Snap...
Example here: https://t.co/aZKscZAHCS

I am honestly wondering which of these alternatives I should start from, to introduce my 8 and 11 yo to programming. Maybe start obvious (so... Scratch, which is used at their school), then introduce the others as needed?
tl;dr author discovers multi-stage build to throw away useless nodejs dependencies.

Same also applies to even Java. Maven downloads tons of stuff these days. You may only be using single static string from a dependency.
Show HN: Interactive HR plot of my wedding day
Cool, now go look at the CDC figures for excess all cause mortality for April this year compared to the previous five years.

From your link:

> The 10 leading causes of infant death in 2018 remained the same as in 2017.

Now go include 2020 there, and we're not even half way through the year.
It seems like a pretty safe default policy for any service you get for free, or where the company is under no contractual obligation to you to do, well, pretty much anything.
shhhh.

silicon valey doesn't know there's life past berkley.
I think using trig and especially inverse trig is almost always an antipattern in graphics code. Careful use of dot and cross product will almost always be both more performant and more robust.
> I have a business that relies on a Chrome extension to be on their web store.

Except some very few regulated things, no store has an obligation to carry this or that brand of product. Even in retail.
That one isn't Github's "fault", though. That's going to happen if you use any service incorporated in the US.
Of course recoverin an email is an innocent disguise.

The same approach works for recovering any secret information that people used on a computer that an attacker can access. Of course there are plenty of possibilities. But it’s eye opening to see them in action.
Mount Pulag: The Playground of Gods
Nah. On the “Wintel” side there are more competitors and some of them compete on price to an extent that Apple does not. E.g. Asus and Acer.
Because it's got a frame around it Lit's non-primary button looks like the primary button. To me.
Sometimes people do things for fun.
Back in 2015 when cloud offerings were still marginally new, a lot of big providers were gettting into the game with Docker offerings (ie, IBM Bluemix) where the charge was based entirely on RAM*Hours.

Naturally this lead to me gaming the system and making my docker images as in RAM usage small as possible. In the end I even abandoned SSH as too heavy and switched to shadowsocks (2MB resident) for networking the docker instances together.
Your priorities are messed up my dude.

Work to live, not live to work. We all end up in the dirt either way.
Firstly, this money is a pittance compared to the costs of development of F-22, which produced a habdfull of planes and thats it.

Second, the decision to use existing shuttle conoonebts was made basically by congress/ lobbyists. Congress gets insane amount of control over nasa, and can fund or de- fund individual projects. As a result, nasa has to tailor them to something congress will like and approve. This miopic managenent probably results in what weve got
The US Navy Admits UFO Videos Are Real
You can still write your test to express user intent (`it completes in [time window a user expects]`), generate the load your representative of what your user would encounter, and test that. If your test looks for `COUNT DISTINCT`, you aren't verifying that the results are delivered in the time expected, you're testing something else entirely and you may have no idea what a user will experience.
Stephen Wolfram’s Science
Man Behind Coronavirus 5G Conspiracy, Has YouTube Channel Shuttered
Of course it doesn't. They've saturated the market though, so it gives them something to sell to people who already have a power toothbrush.
Kubernetes is "hard" when you're not running on the cloud. The solutions for persistent storage and networking are a mess when you're running on self-hosted infrastructure.
that was forced on some cheap androids between version 3 and 4.

after 4.4 they dialled it back to instead of required now they only apply some seven dark patterns to try to trick users into thinking it is mandatory.

same effect to most users, zero regulatory consequences
The demod used case is a silly one that makes zero sense, but instead of asking why, think, what else is possible.

For most peoeple the act of brushing their teeth marks waking up or going to bed.

With such data exposed and combined with timing data you could trigger morning or night time routines. For example, the toothbrush transitioning from running -> idle after 8pm and before 4am could cause the bedroom to go into sleep lighting (gold at 40% fading out over 15 minutes), all other lights to be turned off, all smart plugs turned off, house alarm set to armed, heating turned off and so on..... or I could just continue to be silly and turn it into a TV controller https://twitter.com/imduffy15/status/1256954852996939777
Tangkula Patio Round Daybed with Retractable Canopy
If you don't have knowledge on category theory, even the first part is going to like like spaghetti.
Cognizant Manifestation System Review, Legit or a Scam?
I saw migadu in a recent thread on HN and am now a paying customer. But even the free tier is impressive (unlimited domains!) and support is human & very quick so it won't delete your account for non-payment (looking at you mailbox.org)
Wow. Don't click this link. A very loud child's voice blare out of your speakers. Annoying as hell. Woke my dog.
I just noticed Google does the same:

>Will Google use my social media posts to promote Code Jam?

>If you share or post content on any Coding Competitions social media page(s) or tag a post with a Contest hashtag (e.g. #CodeJam) on your social media account, then Google may feature your Social Media Content in marketing and promotional materials for any Coding Competitions Contest. Learn more in the Coding Competitions Terms.

Guess it is more binding when they write that on their webpage than on their social media
Disclaimer: I am no Statistics master but I'm passionate about Statistics, I'll try my 2 cents on this.

In hindsight, I think I should have reordered the values on the horizontal axis by weekdays, Mon-Sun. If I did so, we would have seen that diagram as some sort of distribution looking like the Gaussian distribution, with the center on Friday. With that in mind, I'd say it's natural that people spend more time on HN during the weekend and that it's only natural that people are inclined to post here on those days. So my opinion is that more posts appear on HN during the weekend, so the probability that a popular post appears on these days is greater than any other day. Still, that's just my rambling and I'd be super happy to hear some other opinions.
1d gaming art is almost certainly the hardest
Agreed. The parent description makes me think of how people used to talk about "justice" before. It was at the whim of others, and only the powerful had certain access to it. But at some point, we nationalized the carriage of justice, and so we could all come to depend on it (on both the giving and receiving end)

I hope we get to the point where something in the commons (government or whatever), can offer comparable assurances about digital things that are becoming critical infrastructure in our lives
I assumed we were going to hear about the mechanic who maintained Herbie and is now making a living in a small car repair shop somewhere. Definitely a strange title.
> This docker image resulted in a 419MB final image and took about 3 minutes to build. There are some obvious issues with this. For instance every-time I change any file it must go through and reinstall all of my node_modules.

He doesn't tell whether there have been any build time improvements after the changes to the Dockerfile. Will the builder docker images get cached and thus reduce the build and deployment time?
I trust elected politicians, controlled by checks and balances, more than unelected greedy billionaires only supervised by themselves.

How about you?
In the last couple of years I've thought a lot that I'm really happy that I changed schools after ninth grade and also repeated class in high school. I'm not too outgoing person, but because of these things I have so broad connection basis with people who I know on name basis. And this helps, whenever I need to do business or just encounters, it is so much easier when you know the person ten years already by name.

I would say this repeating class was highly positive for me, and way more impactful than grades ever were in the long term.
It reminds me of Erlang's pattern matching idiom: if the input looks like this then do that, if it looks like this other thing, do that other thing, and so on.
Show me any three-letter acronym that doesn't have multiple meanings already attached to it.
I ‘know a guy‘ who decided to build a music platform for the network and podcasting would be an easy addition. ;)

Although a dedicated and native recording and podcast publish app would be better and that idea has rolled through my head a few times. Have a good idea on the branding and interface already. Excellent suggestion and reaffirming for sure.
rtm’s worm is mentioned in ‘The Cuckoo’s Egg’ by Cliff Stoll as well. While Cliff was working with rtm’s dad, cryptographer Robert H. Morris, to solve his hacker case, rtm released the worm.

His dad was Chief Scientist of the NSA National Computer Security Center at the time :)
Are those percentages based on data you got somewhere, or are they a part of the 84% of statistics that are made up on the spot?
https://nodex.wensia.com/ (it's not OSS, but $99)
Fair enough, I was referring to "using" Kubernetes as opposed to managing your own infrastructure. I can imagine how running it on self-hosted servers outside of a popular cloud provider can be hard.
Basically yes. ntdll is an implementation detail that shouldn’t be relied upon. kernel32/user32 and friends are considered the “proper” interface to the system and have been stable for decades.
Never seen a starker illustration of the idea that poverty anywhere eventually makes itself everyone's problem. Dude just wanted affordable internet access, and that was enough of an incentive for him to do something that accidentally caused billions of dollars in losses around the world.

Here's a fun thought: was that cheaper to the global community than whatever infrastructural improvements that would have allowed de Guzman stable-enough internet access to not seek out his infamous solution? What other situations like this are there waiting in the wings, and would fixing them cost more or less than the alternative of letting those situations play out as they may? Think how 9/11, terrorist attacks in general, are spurred on by groups aggrieved by socioeconomic or cultural conditions; what would it cost to placate them? Do we not because it would ultimately be more onerous?
Profiteering.
Yes, I was being imprecise wrt Windows, thanks :)
Prof. Johan Giesecke (Sweden): Why lockdowns are the wrong policy
> No authority I’m aware of ever suggested this was a “doomsday” virus

You might want to look up some quotes by Italy's experts, who called this virus a "monster" (side note: I hate how the media turns "novel coronavirus" into "magic virus that transcends biology"), or so the press reported. The doom and gloom communication has always been the key point from the scientific committees here.

> Mainstream epidemiologists, virologists etc. are not just a bunch of schmucks who are having a go at analysis because they’ve got time on their hands

Disclaimer: the below part only applies to what I see first hand in my country (Italy)

No, they're people, like everyone else. And unfortunately, they're bound to make mistakes like everyone else. Note, I'm not saying that they're wrong by default. But some did totally downplay the risk in February and now they act like they knew everything all along. Some of them even made questionable public statements on areas of research they know little about (investigation of thrombosis in lungs; convalescent plasma therapy).

The fact that scientific research is very compartmentalized leads to interesting statements that sound like Murray Gell-Mann amnesia. Most of them talk about vaccines; few if any talk about the drugs in development (but in the interest of fairness, I'd probably do the opposite if I had to speak, as I'm far more trained in pharmacology than in virology).

I reserve skepticism even if agree with their statements. They're bound to get many more things right than lay people in the subject matter, but that doesn't mean they're always right. In particular, one must be wary when some do statements on public policy that are not their subject matter.
This has nothing to do with repair because the product is not broken by any meaningful definition of the word "broken". It's just ill-designed from a certain POV.
Karl Jobst has a Youtube video covering the speedrunnning record history of Quake's first level, which serves as a good overview of Quake movement technique:

https://www.youtube.com/watch?v=43d8fICz6gM

It starts with an explanation of the significance of Quake to speedrunning as a whole, so skip to 5:46 if you only want to see the movement tech.
https://qz.com/1713033/at-harvard-43-percent-of-white-studen...
Yeah, you're right. I got confused by the original phrasing.
Is it intentional that the benchmarks include not only running the program itself but also compiling it? e.g. in the linked source code, the bench.sh includes the compilation step which is known to be slow in rust:

#!/usr/bin/env bash

set -e
run() {
cargo build --release 2> /dev/null
./target/release/rust
}

run;

Sure, if you run it many times in succession the compiler won't do much but the benchmarking script (run.js) doesn't really indicate that and the blog post also doesn't mention that.

EDIT: I was just being stupid, don't mind me. The times were taken within each language and not externally.
I still have Zortech C 1.06 on my old P166. I should boot it up to see if it still lives !
> There are specialized tools you can use to analyze this data blob.

These are called file carving tools and two better known ones are foremost and it's successor scalpel [1].

[1] https://github.com/sleuthkit/scalpel
As someone who was arguing for speedy reporting a few weeks ago: the longer the pandemic goes on, the more important rigor becomes.

Waiting a short time to get things right today is a a very different matter than a 4-8 weeks ago, where on-the-ground information was completely absent. Speed still really matters, but the longer this goes the more taking our time and doing things right will pay off.