skysight-inc/HackerNews huggingface dataset:
I'm just quoting the manual here. I have no idea which style is really prevalent in the wild, now or X years ago.

My goal was only to cast doubt on the idea that WHERE clauses in general can't use indices.

Sure, let's debate what the nicest style is. But let's not claim that our preferred style somehow makes the DB go faster (without some kind of proof).
Yeah, they would have had to download it, sign up, and add us.

She already knew what she wanted to watch, and we were all up for it, so it was just a scenario where it genuinely wasn't useful.

Definitely tongue in cheek!
agreed!
publishing is the hardest part.
What do you mean by "more efficient and lighter methods of delivery?"
Its a pro assad news site.
> Page was convinced that Google could use a CEO after all. But only if that CEO was Steve Jobs.

That was in 1999. Steve Jobs had returned to Apple by then, but wow, the valley would be a different place if that had happened.
I can easily define as many email addresses as I want to, and use a different email address for each correspondent. This way, I can disable that address if it receives many messages that I don't want. The same is true if they paid me for it; I would disable it if I received anything that I don't want.
Of course they should, but it just doesn't seem to work out like that.

I was basically pushed out of my previous job because I was the bug-fix guy and liked it.

When I was the 'new stuff' guy, I got big raises every year. When I moved to being the bug-fix guy, and other people were the 'new stuff' people, suddenly I stopped getting good raises and barely met inflation. Even my coworkers were heaping praise on someone who I knew was over-complicating things because he was doing new stuff.

As I was leaving, a system that I had rewritten twice was up for another rewrite for more functionality. I would have loved to do it, and I knew I could. They gave it to someone else. I heard, 6 months after I left, that they failed and gave up on the rewrite. I am absolutely certain I could have done it again.

Getting a new job got me a 40% pay raise. It's not that I wasn't still worth a lot more every year. It's that they couldn't see it because it was all maintenance, and not shiny new stuff.

I still prefer bugfixes, and I still rock at them. But I end up doing mostly new stuff and don't say anything because I know how that goes.
Trivial. All of the tooling, dependency management, linking, etc. is neatly bundled together under cargo. Just run "cargo build" for the current system, or specify one or more other architectures as arguments to get multiple binaries. Everything's statically-linked so you should be able to scp those wherever.

Still, when we're talking about casual "scripts" even this extra step seems a little bit burdensome
It's not because the way it's made it makes it easier for hundreds of untrustworthy companies to track you...

It says it's about respecting the privacy of users better but in practice it fails very bad at doing so the only thing it archives is allowing Google to disable cookie based tracking and with that makes it harder for 3rd party trackers to be google independent (it not harder for 3rd party trackers if they use/abuse the FLoC Id and generay there are many ways to track users which are not cookie based so especially when it comes to the very bad offender of invasive tracking it doesn't make a difference or becomes even easier, but some of the smaller google ad (and analytic) alternatives will have it harder).
To put is cynically, everyone knows that yesterday's tools don't work. So it's better to try today's tools, which you don't yet know don't work. This allows one poorly thought out idea to replace another - especially when selling new stuff is profitable.

That said, it's implausible that the main problem is scaling since mainframes scaled considerable data quite a while back.
On the contrary, the websites who display ads steal screen space on my machine without paying me for it, some of them even steal computing time by running unauthorized scripts.
Not sure what crypto adds to this. Just make a local currency, then you can have physical cash as well as digital.
> MAGA > Civil War > Jan 6th

Rhetoric about civil war was on everyone's lips in 2020. Both conservatives and liberals increasingly expected one. Conservatives were more 'ready' for one, being opposed to the status quo. Stating that you're prepared to fight for your beliefs in an extremely heated and increasingly repressive political environment doesn't make you responsible for that environment. This is a lot like the whining about Trump's 'fight' rhetoric which his defense skewered with their mashup of more extreme rhetoric from his detractors.

FWIW revolution was never going to happen though. Americans have no revolutionary potential.

