skysight-inc/HackerNews huggingface dataset:
Thanks! I guess I had some gaps in my mental model of how postgres handles these things, this clears it up quite a bit!

Just to confirm/repeat back:

* When you say DDL operations (ALTER TABLE) will "never modify data", they're still allowed to add a column with a non-null default since that's not "modifying data" by your definition, it's picking the value to use when introducing new data. I shouldn't think of it as "set implicit null to 3", I should think of it as "set nothingness to 3", just like how it would "set nothingness to null" in normal column creation. But it would never be willing to "set null to 3" in a DDL operation.

* Postgres doesn't have an O(1) way (meaning: never does a table scan while holding a significant lock) to transition a nullable column to non-null, since it'll need to check the contents of the entire table. (Although maybe it could use an index?) I guess I was hoping that the default would help here, but really it only affects creation of new values.

* More generally speaking, Postgres's design direction is to put data integrity as a higher priority than scale. It'll do both if it can (like in the article), but there are still cases where schema changes might cause user disruption if done on a gigantic table. It could have been designed so that schema changes are always fast (like they tend to be in NoSQL systems), but that would come at the expense of other nice properties.
The use case seems to overlap with noms dB - https://github.com/attic-labs/noms

Noms doesn't have the appeal of SQL, but it is versioned and forkable and strongly typed data.
Go to the risc-v website, they have constant news and updates about people using it.
Thanks, found it

I don't need another hobby, but they keep coming!
Please explain to me how an active choice to use specific apps is equivalent to “blindly following a trend.”

For all you know, people could just _want_ to use Facebook, Twitter, etc., for their own personal reasons.
There should be a way for mid-career devs to do job trades -- like I do your job and you mine (with help from the other person to ramp up kind of like a buddy) for a month or two. It would give companies access to senior talent they could evaluate like internships, and all they would have to do is keep paying the original employee. Even doing this within a big co as an inter-team thing (getting a team rotation or a new team assignment past your first few years) is pretty difficult since your original team is presumably relying on your acquired knowledge.
Give yourselves a pat on the back, top million websites, half of you use HTTPS
And I hope they will all get heavy fines for doing so. Let's see how well the EU will enforce the GDPR.
As senorjazz mentioned, I wonder how much of the really bad recoveries are due to taking too much, mixing it with other drugs, staying up super late, etc?

I only did it a handful of times, a long time ago, but if I took a reasonable amount and just had a chill night on the beach with friends, the recovery wasn’t so bad. One day of feeling tired/down, but similar intensity to a moderate hangover.
The problem is that, while employees still feel this sense of obligation, management has gradually undergone "Americanization" and has far fewer qualms about not holding up their end of the bargain.
What you describe sounds great, just one remark - I hope you are also allowing him to just be a child, play outside, wander around, do foolish things, have fun with peers etc. Without these, a child doesn't have a proper childhood and effects will be felt negatively for the rest of the life.
>The article, though, at least to me, seemed more like it was more about just not using the popular thing.

How's that bad? Being able to resist what's popular is a good thing too. We rely too much on following fashions and trends.
Yeah. Totally incorrect: I say it all the time when I am driving my kids around -- or when idiot teenagers rip through my neighborhood where my kids are playing at 35-45 mph (1).. before kids? - Maybe not.

(1) - It's official: I am now a crotchety old man.
Agreed. I say this to people I am riding with all the time that are speeding.
agreed, if forums are social media then i've been a fucking social media junky since the 90s.
'I hate them': Locals reportedly frustrated with Ford's cars. ~ possibly said 100 years ago.
We are already overwhelming the earth by just about every measure. We're already using more than one planet's worth of resources, sustainability overshoot comes ever earlier each year. As seen by the sheer number of disparate stories about earth and species' inability to cope.

"Population growth has been slowing"

Which of course means it is still growing. How many decades ago should it have started to fall in order to avoid catastrophic climate change or the incessant stream of environmental bad news and loss of species?

No one should feel obligated to sacrifice themselves. They should feel obligated to replicate less if they want their own children to inhabit somewhere worth living.
They're already letting in far more foreign workers.
https://en.wikipedia.org/wiki/Matthew_7:7%E2%80%938

:

https://www.youtube.com/watch?v=23_1WlxGGM4
Ask HN: Why is the Mozilla Public License (MPL) 2.0 not popular?
The MPL 2.0 is considered a "weak" copyright license. It requires your modifications of MPL-licensed code to be released publicly if you distribute your product or service outside your company.

However, if your changes to MPL-licensed code are only distributed inside your company, you do not need to release those changes publicly.

The MPL 2.0 FAQ states:

