skysight-inc/HackerNews huggingface dataset:
> MySQL is prone to /more/ corruption, not less

MySQL isn't prone to "corruption" (meaning, random unpredictable data loss or lack of validity) unless you are using MyISAM, a legacy storage engine that has no valid use-case for persistent data in 2018.

This is my experience as someone who has also been using MySQL for 15 years, including at literally the largest scale on the planet. I am not saying MySQL is perfect (no database is) or "better" than Postgres (both are great databases for different use-cases), nor am I agreeing with Uber's original post or motivations. But I do wish people would stop spreading FUD about MySQL-isms that are long out of date.

Most of your post is describing data conversion issues, which follows predictable (if admittedly esoteric) logic. This is different than random corruption. In MySQL 5.7+ (released in 2015), this undesirable data conversion behavior simply does not occur with default settings. Those settings were also available and widely used in prior versions, just not enabled by default.

> 0000-00-00 isn't a valid date; but in MySQL it is a "null" data on a column with a NOT NULL constraint.

Not correct. 0000-00-00 will error upon insert by default since 2015. https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mo...

> This means that if you delete a row on a mysql replica

MySQL replicas should be read-only unless you're doing something horribly unusual or non-standard. And with global transaction ID enabled (increasingly common on modern MySQL setups), errant transactions that were manually run on non-read-only replicas are more apparent and much easier to detect with automation. Still, I agree this could be improved to be less of a footgun for new users.

> My understanding is that mysql will also truncate data in a column if the column is altered to where a value would no longer fit (IE; from varchar(20) to varchar(8))

Your understanding is out of date. With strict sql mode (again, default since 2015) such an ALTER will fail loudly rather than truncate data.
Prilex: POS malware evolves to target chip and PIN-protected cards
I guess anybody is entitled to say anything they please, yet when you claim time may be speeding up based on the fact that you and your children disagree on whether the summer went by faster or slower, or when Deepak Chopra speaks about "quantum medicine", or whetever, you are being a quack.

>I guess people who never had a conversation over a shared bong can never understand this.

Sure thing, duuuude. Now we're holding a published interview to the high (no pun intended) standard of "college stoners". Great.
South America: Argentina, Bolivia, Brazil, Chile, Colombia, Ecuador, Guyana, Paraguay, Peru, Suriname, Uruguay, and Venezuela

Central America: Belize, Costa Rica, El Salvador, Guatemala, Honduras, Nicaragua, and Panama

North America: US, Canada, Mexico

i.e. The Americas
Because there's been almost 3 decades of lobbying and corp control to snuff out competition. Good luck getting local any local help. I live in Tennessee and right now Marsha Blackburn is running for a Senate seat and she gargles the corporate balls. See here if you think I'm bluffing: https://blackburn.house.gov/voterecord/

If you can shop for ISPs as easily as picking which store to pick up that gallon of milk from the 30 convenience stores, groceries, or international markets on your commute home... we wouldn't be having this discussion.
Not the same thing. Your desktop install might include a few thousand packages total, but that doesn't mean any significant number of packages pull in a thousand dependencies by themselves. Node packages might consist of a single function.
I'm not sure if it was implemented as a 'competitive point' or if Microsoft just has employees that solved the porn search problem for personal use.
Good for you for being willing to admit that. If you have that level of crippling anxiety you need some medication asap. I speak from experience and I know how hard it will be to take that step (or any step at all), but things will get worse if you don't. The easiest way to do this is also a bit daunting but necessary. Go to your local hospital now. Tell them you are having endless and crippling panic attacks. Idk how the Japanese are about prescribing this kind of stuff but you must get a script for something like a Ativan or Klonopin. The goal is to reduce your anxiety temporarily- long enough to enable you to find a way forward with a clearer head. I know you will read this and not want to do it. Or you'll say to yourself that you know you should but then you won't. Summon whatever will you have and do it now. Just shut off your computer and get up and walk out the door.
> jury is that it is of your peers, which implies that to some extent you do know them and they know you

