skysight-inc/HackerNews huggingface dataset:
We use gh-ost at Harvest[1] and it's a dream in comparison to manually migrating on a replica and switching master/slave roles [2].

Also the linked post[3] in the readme hit us very close to home. We originally tried some of our migrations with pt-online-schema-change, which was great in theory but caused a lot of locking contention during the actual process.

I see many people hammering on the lack of foreign key support which is interesting to me. At some point, a database system grows to where relying on MySQL's Online DDL[4] "works" but not really with production load. I feel like a team knows when they need to bring in a tool like this.

The dev in me understands how wonderful FKs are for consistency. But the db-guy in me that has had to deal with locking issues recognizes FKs as a tradeoff, not dogma.

If you shy away from migrating your large or busy tables, or are scheduling frequent maintenance down times in order to migrate these tables, that's when gh-ost (and others) are appropriate to evaluate.

So for us it's not an immediate red flag that gh-ost doesn't support FKs. We just have to work around that limitation[5] because the alternatives are much worse.

For the record, we don't gh-ost all of our migrations. Only the ones that are deemed sufficiently large enough are gh-osted and those heuristics will change from team-to-team.

But as a guy who has had to deal with our database issues AND as a developer who doesn't want to be chained by a database design decision from a decade ago, I love the flexibility gh-ost gives us as we continue to grow.

[1] https://www.getharvest.com/

[2] https://dev.mysql.com/doc/refman/5.6/en/replication-features...

[3] https://dev.mysql.com/doc/refman/5.6/en/replication-features...

[4] https://dev.mysql.com/doc/refman/5.6/en/innodb-create-index-...

[5] https://github.com/github/gh-ost/issues/507#issuecomment-338...
Interestingly, American Psycho isn't on that list. Nor should it be.

It's easy to come up with a few theories as to what sets it apart, but I would love to see a proper analysis of how it tackles the subject matter without glorifying the lifestyle unnecessarily--and what other films should learn from it if they aim to accomplish the same
Or the granddaddy of them all - Scarface.
I have a HyperX Cloud II - http://a.co/1Uh0q9o - plugged into my USB hub. I like the USB audio thingamajig because it has a hardware kill switch for the mic, which I use all the time instead of on-screen mute controls. The mic and headphones are both optimized for all-day wear & talk by gamers, which works really well for my use case: working remotely.
>This is Amazon's problem to solve

Until some adulterated fake dog food kills your dog. Then it's your problem.
> it makes your product much more attractive to people who will improve and promote your product for free

This is a huge myth.

1) even if you open-source, the company retains control over the project, and push their priorities first.

2) codebase can be huge and intricate, very few external contributors would actually put the time to learn it, leading to poor contribution (ie. might fix a given problem, but breaks other subsystems)

3) even if there is external contributors, is the company willing to put the manpower to process the changes and handle community interaction ? Ie. do you really want to handle bikeshed'ing style patches, potentially costing time to actual paid devs ?

Most of the time, niche opensource contributions are merely are more of a marketing tool (or HR tool ala. "your profile looks great however we're too greedy to hire you, please contribute to our software for free").
Do you think there are a substantial number of property owners?

https://www.citylab.com/equity/2015/06/new-york-is-a-city-of...

https://www1.nyc.gov/site/planning/data-maps/nyc-population/...

> Approximately two-thirds of dwelling units in New York are renter-occupied, over twice the national average.

Ok, not insignificant, but the order of magnitude is roughly correct. I'll update the computed figure.
That's fair. My experience with it so far has literally just been aliasing hg to chg. It performed all the magic in the background for me.
> This is all part of the job though. People don't have all the answers and the questions are often poorly defined.

Yeah, agreed. I've started watching the balance between meetings and interruptions, and I've noticed that too many interruptions is often an indicator of too few meetings and/or poor planning, while too many meetings is often an indicator of not enough one-on-one communication in the office.