> The shirts: https://www.google.com/amp/s/www.vox.com/platform/amp/the-go...

A handful of edgy shirts at a massive protest does not an insurrection make.

> "It's just a prank bro" doesn't really hold a lot of water when the actions taken at the event look indistinguishable from what the "real" version would look like.

I don't think you know much about what a "real" one looks like.

> Violent chat in their private channels: https://www.rollingstone.com/culture/culture-news/capitol-ri...

Again, a lot of empty hyperbole from a small minority, par for the course with 'the resistance', antifa, etc.

> An analysis and reporting of the Maga mob's garbage chats: https://idontspeakgerman.libsyn.com/77-capital-coup (audio)

I've had to sit through I Don't Speak German before. Garbage, unsubstantive regurgitation of bourgeois talking-points. No thank you.
How so? Character doesn't necessarily mean ASCII char nowadays, if that's what you mean. And other than that I don't know how it's a mistake to have a concept for the individual parts that make up a String.
Cohorts could be reverse-engineered to give you a probability space of browsing history, which would be identical for any user in the cohort given a single sample.

> There isn't really any hard bound on how much information could be leaked via these algorithms.

With ~33k cohorts, there is literally a hard bound of just above 15 bits per visit. That's still theoretically a lot if you have some other stable identifier, but practically speaking most users on most sites will have an identical cohort and it will drop off rapidly as cohorts stabilize into groups appropriate for ad targeting.

Barring the other considerations I've mentioned in the comments here, that's still immeasurably better for individual privacy than ~infinite bits per visit from stable third-party cookies.
Is this really discrimination? Their algorithms showing ads to those who click them does not seem discriminatory to me, but rather just a probabilistic guess at showing the most relevant content that is most likely to convert. That hardly seems impeachable to me. I would also be curious if algorithms that don’t know gender as an input learn it by proxy anyhow, because there are real differences in how people behave based on their gender. There are, after all, significant psychological differences between the genders that hold true across national/cultural lines (https://en.m.wikipedia.org/wiki/Big_Five_personality_traits).
That's adorable, I always thought it was cute when tech people made things for their partners.

I'm hoping to make something for our anniversary that she'll actually enjoy :)
> Could you help your users spend one hour a year learning about what’s coming for the world, climate-wise, with a small dose of civics to go with it?

Good luck. You can't get a random user to spend an hour learning. You have approximately two sentences.

Like, take YouTube. They've added various "learn about the COVID vaccine" or "here's something to do with Black History Month" rows in the recommended feed to me. I've x'd out of every one of these civic recommendations, pretty much regardless of the content - I'm in the app to get a chill videogame streamer to fall asleep to anyhow, if I'm in the mood to become more informed, I'm not lazily scrolling through what's new on YouTube. Pretty much all those sections have done is told me that Google is, as an institution, pro-vaccine and pro-cultural-left (broadly construed). I already pretty much knew that.
From my understanding the CS:GO matchmaking basically ranks how likely of a cheater it thinks you are, and matches you with people of a similar ranking. If you're queuing with people that are bragging about blatantly cheating you're probably in the "likely cheater" group.

This is all really just anecdotes, but here's my counter anecdote. I play csgo on and off with friends. None of us have ever cheated in csgo (or any other competitive online game for that matter). I'd say we get about 1 obvious cheater every 50 games, with 2-3 less obvious "maybe they're using wallhacks" as well. This is significantly improved from 3-4 years ago where we got a cheater once every 4-5 games.
Did it again! I think you are mostly looking to hire yourself.
What San Francisco tech workers feel is to blame for SF's tech woes
>Instead of “how can we find the smartest people?” think about “how can we find people who will make our team stronger?”

I would have thought that was obvious? Why would you hire someone unless you had a need for their talents?

I guess I'm probably thinking small-business. At the biggest companies, they probably just hire and hope to fit them in because hiring for exact needs doesn't really scale.
As with all things, it's a balance of several competing interests.

