skysight-inc/HackerNews huggingface dataset:
Imagine you are going for surgery and the doctor tells you 'yeah, I have no idea what I'm doing, really'.

You'd be very interested in knowing whether it's 'I just graduated from med school, I'm barely competent', or 'I've been doing this 30 years, the more you know, the more you realize how much you don't know'.

Those are not the same.

Insecurity is there for a reason - to let you know you should tread carefully and learn more.

The feeling of insecurity will go away when you're competent. The feeling of wonder and curiosity hopefully remains until you die - the author's problem is not the feeling of wonder that the parent is referring to :)
You'd be insane to put the primary key in a varchar. Mysql is much faster with static width tables. Your main user table should be static width for all the fields.
also curious
Continuous Discussions (#c9d9) Podcast, Episode 70: Hiring for DevOps
I'm glad they're taking away flexibility. I hope they entirely remove the ability to create animated backgrounds.
What correction did you make? Is the chart wrong?

62 gigatons of CO2 from soil erosion/oxidation

5 gigatons from fossil fuel combustion

If this were code paths and milliseconds, where would you start? I need to save 5ms, do I go for a 10% optimization in one function or do I eliminate a critical function? Hmm, would your brain really be this disconnected in that circumstance? Your conclusion is not rational.

You blame the source for your position. I know how the source arrives at fossil fuels. Soil science is in the agriculture department. You don't get far blaming the problem on farmers in a classroom full of farmers.

What I don't understand is how you manage to throw out all logic and reason on such a simple optimization problem. Your conclusions seem beyond reason. You can't look at that chart and draw your own conclusion? Did you even read the article?

"Across the country, farmers decided not to re-enroll 15.8 million acres of farmland in the CRP when those contracts expired between 2007 and 2014."

Hmm, 2007, hmmm,

http://www.washingtonpost.com/wp-dyn/content/article/2007/01...

Brilliant idea. Let's burn the food and tear up new crop land to do it. We can actually make global starvation worse and increase atmospheric CO2 at the same time. It's like you have a vested interest in raising the price of corn at the expense of everything else. "LOL, we'll call it renewables!"

Maybe you aren't looking at solving the problem at all. Maybe you want to mislead everyone like the media does. Follow the money, as always.
Show HN: Secure localStorage data with high level of encryption and compression
I buy something from Pirate Joes that is tainted or recalled and get really sick or die. Who do you sue? I can see Trader Joes thinking about that scenario.
> Another problem is fragmentation — because UUIDs are random

UUID-4, UUID-3 and UUID-5 are random (3 and 5 are hashes).

UUID-1 is time-based with the time leading, and you can often control the sequence (14 bits) and nodeid (48 bits) fields to be used as whatever you want to avoid collisions.
I have experience with PayPal's customer service but that's nothing compared to this. My account got locked once on PayPal because I was making an international transaction and they thought it was suspicious. They froze my account and I couldn't touch the money for weeks until I sent my proof of identity and all kinds of stuff back and forth. But this is understandable at least. The customer service did respond when I called.

Coinbase had absolutely zero response from their so called customer service line.
Really amazing that their customer support system is done through HN rather than the support form and email?
You can generate v1 UUIDs. v4 are random by design. You can also create your own version of UUID, as long as you set the version bits correctly, although I wouldn't recommend it.
A browser extension could be made pretty easily. If you have a terminal open, do `echo mymasterpassword facebook.com | shasum -a 256 | pbcopy`.
The larger the store the more likely you can swipe right away.

In smaller places typically you have to wait for a total.
I suspect they assume it was an ex-admin probably because of timing. There may not be any proof to back up that claim and thus there may be no repercussions.

Until they release specifics if ever, it's hard to know what to make of the status message.
May has made u-turns on many of her promises recently.
Perhaps not to the same extent, but kids get the same skills out of any rough contact sport. You get tackled enough or dive enough and protecting your body gets instinctive.
for ruby on rails, acts_as_having_string_id [0] is a nice gem for not exposing sequential int primary keys:

it's nicer than using UUIDs because the strings are much shorter.

[0]: https://github.com/hult/acts_as_having_string_id
It's been 17 days - it happened on May 23.
> when a source is charged, any unused bitcoin received in excess will be returned to the customer automatically

Wait, what?!

That seems like a pretty big flaw. Incoming transactions to a platform provider like Coinbase go to addresses that belong the the wallets of individuals. Once confirmed, they're then typically consolidated into shared wallets owned by the service, most of which should be offline.

When the customer send Bitcoin outside the platform, the actual address from which the coins are sent is arbitrary - it's just whichever storage wallet is currently hot. If, as a recipient, you send money back to the originating address, there is no way to figure out for certain which wallet on the platform it should go to. The money isn't "lost" - it's incorporated back into the hot wallet - but it's not routable to a customer within the platform.

In short, this seems like Stripe's fault. They should be assume that an overspend should be sent back to the address from which it came. There are all kinds of reasons this is a bad practice.
expertsexchange had the same problem, in the Bad Old Days before Stack Overflow.
No. Dates are dates. Everyone can agree when a specific day exists. It's all about grouping.

Dates have attributes that group them together. "Month" is an attribute that you're familiar with. "Fiscal Period" can take on many specific definitions but it is analogous to "Month".

Those two concepts share a lot of properties. They each collect a series of contiguous dates. Each is adjacent to a similar grouping that falls sequentially and the last date that exists in one is one day prior to the first day that exists in the next. Each falls within a larger category like "Year" or "Fiscal Year".

Year+Period forms a composite key for a period. We can also assign a monotonically increasing field that increments by one with each subsequent period. That field allows simple arithmetic to shift forward and backward. We typically call this attribute PeriodIndex or PeriodSequential. I'll abbreviate to PI here.

If you have a reference PI, you can always find the immediate prior period by subtracting one from the reference. We can assign these for any grain of time period. We typically see Week, Period, Quarter, Semester, Year.

This is the baseline of how we handle dates. There are plenty of utility fields we'll maintain for specific time-based needs, but it's all sugar on top of that.
I thought power lines, in contact with the dirt, can make the ground electrocutive.
Hopefully you are pulling your Howard Hughes routine everywhere else.

Those doorknobs are the real killers.
I'll just strive on, all I can do. I've worked as a technician and a designer for years before getting over my fear of code. I've learned a lot about how all various pieces connect together to create the Internet, I need to deepen my knowledge of those connections now.

I've travelled too far to quit now.
How do you like the music experience with the Echo? That's primarily what I'd use it for, but the skills are great (and I've even developed one myself, so I have a bit of an allegiance).
Well, whats actually not clear from their message is if the person who is currently an "ex administrator" was an ex-admin at the time that they deleted everything or if they were fired because of a (bad) mistake and are now an ex-admin.
You can fly your drone around people as long as those people don't include me.
No, what I mean is that with 9p you can remote far more than just filesystems. It's an IP based layer with the Plan9 kernel being a router for 9p messages meaning you can do things like 'mount' an audio card from another machine into your 'namespace' and use it like it's local; no magic required. It's all in the kernel.
Because some users still have 32-bit computers. How is this not obvious?

He's talking like there are people with 64-bit PCs running 32-bit Windows out of cluelessness or spite.
Have them removed? They are the seller.

>by Trader Joe's
FDA wants opioid painkiller pulled off market
Interesting, do you think modernist architecture itself breeds problems or do you think the economic conditions bred the crime? I get the feeling that the architecture was used in some cases specifically to group together people that they wanted to get away from the upper and/or middle classes and consolidate together, but I wonder how much of that can be attributed to the actual architecture itself. I don't feel like we can know that until we have a more equal society or at least one where straight poverty isn't as much of an issue.
Source? I have not heard of this. Our nurse emphasized that while a child is on formula, that's really all they consume for both nutrition and hydration, so it needs to be balanced per manufacturer guidelines. They don't have a way to signal "I thirsty" or "My tiny stomach is full of watery stuff but my blood sugar is still low". Their digestive and urinary systems are pretty amazing, but habitually using too much or too little (wrong scoop, wrong ratio, packing it dense) can be unhealthy.
W... What? Why?

The whole point of UTF-8 is that it's identical to Latin-1 (edit: ASCII) except in cases where it can't be. In those cases, it uses a very efficient encoding.

I understand that people (for whatever reasons) don't want to store text in UTF-8, but that's incredible that such a popular piece of software would take that notion to the extreme. "Let's make UTF-8 almost equivalent to UTF-32 when the data is at rest! Yes!"

Are you sure that info is correct? And if it's correct, are there any valid engineering reasons for that decision? It's probably best to be charitable and assume there must be a reason.
Wikitude | C++ Software Engineer (Windows UWP) | Salzburg, Austria | ONSITE, https://www.wikitude.com

Type: Full time

Description: Wikitude is the leading independent augmented reality platform for phones, tablets, and smart glasses. We currently have 100,000+ registered developers, over 25,000 published apps with our AR SDK and 1 billion app installs across the world. We’re looking for a C++ dev to bring our SDK features to Windows UWP and work on the next generation of augmented reality for mobile and wearable devices. You will be responsible for architectural choices and implementation of the Windows version of the Wikitude SDK. By the way we just were awarded “Best developer tool for Augmented Reality”.
Junior to senior level are welcomed. Excellent knowledge and experience with C++ is required. Experience in development for mobile operating systems (UWP Mobile) would be awesome. Office language is English and your colleagues come from various countries around the World.

Location: Salzburg, Austria - Austria in the center of Europe has a great quality of living. Salzburg lies directly at the gate to the Alps. Within 25 mins you can reach great mountain areas as well as beautiful lake side. The vicinity to Munich and Vienna make it easy to travel abroad.

Remote: Not preferred.

Visa Sponsorship: Not guaranteed. Applicants from the European Union are encouraged to apply.

Technologies Mainly C++11 and adopting C++14. Our main development environment is Mac and Linux for server-side tasks. However your job will be running our SDK on Windows. Notions of OpenGL and DirectX is a plus. In a perfect world you have experience with the angle project. Working on mobile systems is a plus.

Salary and Benefits: The salary for this position starts at 32,000€ per year (~35,000 in US $), depending on experience and qualification. The salary is negotiable but also includes several other benefits (meal vouchers, free public transport, potential for company equity,..) The cost of living is way cheaper than in most international cities. Renting a decent flat costs about 500-700€ / month. Most of the taxes go into a retirement fund that is available even when retiring abroad. We offer 25 days weeks of vacation per year. Additionally, Austria has great social security, healthcare is essentially free, including dentists visits. Schools are good and free.
Contact: Send CV and a short and cool motivation letter to jobs@wikitude.com
It's a weird way of writing

ssh -t user@example.com /bin/bash < my-setup-script.sh

That is, take the contents of the local file 'my-setup-script.sh' and run them as commands on example.com as the 'user' user (using SSH to authenticate the user & transport the commands).
Please see my post here: https://news.ycombinator.com/item?id=14523935

It really appears to me that Stripe's default behavior for an overspend is severely flawed.
In contrast, the Fire TV had a huge UI overhaul over the last year. Still a bit underpowered for the Stick, but nice to see it still getting some love.
So what do we do with patients in massive pain? Let them suffer? What about terminal patients? Is their risk of getting addicted more of a problem than letting them die in agony?
Well, for one thing, if you can't ensure that a given privileged person can be locked out of your systems quickly, you have a problem to fix. This should be a 1-minute operation.

Note that I don't know the details and am making assumptions that may be wrong about the case in question, but in general, if you can't deny access quickly to any given account, you really want to fix that. Not just because of rogue ex-employees - what happens when $important_person's account is compromised?
I don't know why gnaritas is being downvoted, but they're absolutely correct.

If you want to open up your device and swap out the RAM, well, you're not even remotely representative of Apple's userbase and you should not be surprised that Apple doesn't cater to your wishes.
Caution-- A popup says that a chrome application was installed.

https://i.imgur.com/5Ye1vcL.png
for event store databases, you'll need to have some sortable sequence ID-- you can't always even use timestamps, since on occasion you'll get multiple events happening at exactly the same time, and you still need to sequence based on received order.
LOL. Same thing happened with IEX a.k.a Investors' Exchange. They wanted to have the domain name investorsexchange.com. Someone pointed out the obvious! I think it is mentioned in the book Flash Boys as well.
I think part of it is chip & signature vs chip & pin UX because this doesn't seem to be an issue in Europe (I also remember their chip reading being significantly faster...but maybe that's an illusion?). There's a story about the Houston airport where people complained that their luggage took too long at the new terminal. They created a longer route for people to walk from the plane to the luggage carousel and the complaints went away.

If I remember correctly, with chip & pin you put in the card, type your pin, then remove your card. With chip & signature you put in your card, wait, after a receipt is printed out (or the screen prompts you) you scribble something that may or may not resemble your name so you can leave.

Personally, I want to use ApplePay/GooglePay but it's slower and more awkward only because I'm not sure if the terminal accepts it. I can get out my wallet and my credit card knowing it'll be accepted. With ApplePay/GooglePay I have to wait, possibly put my wallet away, pull out my phone and pop up the screen.
«Young people break their wrists because they shoot their hands out quickly when falling. Older people break their hips because they don’t get their hands out quickly enough. You’d much rather break a wrist than a hip.»

I once broke my wrist while landing from a unicycle fall (while trying to jump on a sidewalk). I felt unlucky to have a broken wrist, but maybe it saved my head.
I don't think it would have been so hard for them to develop an emulation layer to run 16-bit programs on 64-bit if they were really concerned about having that functionality. It's not like performance issues are going to be a concern in a 16-bit application. So that might be a reason people still use 32-bit Windows, but it surely isn't the reason that Microsoft keeps building for 32-bit.
> Didn't know I could do that.

o_O

Why would you assume you couldn't?
I've seen no evidence they were ever using Mongo for transactions. The only references I've seen is that they were using it for the API and such. That could result in things like incorrect balances and improperly telling the user that an action is confirmed or rejected, but it has nothing to do with the actual transactions.
With UUIDv1, the low bits of the time come before the high bits, so they still don't sort in time order.
Tangentially relevant, one of my favorite journal articles.

"Parachute use to prevent death and major trauma related to gravitational challenge: systematic review of randomised controlled trials."

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC300808/
> Maybe boredom is not something we should be fleeing; it might be an important symptom of a more general existential malaise that bears thinking about. After all, boredom signals a problem with the world and our place in it. The second point is one best made, to my mind, by Theodor Adorno, whose excoriation of boredom is part of a larger, wholesale critique of modern capitalist society. You can scoff at this, of course, but Adorno was the first to see that contemporary boredom is a function not just of modernity but specifically of the political constructions of work and leisure. Boredom is ideology.

I disagree with that statement. We have it for one BIG positive reason.

Boredom = Creativity, especially with children.
Prominent Economists Question Fed Inflation Target
It wouldn't be the only utf8 quirk on mysql: utf8 isn't even utf8. For that you need utf8mb4.
Agreed, normally I'd put the edit at the bottom but I didn't want people to see my enthusiasm and jump out of the comment before getting to the no wait it's not that at all correction.
Agreed, but that doesn't necessarily have as much of a place in modern society or at least there are limits to how many jobs/lifestyles reward those traits. In the same way that women can be frustrated by an unattainable feminine ideal portrayed by media, men face the same dilemma at the opposite end of the spectrum.
Isn't this exactly what the OP is talking about? Why would you sue anybody in that situation?
It does - it allows for 36 code points using your current charset, which with UTF-8 can mean up to 144 bytes.

Of course, that is the worst case, but for index size limits, MySQL has to assume the worst case, which means you quickly bump into the default index key limit of 767 bytes with large string keys.
In a time-series datastore, you may have to replace a set of invalid/corrupt events within an index. Having IDs that are in some way deterministic from the source data, you are able to replace the invalid documents by ID by simply re-indexing that time period with your patch applied. This is the most simple and least risky solution, with minimal downtime

If the IDs are UUID, then the easiest way to fix the values is to drop the index and re-create it, making all of the other data in the index unavailable as it's being recreated.

The less-easy way with UUIDs is to select just the broken events, create new patched events, delete the old events, and insert the new ones in the right index. But you'd have to branch off of your regular indexing logic to do this, probably writing a separate script. Of course if you make a mistake, you may end up with either duplicate documents or loss of data, compounding the original problem.

So I agree, have IDs that are deterministic (that they can be recreated using some known formula and source data, for example: documenttype_externalid_timestamp).
You can specify encodings on a per-column basis, at least with ISAM tables, so you can have a UTF-8 database with Latin-1 key values. MySQL 5.7 has some functions to aid string wrangling of guids, so you can store and index them as bin(8) and address them as string values.

More fun MySQL Unicode facts...utf-16 uses 32 bits per character to ensure it can handle supplementary characters. UTF-8 only handles characters up to 3 bytes; gotta use UTF-8mb4 if you expect to handle 4-byte values. You can create prefix indexes for Unicode string values that exceed the maximum index size.
Probably, people are afraid of uncanny valley elements combine that with a fear of the new /unknown and also pseudoscience feminism. It hits a lot of click-bait buttons.

But I could see it possibly as big a revolution as birth control, especially for a generation born with video games.
I noticed my younger nieces and nephews have an exceptionally higher tolerance for uncanny valley simulacrum.
As much as I like to side with the little guy, I think it's pretty fair for an establishment to restrict whom they sell to (as long as it's not based on a protected class like race, gender, orientation, etc). Despite being banned from the store this guy still sought out ways to shop there, so I can't defend him too enthusiastically.

