skysight-inc/HackerNews huggingface dataset:
You could certainly get the same effect without downtime prior to this. It just needed a few extra steps and some cooperation by the application: adding a null able column without default has always been instantaneous, so you would do that, then update all the rows that are missing the value.

Finally, you add the default to the schema which will now be in the millisecond range because all/most rows have a default.

And then you add the not null constraint which will also be in the ms range.

You can do all of this in a transaction too because postgres' Schema modifications are transactional.

This is how I have added countless columns with default values without downtime over the last few years.
Interesting. The branches could solve the "date-effective" table designs. In the past I had used Git as a database to store multiple versions of a document efficiently.

Or this could be used as some elementary partitioning logic where each branch is effectively a partition.
I see the same thing, and empathize totally...but still, what HR person would see this and think "yeah, let's reach out to this person for a job"
> Deleting years of stuff that might not exist in other places would certainly be much more draconian.

This is exactly what the report says they did. The original post may exist on Twitter, but the conversation that happened on Facebook does not.

I just checked my feed, and my Twitter posts do seem to still be on my FB profile, at least when I look at it.
I would say there has never been a consensus. The Glacier API is defined such that it could be backed by any technology. It's possible that early "MVP" versions of Glacier were just S3 with lower pricing and artificial delays. Once demand was established, they could have swapped out the backend with MAID, tape, optical, or some combination. There are a lot of comments out there saying "everyone knows Glacier is X" but nobody says "I know Glacier is X".
Is the function similar to PostgreSQL's deprecated "Time Travel" https://www.postgresql.org/docs/6.3/static/c0503.htm ?

AFAIK this can be a foundation for some form of Snapshot Isolation https://www.sqliteconcepts.org/SI_index.html (?)
What a total sequitur. The point of the quote isn't who said it, it's that it's true.
That URL certainly looks like it didn't make it. For a minute I thought you managed to cut out a part somewhere in the middle but the link works!
The iPad Mini isn't the only touchscreen tablet in its rough size class; there are plenty that aren't discontinued; Apple isn't the whole tablet world.

Plus, to the extent that touch is a desirable interaction for the target age group, many current Chromebooks are touch devices. (Even the tablet-convertible ones, though are not a convenient size for handheld use by a kindergartner, to be sure.)
Can you easily run AFL on .NET (or jitted) code? My understanding was that AFL works by instrumenting paths taken and kinda needed a gcc-produced binary with normal Linux debug symbol stuff.
If there's any class of medications you'd expect to be generally problematic, it'd be "antibiotics". They have the name because their purpose and observed functionality is to "just generally kill stuff".
> The same way the gp expressed it, that the robot was bad at dealing with the cats excretions.

That (what the GP/OC expressed) omits the intellectual-curiosity point I was trying to get across: why?

Is there something backwards in my wondering about the reason for the mismatch?

> Do you not see the cold irony in expecting the cat to poop in a way the robot can handle?

That borders on being an uncharitable interpretation of my comment. I certainly have no such expectation (and certainly did not say so), but, as an engineer, especially on HN, I see no coldness nor irony in if the designers of the robot had certain expectations as to what the majority of domestic cat feces would be like.
Argumentum ad populum.
Cloud Server vs. Local Server: Which One Is More Profitable for Your Lab?
It's 99.9999% not a hard delete. They have fail overs and multiple backups.
I don't know why, but I found it really hard to resign at my old job. I actively disliked it and I didn't owe them anything. But still I found it really hard to resign and tell my colleagues that I was resigning, I didn't even care about them.

Most of the team only learned that I was leaving on my last week (I had given 3 weeks notice). I just felt really awkward telling them for some unknown reason. Funnily enough, I worked in a coworking space, and most other people in the space knew I was leaving before my coworkers. My coworkers only found out because they put my leaving party on the "this week" board in the kitchen.
Google has been personalizing search results, and going way beyond just "link counts", for a while now.

