skysight-inc/HackerNews huggingface dataset:
Strong disagree - you absolutely need to factor in liquidity effort alongside vesting schedule and face value for equity comp, and in general for most non-public companies that liquidity capability is zero.

- RSU's that I can only dump on a secondary market are worth a fraction of their face value.
- Grants in a company that'll never have a liquidity event are worth a fraction of their face value.
- Options in a public company are definitely worthwhile, but I shouldn't be negotiating their face value one-to-one with cash.

It's possible you've had a great outcome liquidating some equity from a private company, in which case I'm super stoked for you and that's a great outcome - but it's not the norm.
Everywhere you can have a table expression, you can replace it with a subquery.
Speaking as someone who does have a strong interest in machine learning, and who follows the pertaining literature and ML-related news and has done so for years, I can tell you:

To this day, every single time I see the acronym ML, my first thought is Meta Language.

https://en.wikipedia.org/wiki/ML_(programming_language)

In fact, this was the reason why I clicked this link, only to notice that, as in the vast majority of other cases these days, ML here means a different thing than I initially thought.
I'm a big SQL fan too. Like the author, I kind of intuitively got the order after years and years of writing sql but if the syntax had evolved into FROM then SELECT I could get how it would make more sense. As it stands most of my queries start out:

1. "SELECT *" because habits

2. Start writing the FROM/JOINs and table aliases

3. Go back and refine the SELECT to tableAlias.ColumnName

4. (OPTIONAL) Aggregates

5. Forget the WHERE clause and burn the optimizer's cached query plans to the ground! (j/k, add WHERE or just throw a TOP 500 into the SELECT)
Thank you for your valuable feedback
I spent time homeless. I was frequently mistaken for a tourist based on how I looked, because of my casual clothing (usually a t-shirt and sweatpants). People typically figured out I was homeless based on my habits, not my appearance.

I'm off the street. I still look and dress the same, in part because I currently do freelance work from home. I don't have to meet a dress code.

While homeless and in downtown San Diego, I fairly often gave away food I had been given but couldn't eat, either because of dietary restrictions or time limits (in that a large amount of stuff that should be refrigerated would spoil before I could eat it). I tried to offer it to other homeless people mostly.

One woman who panhandled regularly was reluctant to accept too much food from me, explaining "I'm not homeless." She panhandled because she was a retiree in high-priced downtown San Diego living on a fixed income. I told her to take it home, stick it in the fridge and eat some tomorrow. I assured her it was fine, I didn't have a fridge.

Another woman got mad at me for offering and told me to feed it to my dog. She was sitting on a curb in a neighborhood near a lot of homeless services where sitting on the curb outside was often a sign of homelessness.

She was also black and I'm white. She likely lived in the apartment building she was in front of and probably thought I was being a racist bitch. She was insulted at my sincere offer of charity and attempt to give away most of the fresh fruit I had been given so it wouldn't go to waste.

There are a lot of stereotypes about what homeless people look like. The reality is that there are a lot of homeless people with jobs and/or attending college and/or living in their car who successfully manage to pass for "normal" much of the time.

I have no idea what criteria was used to target homeless people by Google, but I'm skeptical that the dataset:

A. Is representative of homeless people generally.

B. Was chosen based on people looking homeless, rather than people behaving homeless.

C. Actually is a 100% correlation that people believed to be homeless were actually homeless.

