thomzi12

Hey, HN! Since I couldn't find a good resource online for the self-join and window function SQL questions I've encountered over the years in interviews, I made my own study guide which I'm now sharing publicly as a Quip doc. Would love your feedback or thoughts!

How did Clearview scrape so much of Facebook? Is this fundamentally hard for Facebook, Instagram, Linkedin, etc. to stop if someone determined wants to suck in photos for a tool like this?

Awesome! Some quick comments:

* What about non-human use cases, like shearing pets between seasons? If you can solve getting pets to stay still could be a possible initial use case. Seems easier to get traction!

* As pitched, this seems more like an add-on than standalone product. Where could this be an add-on? Airport bar? Airport massage parlor? You need people to get into the door, the haircut won't be it but it can be part of the experience!

* Would salons/barbers be interested in buying this device so that they can service more customers, i.e. increase customers/hour or a similar metric? Run some surveys/ask owners to find out!

* Youtube video for the next iteration of the product can be sharper ... see something like Paolo from Tokyo videos, etc. Editing matters. You want this idea to go viral!

That's really interesting to see more Latinx developers (7.3%) than East Asian developers (5.3%) as a proportion of all professional developers. It's an awesome surprise, but is there a measurement reason for this? Unfortunately, this doesn't match my experience working in tech in the Bay.

Contrarian opinion: repetitive writing is actually important in helping us remember what the article or book is talking about. Humans learn via repetition. If we took out the fluff, the article/book would be <50% as effective as it is with fluff and repetition.

*FAANG

Activists at an institution are very different people from the admissions personnel at an institution

Why didn’t he leave to the private sector?

What was the point of the rebranding?

I actually quit Prime after moving to San Francisco — it felt hard to justify when grocery stores and other shopping is blocks away. People forget about walking, haha. I just don’t buy enough stuff to warrant the subscription.

Did you not read the article? Millions of users took a personality test that had nothing to do with politics, and that data was sold to the Trump campaign for targeting.

When did Obama’s campaign ever do that?

I don't get the outrage over this -- haven't Uber and Lyft and Google been doing this for years?

Could someone compare this to Dask? Would you use the two in different situations?

Um, people have been “rabidly” consuming fiction since the Greeks created theater?

To echo someone else's post, saying you work at [a boring tech company] working on [boring ideas] is what is truly taboo in Silicon Valley.

Interesting article, kind of wish it started off with some context and simple reporting on the situation though -- I'm not familiar with the story.

Without earnings per hour metric, it's hard to make much of this post.

Yes, it helped. But how much jerkery are we willing to tolerate? And, for how long? Uber isn't an early stage start-up anymore.

What exactly makes you think Uber would hire your friend? This isn't Wall Street in the 80s where hustling is what matters. You have to have technical skills and experience working in tech. Your friend might want a job at Uber, doubtful he'd get one.