e.g: When I type "pandas" or "kafka", I get the Python library and the streaming framework. I don't get cute black and white animals and a depressed novelist (what the average person would expect).
While I am usually sceptical of anything that has even a whiff of human exceptionalism, this is a fascinating result. Ed is extremely interested in and well versed in comparative neurobiology, and despite the deathgrip that Allen's PR team has on all external communication, the fact that he seems to have approved of the spin is a good sign. Second, the primary outstanding question that I have is whether we have actually sampled the population in L1 sufficiently in other species. Another (maybe unpublished?) result that has come out of Ed's group (and collaborators) is that human neurons are extremely metabolically robust. They are almost like turtle neurons, they can be patched for extended periods of time and live for days to weeks. When compared to rodents this means that this cell type might simply be living long enough to see it, and dying too quickly/being too unhealthy to patch in rodents. The transcriptomic data suggests that this might not be the case, but the results from the sequencing of marmoset cell types are not in yet, and good luck getting this data for a great ape.
That is already the case right now, anyone can be held without bail
> How does reading maintain its hold on our imagination, or is that question even worth asking anymore?

Clearly Harry Potter and Lord of the Rings do. Think how old The Hobbit is!

Maybe he was onto something with respect to polemics, philosophies, propagandas. Maybe kids are tired of that shit, they'd rather just be ironic.

> Then television, with no malice whatsoever—just a better buy for advertisers—knocked the magazines out of business.

I think Kurt Vonnegut is right here. The sad thing is, all those talented people working at Google didn't get us the quality of writing that magazines did or TV does. They gave us eHow.
"When you are gay or trans and a significant chunk of people find your mere existence revolting, when you are black and a significant chunk of people believe you are innately less intelligent and more prone to violence, when you are a woman and a significant chunk of people believe you have no business starting a career or working in tech or people don't believe you when you claim to have been sexually assaulted, it's hard to treat "politics" as an abstract debate where free-thinking intellectuals joust in the marketplace of ideas. In these contexts, you actually live "politics" - every day, from the moment you wake up to the moment you sleep. You can't opt out of it."

This is an absurd dramatization. Really, what percentage of people at Facebook do you think believe that stuff? 0.0001%, or 0.00001%? Later in the post you indict apathy for the status quo, but this sort of left-leaning dramatic nonsense is as status quo as it gets.
Facebook still does notification emails?

I've been filtering them straight into the trash for the best part of a decade. It seems so backwards to send them when most people check their Facebook more often than their email.
Feels a bit like that's a post-facto argument to me.

It sounds like the Surity thing had "blocks" consisting of a week's worth of documents which got chained together and had their hash published irrevocably every week.

Without the subsequent invention and popularity of the specific implementation of the bitcoin blockchain - I don't think the slow/costly consensus "feature" could be considered a requirement to distinguish between "hash chains" and "block chains" like that.