Does not follow. I'm not aware of any context where that's part of what "peer" means.

> A jury of perfect strangers unrelated to you is not constitutional.

Generally speaking, if you're not a perfect stranger, you're kicked off a jury for conflict of interest.

A "jury of one's peers" means people in the same social class as you, i.e. a jury that is not biased against you. The word "peer" is a hold-over from English society with more pronounced social classes, and is meant strictly as a counterbalance against those social classes.

Note that the Consitution itself doesn't actually contain the word "peer," but rather uses the phrase "impartial jury."
Perhaps the Culture series?
Have you considered the possibility that the scooters are genuinely unpopular? It may only be a minor inconvenience for you or I to walk over them when strewn all over the sidewalk, but for someone in a wheelchair, they can be a serious obstacle to getting from one place to another.
Oof. That’s disappointing (wrt that position having limited influence). Thanks for the context.
...An interesting question, but I'm leaning towards "yes."

1. Our immune systems are pretty good. Much better than is generally appreciated.

2. People usually buy lemonade from lemonade stands to support the kids, not for the taste.
As it's the case very often in our business, the answer is: "it depends".

It depends on the write load, the read load, and the write patterns.

Think about it this way: for the duration of any transaction, Postgres is basically in append-only mode.

If you have cache tables that normally get rewritten entirely, no row will be deleted during the duration of any transaction in the whole cluster (so this even affects databases other than the one the transaction is connected to).

In our case, we run some heavy import jobs daily which causes transaction lifetimes in hours, depending on the job. This isn't an issue, or rather, it's an issue, you can throw hardware at in order to circumvent it.

The transaction I was referring to in my earlier comment had a lifetime in days and nearly brought down the whole system.
Fountain codes, segmentation faults, improving CSS.Monday Cup of Coding Issue #4
> They frequently get shut down (or even ticketed).

I do not think this is correct for any commonly accepted definition of the word "frequently."
What do you meant as far as discrimination v. discrepancy? Just because numbers don't line up doesn't automatically mean there is nefarious intent. Corporations can care only about profit and still operate within the bounds of the law.
The actual attack vector relies upon drivers signed by Taiwanese chip makers. (Taiwan happens yup be a country whose continued existence depends entirely upon the US.) If you depend upon say a Realtek card reader you're vulnerable.
Ahhh cool!

Either way, the fact that you can end up with strings in an Integer column is certainly surprising...

sqlite> create table test (foo INTEGER);
sqlite> insert into test (foo) values (123);
sqlite> insert into test (foo) values ("blah");
sqlite> insert into test (foo) values ("123a");
sqlite> select * from test;
123
blah
123a
Sure, but the major difference is that those packages are for everything on your system. Dependencies are often added very carefully.

In the node case it is not uncommon for a small app to include 50 small packages, and then those packages pulled in 30 unique smaller packages each (on average).

Imagine you did an apt upgrade on your system, or decided to install a new package and it said it was going to install 1500 new packages. Would you continue? It would definitely make me pause for a while. But this is the norm in the node world, and people seem to think it is a good idea.
WebUSB – Bridge between USB devices and web browsers
Depends on what the data have to say. What fraction of pedestrian-cyclist collisions/incidents are the result of "zombie" pedestrians? How many per person-mile traveled? How do these compare to the same figures for drunk driving?
Alex Krishevsky Joined Canadian AI Company Dessa
Now i'm wondering, what is the ratio of odd to even outputs when calculating this?

are they perfectly even or is one more likely for each flip?
Agree but there are two new issues today that I can think of -

1. Targeting is much more sophisticated. Today you can round up every lunatic who hates squirrels or whatever by tomorrow morning and influence what people need to focus on.