> "The MPL fills a useful space in the spectrum of free and open source software licenses, sitting between the Apache license, which does not require modifications to be shared, and the GNU family of licenses, which requires modifications to be shared under a much broader set of circumstances than the MPL."

The above taken from: https://www.mozilla.org/en-US/MPL/2.0/FAQ/

The MPL 2.0 seems like a reasonable compromise between the permissiveness of MIT and Apache licenses and the strictness of the GNU licenses.

So why is the MPL 2.0 not more widely used?
Ask HN: Blogs or resources covering hardware or physical, non-software startups?
Why emacs is awesome
would adding sugar to the coffee have the same effect?
Dweb: Building Cooperation and Trust into the Web with IPFS
THE GREATER GOOD
Andrew Moore Steps Down as Dean of CMU's School of Computer Science
> Social media exists as a way to facilitate communication online over a long-distance, i.e. old friends who now live in different places.

That's an optimistic view to hold. If that was the case we'd pay money for the service. But we don't because that's not how social media companies make money. They make money by learning information about you by tracking who you are and what you do. That's the business model. Not making you more connected to anyone or anything. They make money by keeping you on the site as long as possible and showing you as many advertisements as possible. We can debate the efficacy of how well advertisement/political campaigns are but a corporation's job is to make money and social media's corporations incentives are clear. I'm not comfortable giving up information about myself for free, and I am not so confident that I'll make smart decisions in the face of advertisers and political activists. So I'll continue to abstain from social media. Not because I feel superior but because I fear the business incentives and I don't want to risk subjecting myself to hyper personalized advertisement campaigns.

Also it's a huge time sink, and I have the phone numbers of all the people I would ever want to contact. Calling or texting someone is a much more preferable to me, and has none of the costs of social media.
Same here, but his point is still somewhat correct, while not specifically accurate.
Adopting Airflow over cron was a huge leap for the analytics company I worked for. I think the biggest win was making the complex net of dependent batch operations explicit. That logic lived inside the head of the lead dev before that point. This allowed management to reason about how new functionality effected operational complexity, which would have been unimaginable before.
the desire to have kids is one of the most hard-wired desires in sexual organisms.

And yet, Europe and Japan have plenty of childless people.
> Technology is much more advanced nowadays, why not use that?

Is it though? I mean, it ostensibly is, at least on paper. Not so much in practice, though.

Maybe there is a cycle of expansion and contraction? In the 50s-80s we've pushed tech across all domains as far as we could, doing miracles. Then it got all scaled back in an attempt to optimize the most common use cases to be cheaper. If so, I can't wait for the next expansion phase.
Wealth is just a proxy. What lowers the reproduction rate is higher living standards. And having all humans on current industrialized nation living standards with current methods of production certainly would not make things more sustainable.

If you want sustainability you either need fewer humans or clean up the entire supply chain. And the latter might just suffer from jevon's paradox.
I've used FMC[1] with decent results. C4 modelling[2] is another option, but I personally haven't used it yet.

1. http://www.fmc-modeling.org/quick-intro

2. https://c4model.com/
I believe there is no support what so ever for this particular broadcom wifi chip on FreeBSD so I'm using a TP-LINK TL-WN725N instead.
> Going against the mainstream often is a package deal that comes bundled with a superiority complex against people who choose to engage in the activity that you choose not to engage in.

Ironically, your post reeks of a superiority complex found only in those that like to point out how much smarter they are than the people they are criticising because they believe they've spotted a pattern in their behaviour; and to show everyone how they didn't conform to that same behaviour.
Has Google (or any other company) ever said "we are programming our cars to follow the letter of the law"? I don't believe so. This seems to be something that programmers and lazy reporters have inferred to be true, without evidence.

For example, it is required in California to signal lane changes/turns for at least 100 feet before the maneuver. (Other states may have different requirements, so better hope your GPS is functioning.) If little Sally runs out into the road and can only be avoided by swerving, heck, even crossing double yellow lines, the letter of the law would be to strike Sally without swerving since the swerve maneuver can't be legally executed. Is that what is being programmed [Y/N]?

Indeed, they are not being programmed to obey the letter of the law:

https://venturebeat.com/2014/08/19/google-cars-are-designed-...
Just because an agency charges a fee which covers or exceeds their costs doesn't mean they get to keep those fees. They may go to the government's general revenue fund or they may be used within the Home Office to fund other activities within the agency. Even if the fees are directly returned to the immigration agencies with the Home Office they still may not be authorized to hire additional staff without prior approval through the budgeting process. Most governments don't like to give agencies unfettered ability to increase agency staff.

