skysight-inc/HackerNews huggingface dataset:
The amount of inflationary BS on "senior engineer" resumes I've read when hiring is astounding.
5 years of this, 4 years of that, 5 frameworks, 3 languages, the whole AWS alphabet soup in the toolbox.

But then, 95% of them can't fizzbuzz.
I would pick Postgres. Tables are the best format for data storage, SQL is the best language for exploring them, and Postgres is the best SQL database. With its support of myriad contraints, aggregate functions, and data types, including JSON, you should be able to build whatever view into the data that the different people want, with either database views or functions. You might have to copy data into different databases (or just different schemas) for different teams, but maybe not.

Datasets of a certain size might make Postgres fall over, but I don't think you're anywhere near that. That doesn't mean I would always stuff all my data into Postgres raw. I don't put Word documents or images in Postgres. I leave my Apache log files as Apache log files. If I want to analyze them, I usually use Bash (sed, cut, sort, etc.). But if I want to get really fancy I will import them into Postgres to run SQL queries on them, but usually just a certain segment of them (3 months, a year, etc.), only certain rows (grep first) and only certain columns (awk first).

If your data infrastructure is staid and boring, I think it's a good sign that you're doing it right.
1. What do you think about charcoal tooth pastes? I've been using this[1] and it got rid of my persistent "plaque wall" on lower incisors within ~month. I don't feel this particular one is really abrasive, but I was wondering will there be some damage to enamel with persistent use? Should I maybe alternate it with normal fluoride paste?

2. I've heard that brushing teeth before sleeping, regardless of food consumption, is great because of reduced saliva during rest means reduced anti-bacterial effects of it. Any truth in that?

3. Last dentist appointment I got mentioned that my tooth will literally explode if I don't remove it. I've read there been odd cases of that happening in history, but is there realistic chance of that happening? How would that even come to pass?

[1] https://www.splatoralcare.uk/products/biomed-charcoal-toothp...

P.S. Thanks for doing AMA. I've had nothing but horrible experience talking with dentists, or even bad experiences in general.
Is the root of those housing crises those billionaires? How much of housing crises is attributable to corrupt zoning laws which prevent development? How much money spent by the NYC government is wasted, mismanaged, and poorly spent when that money should otherwise go to said housing crisis in NYC?

I don't know the answers to those questions but its much easier to point at the rich buying ultra condos in NYC than it is to get to root issues in NYC. NYC is a high tax city in a high tax state with high wage earners. And the rich in NYC are still 100% the villian?
HPKP as people know it is being withdrawn from browsers so there is no need to discuss it further.

Source: https://chromestatus.com/feature/5903385005916160
Its if you let HR be the sole gatekeeper where the problem stems however
Can you point to the research on the “mostly plant-based” part?
I keep refreshing looking for the answer. Seems that it would be the top question for somebody who was 30. He was 68 but he had way more energy than many 20 year olds that I see.

I'm deeply sad. Despite being absolutely brilliant he was also extremely positive and full of humility. It's a rare combination.
Making a throwaway to share my anecdote.

What I find interesting is that if you point all of this out to HR/management, sometimes they don't believe you!

I just left a company for which I was the random unicorn (perfect intersection of 3 different skillsets and relevant past experience) after one year. I was referred because someone at the company knew I had the exact skillset they needed, and ended up joining right as they were planning to expand to several other states.

Two months in, I brought up the rarity of finding someone with such an intersection of skills. Looking for an exact match would not be realistic. Especially when trying to expand to states with a much more competitive job market that requires a higher salary than what they offered me. Of course, my concerns were shot down with such confidence that I thought, "maybe they already have the perfect set of candidates lined up."

One year later, expansion plans have completely 180ed because they simply cannot find the personnel that they need. They cannot even entice those who are capable of learning and performing in the role because they aren't willing to pay market rates. And now I left because they weren't willing to give me a reasonable raise or additional benefits like more equity.

This experience has made me wonder if cognitive dissonance plays a larger role in blinding HR/companies.
I knew someone who used to work for a company where they had a policy to only hire developers on work visas. The management treated them as indentured servants rather than employees, using the threat of losing their visas and making them pay ‘legal fees’ as tools for coercion.

The guy I knew only got out because my then employer promised to endorse his visa and deal with any legal stuff.
I'm typically cynical about claims like this but the situations he describes are absurd and support his claim.