2. Messed up social signals i.e. like counts/views/retweets/upvotes etc are just misguiding people left and right. If I don't know what to make of something/too busy/too distracted etc I fall back on these highly inaccurate proxies to make decisions. This is happening all the time and not just to the poor or semi-literate but too highly educated folks. Everyone is unconsiously nudged to support X or Y cause, org or person purely based on these numbers. Take those numbers away and it would be a very different world.
We all do it, it’s just the Japanese are more poetic about it. Read Marx on social masks.
Does he mean full-autonomy as in: "enter a destination and be done with it"? That would be an amazing jump forward from the current system.
Man, go spend a couple months in Cuba. Prejudice and bigotry doesn’t really discriminate based on colour! They’re on the whole the loveliest people I’ve met, but go out rural and they’re basically the Cuban version of your racists white redneck
Who benefits from the sun shining? Whoever can figure out how to harness the sunlight. The sun doesn't care either way.
No one in the world should look to Jenny McCarthy for guidance on vaccination, yet here we are. Dead kids and all.
In this particular case, you know the result has to be a subpath under /sys/class/net/... and, specifically, an interface name. I'm 95% sure that, if it's not alphanumeric, you can safely throw it out (and the other 5% is in the kernel and udev docs).
How to Bypass Server Cache When Retrieving Web Content?
Good regulation protects people from themselves. Before the Cambridge Analytica/Facebook fiasco, people would claim why care about privacy I have nothing to hide. Its not about hiding the things you do, its about protecting you from smarter people with ulterior motives that might use your data to straight manipulate you (make you buy something, make you feel something, make you do something, etc). We have to change the dialogue regarding privacy into its for your own benefit not because you're doing illegal activities but because your data is valuable to many outside actors.
I think that's the point. Outside of very few operating systems and languages with the organization and history supporting them, there's not much that one should trust. Since you can't validate every package yourself, you have to ask yourself if you trust your counterparty. Do you trust ElementaryOS to do have dozens of people validating upstreams before pulling into stable and correctly doing proper package source integrity steps like Red Hat, Canonical, SUSE, et al do? I know they are Ubuntu LTS based but what are the additional packages and how carefully are they curated, built, and stored?

May the answer is to not use Node or ElementaryOS depending on how important security is to you. May I'm the weirdo for critically inspecting 3rd party libraries before including them and looking at the transitive dependencies they pull along.
Man... the lemonade price inflation! :D
When I parked my lime scooter the other day (before they were all removed from SF) it asked me to take a picture of the scooter to help others find it. I think a similar coin return situation (ie a small credit for their next ride or discount off of current ride) could be implemented with this picture taking. Show them where you parked and then if they can see that you parked it inappropriately they can start tracking bad actors and do something to intervene. This would most likely take the form of banning certain people by phone number or drivers license.
As the other commenters note, this is part of what it means to be a minority; internalizing this is one of the personal benefits of extended travel.

That said, a lot of people go through this when they're new to Japan. People are so unusually polite/friendly that it makes you self-conscious of your own habits. Eventually you become more familiar with what you're seeing, and you're able to relax and be yourself. I think it took me about six months to stop worrying about offending people -- perhaps not coincidentally, this is when it became easier to make Japanese friends.