I have no idea what the situation is with the Home Office. They very well may have the required authority to increase staff but to assume they do doesn't seem logical since this is against the norm for government agencies.
Well, that actually was a transition away from self-driving cars.
Not so much because it’s new, but because it’s safer
This doesn't directly answer your question, but there is some silliness in the way some large companies hire contractors that typically prevents an individual contractor from making more (including benefits) than an employee. I know somebody who was able to work around this that I'll describe at the end of the post.

Many companies prefer to hire contractors through agencies they trust or professional services companies. Sometimes this is just baked into HR policy so you can't hire an individual contractor even if you want to. I used to work for a services company that charged customers ~$225/hr for US based people with specialized expertise in a certain area. The employees would get less than 50% of that in salary, but it probably came to 50-60% of that if you added in benefits.

Note that "specialized expertise" is really broad and many customers were paying premium rates for very average consultants. The customers that really needed experts cycled through a few average consultants before getting a great one.

I've also been at the other end of this, being the person who was hiring through an agency who charged ~$150/hr and paid their actual contractors much less. Again, the quality of the "experts" on their end varied widely.

At those rates, if you paid an individual directly you could get somebody amazing. But none of these companies were willing to do that and directly hire a great person for 75% of what they were paying a firm to do the same (or worse) work.

I knew one person who found a way around this. He was part of a professional services group and was contracted to a large company for 2+ years (multiple short term contracts) and built a bunch of custom stuff for them. He was literally the only person on earth who understood what he had built. He was also really good, so you couldn't replace him easily. He had some family issues and had to quit from the services company to take care of family.

The large company had no choice but to hire him directly as a contractor and give him a lot of leeway in his work schedule so he could take care of his family. He got a great rate and made that work for multiple years. I think the large company wanted to hire him as an employee, but he had no interest in getting pulled into their day-to-day politics.
Some "racing" bike helmets are wonderful though - they block minimal airflow and are very lightweight, so you don't even notice wearing them.
There may be an issue with running a "brain" program on a non-brain hardware depending on what the program is. We don't know what the program is so it's hard to speculate but, it is possible that brain program is not well fitted to silicon based architectures. It may turn out that low-level physical and chemical processes that are crucial to brain functioning are prohibitively expensive to simulate. Brains after all operate in the perfect simulator and evolution had no reason to avoid expensive to simulate solutions. I would guess that it is rather unlikely, but it is possible since even a single cell chemistry, well even a single organelle chemistry is complex. Simulating processes involving RNA may turn out to prohibitively expensive.

Also, I'm sure that theoretically optimal "intelligence program" on silicon processors is vastly different from organic ones. They may share a lot, but the constraints are just so vastly different including the most important ones like energy efficiency or space availability.
You first. Me, I’m defecting to the incel revolution, and becoming a breeder casual.
mapping of 居民身份证 to real names..
Empiricism. There have been many claims to human exceptionally that have been spurious or found elsewhere. And there are exceptionally human things that are probably just chance because every species likely has something odd going on (rats! Have no gall bladder and have two insulins)
A Mac-only app?

The 90's are on the horn, they want to know when this will be shrinked-wrapped and sold at Best Buy.

Why is this even on HN?
When i honk at another car it is always to correct bad behavior of some sort, normally when someone doesnt notice when a light turns green. But can these cars learn from being honked at? If they are doing 50 in a 90[1] clearly because they missed a sign, is there anything we can do to communicate to them that they are making a mistake?

Still wondering if they are capable of handling a police stop. Can they know that the cop wants them to pull over? can they know that the firetruck wants them to drive through a red light to let them by?

[1] Just had to honk at someone for this. Highway drops from 90 to 50 for road work but he missed the "resume speed" sign.
I'm not the one you're asking, but...

I'm a conservative Christian. I believe that homosexuality is a sin. The one co-worker who I knew was gay, I told him that straight out. I also continued to work with him, and kept him as my friend. (Lots of my friends are sinners. For that matter, so am I.) I continued to be someone he felt he could confide in - he'd come talk to me when he needed to gripe, because he knew he could tell me sensitive stuff and I wouldn't burn him with it.

Now here comes company diversity training. It includes LGBTQ stuff. If it says "treat people professionally; whether they are LGBTQ or not is not something that affects how you treat people in the office", well, I'm fine with that. It's what I do anyway.

But if the diversity training moves on to "you should have a positive view of gay marriage" or some such, well, that's forcing a political position on me.

Note well: I have never experienced that. But I think I've heard of such things happening (and no, I can't document even hearing it).
> Sometimes I really wonder how people use their phones. Is it really necessary to go the extreme of needing to turn it off just to "fight off" the "addiction"?