The examples you give are blatant misuses of data sets. How you source the data has little bearing on the dumb ideas people come up with for how to use it.
Shameless plug (but I hope that's okay, again): IRMA Authentication is an open-source app [1] and protocol that offers privacy-friendly attribute based authentication and signing using Camenisch and Lysyanskaya's Idemix [2].

It's currently heavily focused towards The Netherlands, where citizens can obtain attributes such as name, home address and age. These attributes can then be selectively disclosed directly to a service provider, without the identity provider being able to see the transaction [3]. Multiple disclosures are also unlinkable as long as the attributes themselves are not identifying.

The fact that the identity provider is not at all involved with the transaction is an enormous privacy win compared to OpenID Connect, especially in the case of centralizing providers such as Apple – and less so in for example the domain of education single sign-on.

It's not currently using the verifiable claims data model, but it would very much fit it. It also doesn't use a 'blockchain', simply because it's not necessary to do so, and makes it all a lot less complicated.

[1] https://github.com/privacybydesign

[2] https://privacybydesign.foundation/publications/

[3] https://privacybydesign.foundation/meeting-slides/slides-8-3...
real question is, why do you need a distributed relational database? when it comes to scale (both in size, QPS, latency)
existing RDBMS would just do fine for 95% use-cases. For very small use-cases where you would absolutely need distributed RDBMSs keep some good hygiene of not using DRDBMS specific features, data types etc that can lock you in for future portability/mobility...
Very nice catch, thanks.

That being said, substitute out this program for something like Dolphin with the Wii, and I think the point still stands.

There are people working on circumventing cross-platform restrictions for just about every console out there, even in cases where the restrictions are technological and not just policy.
Living in San Francisco and seeing homeless people everywhere, it really doesn't feel like one of the biggest economies.
'Goliath Is Winning': The Biggest U.S. Banks Are Set to Automate Away 200K Jobs
China's situation is similar to the US in the 1800's when land was basically free and railways were being built everywhere. There is little US land availability today to build infrastructure on, same issue in a lot of europe
Note that for Java/Spring cron there is an extra field for "Seconds" so it has one extra field to be configured.
> being treated better than google wanted to treat them

They're asking for 5m of their time and a scan of their face, in exchange for 5$. It's a simple transaction, and unlike what the HN-crowd would like to think, the majority of people in the street would quickly make that deal.

The article is putting a lot of their own feelings and opinions on the situation. Just because you have a fear of Google doesn't mean the whole world does, and no one was forced to do anything they didn't want to.

Also, the article mentions homeless people not going to the media (avoiding leaks), not being vulnerable.
+1 gold star for your wife being supportive, and +1 gold star to you for making a classy exit.
> JIT enabled by default.

Only if you actually happened to compile the support for it, which is not the default.
Huh? Maybe you mean @icloud.com or @me.com. There is also a discovery/query mechanism that should tell you if x email is registered on a specific idp but I don't think Apple implemented it. Anyway there are various UI/UX solutions. Check gigya and related openID SaaS providers.
I learned this and more earlier from https://blog.jooq.org/2016/03/17/10-easy-steps-to-a-complete...
my goto guide and recommendation for people with practical SQL experience who want to improve their understanding. (I first read it via Hadley Wickham's tidy data writeup.)

It leaves out SQL window functions though.
repl.it's jobs page[1] is basically a bash terminal running on the web. You navigate it by using standard commands like cd and ls, and read files with cat, more or similar. This is NOT a bash emulator, this is an actual bash, running in a Docker container somewhere.
repl.it lets you build an app, in almost any language, on the web, and run it. If it's a console app using stdin/stdout, they even provide you with a terminal emulator. Well, that's some pretty impressive instance of dogfooding.

[1] https://repl.it/jobs
Unless required by law in your profession: Don't go to college.
The Sociology of Technology Adoption (1992)
Which is why US healthcare is the standard of the world. Because it’s so profitable. /s
FYI you weren't screened. You were investigated. Screening is for asymptomatic people. There is a huge difference. The pre-test probability will be very different.

And congrats to you and your doctor. You both made good decisions and saved your life.
How does that help at all, though? When it comes time to write the final select, you still haven't established the meanings of the things you are selecting from until you write the from and join clauses.
They are following the exact same law literally everyone follows and always has followed, which is to take down apps that violate the local laws. I don't understand why you're taking a particular issue with this. "Apple, in its capacity as an app store owner, shall not publish apps that violate local laws" is not even a remotely problematic stance. If you have an issue with this particular app being taken down, you should be directing your ire at the law that makes it illegal, not at Apple for complying with the law, because taking the app down does no more harm to anybody than the alternative, which is for Apple to take the whole store down and stop doing business in the country.
Someone should actually write the article that goes with this headline -- it'd be super interesting.
> Every time California's high speed rails come up on HN it's obvious that everyone here hates the idea

California's major cities are almost in a line along the coast. That's the route that makes sense.

California's HSR instead took a tour through the Central Valley's farming communities, taking a slam dunk pitch for linking San Francisco and San Diego via L.A. and turning it into a carcass.
> We're not in a large scale war.

No, but we're in a large society where men can and do have sex with women (consensually or not) once and leave them pregnant. I'm not making a moral judgement, I'm saying that mostly anonymous sperm donations have been happening long before IVF and sperm banks were a thing, so the results aren't as unpredictable as you paint them.
Not sure it counts but there are a few anime and video games that some people call steampunk. Sakura Taisen/Sakura Wars, the latest version for PS4 was just announced at Tokyo Game Show a few weeks ago.
The house I live in currently is exactly this. It's a block of townhouses (20ish total), grouped in sets of 4, where each person owns their individual unit. We have a pretty diverse mix of people, and I quite like it.
"HR does not operate with your interests at heart, do not talk to them."

-- Anonymous
In the real world, you end up with logging, ways of progating errors, etc

All of which tend to introduce monads.

When you have multiple moands on the go you need some combining them.
> Want to fix this? Sure, easy, just scrap the democracy and just don't ask people, send those who object, to "re-education" camps. Or scrap market economy: if all land is government-owned, it won't be an issue at all.

I'm just going to assume that you've never been to major Asian cities.
"For several days, the British and U.S. soldiers exchanged insults, each side attempting to goad the other into firing the first shot, but discipline held on both sides, and thus no shots were fired."

So basically they all wanted to shoot each other, but not so much that they would defy orders.

We absolutely suck.
Thanks for highlighting this, this was cuz firebase messaging is not supported in safari. moved away from it. Thanks once again
I still love this chestnut from years and years past: http://noonebelongsheremorethanyou.com/00025
You are right, thanks for highlighting this, this was cuz firebase messaging is not supported in safari. moved away from it. Thanks once again
SELECT as the first keyword also makes sense as an opening indicator of the SQL statement's type. "Start a new task that SELECTs data" (then "what [data] do I want" then "given these rules") instead of INSERT, UPDATE, etc.

From a source code structure perspective "SELECT foo ...;" sort of works like a function header: "function foo() { ... };"
> It's definitely possible to eliminate all crime with total surveillance with a high degree of accuracy.

Unless the state itself is criminal. Not only can law stray from morality, authorities of the state can even violate the laws of that state itself. If you can imagine an extreme authoritarian state with a constitution, can't you also imagine that the leaders of that state choosing to ignore that constitution?

But before even getting into the above, you've assumed the possibility of perfect surveillance. Who or what and how could that ever be possible?

The only way I can conceive of perfect law enforcement is to have very few if any laws. Everything else is an excuse for the personal fancies of authoritarians.
Start from cryptographic right answers:

https://latacora.singles/2018/04/03/cryptographic-right-answ...

On a glance none of those recommendations have become invalid in the passing 18 months or so.
Yes, that's the implication.
"A lack of planning on your end does not make it an ermergency on mine"
I believe so. I would say it’s more useful for rollups or aggregations where real-time isn’t necessary.
I do see some difference. Home, always on, always capable of transmitting, unlimited power means they can listen as much as they want.

The phone has to cherry pick phrases and capture times. With the right codex, the phone could keep recording for a long time after the right phrase or your IMEI is targeted. Still sub-optimal, but not as easy as Alexa. My bigger concern around phones is GPS data. That's why I've not had a phone in my name in the last twenty years and never owned a smart phone.

Now put the data sets from your phone, Alexa, your credit/debit card together and that paints quite a full picture.

The Ring device is very interesting. It faces the street. I mean, the house on the other side of the street. A network of those can track the movement of anyone that lives near one.
The UI primitive was named after the operating system.
> those in the Centra Valley opposed it unless it connected some stretches like Fresno <-> Bakersfield together.

Why would they support being essentially left behind?
That's just temporary shocks. We have lots of Helium available should we increase use.
I'm fairly certain it was World of Warcraft. Also my AT&T router's UI does this, which probably explains why it's so slow.
Steampunk not dead. It's just that we discovered retrofuturism instead and graduated from the Victorian age that never was into the space age that never will be.
But the chances of a smooth transition are higher if the people of the country mange that by themself, instead of foreign forced change, where many suspect the motives are different.
It would be at first. But if almost all of a hospital’s revenue comes from CMS, why wouldn’t CMS simply run the hospital? If it can run provider networks more efficiently, why not hospitals? At least that’s how I predict the political discussion will evolve.
This is interesting. Wondering if you plan to support (or do support) the archive feature like the bottom of Anarchaia does by year?

Also, curious what inspired you to create this? (I haven't a lot of knowledge of the space or existing tools for micro blogging.)

Thanks!
Thank you for your valuable feedback. Can you please share if you are tech/non-tech if you don't mind?
>The US has 50% more road deaths than the UK. Are US drivers that much more likely to be distracted by their phones?

It sounds like you're being rhetorical, but that sounds totally reasonable to me. It seems believable that one country might have some variables that cause drivers to be more distracted by phones, and when the safety margins of attention are so small, even a small difference in average distractedness could equate to 50% more deaths.
Thanks for taking the time.

> the claim is stated in a rather unproductive way

Do you mean, identifying it as "mindreading" in this terse way is unproductive, or the subsequent phrasing and is unproductive?

> The GP is not saying that we should apply new ideas about speech to past thinkers

Oops, that wasn't what I meant to imply. My point was, JM and JSM would roll over to hear what I saw as GP's (recently revised) weasel words, e.g. "negatively impact" for "harm", employed towards what I saw as GP's desire to delegitimize large swaths of the political spectrum. But maybe that's some mindreading of my own.

I had a visceral reaction to what I read as GP's roundabout argument against free speech. It seems to me like GP is imputing and denouncing the motives of people they dislike, and questioning the legitimacy of people's free speech rights given that GP know's what's in their soul. Do you see where I'm coming from here?

< is not a simile

How not?
How is that beneficial to someone's career though?

Sure, it shows one's morals and standards, but how does that boost one's career?
> the police remain armed [...] armed bodyguards

The police and bodyguards are there specifically to deal with dangerous situations and attractive targets. You are not authority, not trained, and not a target that attracts attacks. You don't need the gun, you want it "just in case", makes you feel "bigger". What else must you be allowed to use just because someone else is? There are bigger hurdles to clear for many other things that are less critical than obtaining and using guns. Why not have some formal training, medical checks, background checks, exams, etc. for getting/using something close to an assault rifle?

> carry guns because they are an effective method of stopping an attacker

No, the effective method is to prevent the attack altogether. Something the rest of the western world is far closer to, even without guns. Education is a wonderful thing. It's the inability to educate and prevent this kind of behavior that makes you live in a society where you "have to" walk around armed "just in case". Instead of preventing a fire, you're letting it start and then soaking the house in water. That's just what you do when you failed at every other step and there's literally nothing else to do.

> The lack of relation

Now you're just hiding your failed argumentation under a layer of insults. Is it working yet? Nobody asks police/military to not carry guns, surgeons to not use scalpels, pilots to not fly planes, or physicists to not fire lasers. Just make sure guns (and all other examples) don't get in the hands of people who can't make or understand a rational argument, let alone take life or death decisions.

> The most recent talk

The most recent mass shootings have shown that unstable people (especially children) with easy access to guns leads to tragedy. But by all means, if "the talk" said something else don't let reality spoil it.

Again, guns are not the problem with the proper brains behind them. Just look at Switzerland or Germany if you need proof.
It takes so little provocation to get humans at each-other's throats. Long term, i imagine that will be the undoing of our species.
Y combinator is more a math thing. Not a programming primitive. Highly doubt there's any Y combinators in the code being used to build this site.
Alex Pinto gave a phenomenal DefCon talk several years ago that really highlights this issue, "Secure Because Math". It gets into how modern ML/AI/Voodoo IPS systems essentially can't work because the training data or baseline is so impossible to accurately come up with.

https://www.youtube.com/watch?v=TYVCVzEJhhQ
Thanks for the clarification!

Even a "we tested this specific function, and didn't find an issue" would usually be helpful.

The situation I've faced as an implementer is that people show up asking about a paper (e.g. https://github.com/bitcoin-core/secp256k1/issues/238 ) I read the paper, it discusses a risk vector we were aware of and believe we avoided and I find myself somewhat surprised at the list of vulnerable implementations. This makes me worry that I didn't actually understand the issue-- maybe the countermeasures we had weren't really good enough-- and uncomfortable giving the really strong "not vulnerable" that the requester was looking for.

This is especially the case because the results in papers like yours aren't against toy implementations, but in implementations that I know are written by extremely competent persons.

The end result is usually that I go and read the changes that fix the vulnerability, if possible-- sometimes they're made somewhat surreptitiously and hard to disentangle from the other changes--; and convince myself that it really was the issue I understood it to be... and rest back on my prior constant time testing results and our design countermeasures to be confident that no similar issue exists.

> One could choose just random hobby ECDSA implementations and list them as likely vulnerable, these are just a few that are worthy of listing because of their popularity.

Fair enough. I think actually searching to see how many other projects have copied the vulnerable code might be a better proxy than stars, since there is no particular reason to click the star button if you're using a piece of code. Often end users will pick up vulnerable code via a popular program that links or embed it, and the bulk of users never directly see the repo for the crypto library.

For years searching for "python eddsa" yielded an extremely vulnerable first result (including setting K to H(private key), using double and add, non-constant time infinity handling, etc.) that by all appearances was some random hobby project but because it was the first google hit, it actually got used in a fair number of places.
But each time they get faster. This is hold weight if you have a lot of data points but in tesla case they are really young with lots of room of improvement which they've shown
They lack infrastructure because there isn't the demand for infrastructure. We build where there is demand, and the building creates further demand. It's a self-reinforcing cycle.
Sure. But the comment I was responding to cited the difficulties of buying specifically like scraping together a deposit.
It's not any different than selecting from a view.

Are CTEs an optimization barrier in MSSQL? I would've thought that the query planner could move the execution plan nodes across the CTEs.
No obviously not, but I would think they have influence on the name.
"Upping the PIPs"? Is that a thing? For a company to formally raise the bar across the board as a means to not give bonuses or raises!

I wonder if having Amazon on your resume is a bad signal now. Risk of the candidate being a participant in a toxic environment. Also a signal that the candidate was at Amazon because they couldn't get into other FAANGs (is it common for people to select Amazon over others when holding multiple offers?)
Non-controversial, manufactured advice that pretends to be insightful.
Since when have we had free speech in the west? If anything we're more free than ever ever been. Being anti-Christian would get you barred during the founders time, being pro-communism during the cold war got government attention and black listing, not being patriotic enough got you in trouble in WW2, being pro-union used to put your life at risk.
I think so many of us dream of having the financial freedom to be able to do this. At least for me, that's one of my big drivers to build passive income streams and lifestyle hustles.

Honestly, that's the kind of teammate I deeply love to work with - one who doesn't _need_ the job, but one who _wants_ it and believes in what we're doing.