I'm fantasizing about something to schedule micro-meetings. Not a heavy hammer like days of quiet time, just something lightweight that only protects my flow-time a little bit, not a lot, by design. I want to and expect to have to talk to people, I'd just get a small amount of control over when, instead of an interruption right in the middle of my thought.
Does NYC impose heavy restrictions on the height of buildings? I've never been there, but they seem tall to me.
yes, the checklist is in my point of view wrong there!
His wrongdoing is using his access to find information on his Tinder date, not on hackers, which his job is supposedly for.
Birds ffs iPhone, brides using tools isn't that impressive i think.
Hacktivists and tech giants protest Georgia's hack-back bill
I think there are two groups, one that shapeshifts and moves goalposts for the purpose of selling coins at a profit (either offloading a huge stash or being on the right side of the bubble cycle), and another that treats it like a portfolio piece next to their gold coins.

The first is truly impossible to reason with. For the second, the event is simple: breaking the crypto or the crypto-economics in a way that prevents it from being scarce and “decentralized” (what’s it called when something is “actually, very centralized” but I can use it to move $50m across the rio grande?). How do you convince a goldbug that gold isn’t valuable because their lifetimes are not going to be thousands of years?
Only if you can't maintain emotional separation. Actors, Doctors, and Lawyers, all legitimate respectable honest jobs, require workers to maintain emotional separation from their work.
Haven't watched "Mad Men", but I think part of the appeal of Walter White was that his character, being the show's main character, was also the most well-written and nuanced which almost necessarily leads to him being the most sympathetic. The reality that he was unhappy is more than outweighed by the fact that he was living out carpé diem rather than surrendering to terminal illness.
That's a very nice way to look at it but you're talking about a good engineer that's been with the company for a while to prefer mentoring others over just working on whatever they want.
Remix is hiring software engineers and managers to build better public transit
to answer your question, the overhead is very small for a small change. you can add a bit of noncoding DNA to a virus' genome without ruining its ability to compete in the wild. but the survival margins are very thin. on a population scale, natural selection is very harsh. anything that is superfluous given the environment is an inefficiency which eventually results in extinction. of course, between organisms this isn't that frightening because there are different niches, so sometimes a large change can be more viable than a small change even if it's a lot more expensive, provided that the large change lets the organism live in a new niche.

making HIV airborne isn't a simple change, however. it's more like a massive change of niche. it's a change in the transmission modality of the virus -- for comparison, consider the scale of the changes you'd need to make to turn a car into a plane. or maybe a car into a boat.

it's doable, artificially. but the result won't be as good at being a car, plane, or boat as something which was purpose-built for that application and didn't have to carry the features of something intended for a different purpose.

many of the "small" changes that make a disease spread more easily are actually mutations which don't change the ability of the disease to weather external conditions, but rather change the ability of the disease to survive first contact with the host's immune system.

the flu is a great example here. we need a new flu vaccine every year because the flu mutates constantly and drastically. the flu never becomes capable of surviving outside a host for longer than before, though. it just becomes more effective at evading the immune systems of most hosts.
Ask HN: How do you solve internal software documentation at your company?
We have a big mix of markdown files / swagger docs / docstrings / other html/css/js docs (react storybook).

And are looking to centralize them in a way that allows for: Github authentication, search / indexing, internal commenting / discussion.
Here are some Cute pictures of Indian Singer Shirley setia
616M/20M is not 30 million - you have to take out the million :)
Fun with Very Large Numbers
Perhaps a program that can detect when a user is in a state of flow and allow others to inquire if it is a good time to contact that person. A flow guardian.
What are the other uses for this? Civilian power? Military applications?
Yeah, I was about to say, an aggregate figure isn't very meaningful here -- it should be per capita, or per household/unit, or per square foot.
Please elaborate on how being off by a factor of 7x makes your point even stronger.
Challenging, but beautiful, rewarding and enlightening!
The project itself makes that abbreviation often, such as in e.g. the pgdump command.
Rule #1 of public relations - don't give negative news more attention then you have to.
Ah, so you get free bandwidth from people that want to balance their traffic for better peering contracts. That's clever. Probably not a helpful model for other areas that aren't bandwidth centers like NYC, and should probably be more out there when you're evangelizing so people understand you're getting a large portion of your operating expenses donated...