Then again it kind of annoys me that TJ's just didn't open a damn store in Canada. And if they don't want to do that then why not just look the other way while someone else took on the risk of importing their products into another country?
Wasn't that only the first generation of hardware they made with Intel's processors? IIRC, my friend and I both got laptops about 3 months apart and mine had support longer than his, I don't know if this was the issue or not.
Here are the rules in Canada: https://www.tc.gc.ca/media/documents/ca-opssvs/Infographic_-...

"[Do not fly your drone:] closer than 75 m from buildings, vehicles, vessels, animals, people/crowds"
And to think Coinbase wants my photo ID. Yeah about that, if I can't trust you with simple transactions I am definitely not trusting you with my photo ID. I say "Good day to you Sir!"
I have heard this from several taxi drivers. As a passenger cabs have all but disappeared from the streets compared to a few years ago
This thread is a hell hole

One on hand "Company doesn't satisfy my $overly_specific gripe! They're an enemy of humanity!"

On the other "nuh uh!"
But big companies can't allow this kind of infringement. They have to defend aggressively. You never to which mistake may cost billions of dollars in the future.
RPGs
- The original Fallout series (1, 2, Tactics)
- Morrowind/Oblivion
- The original Deus Ex

RTS/TBS
- Civilization (any)
- Age of Empires II (now remastered on steam)
- Rise of Nations

Roguelikes
- FTL
- Rogue Legacy

World Builders
- Sim City 3k
- Terreria/Minecraft

Fighters/Shooters/Hack-and-Slash
- Day of Defeat
- CS 1.6/CS Source

Puzzles
- Portal/Portal 2
- Puzzle Quest

Great Cashdumps (They have TONS of DLC content)
- All games by Paradox (Victoria, Hearts of Iron, EU, Stellaris)
Sure, the VARCHAR(36) column would have enough room, but if you have a 36-byte index on that column, then suddenly it won't be indexing the whole column.
Well, that's possible, but I'd say it's generally better to keep close to the spec and v4 is the closest option here.
https://www.quantamagazine.org/ does what you describe
It is beyond correct. Mysql's "utf8" only stores stuff from 1-3 bytes.

https://mathiasbynens.be/notes/mysql-utf8mb4

You have to use utf8mb4 to have proper utf8 support. Yes its stupid, this is the main reason I prefer not using mysql for anything. Too many gotchas lurking about.