skysight-inc/HackerNews huggingface dataset:
I wrote a quick Python snippet to compute the probabilities for all sequences of length 3 over 20 flips:

[(x, sum(1 for i in range(2**20) if x in '{:020b}'.format(i)) / 2.0**20) for x in map('{:03b}'.format, range(8))]

The output shows a 79% chance for "000" and a 91% chance for "010". "000" and "111" are actually the least likely substrings, with "010" and "101" in second place.

Furthermore, "001" has a 97% chance of occurring. It's pretty easy to see why "001" is so much more likely than the others. Unless your string perfectly alternates 0s and 1s, you're going to get repeating pairs. What happens after you get a "00"? If there's ever a 1 again, there were at least two 0s before it.

So you're almost guaranteed a "001" after "00", unless it's near the very end of the string. You only have a 50% chance of getting "000" from these though. A 1 completely resets the search for "000", but a 0 keeps the search alive for "001".
Artificial Intelligence – The Revolution Hasn’t Happened Yet
Vertically organized tabs use more pixels, but in addition to demanding less valuable real estate (when in fullscreen at least), also let you have more tabs open at once without scrolling the tab bar.
Most brains have relatively equal number of neurons.

So ... most things were created by creatures with equal computing power as you.
Your filters seem to be getting stripped when you use the pagination making it impossible for a user to see all possible positions tagged in a specific category. (ie - clicking design lists 51 jobs but as soon as you go to page 2 it's now put you at page 2 of all possible (1100+) jobs. Resetting the filter still only shows you the first page of the job listings).

Additionally, if you change the filter the jobs section seems to be automatically updating but your pagination isn't. (ie - click media, it lists 171 jobs, navigate to page two (which resets your filters) and then click the backend filter tag. Your pagination now says you're on page 2 of all possible backend jobs.
The best app food icons in the world. Don’t look at it if you’re hungry
TSA makes me drive exponentially more than I would otherwise.

Dealing with the airport is terrible now. I flew probably 80+ times a year as a consultant in the 90s. My wife would drop me off 30 minutes before my flight (DFW), I'd curb check my bag and walk onto the plane and wait 5-10 so minutes until takeoff. It's hard to deal with the 2+ hours of bullshit security theater now.

I forget to take my knives out frequently, have never had them confiscated, but my toothpaste, yeah, that's a threat. Hell, the Lithium Ion batteries are probably the biggest threat, no issues there either.
I find code review-style discussion of a simple coding challenge to be great for assessing both culture fit and skill.

What we administer is like a web app equivalent to FizzBuzz in terms of difficulty level. But unlike a whiteboard FizzBuzz, it doesn't put the developer on the spot. As an extra bonus, unlike FizzBuzz, you'll get different results from the kid who just successfully finished a CS degree and the grizzled veteran who's built and maintained complex systems for decades.

The right challenge can be completed in an hour or so by a mid-level developer in a brute-force manner. It will weed out those who simply can't code (or don't grok how the web works or how apps are constructed); and also highlight candidates who are capable of more sophisticated work. If being up to speed on a specific technology from Day 1 isn't important, you can give the developer their choice of framework or language or whatever.

Then when you do a code review in person you can get a feel for both how the developer approaches code (a skill) -- but more importantly, how they take critique. Do they get defensive? Do they riff off your ideas? Do they suggest improvements/refactorings they would have made if they had more time?

You can also explore other cultural factors - for instance, how did they approach constraint trade-offs in terms of time vs. completeness vs. sophistication? How clearly are they able to communicate about technical concepts?
Would it make sense to rewrite everything in Python to gain some speed?
Google Apps Script.

If you’re all in on Gmail, Docs, Sheets, etc., there’s so much you can do with GAS. I’ve used it for creating automated emails with charts pulled from Sheets, scraping websites, analyzing my emails, rall sorts of stuff.
I don't know why you're being downvoted. This is exactly how employers abuse the H1B system.