I have to assume another cost that's not noted is roof rights. That's not free - most people either have to pay or give the property management a kickback.

NYC is an interesting place for this - if you live in Manhattan, you clearly can afford the $80 for 1Gb/s FiOS or $40 for 100Mb/s FiOS or whatever Spectrum is charging. It would be way more interesting to plop this in a rust-belt city where people are on a paycheck-to-paycheck salary...
Tesla shares fall more than 7% after company reports record loss
You're entirely ignoring comorbidity.

Glioblastomas are associated with Alzheimer's disease. Its entirely possible that 20 years ago the symptoms of a brain tumor would be attributed to Alzheimer's when the patient was already dying of Alzheimer's, or other terminal illness for that matter. With better awareness and detection we may pick up new diagnoses in the sick and dying.
Dual sim routers are awesome
If you are dismissive of the pain of an extra $1, you are probably dismissive (and even more so) of the pain of an extra $0.14.
I didn't boil down diversity to one metric. I was responding to this:

> I'm curious what definition of Diversity you're using that a team of people from all over the world doesn't qualify.

What you wrote would work better as a response to that than to what I wrote.
When I first read this my mind immediately flashed back to when I played FASA's Shadowrun, and several William Gibson novels. It will be interesting to see if this bill legitimizes corporate 'IC' (pronounced "ICE" and standing for Intrusion Countermeasures), and thereby causes a proliferation in corporate jobs doing Offensive Information Operations.

Also, there's some irony here. Georgia Tech was the home of Phrack for many years, considered by some to be the best hacking e-zine of its time.
The scoring algo is pretty bad. You get 1 or 2 points for each characters classes and some points for length (at lengths 7, 13, 16 and 21).

"AAaa11!!" scores nicely using this method (one "blip" from a perfect green bar), but zxcvbn (from Dropbox) gives it a score of "1" with an estimated crack time of 13 minutes.
The new "version" for Firefox is: https://github.com/cmcaine/tridactyl
>if true, especially in the presence of supply constraints, this has to increase market clearing prices.

AirBnB arguably increases supply of people in beds through more efficient utilization.
How Casey Neistat Changed a Software Engineer
Asperger's Syndrome, the Nazi Regime and the Dangerous Power of Labeling People
Why aren't they competing with established vendors?
Keep in mind that only some multiverse hypotheses are extradimensional. Many would prohibit viewing other universes because they don't occupy the same "space" as us. For example, one hypothesis suggests that black holes are the creators of universes (where a star collapsing in our universe occurs simultaneously with a big bang within the singularity). We'd never be able to reach that universe and so could not perceive it, regardless of exotic senses.
That is correct, it does not protect functional portions, but it's fairly nuanced.

https://www.wintechblog.com/2016/04/functional-features-in-d... is some recent caselaw on this
How does it work for torrenting?

Does VoIP work?

What if I want to run a server at home?
The black helicopter people might arrive and have a nice chat with you when they discover you ordered a bunch of HEU from aliexpress.
With the exception of Bavaria, this almost looks like a map of historically Protestant vs Catholic regions.

Also, what is so different about Macedonia compared to the surrounding regions that it has such lower unemployment rates?
SoundHound has raised a big $100M round to take on Alexa and Google Assistant
The Landlord Rental Complex dictates that non-rental properties will be bought and turned into rentals, and they will constantly test increases in price - putting a constant negative pressure on the quality of life of everyone else; this leads to urban sprawl as well, passing a time cost over to people who need to travel further distances. E.g. Building more affordable housing isn't really as deep as the conversation needs to go.
I'm using Bell in Ontario. It could be either my Router doesn't support it, the Apartment isn't wired up to support it (if that's required?), my ISP doesn't support it in my area, or my Bell internet plan doesn't cover IPv6...