(Also, it's essential in order to learn the language. You have to be willing to barge ahead with communication, regardless of politeness. This is still a challenge for me.)
Are the feces, shattered glass, and tent cities only a minor inconvenience to this person in a wheelchair?
What is the Aggregation Theory and how it is related to scooters?
What I meant was that (a) companies are already spinning this as an advancement for the consumers and (b) consumers seem to be happy about it so far.
Running the same algorithm in my system, C/C++ with -O3 are almost equivalent, and Crystal too:

Clang C++ 1.069s

C++ 4.2.1 1.075s

Crystal 1.082s

But using a different algorithm (non–recursive) in C++ (http://rextester.com/discussion/OGIF47151/fibonacci) you can achieve

C++ 4.2.1 0.005s

someone should port it to Crystal :)
Nobody was proposing blackmail. They were talking about bespoking the defence/prosecution for each individual juror based on their personal information.

We're already seeing it with political ads. It isn't that crazy to imagine lawyers using every [legal] advantage available to them.
2nd word in article = 'apotheosis' Great clear writing!
Even Konami varied it some between games.
Nice. Is there a simple explanation somewhere of what the different bands mean? E.g. I'm looking at my place now and we have this spot on our property where the vegetation is quite different and this exact spot shows up clearly on the NDVI layer. Houses etc do as well so could be temperature?
Is this a web-based version of World Wind, or a separate project? https://en.wikipedia.org/wiki/NASA_World_Wind
Lintly: A CI tool that slurps up linter output and sends it to a GitHub PR
I value that until the point they claim their imagination is reality.
Indeed. "Evolution" would imply that humans with bigger jaws were somehow disadvantaged and died before they could pass on their genes. Really bad article.
Google, enabling the Verbatim option? You can add "&tbs=li:1" to the search query in your browser or use http://mycroftproject.com/google-search-plugins.html in Firefox.
Do you have any sources for what you're saying?

I have read dozens of examples of lemonade stands being shut down because of the lack of a business license.

I have not read any mentioning health code non-compliance.

FWIW - you put water and powder in a large cup with ice cubes, then pour it into smaller cups. Not sure you need a 60 minute health inspection for something like that.
yeah I heard an odd radio ad in Canada last week where Toys R Us straight out said we're not going anywhere!
How Odd

Yahoo insist that for me to read this page they must store cookies on my machine [0]

However when I load the page in lynx and choose "neVer accept cookies", the content loads just fine [1]

[0] https://i.imgur.com/OIcmAby.png
[1] https://i.imgur.com/ZdtpCxC.png
Escaping and quoting is the wrong way to go. Even if it works you're technically not totally correct as you can't reference my network interface named "bad'name"[1].

If you can avoid fork/exec you're always better off. In this case reading the file directly is fine. I can't think of a valid reason to fork and invoke cat.

If you have a legit reason to fork and run then use execFile(...) as you can pass the arguments as an actual array. No escaping needed as it gets passed in total without shell parsing of args. Your example would be something like:

execFile('/bin/cat', ['--', `/sys/class/net/${iface}/address`,], (error, stdout, stderr) => { ... })

Though that has the issue of being able to pass in ../../../ and read a file named "address" anywhere on the filesystem. Should also add in a regex validation that no directory separators are in the text of iface.

[1]: Yes this sounds stupid but it's a valid file name. A more realistic one may be something like "Alice's Wi-Fi".

[2]: https://nodejs.org/api/child_process.html#child_process_chil...
Okay fair enough, maybe we’re just talking past each other :).
The RPC mechanism uses Gob, not something like gRPC, so first you’d have to write a Gob parser. It’s not clear to me that that’s better.
hasn't Tmobile been offering this for years?
"We've accepted one thing that turned out to be bad; so we must accept all future bad things".