Super Narrow Selection Criteria in particular however is not absurd; it means they have a specific candidate in mind. I don't mean to defend the practice (it either means the company has a screwed up hiring process or more likely they are trying to hire a specific domain expert from overseas and want to minimize the number of interviews of less qualified people) however I do believe this one case doesn't support the thesis.
Do you have an alternative that addresses all those points and is cheaper than the current American system?
I've been looking for jobs recently. Have a background building pretty robust Node/React apps. At the 4 places that have given me an interview. I've been told that I don't meet their needs. The reason for this. I'm unable to solve their pet coder wars function challenge. Being a self taught programmer, not having a 'learned' background has proven to be a hindrance. Because I don't have the traditional algorithmic chops. In the time I've been working as a programmer I've had the need to use recursion one maybe two times. 3 of the 4 interviews have required me to over use recursion because iteration is to 'easy'.

Apparently my ability to answer some random function that in no way shows my ability to do day to day engineering work disqualifies me from employment. Yet these same companies are posting month in and month out looking for engineers and complaining that they are unable to find viable employees.
I like how you've identified the moral qualms with your current profession.

How do you continue to justify to yourself working in that domain? Do you struggle with the question each day or perhaps have a philosophical framework to rely on? (maybe just /r/NatureIsMetal is enough?)
I've been that person so I can attest.

The "opening" was essentially a copy of my resume. The more specific requirements (details from my resume) the better.

Either way, if listings are that specific, I ignore them for both reasons.
I've got to ask... at that point why are you making queries on Maps?
I'm actually more interested in if there was ever some sort of extraterrestrial outpost on this planet in the past 1 billion years or so.

At that time scale, exploring the entire galaxy seems reasonably practical. And stopping here to refuel and recuperate, not so unlikely, at least to me.
> Literally the only attack scenario that DNSSEC protects from is when someone is MITMing your ISP, which, I believe, is something that practically never happens.

It also helps when your ISP is MITMing your attempts to get accurate DNS information. That happens all the time, though most of it is just sending you to advertisements when you're supposed to get NXDOMAIN.
(2015), edited (2018).

I've had week-long HSTS on my personal website for a few years (which is short enough that most clients ignore it) out of an abundance of caution/FUD, and it hasn't really been a problem - I have had periods where my cert expired (for complicated reasons, I renew Let's Encrypt certs manually every three months, and sometimes I don't get around to it in time), but I didn't remove the regular HTTP 301 to HTTPS during that time. So I don't think permanent / preloaded HSTS would have been a problem.

On other sites I've set up since then, I've built them on top of hosting that assumes reliable HTTPS and renews it for me, e.g., Twisted with txacme or AWS Cloudfront with Amazon's CA. So I've been able to assume working HTTPS from day one.

In October 2017, Google announced plans to deprecate self-service HPKP for exactly the reasons outlined in this article, which took effect in late 2018. See https://developers.google.com/web/updates/2018/04/chrome-67-... and the links provided . If you're a major site and you really, really know what you're doing and you're confident the risks outlined in this article , you can still get a hard-coded HPKP entry in the browser source code.
I find the term 'questioned' almost hilarious
I think the form being used is "infinitive" rather than "imperative". The forms are identical in English, so it's hard to be sure, but in other European languages it would be the infinitive, I think, so I would guess that it's the infinitive in English, too. Also, it just doesn't seem like a command to me.

The document is translated into two other European languages, but the examples are still in English, which is a shame. A translator who is keen to go the extra mile would provide the examples in English and the target language, in my opinion.
"Our solution for homelessness should also make a profit?"

Profits are merely an incentive to getting more individuals involved and VC capital backing is unlikely unless there is an eventual ROI I'd imagine. How that ROI is determined is beyond the point, it could be government subsidies, cryptocurrency/blockchain related, etc.
Online version of the original paper:

"The Silurian hypothesis: would it be possible to detect an industrial civilization in the geological record?"

https://www.cambridge.org/core/journals/international-journa...
How does not reporting them to the labor board make you a better person? There’s more to this story than you’re telling us or it’s made up. This story doesn’t add up.
Does it support interop with plain C, eg C99?

No C++ malarkey for me!!
Whenever the topic of MITM middleboxes comes up, there is usually a vehement opposition to them from much of the security community... while they bring up some valid points, I can't help but wonder if there is some deeper agenda behind that opposition, since these also seem to be the same people who are pushing the user-hostile walled gardens.