I'm running a business on my phone, so for me - yes. If I pull out my phone to take a photo on a Sunday and I see that a big client emailed into support, I'll get distracted and feel the need to respond quickly. Monday through Saturday, this is the proper reaction - so I need at least one day a week to disconnect and enforce more strict boundaries.
> And yes - it's a huge hit to your ability to continue an active social life.

Also Gen X, also don’t touch social media, and I don’t agree with this at all, despite how much it gets repeated here. Staying away from Facebook has had zero effect on my social life or ability to catch up with friends and family. In fact, I’m busier than ever outside of work and home. I assure you all, there are plenty of ways to keep in touch and maintain an active social life without scrolling through a company moderated ‘feed’ on your phone. The old-school ways still work fine and, as a bonus, don’t require you to be glued to your phone.
Love using them, hopefully with this money they will finally implement the date filter to allow for the last year instead of just the last month. Very important when searching for the latest coding implementations of a new version.
Surely they're even less likely to uphold their legal duties if you signal that you haven't got the courage to turn up in person.
>The appropriate entity to police children's behavior is the parent. Some parents do a crappy job, but the state tends to do it even worse.

I'd say the appropriate entity to police children's behavior is the community.

The state is too powerful and over-reaching (and doesn't have skin in the game), the family unit is too restricted (and not enough people to include a representative variety of opinion).
I didn't say it would be easy to get from A to B. But it's not impossible.
Is having group conversations in person a social medium too?
A case for better Python docstrings
> The article, though, at least to me, seemed more like it was more about just not using the popular thing.

If you're never going to dive deeper than that I can see where your misconceptions come from.

Sometimes the popular thing should be avoided, for very good reasons.
A collection of open AWS security solutions
They could rob people to pay their buddy's bail too, and threaten the judge to reduce sentencing. What's your point?
The worst type of drivers are the ones who go 20 under the posted speed and are overly cautious.

It sounds odd but one driver who is too cautious may be OK for them but it makes everyone around them go out of their minds.

Go with the flow.
Just like most of Australia is fine with this law. This is what enlightened centerism is giving us at the moment.
Reputation and repeat business. You might get away with selling fake information once, i highly doubt you would get away with it twice.

I imagine its a similar scenario to how other dodgy markets work such as drugs or cryptolocker decryption keys, reputation and customer service mean a lot.
> but the complexity in ARM/x86 doesn't exist for no reason. It's driven by real software requirements so RISC-V will need similar complexity if it wants to seriously challenge either architecture

Like what? Are you talking about extensions that don't exist for RISC-V, like Transnational Memory?

I would say most reason for complexity is legacy and there is little actual software requirements in that regard if your doing a new architecture.
> as though the two things, a person's character and their ideas, are somehow not connected.

I somewhat agree with you that the character of a person can be inferred by the ideals they claim to hold. Perhaps it would be more accurate to say that, given the context of the worldview held by the speaker, you can infer positions that person might take on other issues of the day.

Understanding the worldview of the speaker is incredibly important when making character calls. I've found that people will attempt to reveal their character to you in subtle ways, often in an attempt to see what positions you claim to hold in response. The ideals they claim to hold often mean very different things for their character depending on their worldview.

Example: I've found that when interacting with people who have grown up in black culture, when they make a statement against the ownership of guns, they're actually signaling to you that they don't believe in the unjust use of violence. In white culture, revealing a pro-gun stance says more about their belief in the role of the individual in relation to the government. Confusing one for the other will result in a very unproductive conversation.

People tend to interpret other's words outside of the context of the speaker's actual worldview. My understanding is that this is the problem that 'attacking the person's ideas, rather than their character' tries to solve.

Full disclaimer, I grew up in a very conservative circle(The kind that didn't vote for, and generally has a strong distaste for Trump), and as a result I have a very good understanding for how their ideas tend to be generated. I can say with confidence that many of these people have outstanding moral character, but would also be condemned by those in more liberal circles.(Granted, the conservatives I know are absolutely guilty of the reverse)
Well that's dark. Unfortunately, I suspect Canada is not far from proposing a similar bill. Currently the federal liberals are working on an Anti-Foreign Interference bill that plans on clamping down on free speech in social media in a very serious way. Scary times, authoritarianism sneaks in.
Indeed. I have a particularly good friend and they don't have a Facebook account, yet we still keep in touch.
> achieving good public transport in US is impossible for cultural reasons

Self-driving cars are not going to solve congestion - quite the opposite. Personal transport will remain extremely inefficient in space and fuel compared to public transport.