If the string is stored in a contiguous array of memory, you can maintain a pointer to the start of the string and then do some pointer arithmetic to get char n. This is an O(1) operation.

If you store the string as a linked list of characters, then to access the nth character you have to follow a bunch of pointers until you get to that char. This is an O(n) operation, and it's going to take up more memory (4/8bytes per pointer, plus a byte for each character). Also it can make your memory fragmented. The upside is that you can grow and shrink the string. Adding chars to the front or end will be O(1). Adding chars in the middle will be O(n).

In the array case, if you want to modify the string you'd likely have to allocate a new block of memory for the larger string and copy all chars over. That will be an O(n) operation.

Null terminated strings are annoying because you don't know how big the string is without reading it. So getting the length of the string is an O(n) operation. The plus side is you don't have to carry around an extra byte(s) to hold the string length.

So it really depends on what you're doing with the string. Are you reading the string and accessing random characters often? Then an array is better. Are you mutating the string often? Then probably a linked list is better. Do you need to know how large your string is? Then keeping a byte around to indicate that is useful. But if you often read the entire string until the NULL character, then that extra memory dedicated to its length is wasted.
Depends on the program. Sometimes I use shell scripts, and sometimes I use Node.js, and (more rarely) PostScript.
Integration with Google services and account
Erlang is the well maintained OTP language on Beam. Elixir being newbie friendly tends to generate first blushes of excitement...I mean “awesome erlang” is approximately OTP and the standard libraries. Nobody is trying to become famous with it. The idea is to avoid churn instead.
Your last point perfectly encapsulates the value of a shutdown corner in American Football. Their counting stats (interception, passes defended, tackles) are generally very low, but they are one of the most valuable player archetypes in the sport. A good one can make the other team’s top wide receiver a complete non-factor because the QB rarely even throws to his side of the field. To even get that receiver involved requires scheming around freeing him from that coverage, which tacitly allows the defense to dictate how the offense calls plays.
As a user, I'm very happy the stores impose stringent rules.

"And there are all these stupid requirements. I need at least X screenshots, and they have to be this exact resolution blah blah blah. On top of that, it took so long to get approved. My ADHD brain really suffered waiting for the gratification."

I would hate to browse a store where the products didn't have at least X screenshots with at least X resolution, etc etc. The process for getting into the store shouldn't be easy and the quality bar should be high. I pay Apple to uphold this bar by any means necessary.
Not a single word of how much THC in the blood is too much. Many countries have drug tests that sets limits already so it really shouldn't be hard to find.

In Denmark 0,001 mg THC pr. kg. blood is the limit. At above 0,009 your license will be confiscated.
Honestly reading about this ,none of this sounds any bad. There are worse interviews where you make videos of yourself answering questions about yourself and posting them on anonymous servers.

Then on the other side of the spectrum is the whole leetcode thing where you solve 3-4 leetcode hard questions in 45 minutes while someone is staring and judging you for asking clarifications on questions.
Fast, stable, feature-rich, well tested, excellent security, continuously updated, first-rate support on all websites, cross-platform continuity, best extension ecosystem, excellent developer tools, easy to run different channels (e.g. stable and canary) simultaneously. I would use it on mobile if it supported extensions.
Patent trolls are terrible.
Most cost is producing content, not hosting.
> I tried getting her a card, but none of the local banks would do it, and even the prepaid cards that you buy at supermarkets will not allow you to activate in your name unless you are a certain age.