(But I'm regularly on the losing side of nomenclature arguments - I'm still pissed at all the people who've decided they should call my non-autonomous quadcopters "drones"...)
That is for better or worse, mostly down to someone actually spending the time to ensure that it happens.
Huawei bags Apple’s 2nd place spot in global smartphone sales
I have seen a pro calk the edge, then it was easier to tape over it straight.
You can spend all day criticizing people and organizations in power in the US. The most powerful people, the most powerful companies, and everything else. How is it true except as a dog whistle for conspiracies? You can literally spend all day calling whichever president happens to be in power a cunt, along with every congressperson, judge, General, and CEO. The people who literally have the power of life and death over the citizenry are constantly criticized.

Maybe the origin of the quote is important to understand what it really means. It’s a dog whistle to claim that insertgroup is really the power behind the throne. It was a way of saying that because it’s considered bad form to be a Jew-hating Nazi, and most of society will despise you for that, it means that Jews really run things. Changing Jews to some other group doesn’t change much. Claiming that gays or blacks or “lefties” or whichever group you think are really in charge because you’re not supposed to denigrate them, isn’t a good point, and using a Nazi pedophile’s quote to make it is telling.
and this is exactly why Archiveteam has to exist: https://archiveteam.org

They try to stay ahead of troves of data going dark so they can save them somewhere first.
I'm not sure who you are addressing, but I would stop using ProtonMail if they did. Then again, I've never found Google's response suggestions to be useful.
> People are often released of their own recognizance if the judge is confident that they will show up to court. And sure, maybe they should do that more often. Likewise, some people are straight up denied bail. But there’s a wide gray category of people you don’t necessarily trust to voluntarily show up to court, but who can be incentivized to do so through some mechanism short of just going to jail, and getting rid of that mechanism will just keep those people in jail. So what’s that mechanism?

The mechanism in the new California law is a pretrial services system similar to the one that has for years been successfully used in Washington, D.C., in place of money bail. It's not just getting rid of a mechanism with no replacement.
If you need a free/encrypted/open-source email forwarding service w/o having to set anything up - see https://forwardemail.net
The inability to sell their next bug.
"It's possible for a company to promote hiring underrepresented minorities without allowing employees to advertise their political beliefs."

That's only true with extreme censorship. If a company I was working for was hiring people based on race, I would call that out for the blatant racism that it is (under the disguise of "hiring underrepresented minorities"). Would that be an inappropriate airing of my "political" beliefs. It may be construed as "political", but really it's just pointing out a tautology and making a very obviously true value judgement (people ought not to be hired or not-hired based on their race).
This is incredibly slow updating a billion rows to give a value to a new column as a blanket update will still be run as an implicit transaction. As does the constraint check before the default is applied. It can also use a LOT of disk space to do this as well.
whoops the email is - km at shivala dot in
Thousands of dollars worth of my time.
I'm assuming that is the bail bond. Bail bonds aren't free, you pay a small percentage that you don't get back. So if you have no money at all, you obviously can't afford to pay the bail, but you also can't afford to get a bondsman to pay it instead.
> I've been filtering them straight into the trash for the best part of a decade.

Why not just turn them off? I haven't received a single notification email from then in years
Pretty simple and fully asynchronous library for Telegram Bot API
> But the very idea that a company would display or promote politics in the work place.

This is indeed not a good development, but I think it already happens literally everywhere. It happens in hi-tech, it happens in restaurants, it happens in entertainment (massively), it happens in payment processing, it happens in travel... Literally every industry I interact with had done some political action lately.

> If you are my coworker,I respect you as a colleague and a human being. Your private life and beliefs are not mine to police or encourage in anyway.

That is a nice sentiment, with which I agree. But imagine proponents of some ideology - say, people that are opposed to wearing hats - do not subscribe to that. To the point they'd refuse to hire anyone who have ever worn a hat (either overtly, or by subtle sabotage if they can't do it legally in the open), would stage a public spectacle if they notice their coworker wears a hat, would sponsor company hat-burning parties (or call for a boycott of the company if the company refuses to sponsor one), adorn their workplace with anti-hat posters and loudly discuss how people who wear hats are just lowlife scum.

Would you wear a hat in such a workplace if you think wearing a hat is OK? Would you feel comfortable even mentioning you know someone who might wear one from time to time? Nope. So, some of the people would feel happy and supported in their private beliefs in the work place, and actively sharing and promoting them, while others would secretly terrified that someone would discover their instagram account and find out they wore a hat once. Not a good position to be in.

So, how you keep your right to your private beliefs and not bringing politics to work if the politics is already there? I don't know the right answer.
Some people like independence more than others. Although it can be impractical in some cases, I do appreciate people who try to live "off the grid" in an age where we are born plugged in.
Well, I was keying off the article itself, which said the following: The long length of the tape held in a cartridge—normally hundreds of meters—results in average data-access times of 50 to 60 seconds