(Personally have been using a MITM proxy on my network for over a decade. Besides the filtering, it also has a useful side-effect of upgrading all connections to TLS 1.2, and when 1.3 becomes more common or mandated, I only need to upgrade the OpenSSL the proxy uses to start using it for all TLS coming from the network. Even older devices that don't support it will still use it when communicating outside the network.)
Maybe Mueller figured out who killed JR?
Why should you get a say in who works with you? As a team lead I'm trying to find the right balance. If we hire only people the current devs like we endup having too many similiar developers with the same mindset and shortcomings.
Trying to have a more diverse, balanced team means you don't get a say.
You've been pushing this reply around to various comments without actually mentioning any of these other ways. What are you proposing?
> Can't say I've found the same with dicts tho

I would think a NamedTuple would do the trick? (https://docs.python.org/3/library/collections.html#collectio...)
Why write "must have" when it's not a "must have"? Why not admit that you'd consider people not ticking all the boxes?
Well yeah, companies will always want better employees that cost them less and employees will always want better jobs that pay them more. These desires are somewhat at odds with each other.

"Talent shortage" is the language employers use to imply that rather than this just being an eternal truth and their current situation being the current market equilibrium, there is some kind of societal problem that society should help them solve (at society's expense of course).
GB Studio: Visual Programming-Based Game Boy and Web Game Maker
Instead of passively waiting why not encourage him to comment with a note such as "Finally! DNSSEC will solve most internet problems! No need for CAs!"
I'm not in position of hiring people but, a priori, the maxim - trial most, hire the best - seems correct. I consider CV and interviews to be a waste of time. Any thoughts about this?
A modern GUI library without screenshots on the homepage...
Game Reward Spending Program by Blockchain
It depends? If the satellites used chemical rockets to produce stationkeeping thrust then they’d be long gone, but if they used some exotic power source who knows? If they had a good AI and power, there is no real limit on how long they could stay in orbit. If they were using technology like ours they’d be gone, but a hypothetical civilization might use exotic materials and power sources that would stand the test of time.

For the moon thing, the above applies, but assuming that they were obliterated we’d have to get pretty lucky to detect their remains. They could also be totally intact because there would be essentially no weathering, they would never be buried by shifting regolith, and so on.
There is one screenshot on the front page, and I must admit, it does not look modern.
> are effectively searching for a perfect match, rather than someone who could do the job well.

Maybe they actually aren't doing either. Perhaps they are simply building a log of candidates for a position that does not exist currently but may exist or another future hypothetical position related or unrelated. In other words doing the legwork way in advance and figuring if they dangle a large enough offer (at that time) someone will leave what they are doing and join the company.
How Google Is Making It Harder for Rogue Apps to Get into Android Play Store
Sure, there's perfectly good reasons not to share the name. "being a better person" isn't one of them, IMHO.
One of the smarter folks I know makes this point repeatedly and firmly. Delivering reliable value to customers and a good environment and career path to employees is a worthwhile and valuable achievement. Even if in the process you aren’t “curing cancer”.
>Why is it immoral to lock away people against their will, people who have not committed a crime?

That's unfair. It isn't right to talk about doing things against the will of an individual who isn't a free actor due to their condition. This is very well established notion legally, culturally and morally.
For example, if a schizophrenic person commits murder, their condition is a mitigating factor in their sentencing and will prevent them from simply being locked up with the general population.

Similarly, you're already treating them as individuals incapable living up to the responsibilities of living in society. All municipalities have zoning laws to control where citizens can live and laws against squatting in tent-cities or on a sidewalk and living in squalor and filth, without proper sanitation, and protection from elements - yet somehow you still argue that those laws should not apply those individuals. So you're trying to have your cake and eat it to. On one hand, you're saying forced institutionalization where care could be provided, is wrong because those individuals CHOOSE not to be institutionalized, and on the other hand, you're arguing they shouldn't be held to the same responsibilities as other citizens because they can't help their situation.

This position is arbitrary and incoherent.

Finally. I disagree with your contention that institutionalizing people for the purpose of providing care (not locking them up - as you called it) who aren't capable of making their own decisions is immoral - and you haven't attempted to show why it is, you just assert it as a fact - which it isn't.

>What's wrong with people in the US that this even has to be discussed

I'm not American.
I think we do have a talent shortage, seriously, I see it all the time in the companies I work for. And if you run in an interview like the author describes, it is very likely that the interviewer just lacks talent and happens to be in that position, otherwise he or she would recognise the opportunity and go for a good deal.

But there are also good reasons why companies are often extremely careful hiring new staff. Many companies are desperately seeking the right dev's because they know that the wrong pick can cost them tons of money. The mess a wrong dev can create can do so much damage to the product while it often has to be released within a certain timeframe. I've seen a startup failing because of that.
Speed is the number one most important thing for broadband service, and it’s also the thing that requires lots of capital investment to provide. So massive investment and dramatically increasing speeds is a critical sign of a functioning broadband market in the US. (What you see in public infrastructure in the US is the opposite. Lack of investment leading to decay, and not only an inability to keep up with growing demand, but an inability to even maintain previous levels of service.)

The WMATA example is not “one instance.” I use it as an example just because it’s local to me. (You want to hear about my water service? It cost $30,000 for the city to hook us up to public water/sewer in 2015. We just had the chlorine levels tested and they’re squarely in the middle of the range for pool water.). And frankly Maryland is a wealthy blue state, with better public services than say Pennsylvania, Virginia, Delaware, or Georgia, other places I’ve lived.

Transit is also an example of infrastructure that, like broadband, requires expensive maintenance and continual upgrades to handle increased demand. The NYC MTA is also in dire straits. When there’s only a handful of cities in the US with “real” subway systems to begin with, the #1 and #3 systems being in a state of emergency is a pretty significant data point.

But the problem isn’t unique to subway systems. US infrastructure, which is almost entirely managed by state and local governments, is a disaster across the board: https://www.infrastructurereportcard.org (American Society of Civil Engineers Report Card giving US infrastructure a D+). Whether you’re talking about lead water pipes poisoning kids in Chicago, civil war era sewer systems dumping raw sewage into the Potomac, Baltimore’s subway that celebrates 75% on time performance, California HSR that ran out of money after construction barely started, etc., American state and local governments prove time and again that they cannot be trusted with infrastructure.
"I find it strange, as software developers, that we discuss the effects on automation all the time, but no one seems to understand that automation has made searching for new employees incredibly inexpensive and efficient compared to the past."

Yes, just like Tinder and other assorted dating apps and sites have made it incredibly easy and efficient to search for a mate, but relatively few people end up in a relationship because of it. The act of swiping endlessly appeals to people, apparently. I vaguely remember hearing that once you are given 2 or more options, it induces strong paralysis, whereas if you have one option you tend to just jump at it and move forward with your life. I imagine the dynamics of dating and hiring are quite parallel.
Wouldn't it make more sense to acquire fuel from bodies with weaker gravity, so that you don't have to burn as much of it to get the rest back into space?
Related to this question:
Does Darwin block remote images from loading automatically? I find this is increasingly hard to find (Geary Mail comes to mind) and it's surprising to me.
Also it assumes our hypothetical prehistoric civilization took the same technological path we did and developed plastic or if it did used oil derived hydrocarbon monomers like we do.
It becomes more absurd the further you get away from employment too
I think the modernity is in the code and the API rather than the output
Based on my experience this is very true. It's very annoying when you want to find a job, but you don't want to be a sucker, so you end up looking for a job for a long time. I don't get it. You want to hire someone talented or smart, obviously, you are gonna have to pay them good money. What's the problem with that? I'm sure they will bring much more value than a usual sucker.

Personal story ahead. I've been looking for a job for around two months already. I'm Ruby/JS dev, so there are a few offers I can choose from. The problem is, half of that offers pay very little. Based on my experience, related to working with other people and to my previous salaries, I'd be a sucker to apply to those cheap offers. What I'm even more afraid is the people I'd work with. I'm pretty young and ambitious and I learn fast and I want to learn a lot, but if you don't have a good mentor you are not gonna learn that much.

Unfortunately, the offers, that interest me, require much more experience than I have. I doubt that I'd have a real problem with adapting and doing the job unwell. But I don't even get invited to any interview from that offers, because my CV has one year or two years of experience less than they expect :( How can I show that I could be a good fit then?

I know it's not that much related to the topic, but I've been a bit frustrated.
What you're saying makes sense.

On the other hand, what are your thoughts about the relation between the type of foods we eat and dental health?

My understanding is that sugar, and (complex?) carbs in general have a massive toll on teeth. Admittedly I'm no expert, but it would seem that eating the food we evolved to eat (vegetables and meat mainly) should not damage our teeth in a significant and therefore would be no need for dental health practices.

Whether or not that is feasible on a population level is another question, but I'm fairly convinced at this point that the garbage food is wrecking our health and that includes teeth.
The two biggest expenses year over year are colocation ($25K/year) and PayPal/ Stripe fees ($11K/year). I pulled the $97K figure from the year I bought Delicious, so it includes a lot of one-time hardware purchases.
What is a license plate lottery? Does the different license plate give one privileges? Or is it about getting a license plate at all?
People don't like HDHP, but they are the only type of insurance that puts downward pressure on prices. the only alternative is to regulate.
There is scope for putting "experience with x an advantage/bonus" instead of "must have x" if don't want to put off the vast majority of well-qualified applicants that are not likely to have x, but would like to be noticed by the people that do.

Especially if x isn't something very useful like experience with a framework you use, but something relatively trivial like knowledge of a CRUD app they periodically do a bit of data input into.
It's interesting that no laptop vendor seems to have made a physical webcam cover included by default- to me that seems like a no brainer that most customers would benefit from.

Edit: Thanks for all your comments. It seems that there a few vendors that do offer webcan covers by default now. Definitely will have to check those out.