I'll ask them about it when they ring me up next time asking for more money.
It's important to look under the surface of what this is saying. This boils down to an extra 77 dollars per person per year, so basically this amounts to an extra 10 dollars per month for any given unit.
Asylo: an open-source framework for confidential computing
Pilot is doing this cheaper than others, look into how they get their fiber in the ground...
Sandboxing and app storification are separate things - one is a security measure and one is a grant of veto over all software on the platform to a single company.
They are not intentionally running untrusted code. But yes, anti-virus software can reduce security.
I'm confused...

"Before the first prisoner enters the room, the prisoners may discuss strategy—but may not communicate once the first prisoner enters to look in the drawers."

And, in the example given, "That prisoners 5 to 8 will also find their numbers can also be derived from the information gained by the first three prisoners."

There's never any explanation of what happens when a prisoner opens a drawer and finds it empty. In the first example given, what happens when prisoner 5 goes in and there's nothing in drawer 5? The algorithm doesn't seem to account for this.

It seems like there's some sort of assumption that the later prisoners are gathering information from the earlier prisoners, but the problem set-up seems to preclude this? They're going into a room so they can't watch each other, the drawers are closed afterwards so they can't derive information from which drawers are open/closed, and they're not allowed to communicate.

Am I not following something?
Microservices enable optimal uptime for customers
There's already a major building boom going on in NYC at the moment!

11+ super-talls (300m+) and 40+ talls (150m+) are under construction at the moment, and more than that has been completed in just the last few years. Massive amounts of rental units and co-ops are coming online in UWS (Riverside Center), Hudson Yards in Mid-Town etc [1]. And prices have come noticeably down as a result, you can also get more concessions than ever. I just recently received 3.5 months free on a 14 month contract in a brand new building.

[1] https://ny.curbed.com/maps/nyc-new-development-hudson-yards-...
Isn't this post conflating multiverse hypotheses with the relative-state formulation of quantum mechanics?
The problem is still that your $109 is per renting person. A family of five in one dwelling is five renters: but they are not paying 5 x $109 more on their rent because of AirBNB!

The denominator has to be the number of rental dwellings; then we have a better idea what the impact is on rental prices, on average. Still, it must be dependent on area, and the size of the place and rent amount. Not everyone pays some sort of "flat AirBNB tax" across the board.
Show HN: MU5B – Browser extension to show movies for sale under $5 on Amazon
I suspect it would be better worded as 'least urgent' project. Some of the most interesting projects I've done have been long-term things that didn't need to make it out for 6 or more months, and really only needed a month to implement - but they did really need to make it out at the end of those 6 months.

With things like that, though, you can a) pull the engineer off for truly urgent 'done by Friday or we lose the customer(s)' issues, and b) losing some time due to interruptions isn't really world ending. For (a) to work you'd also probably want to stop having them interrupted.
Thank you for this comment; it has been an eye-opener for me. I always eyeballed those statistic and assumed 0.95 is good; now I've realized that it's not specificity, but (100%-specificity) that matters.
> If they didn't, they would have demanded that their leaders change this system

This is an assertion, not a fact. There are plenty of ways in which systems which are not popular persist long after a majority, not to mention an overwhelming majority, support them. In fact one of the major intents and effects of propaganda, which is being used extensively today in the US, is to raise the level of apathy in a population.
$4K sounds incredibly overpriced.
The wiki page you linked specifically mentions deep space applications as a design goal.

I'm not sure about the sodium heat pipes but the alcohol vapor heat pipes you see in electronics typically use an internal wick to return the working fluid.
Here: https://www.youtube.com/watch?v=h-dyiASgGkk
> Getting lost in the text-cities of Joyce, Döblin, and Dos Passos.