I know this comment doesn't address your absolutely legit larger concerns, but for anyone else in this situation: I'm having a good experience using Greenlight (https://www.greenlightcard.com/) as a solution for my pre-teen kids.
Alibaba Hit with Record $2.8B Antitrust Fine in China
Do you know which extensions are not available on Firefox? I'm considering moving to Firefox and feel like after I move there'll be that one Chrome extension that isn't on Firefox.
Except the privacy conscious just won, so there is no need to compare it to the former status quo. Why squander our victory?
do you have some resources on this?
> How so? Character doesn't necessarily mean ASCII char nowadays, if that's what you mean. And other than that I don't know how it's a mistake to have a concept for the individual parts that make up a String.

But why? It seems like having a `Digit` type, and having a `NatNum` type that's `List<Digit>`.

(OK, to nerdsnipe myself, that runs into trouble with leading 0's, but hopefully the point is clear. `0 | NonZeroDigit:List<Digit>` is maybe more accurate but less punchy.)
So the runtime will just randomly segfault or cause memory corruption? That wouldn't make a very useful language, maybe they have a workaround.
SCHB, SCHF, and SCHE.

That's a bit of an oversimplification because I do have some other assets I've picked up over the years. But the bulk of my net worth is invested in those 3.

If I were to start over again I might even just hold SCHB, which I feel has enough international exposure to make SCHF and SCHE somewhat redundant, while also being more efficient for taxation purposes.
I try to use Firefox (I do) but there are still issues every now and then and I find that I have to use Chrome for something at least once a day.

Most developers develop for Chrome and don't even consider Firefox.

I'm not particularly fond of Google (and growing less fond by-the-week) but the best I can do for now is use Firefox for 95% of things and keep Chrome around for the rest.
The permissions system for functions looks really neat. Lately my favorite features in a language are the ones that allow you to narrow down a function's contract with the calling code in interesting ways (in fact I'm working on one right now that's built around this idea)
No matter what my current dreamboat browser is at home, I always use Chrome at work. Their dev tools are unparalleled. I’m amazed MS hasn’t poached the Dev Tools director to work on VS.
Ghb leads to memory problems, its addictive and indeed, mistakes in dosages can send you right to a heart attack..

Source : addiction happened to people i met and the HR happened in a friends party.
> Im quite happy drugs are banned and not mainstream so that my children will stay away from them and maybe try later when they feel more mature.

Illegal drugs are much more accessible to teenagers than alcohol is.
I don't actually think LuaTeX is capable of even handling right to left languages like Arabic, Hebrew and Farsi. Only XeLaTeX is. Or am I wrong?
Would it take too long or not? I feel that is the deciding factor.
It's a very good question, I'm afraid the answers will mostly be shallow post-defacto justifications. I think we do many things autonomosly, reflexively, and come up with justifications after-the-fact.
Habit. Also my employer some years ago settled on GMail and Google Sheets/Docs/etc. (Not that they don't work well enough in Firefox.) I tend to use Chrome for work and Firefox for personal stuff, just as a convenient way to keep GMail accounts separate.
Ok, then don’t patronize sites supported by ads.
I have the same experience on Roku. It was bad enough that I cancelled prime and started pirating the couple of prime shows I wanted to watch. The Plex app on my Roku runs great...
What It’s Like When a Billionaire Surprises You with $8M
The hurdles are high but if you’ve been doing mobile releases for a while, they aren’t that bad. There are more asset requirements now but I think dealing with iTunes Connect back in the day and all of its friction was harder.
Maybe you were "solving" something that wasn't a problem.

Perhaps the process of talking about what you are going to watch together is a valuable and fun part of your relationship in of itself.
I was there when IE was better than Netscape. Gmail became a thing and I loved Google and their quality since.
Senegal has a currency. It's a regional currency with several other West African countries and it's pegged to the Euro.
I use Chromium, but I've always had a better experience using hardware acceleration and it runs a lot faster than Firefox when playing videos and having multiple tabs open and uses less resources.
That was a fun read. Especially the funny bit at the end. Did you consider making this a progressive web app?
> How do you distinguish alcoholism from alcohol abuse?

Alcoholism a behavioral health condition which inclines one toward unhealthy alcohol use.

Alcohol abuse is a behavior which can exist with or without that underlying condition.
Source engine itself is at least 16 years old, and has pretty direct lineage to the original 21 year old Quake engine (Quake (-> Quake II) -> GoldSrc -> Source). I would be more surprised if there weren't lots of RCEs in it.
Lets not pretend that ads help people with less money. Ads are designed to manipulate people into buying things they don't need.

They encourage people to believe their self worth is linked to the things they own. That a persons status in society is somehow associated with how much money they have to spend.
> be an engineer yourself before attempting to manage some

I honestly think this is a luxury for a lot of companies that are trying to transform themselves into a tech company.

When I took time off from my first failed startup attempt, I ended up working for a fintech and it was obvious that a lot of the "tech managers" were not technical people themselves. The challenge for this fintech, which had close to 1 trillion dollars in assets, is they couldn't really attract engineering managers and they had to make do with the people they had.

This is why "engineering metrics" is currently gaining a lot of steam. A lot of managers and organizations are suddenly finding themselves having to manage techies and they are desperately looking for ways to compensate for the fact that they aren't tech people themselves. This is why when companies see solutions like GitPrime, GitHub Insights, and other similar solutions, they get very excited because they feel they found that magical translator that can help them better manage tech employees.
Sounds like an app opportunity right there.
What is the difference? Wouldn't it only matter if the patient was somewhat in disadvantage?
I think this practice is widespread and kind of why doctors despite not earning much seem to be happy with how things are. In my country they don't even have to declare any cash and hospitality benefits.
Chrome dev tools are great. Or maybe I'm just use to them by this point.

Chrome also just by far has the best compatibility throughout the web. Whenever I try going to another browser, I always keep a copy of Chrome just so that I can pay utilities (because, of course, their site is broken on Safari, for example).

Also, I use all three major desktop OSes, and Chrome has been the most consistent throughout all 3. Firefox use to have serious rendering issues on macOS; I believe they may have been fixed but I can't be arsed to keep track of that.
Wow, I don't know exactly why, but this made my skin crawl.

There's so many red flags. I hate these philosophical questions, you're just trying to prove you're clever. I hate contract periods, it's just firing people with cover. I hate that you make these decisions unilaterally, you clearly think you're good at hiring but this just means you're not asking others to help with your blind spots. You refer to yourself as a leader, which just makes me cringe.

But most importantly, you clearly have no respect for your team because you don't believe they can interview without being horrible humans. If nothing else, wouldn't the candidates want to meet their peers?

Everyone's allowed to hire however they want, and that's a good thing... means there's lots of jobs for different types of people. But I have a strong feeling you have high turnover and a pretty bad company culture based on the way you talk. Or, you've never really built a team, just hired a few one-off people.

If you're reading this, please don't hire this way.
Fortunately, removing a feature and removing code is pretty easy. It's when a feature is added that it requires much more thought and effort.

It's not zero effort, but pretty easy.
Our quest to understand the brain [video]
The world is fast. Bad Brains are faster
You found a video that says that they detect most old cheats from hl2 days and ban them and then the video just goes to show random github repos. What is that even supposed to prove? Theres nothing stopping anyone from creating repos with cheats that get detected or don't even work. Like it's just a super cringe "gotcha" type video
The complaints about having to have enough screenshots and information seems really ... dumb? The website has a bunch of screenshots and info, and users will not download the app without it. Google and Apple are doing you a favor by requiring that you provide enough information.

I think Apple's $100/yr is crazy, but I don't think Google's $25 is bad. If you plan to make any money at all on it, that's nothing.

Scrolling through the site, it feels like the site is constantly hiding information from me, and then spoon-feeding me bits that I don't care about. The text doesn't even show up until it's halfway up my screen, and then it's just a scroll or 2 from disappearing. Scroll too fast and it's really hard to read. Maybe you should animate the information leaving, instead of appearing. You definitely should provide more information in a readable form.
>This is literally the first time ive heard about that.

I had hoped it was common knowledge that alcohol withdrawal could lead to fatal seizures. People should be aware that going cold turkey (abruptly stopping heavy drinking) can put them at serious risk.

"All the people who want to do drugs are already using them, but society will crumble into degeneracy if they are legalized"?

What do you anticipate changing if they are legalized?