It's tens of seconds, up to a minute, but that's just average, so I think we're on the same page here!

Even when not in academia, everything has to be funded by someone at some point. Sounds like you have a pretty awesome job though, and I imagine Stanford is one of the least likely to get cut off from precious NSF grants!
Error correction codes are quite magical.
Instead of splitting in 100 pieces each piece 3 times, you split it in 300 distinct pieces of size 1/100 * filesize, which any 100 can reconstruct the file. So basically you can drop 2/3 of the pieces and yet be able to reconstruct the file.

So as long as your nodes uptime is greater than 33% + eps, the file is not gone. The eps is quite small because of the law of great number.

For example if your node uptime is 50%, the pieces will be in average available on 300 * 50% = 150 +- C*uptimevariance /sqrt(N) nodes which is greater than 100 with probability ~ 1, so the file will be recoverable almost surely.
Pay more taxes so kids can "learn" more common core bullshit? Why on earth should the institution of force in our society have a monopoly on funding our schools and legislating what's taught in them? The tacit statism on this forum is just absurd...
As a occasional cyclist with a habit of casually breaking all possible traffic rules that are relatively safely breakable, my thinking is that if I crash with a car, it is me who dies regardless who was right. So as long the traffic culture amongst car drivers is so ignorant toward cyclists that me following traffic rules and actually trying to use the rights the rules give me results to life expectancy calculated in weeks, I keep my relaxed attitude towards traffic rules. Once the driving culture is such that I can drive safely by following rules, I start considering following them. The ball on this one is on cars, not cycles.

(To be fair, when I drive a car, I find myself driving similarly badly way too often. So I definitely do not claim changing the culture is easy)
As you said, the common Axe blink-call combo does not work on these bots; they dodge it immediately.

What was interesting to me was that since the bots trained against themselves, they discarded this combo as being ineffective - the result being that they did not use this combo even against vulnerable human players.
> As a dutch person I would absolutely NOT want to ride a bike in the US,

It depends where you are. I used to spend a lot of time in Raleigh and Cary, North Carolina and often borrowed a bike to cycle from Cary to Raleigh and around both places, I was told by many Americans that it was dangerous but in fact I only had one slightly difficult moment in hundreds of kilometres of cycling and that was a low speed bus that came within ten centimetres of me.
Not sure where you live but in Canada there are laws regarding doing this, not saying you can't but you might get in trouble, that being said it's almost always easier asking for forgiveness than permission. Here is a link to the Canadian law that covers this

https://www.google.ca/url?sa=t&source=web&rct=j&url=http://w...

If your interested in satellite tech I suggest looking into amsat, and if you want a cheap way to communicate with satellites, I suggest getting your HAM license and go that route.

Good luck
Facebook did not purposely remove the cross-posted tweets. Twitter removed their app from the Facebook platform which had this as an unfortunate result.

Source:
https://www.axios.com/how-cross-posted-tweets-disappeared-fr...
Archival Disc doesn’t appear to be available to buy yet.
I've got an idea - classified advertising!

We'll start selling space in the coinbase field to real estate advertisers and escort services!

'The Times 03/Jan/2009: room to rent in 3br share house in The Mission, $2600/month+utilities'
vendor lockin is terrible
I have the data available for felonies right here [1]. And according to those data 77% of people without prior convictions end up being released (63% for those with only misdemeanor convictions, 46% with prior felony convictions).

Of those released, about 33% are released for $0 bail, and the remainder met financial conditions. For those who faced a bail of < $5,000 70% were able to meet it. I'd like a non-media source indicating that "a very large percentage" of people in jail are in there due in an inability to meet bail of $50 to $100, because all the data I've seen indicates that you're either making things up as you go or being misled by a source who did the same (which is why I requested a non-media source).

[1] - https://www.bjs.gov/content/pub/pdf/prfdsc.pdf
And this is starting to take place - reducing fluroquinolones are one of the major cornerstones of antibiotic stewardship programs.