Give an employer absolute power over an immigrant worker with no connections, support network, or other job options and their residency status on the line--what could possibly go wrong?
Damage to Great Barrier Reef from Global Warming Is Irreversible, Scientists Say
> the task was to set up flask with two routes

Setting up a web server is also a different skill than backend programming -- many experienced back-end programmers have never needed to spin up a new server for their job.
Blockchain Jobs Fluctuate with the Price of Bitcoin
Aye. I'm not going to say she did the impossible, threaded the eye of the needle or anything like that. But there was plenty of opportunity or circumstance for things to horribly wrong. But she's got a ton of experience and in the moment of truth she didn't choke and everyone who could be saved was saved. That ought to be enough for anyone.
They have "bounded staleness" as an option for consistency, but obviously it doesn't break the laws of physics, latency is latency and you still have to account for that somewhat but at least you have the bounds to work with.
Let’s stop pretending Facebook cares
IMHO this is more correct than you give it credit for. Humans need to feel a sense of accomplishment to maintain their mental health over the long term. Just giving them money to survive without giving them something to do leads to high rates of depression and self destructive behavior. A good percentage of the population is not self starters, they'll sit on their ass all day long if nobody forces them to get up.

IMHO New Deal type projects are a better use of resources than UBI. Put people to work building/repairing infrastructure instead of just handing them cash and hoping they don't just spend it on drugs.
“faggot 31 minutes ago | parent | on: The latest trend for tech interviews: Days of unpa...

If you're going to expect people to do real work, you need to pay them.”

It’s not real work, just a small proof that you’re able to do real work.
I doubt the pilots’ priorities during the incident is giving a casualty report. I don’t think it helps ATC land the plane any better, either. The number of people on the craft help determine the state the plane is in (weight, crewmanship/passenger ratio, etc.)
Let met get this right you ae cool with "corporations" doing this with zero oversight but not with law enforcement and TLA's who have at least some legal oversight.

Are you are also cool with companies in the past hiring pinkertons to kill people also - because that's where your argument is leading.
I hope the airbnb is better than your apartment.
What about paying someone to do client work as a test? That is what I've found to be the best approach for me. It gives the candidate a very concrete understanding of the kind of work they'll be doing as opposed to a more contrived example. It comes at the cost of paying for poor work but usually some portion of it is salvageable.
FOIAs are not made to companies, they are made to government entities. But yes, of course you can make FOIA requests to government entities we work with (the law guarantees you this privilege), and about the work we do with them -- reporters do this all the time.

In some of the more liberal countries the things we do with the government are even part of public record and you can find contracts and services we provide them etc documented online without having to do any kind of request.
What’s the value of a currency that can only be used to buy limited items?
He never said anything about SQL being hard. In fact, I think MongoQuery is much more obtuse than SQL.

That being said, when you don't know what your schema is going to look like, why not use a Nosql solution - either a pure nosql solution or the JSON support built into modern databases? If you write your code correctly and have one module retrieve for one domaim, you should be able to isolate changes.

But, if I do have to use Sql, I agree, put all of your changes in sql files numbered and have a "database version" and find/create tooling that can automate running the Sql scripts and run it as part of your CI/CD.
Contract before hire is a practice that is slowly growing, and not fast enough.

I find test paid projects are the best interview technique for detail oriented work, whether it's software or otherwise.

It's far better to select a task that is simple enough for the potential candidate to be a pinball through the code base or problem domain, ideally to solve a small problem that will be directly transferrable into the project they will work on.

I also make myself available to answer any basic questions or assumptions to save them time, because that would be the case on a normal team.

This results in a far lower expenditure of time trying out different resources to find relationships that work.

Unfortunately a lot of technical hiring is still done by non-technical people, or tech folks need to level up their hiring skills.
There are quite good improvements. I hope open source embraces .Net finally.
I consider that too, but that's really just because the risk is acceptable to me compared to the hassle of airports, TSA and car rental.
I've definitely seen some prompts that looked suspiciously production-ready.