I've long wished someone would make a computer 'game' of Joyce's Dublin. And where is the James Joyce of the interactive multimedia era?
Having experienced so many platforms with 0% thought put into how does this work on more than one platform certainly gives me a huge appreciation of stacks that are built multiplatform from the start. I don't see myself jumping deep into any tightly-coupled-to-one-machine tools anymore for example.
Not surprising, hell the reason why real life sociopaths/serial killers have admirers is because they were plastered on the news.
I hope someone gets Weltmeister running client side now (without PHP). Then you could hack on Impact using a Chromebook!
AI researchers allege that machine learning is alchemy
While commonly used as an example, I'll note this isn't actually even always true for antibiotics.

The development of Fidaxomicin/Difficid is actually an example of a fairly inexpensive clinical trial (by clinical trial standards), and Merck didn't buy Cubist for $9.5 billion for a drug they don't think will recover their outlay.
Yeah, absolutely. That's exactly right, the open floor plan is unfortunately intended to encourage interruption (aside from the obvious advantage of just being cheap.)

The last open floor plan I worked in established that the meeting rooms were allowed to be used for engineer quiet time, and that someone in the meeting room was not to be interrupted. It was great for the first couple of months in the building, but eventually the meeting rooms were crowded with meetings and there just weren't enough for engineers to use for focus time very often. Headphones became the only means of staying sane.

When I tried office hours, I was actually in shared offices. 4-6 people to a room. It was a game company, and I was supporting artists. The artists were the worst about not respecting office hours, most of the programmers left me alone because they also wanted to be left alone to concentrate.

Ultimately I decided I was setting a bad example by trying to establish office hours for myself. The company wasn't that great at planning, and the interruptions I was getting were a symptom of not enough training and formal communication. What was needed was a little more communication, not less. (*But the right kind, of course.)
I think what's more impressive is that if the dating is correct those artifacts span 10,000 years. This means that that ISS is closer to the great pyramids those are to each other.
You sound like a great pm any thoughts to transferring your system into a package for other pm's?
Even if this were the case, luckily no one really talks on their mobile phones anymore, it's predominantly FaceTime and candy crush.

I would also be interested to know if the tumors are predominantly on the right side of the head near the ear...
Umm. . . it probably wouldn't be cost effective for you: the NRC is pretty brutal in it's regulations. I'm very gun-ho on nuclear power, but that is one bureaucracy I don't mind charging ~$4-500/hr for people to review submitted designs for approval and then painfully inspecting operating plants.
I don't think it's just the visual element. I mean Scarface looks pretty terrible by the end of the movie, and people idolize him. I suspect it's more that stories are now told purely for short-term entertainment value. We don't focus on the substance of the story or the moral, we focus on the kind of clips that end up in a trailer. You see similar trends in popular literature too.
Where would those tourists stay if they didn't use AirBnB? I can see where the residents may get priced out of a certain area because short term rental drives up the price, but the increase demand and higher prices should stimulate new construction. Now, if height restrictions are causing no new construction to be built, then perhaps the city should ease those so more housing can be built, driving the prices down. The 'character' of Manhattan isn't going to be ruined by higher building heights.
Answering random on-demand questions isn't the same as mentoring. In order to mentor people, you need to be given long-term leadership roles where you work closely with a small number of people.
Well, those are related with the business with have them (even informal 'word of mouth') - they provide you service and to comply with it they call you.

It's completely different for unsolicited calls - you don't have any business with them and they don't provide you any service.

Having severe fines for the latter should work just fine: they call you, you report them, they receive a fine that put them out of business.

It seems to work just fine in Europe so should be doable in US as well.

Imagine the "Do Not Call list" but with an angle that everyone are on that list (so no company can call you). You make an appointment with dentist - they ask you for your number and they call you to reschedule, you also provide the phone to the company/technician to install your cable.

It feels cleaner