This is a snarky but accurate restatement of your (commonly professed) belief.
I think that timeline is backwards -- before 2015 there were net neutrality rules in place but then were struck down in the courts because ISPs were not subject to Title 2. So in 2015 they were reclassified as Title 2 in order to make net neutrality rules enforceable.
Tomorrow I am presenting Bondy (our OSS WAMP router implementation) in the Riak London Meetup (https://www.meetup.com/riak-london/events/250813756/) and it will be available in Youtube later. As opposed to everything you might have seen, BONDY works in cluster. It is written in Erlang and uses eventual consistency model where data is replicated throughout the cluster using a gossip algorithm (plumtree - epidemic broadcast trees http://asc.di.fct.unl.pt/%7Ejleitao/pdf/srds07-leitao.pdf). Bondy embedds an HTTP/REST API Gateway and will provide an MQTT gateway in the future.
How much does it cost to buy a comparable electric scooter?

I just don't see how any of these rental scooter companies survive due to the capital and storage costs being so much lower than a car.
First off get some help/guidance.

Call a suicide hotline, even one in the US if you are considering it.

The answer to this isn't suicide or fleeing the country.

Consider winding down the company and getting out the funds you can. Close it properly to avoid any future tax issues.

Reach out to patio11 (Patrick McKenzie) he's born in the US lives in Japan. He's commenting here. Try to connect with him privately.

He can probably help you get to an english speaking accountant.

Occupy your mind/time with positive things, exercise, communicate with friends and family, see the sites locally. Do things you enjoy.

As far as staying in Japan, talk to patio11 about that.

Business/Job sounds like you want to have your own business. It's tough staying motivated working for a company or having your own.

Get some advice on winding down your company, getting your money out of it and staying in Japan. You'll feel better once those are sorted out.

Would it be possible for you to move back to the US close to friends and family to reset and plan your next move?

It's hard creating your own company and it's hard wanting to create your own company while you're working for someone else.

Check out Rob's stair step process on StartUpsForTheRestOfUs.com.

Rob's wife might be able to help you out too:
https://zenfounder.com/consulting/one-on-one-consulting/

Check out these:

https://www.youtube.com/watch?v=0CDXJ6bMkMY

http://www.startupsfortherestofus.com/archives

I think patio11 should be your first go to on this. He should have lots of relevant advice.

Good luck, take care of yourself.
"This is what car owners and house owners are going through right now, they know that car and house registries are precursors to confiscation and prosecution."

Oh..wait...
retail sounds really perilous to me. there is little to differentiate yourself from competitors. even if you find something, others can just copy.
Working with modules in Fedora 28
The technology would be available already, what is needed is the data on a competitive scale. Google buys a lot of high resolution aerial imagery. A free project has no chance against that.
You are a beginner. Ruby is a dying language that hit it's high point and died and now is at it's at a low point and not going anywhere. It's time has passed like php and now it's used mostly for devops scripting as the technical debt the language accumulates is generally too high even for web apps.

Python, C++, C, Java and javascript are the languages with staying power that came and never went. If you were in the industry that long you'd know that most of the languages I mentioned have serious issues and problems and that the languages staying power has nothing to do with how they fit the "mind" or how good they are.

If you weren't a beginner you'd also note that ruby, like python and like javascript has serious issues when it comes to writing long lasting, reliable code. To code something as reliable and complex as an operating system in ruby would lead to huge amounts of technical debt. As a ruby or python code base grows in complexity it becomes more and more unmaintainable... It would be a mistake to write super complex systems in python or ruby because such systems benefit highly from type checking. Your comments indicate to me that it doesn't matter how long you've been programming... you lack the experience to understand this concept. Ruby is better for scripting then it is for writing applications.

What I have learned over the years is that programming is more about combatting our own faulty human nature, our own propensity to make mistakes. Ironically, the more expressive a language is, the more it gives, us the opportunity to express this fault. Power comes from restriction. Type checking is one such restriction.
Keep in mind that this article was written in response to a book that an anthropologist recently wrote. At the risk of sounding distrustful of academics, I do sometimes wonder if some anthropologists view the world through an "us vs. them" lens - trying to understand the differences in cultures. FWIW, as a person of 100% European decent who grew up in New England, I consider all of Latin America to be Western for the reasons you pointed out (with the exception of the un-contacted Amazonian tribes).
> a town that is still scooter-free at the moment (Chicago)

I was surprised to see this, given that Atlanta is covered in scooters. (We usually are on the later side of these rollouts.)

Lime is claiming they have a presence in Chicago, so maybe they just haven't made it to your neighborhood yet.
> In this particular case, you know the result has to be a subpath under /sys/class/net

I get that in _this_ case, but I'm talking more generally, sometimes parameters are allowed to or even need to have various other non alphanumeric chars, and then you start going down the fallible road of differentiation... trying to sanitise not quite everything without letting exploits pass through which is dangerous.

But in the more general case of "it's a parameter" can't we just quote it, sanitise for single quotes and then know it's safe?