It's usually not "build out our new feature", because spinup time is a thing, but some companies do seem to throw around "build our new one-off microservice". Stuff like "given this incoming data, set up intake, a storage layer, and a backend layer that applies formula X". If the data and the formula look business-relevant, it's at least enough to raise an eyebrow.

That said, I'm not sure how much I care, provided the interview is sincere and not some kind of bizarre scam to farm out work. My main concern is much more with scale. I totally see the merit of replacing 5 hours of whiteboard interviews with 5 hours of "build a toy project at home". I don't so much appreciate "take a week of your life and build a substantial project so we don't have to do any legwork".
Definitely this. I get a nice 4 column layout that works great considering my code is generally 80 chars wide. I wish my monitor where actually 2:35:1 CinemaScope.
Check this out https://www.quora.com/What-are-the-best-startup-stories
Jon Bon Jovi Inducted into the Rock and Roll Hall of Fame 2018
Is My DNS Fast?
Oracle 18...
How do you try to hire people who currently have jobs with strict anti moonlighting policies? (Or maybe the answer is just don't bother, and you can afford shrinking the applicant pool without any big adverse effects)
How many engineers would accept an offer which is conditional on "a week or two of contract work"?

Most of the engineers that I've hired came from another job (not all though), and so they need a confirmed offer before they are willing to jump ship.

So this practice introduces its own selection bias; you'd only be sampling from the pool of currently un-/fun-employed, and those who hate their current job enough to quit without a safe landing.

I'd vastly prefer to have a week or two of paid contract work from each candidate before making the decision, but it feels insulting to even ask.
The advantages of Postgres (and MariaDB) over MySQL are pretty well traveled on HN. OP wants to move from Redshift Postgres & SQL Server to MySQL - which isn't something you see very often.
This can be done with Firefox Multi-Account Containers[1] and Temporary Containers[2].

[1]: https://addons.mozilla.org/en-US/firefox/addon/multi-account...

[2]: https://addons.mozilla.org/en-US/firefox/addon/temporary-con...
I would say just the opposite. Model your domain first. Why tie your database to your user interface? Your user interface may change. You may write a separate API to be consumed by another team, etc.
One in 10k? Nonsense.

> Your odds of dying in a car crash, over the span of your entire life, are somewhere in between 1 and 50 and 1 and 100.
— http://www.asktheodds.com/death/car-crash-odds/

> Chance of dying in transportation accidents (mostly motor vehicles): 12 per 10k per year
— https://www.livescience.com/

> Lifetime odds of death by motor vehicle crash, United States, 2016: 1 in 102
— http://injuryfacts.nsc.org/all-injuries/preventable-death-ov...

If you don’t know anyone killed in a car accident, you are very lucky.
Like AWS redshift the nosql database or what? What is redshift postgres?
This is likely the FB job listing: https://www.facebook.com/careers/jobs/a0I1H00000LgnqFUAR/ Looks like all of the difficulty of building a hardware startup, while maintaining all of the downside of being part of a large company.

[IIRC, Cisco used the "spin-in" model to great advantage in order to address some of the downside. However, that was 10-20 years ago, and I don't know any recent examples.]
I kind of can relate, as my last project was finished just after the "Run SQL on CSV and TSV" submission popped up, and my project was the same thing but for XML. So have a star (:

Also, I like the way your dashboard looks like (judging by the screenshot on your website).
PA Starbucks "loiterers" arrested in minutes of arrival
I thought of undue grace or generosity because typically the term is used to criticize the unmeritorious for undue position -- is it not?

What does it mean if I say you are privileged? When one looks further at the definitions listed for privilege, one sees examples discussing kings and royalty for birthrights. If we're discussing whether people are unworthy, then we are on the same page.
Former MySQL Product Manager here (no longer affiliated). To cover your specifics:

MySQL was first in offering JSON with 5.7. It is still well ahead, for example, there is no JSON_TABLE, aggregate functions, native type or partial update in MariaDB. Some examples of the value here:
https://mysqlserverteam.com/mysql-8-0-from-sql-tables-to-jso...

Both have always had GIS support, but have taken it in a different direction. With MySQL, the GIS is now based on Boost.Geometry and has Geography support.

w.r.t. metadata in transactions - I am not sure which feature you refer to here. The native innodb-based dictionary is a MySQL only feature.

For Window functions and CTEs, they were added at a similar time, but MySQL is on a ~3yr release cycle. MariaDB is on a ~1yr.
Show HN: Telescope – News and RSS Reader
Yes - those El Salvadoreans - since they are born with only 3 fingers on each hand, they have a very difficult time using tools that were designed for people with 5 fingers on each hand.
Its many orders of magnitude more likely for your kids to die in a car than be kidnapped by a stranger. Look at our paranoia in the US about 'stranger-danger'.. Humans on average don't comprehend the odds.. its about what scares them on the news.
One of the applications for graphene membranes that I am watching for are large scale desalination plants. It has been shown to work for small membranes and if you had enough surface area you could build a desalinator that was using not much more energy than the energy to pump the water around.
Why not use AWS though? It is so much better, reliable and overall super cheap.
> What's stopping them from going this route

The same issues, that preventing them from fullfilling their promise to open Moon base in 2015.

They're behind in technology, in science, in work culture and they're plagued with corruption.
Hide the toolbar. Trivial on OSX.
Well part of it is preventing the kid from eating something toxic and I imagine that is wired into us genetically. The other is that ER bills are expensive... :) And the problem is kids have a hard time telling you what is wrong if they are hurt non obviously. Still kids should get to explore, I agree.
Do you (or does anyone) know if Textmate has a feature to automatically wrap text from one column to another? I've looked for one and not found it. I know emacs will, albeit with typical difficulty, but I just can't go that far.
The same thing happened with Java. After Java 1.4 they just dropped the 1 and released Java 5.
Companies don't do this because it will wildly cut down their candidate pool.

There is _literally no chance_ that I am going to leave an existing job for a "week or two" contract with a company. If that's part of their hiring process, I will simply look elsewhere.
Great value mate!
Training cells to target cancer might be the next step to finding a cure
How to Develop Online Marketplace MVP
Free Docker Training for Beginners Intermediate and Advanced Users
What We Get Wrong About Closing the Racial Wealth Gap [pdf]
At work, my widescreen monitor is perfect for showing two columns of code on the screen.

That may be a reflection on the cleanliness of our codebase though...
I agree with you, I think your point is in a similar vein to my comment about the extraterritorial nature of the law. It's great whilst we have people in charge who we might agree with, but where are the protections if you do not agree or if the circumstances change. I can envisage the legislation, being interpreted in the strictest fashion, being used against organisations for political or other motives. Do we have adequate protections against this in the legislation?
Residency is what matters, rather than citizenship. I expect the practise when having multiple data policies will be to ask users which country they live in when they create an account. I doubt you would be able to expect the protections of the GDPR if you falsely claimed you were resident in the US.

If this is the case, I wonder if this will lead to many people around the world falsely claiming to be EU residents to get GDPR protections, or claiming to be US residents to use platforms refusing service to the EU on the basis of not complying with the GDPR.
For me, desktop 21:9 displays have been a good substitute -- divide the screen down the middle and it's comparable in feel to having side-by-side 4:3 displays.
Selective enforcement. Practice surveillance of the population. Select political opponent, as desired. Consult surveillance data. By random chance, sometimes you will find something. Parallel construct a case. Proceed to blackmail/extort/convict.
Maintain political power. Repeat.
Some of them seemed a little silly to me, but most that I looked at had a real product and revenue at least.
Can you explain how you use Terraform to automate google calendars?
>A privilege is something granted out of generosity or grace by another party, perhaps even undue (and hence the grace).

That's quite a narrow definition. A privilege is any kind of advantage enjoyed by virtue of belonging to a group as opposed to personal merit. It's not fundamentally imoral and may well be temporary. Certainly no one has to grant someone the privilege of beauty or intelligence.

In relation to other professions , programmers have the strong privilege of being highly in demand in the labour market. This is clearly a temporary situation, and they should absolutely make the most of their "game" towards the tech employers.

What I was underlining is that the tech job market is ballanced, and certainly more favorable towards labour than almost any other.
That makes it a lot harder to deploy and rollback. Your business logic is in two separate places - the stored procedures and the code. Then you see stuff like

UpdateCustomer_1

UpdateCustomer_2
I'll take a 3-day take-home project over a whiteboard interview or live coding session any day. Working at my pace with my tools in my space? Yes please.

The article makes two good points re: bias and lack of research. To the first I think it's up to us as interviewees to mention this in all of our calls. "Do you have a non-take-home option? For some groups this could be an exceptional burden."

To the second there's no real answer other than a lot of companies need to try it out to see how they fare and then when they have a basic idea of logistics that work run a study on efficacy / predictive power.
Imagine if in cars people ran a checklist and reminded themselves of training when things went sideways. Instead, we road-rage, swear, honk, scream, yell and let our days get ruined and sometimes our lives get ruined out of nothing but sheer ignorance and stupidity. Sure, sometimes accidents just happen and people die, but more often then not when we get into cars people are assholes. When we get into planes, people are generally professionals. (as far as crew / pilot / captain is concerned)
If you see the users of your library as SPAM you might as well kill yourself.
Securing Wireless Neurostimulators [pdf]
This is 100% the reason why I prefer driving. It is a matter of control, even if the numbers prove that won't reduce the risk to my life. I'm almost as nervous as a passenger in a car as I am on a plane.
> MySQL 8.0 delivers SQL window functions.

Great to see these in a MySQL release. Something so worth having I once had a script which would automate MySQL -> Postgres for data analytics purposes.
> We've designed this project to take about 2 hours to complete.

Then you've got it right.

It's good to see people admit whiteboard interviews are a crummy system, I think you can learn way more from X hours of "do a task on a real computer with the internet" than you can from the same X hours of "do algorithms work on a whiteboard".

The objection, for me at least, is to "do 10*X hours of work on a real computer". It's bizarrely common to massively scale up the time investment when moving to this sort of task. And the answer is so easy - just don't do that!
"Mad Max", where the heck do you live in the US?
I personally would never, ever accept a week or two of contract work.

Companies dont do a week or two of contract work because people that have strong experience will just say no.
What is particularly toxic about this comment though?

I would actually agree that there won't be many poor/minority people participating, but that has more to do with the challenge itself, not the fee. Poor people buy a lot of lottery tickets, particularly when the chance of winning is high. The issue here is that the chances of winning are not high, so the only reason someone would try and go after the prize would be to prove a point, and spending a lot of time and effort to prove a point like this one is a luxury many people don't have.
Velodyne invented modern lidar–it’s about to face real competition
LightScribe kind of does this though it's not iridescent. You can also find some free code to achieve a similar effect on the data side of a disk.

https://en.m.wikipedia.org/wiki/LightScribe
http://weworkremotely.com/ exists as well.
We ended up building our own framework to solve for that with a simple tank confit if we need to change the breakpoints. Bootstrap was just too big yet too limiting for all of our client work. We don’t force the mobile menu either.

https://github.com/firstandthird/clientkit
To be fair, such an employer usually can't get a H1B these days. Which is probably for the best because those people were probably not completely truthful when they described their tech experience.

There is also an filtering effect on job sites where good jobs get snapped up right away and disappear from the site, while delusional prospects concentrate over time, causing people to think that those sites have nothing but garbage offers.
+this. I'm reading this thread 10 days after it was posted, on my purchased-in-December-2017 Macbook Pro, because I'm almost to the point of throwing it in the trash, and trying to figure out a better alternative. The keys keep getting stuck, the touchbar is too-touchy and gets phantom touches, and the increasing emphasis on locking down the OS has just utterly prevented me from getting the latest VirtualBox installed (until I get home, at least). I was on a 2013 MBP before and I miss it -- I deeply regret this purchase after four months of using it.