One of the problem is that they also work really well. A broad spectrum bactericidal antibiotic that works really well, isn't in the beta-lactam family (dodging both beta-lactam resistance and penicillin allergies) is very tempting to use.

It's a hard fight, especially in the outpatient setting, because of this.
Was it difficult to install the Broadcom drivers? I've been looking into using FreeBSD and given how they're a headache even on Linux, I imagined it was even worse for FreeBSD
A Quick Guide to Choosing a Trade Promotion Optimization Software
Transitions aren't really too difficult so long as proper steps are taken:

- Notify your contacts of your address change.

- Set your old address to forward to your new address and always reply to emails from your new one.

- After 2 months, set your old email to auto-reply to all messages saying that you have changed your address and the old one will soon be deactivated.

- Finally, turn deactivate the old email.

It's work, but I've done it on multiple occasions. I wonder if there could be a service that could automate the entire process, since it could all be done via IMAP.
Teens who refuse to use social media
With all due respect to this project, I’m sure it has a lot of great potential, however:

> Our patent pending switching technology ensures data integrity.

I personally have little interest in trading one network which is controlled by a few people for another which will just be controlled by different set of a few people. Even if it is powered by trendy blockchain or whatever.

I am incredibly excited by some of the meshnet work we are seeing, but any of these which are just seeking to position themselves as power brokers on our future communication systems really need to be left on the wayside.

We’ve already seen firsthand what happened when our first iteration was turned into a glorified shopping mall. I’d prefer that we avoid this fate with the second iteration.
I use this with an rpi running offline imap read-only.
Rather than speaking in generalities, can you specify particular political positions that you feel have been forced upon you?
I had neither written code to test it nor was speculating - I was reading the kernel source, which is pretty clear (if you know in general how file polling is implemented in the Linux kernel).

However, because of what you have observed I wrote up a quick test, which confirms to my satisfaction that epoll_wait() respects SO_RCVLOWAT on TCP sockets: https://gist.github.com/keaston/d2473b8b996a34a5860b0744684f...

It seems likely that you must have been dealing with an old "enterprise" kernel in 2015 that hadn't had this fix backported to it?
Alcohol, cigarettes, sugary snacks...?
You are absolutely right, but we should probably just stop calling it "insurance", since it is nothing like what you are talking about. It's more like a pre-paid health plan. You pay a certain amount per month, and the plan pays for your health care. It's more like a co-op.
I was just thinking about using stats in startups. For sure you need to know your runway (and burn rate) - but then for SaaS (and similar business with recurring revenues) the first useful statistics is churn. Customers quiting is the most important info when looking for product market fit. Customer groups with lowest churn are your target group (market). Before you start scaling business you need first to decrease churn - because you don't want to grow the holes in your system together with it (this metaphor is not mine - but I cannot now find where it came from - but I googled this article instead: https://pakman.com/churn-is-the-single-metric-that-determine...).

Sales statistics become important after you have satisfying churn rate (i.e. after product market fit). With advertising you can quickly grow sales - but if your churn is too big - then the LTV (https://en.wikipedia.org/wiki/Customer_lifetime_value) will be too low. And generally customers that come from advertising will have a bigger churn than those who learned about the product organically.
We are generally talking about very simple wrapper functions here that don't have a lot of scope for hidden bugs to creep in.
Fixed:

> I really did not get anything for this bug, and I know I'm probably forfeiting an acknowledgement too right now. But I wasted alot of time on this bug, and nobody but me should be able to decide what to do with it. People who criticize this type of behavior I find frankly annoying. I used to be one of those self-righteous types, but I'm also pretty annoying, so perhaps there is a correlation.

> Besides, this bug is way to silly in its complexity to be of any use to anyone. I would not drop a full 0day exploit, which I can assure you, I have totally sitting on my hard drive (not referring to this bug :).