skysight-inc/HackerNews huggingface dataset:
There’s

class AmazonAffiliateLookup(models.Model, TotalCountMixin)

I guess that TotalCountMixin adds some triggers that maintain a count of the records in the table in a separate table (could or could not be a good idea, depending on the table size, relative frequency of ‘give me the number of items’ calls relative to inserts and deletes, etc, but might introduce a bottleneck on updating that count)

There also is:

song = models.ForeignKey(Song, on_delete=models.CASCADE)

I don’t understand why that foreign key is there, but it can’t speed up inserts and deletes.

Then, we have:

created = models.DateTimeField(auto_now_add=True, db_index=True)

I think creating an index is done to implement the equivalent of Redis’ auto-expiry.

Again, that may be suboptimal if there are few records in the database. DateTimeField also may be ‘too structured’ for the task at hand (it might needlessly parse year/month/day out of time stamp in nanoseconds, for example, or even do time zone calculations to convert a local time to UTC), but I don’t know. It would be helpful if the text showed the actual SQL DDL.
The operational problems can't be understated either. Customer service experiences that are all over the map (Ranging from they came out to my driveway and fixed my car to its been in the shop for 3 months with no end in sight), production issues, QC issues, engineering issues... for every way they tend to "surprise and delight" they also tend to find ways to horrify by not nailing the basics.

And you only get to play the startup card so long. Tesla is indeed a 16 year old company whose production struggles look even more troubling considering their growth isn't what anyone would really consider hockey stick, and their competitors have none of their scaling issues.

Add in a leader that has shown some stability issues, and its tough to make a case for it.

Personally, I root hard for Tesla the company, want to see them succeed, and after recently buying a house with a parking spot, may buy a Tesla as my next car, but I am not buying shares anytime soon.
I have tried this, and it was very slow. I have had better luck with gvim or neovim-qt
Show HN: SeqALib – Efficient Sequence Alignment from Bioinformatics
Most? I have been working for almost 17 years and have only had shares of any kind as part of my compensation for the past 15 months. I have yet to actually get any of those shares as I switched companies in the middle of that period, so I have literally never, to date, received shares as compensation in my career.

My wife has never received, and likely will never receive, shares as part of her compensation considering all of her experience is with non-profits.

Also, I suspect you meant "private-sector" here, not "public-sector" (i.e., government work).
Let's not forget the issue isn't really the language, but the anti-patterns that can create absolute hell.

See Rails callback hell as an example.
Restricted Stock Units (RSUs) are a standard component of compensation, at least for higher-performing employees, at many large tech companies. An RSU grant is a direct grant of shares, conditional only on the employee remaining at the company through the vesting date. I've received them, and know others who have.
negative properties doesn't mean there aren't any beneficial properties. maybe fermented food are good for our gut biome or something, which impacts our metabolism and fat levels, which impacts our hormones levels, idk. you're missing the point.
This is a post by Cliff Mass, Professor of Atmospheric Science at the University of Washington, who maintains a great blog on weather and climate. This post is an account of censorship, reduction of academic freedom, and bullying. It's also part of a larger trend of academic grounds being forfeited to rabid activists.

> Academic freedom and freedom of speech are acutely threatened at the University of Washington’s College of the Environment by the actions of the Dean and other college leadership.

> As only one faculty member, I simply don’t have the clout to fix this alone. Furthermore, my ability to tell you honestly about what I believe regarding climate and other topics in my blog is threatened.

> Now I need your help. The only individuals with the real power to fix this situation are the UW President, Provost, and members of the Board of Regents. Let them know that you value academic freedom and constitutionally protected freedom of speech (contact information at the end of this blog). Tell the UW administration you expect the COENV leadership to follow university rules and to protect diversity of viewpoints. If you use social media, let you friends know about the problem and ask them to assist.

Contact information:

UW President Ana Mari Cauce: president@uw.edu

UW Provost Mark Richards: provost@uw.edu

UW Board of Regents: regents@uw.edu

Chair, UW Faculty Senate: jwj@uw.edu
There's something about the sound of clacking keyboards that's more intolerable to me than nails on a chalkboard. It's pretty inconsiderate to use a mechanical one in a shared office
Sounds like OCD or at least severe germophobia.
It's because Tesla is still a pretty risky investment. It still remains to be seen what sort of "moat" they really have in the EV space. Most other major manufacturers are preparing to launch EVs over the next 3 years. It may turn out that Tesla really is a few steps ahead technologically or all of the guys that have been building cars for the last 80 years may eat their lunch.

But I do agree that they could definitely use a COO. Musk seems like a bright guy but I'm just not sure how suited he is to handle operations at scale.
The shares I and my peers receive for employment add up to ~0.3% of my employer's outstanding shares/year.

In 30 years, that might pool into ~10%. However, there is no mechanism for me, and my fellow coworkers to turn those shares into any kind of power over the board.

Me personally controlling a tiny fraction of a percent of voting shares does not make my interests align, in any meaningful way with the board. It also means that I have no ability to influence the board to consider my interests.

I need to act collectively, with like-interested co-workers, to have any influence. However, there is way too much friction for me, and like-minded coworkers to meaningfully undertake any collective actions.

In fact, this is understood so well by my employer, that I, and my peers receive non-voting shares as my compensation. I'd never be able to put the voting power to use, anyways, and neither will anyone else who has to gasp - work for a living.
"Having money's not everything, not having it is"
I think you understand perfectly well that I'm commenting on referring to catastrophic famine as 'a feature, not a bug.'
My problem with your "solution" is that it only works under very narrow assumptions. E.g. how does the Netflix client handle such a redirect? At best with "bad connection", I'd presume. I'd hope they would at least forward a better message when using a proper standard to do the blocking, if they consider this worth the effort.

(And yes, I set up a similar easy makeshift DNS solution to "authenticate" for the un-encrypted WLAN i had many years ago)
> you will be desd

our dsying …
Great. First thing we have to do is figure out a way to evaluate teacher school, something that I'm sure will be totally uncontroversial to do and not simply be a group of people bringing all their own biases in.
Okay then I don't get it. What even is the point of secure boot when your entire goal is to run arbitrary kernel mode code? You're effectively always running in test-signing mode on Linux -- your entire goal is to be able to run your own modules, which is what test-signing mode does. And if you want to be in that situation, you can permanently enable it with bcdedit; there's no need to constantly toggle it.

If your complaint is that you have to cough up $$$ to have your driver be trusted by other users' machines, yeah, I'm happy to rant about that issue, but that's not an issue with the "difficulty" of the process. That's like saying it's hard to use a Lamborghini because it's too expensive.

As for the names and patterns... idk, it's hard for me to see what's similar, except that both systems have file systems, both have handles/descriptors, etc... which is hardly an interesting point. Everything from the way you hook I/O to the way syscalls are handled to the quality of the documentation is vastly different on each system.
Big companies are good at following laws and great at following unfair laws.
This is the end result of all the Earth Day style propaganda. Regular people have made their lifestyles greener. And the impact it has made is not very significant, because the top polluters just kept on going. Instead of tackling the economic fundamentals that allow that to continue, the thought-leaders are just asking more and more ridiculous sacrifices to be made by consumers.

All the straws and all the 6-pack cartilages that make it into the ocean are nothing compared with lost fishing net detritus--the things that are designed to kill and capture marine life.
Amazon has been cash flow positive since 2003. Amazon has a unique negative cash flow cycle where they collected revenue significantly prior to paying their accounts payable. As long as they are constantly growing, it is basically like running a business on a credit card.

Tesla is in a completely different situation. Cars require massive upfront investment before their revenue is realized, and given the results just posted, Tesla will most likely post a quarter with declining revenue.

People should stop comparing things to Amazon. Amazon was successful because it was unique.
If you did not contribute to the pension funds, you get money as social care, at least in my Eastern European country (part of EU). You never have to work a day in your life, this is what a number of people are actually doing.
A lot of users spend their entire life in Office and various MS online apps. This would be worth having just for PowerPoint alone. It would let you keep slides open while presenting and have other apps open privately.
I would be surprised if gigafactory 3 cars are exported from China.

From what I understand, most domestically produced, internationally branded vehicles are sold within the county. (Audi, VW, Mercedes all manufacturer cars in China for domestic consumption)
> Right before the report they increase the expectations

Wasn’t the source of the 100k number Elon himself?

Wall Street analysts were estimating below Elon (and the actual numbers). It looks more like investors ignored Wall Street and took Elon at face value again.
I fell prey to the “sunk cost” fallacy - after the first full day when they asked me to come back, I thought: a) it would be a shame to “waste” that first full day of interviewing by saying no now and b) surely nobody would be a big enough asshole to ask me to take two full days off of work to interview with them only to reject me after the second day, so surely this second day is just a formality.

Apparently I was wrong.

And no, it was just a regular programming job, nothing special.
this looks an awful lot like buildroot. what are the differentiators?
The word "qualified" is pulling a lot of weight in your argument.

You can absolutely hire a programmer for $70k if you're willing to significantly relax your standards. On the other hand, you probably wouldn't be able to hire enough teachers at existing teacher salaries if you significantly raised your standards for what counts as "qualified".

Tech companies have to use a relatively high bar, because bad developers will drive them out of business, but such market forces don't apply to schools. Unless you want to completely privatize education (which has its own set of issues) we have to use the political process to drive schools to raise their both their salaries and hiring standards.
Can you elaborate further? Why is Java better than any of the other languages commonly discussed in hn?
Of course it's not the only 'maleness' that could be tested and analyzed, but the article say it is the one most strongly linked to autism.

> Prior to this work, the strongest evidence for a link between testosterone exposure and reduced cognitive empathy came in 2011 in a study that [...] supported the idea that prenatal testosterone exposure created a more masculinized brain that less readily inferred the emotional state of others. The study was used as support for the “extreme male brain” hypothesis of autism, which contends that autism is an exaggeration of “male” tendencies toward a cognitive style characterized by systemizing over empathizing.
Many people don't trust facebook for one. I have family members that explicitly decided not to use it, so having a focused product/company around the particular subject may be more enticing.
It works very, very well with the "duet" app. Duet supports Windows/Mac along with any recent iPad (or even iPhone).

The upcoming version of MacOS supports this natively but it's not clear to me yet how it will compare with Duet.
Presumably to prevent trafficking in minors like this:

https://www.westernjournal.com/border-patrol-busts-illegal-i...
You do realize that the Islamic prohibition on interest comes directly from the Christian New Testament, right? That early Christians forbade interest for centuries? That some Christian groups still forbid collecting interest?
Name any investment bank which started after 2008 and has some decent amount of market cap. My point is suggesting investment banks can make rational decisions is not based on facts. They make decisions which make most money or save existing investments. Aside from the level of toxic hatred on the stock what can you fault about the products they are selling nothing. Can you find another company anywhere delivering value/$ as Tesla I'm not sure.
Cash Flow positive every year since 2003, not necessarily profitable. (Though the were profitable for some of those years, they weren’t necessarily).
Sure, perhaps we will solve by shrinking ourselves down like the ants did to effectively expand our territory while reducing our footprint. It's clear that our current large size is economically inefficient.
Trans woman here. I agree that the neuroscience feels kind of flimsy. I would further argue that neuroscience shouldn't be used as an argument in favor of "accept trans women as being women" because, among other things, it can just as quickly be turned around by people who seek to pull the You're Not Really Trans Unless A Doctor Says So card on other trans folks.

We're women because we say we are - and that's really all there is to say about it.

We are disproportionately into things like coding because, growing up, the vast majority of us are socialized the same way as boys would be. Amazingly, it turns out that in a vacuum, the activity of programming a computer isn't actually gendered.
android-gif-drawable has an older copy of this lib:

https://github.com/koral--/android-gif-drawable/blob/dev/and...

Or perhaps the function from the libc was being used?
Or they don't want one. I like safety nets, they are needed for some people that cannot make a living on their own, but I don't want one for me. It's a huge difference between "like", "need" or "want".
And they didn’t amass nearly as much debt to get there
Unix did it Simpsons did it, but software
> the company would just pay reduced wages on the order of the amount of profit sharing, since it would not need to pay more to attract the requisite talent

Not necessarily true. Much of that talent might have joined precisely on the hope of receiving above-market compensation if the business did well.
> doing anything—getting the vacuum from a tiny closet or something out of a drawer in the kitchen—often involves a Tetris-like game of moving multiple other things out of the way. Right now, because I have one chair too many, lowering my Murphy bed from the wall means moving the chair, which then blocks something else.

This is the number 1 problem with a tiny living space.
As an experiment, you should let one rip at an opportune moment. Should be enlightening whether they carry on as if this is indeed normal or try to gaslight you about your strange behavior...
That study is worthless based on the small sample size. I'm also a trans woman and I hate when this study is brought up. I think brain development could be a reason but I also think how a person is raised could play into being transgender for some people. Our generation will likely never know for certain. I just don't think there is an all encompassing answer for everyone.
Hell yeah it is. Have an upvote.
The Parasite Awards: Celebrating rigorous secondary data analysis
They made money because the FED started buying the types of securities that they owned with electronically printed money. If this was China the whole thing wouldn't have even happened. The government would have just printed the money, recapitalized the banks and sold off their debts at a discount and punished (severely) anybody who violated banking regulation.

The whole fiction that the government has to lend money into existence from the FED and the FED can buy assets off banks from money created out of nothing is this complicated convoluted game is intended to make it hard to figure out what's going on and to make it look like actual productive economic activity is occurring here.
I see it like dating apps. When/if you find a partner, you may stop using the app and even uninstall it. However for some people they may end up single again and then reinstall the dating app.

As long as the experience is positive, people will return in the future if/when the need arises.
This is probably a really silly question, but how do astronomers and the like define "west" in this case? I assume it must be useful to have some sort of reference orientation for the galaxy, but how is it defined?
rabbits, dont make me laugh!
You're right, didn't think of that, Thank you.
How Feasible Is a Warp Drive?
I've practically stopped hearing about Tesla in the news, which must mean they're doing great. Great job, Tesla folks!
Or you happen to be in middle of nowhere, or there are other incentives like equity that you can use to make up for the subpar base salary.
Or maybe the older discovery that the Milky Way is a barred spiral galaxy. And may not have a pronounced central bulge.
It was item 12 on an ordered list. I know I struggle to get past item 7 on any prioritised list.
Andrew Yang's plan to make your data yours has crypto written all over it
It could also be to some degree there are very weird decisions that have been made at Tesla.

Lets just look at Kimbal who has been on the board since the beginning, with a multi-million dollar compensation package even though he has zero relevant experience in the industry and is a huge outlier compared to the rest of the industry. Sure they are making strides in electric cars but as a business its very out of the norm.
There is a place for debt in society. And that is: emergencies.

But why the hell does debt have to be the only way of creating money is totally beyond me.
These numbers are averages aren't they? Can someone speak about this that knows more than me, but isn't it possible for two siblings to pick up more or less genetic material from one parent?
He mentions that the height is 2,000 light years, so the deviation from the center is 55 ÷ 1000 = 5.5% (+- 0.16%)
I have no idea what my IQ might be. But, this all seems very, very familiar to me.
This is big news when the Facebook employees we are referring to starting salary is 120k a year and the median employee is 240k a year. [Note many people who work for facebook are some form of contract employees and thus do not make this, but it was also not a contract employee who recorded this conversation for they do not get to sit down with Mark in these weekly meetings.]

Even if you are not happy with everything about Facebook that income level often prevents this type of behavior for the incentives of company and worker align generally. And it is a big deal for this was a new thing, not a thing that never happens, but also not a thing that happens often that it becomes the new normal.
or am i laughing
I don't think this is true.

Intramuscular testosterone is the most common method of HRT for trans men / trans masc folks.

The effects of which are not "androgen".
As I recall from the lecture by Robert Sapolsky, researcher can look at a preserved brain and determine with a fairly good accuracy if the brain came from a woman or a man. Experiments has then show that for transgender people the same is true for the gender the brains person identified as, including for people who has not undergone any hormone treatment.

I would have to rewatch those lectures to see if he gave any direct examples of markers, numbers, or sample size.
Starlink can’t come soon enough. Imagine internet beyond the grasp of control freak governments
>Straws are a very small part of that and a weird thing to fixate on relative to all the other one time use food waste we generate.

Straws are completely superfluous. If you take away my straw I can continue drinking the beverage. Chips need a container, sure I'd prefer more bulk bins and recycled containers, but if we banned plastic containers for chips you interfere mightily in someone enjoying their product.

ANYWAYS, the fixation is from the bad actors, the trouble makers, the noisemakers.
Free No Logging and Blockchain Integrated DNS Servers
This seems like an extremely poor quality news source, and a presumption has little evidentiary value.
The way this would work is that people work out a target price based on that estimate, and the price should rise accordingly. In any case, they are only a few percent off, the fact that its a "miss" or a "beat" needs to be taken in accordance with magnitude. You are onto something though that a "beat" or a "miss," ever so slight, is generally followed by an increase or drop that tends to be excessive, but this tends to revert within a few days. Some stock pickers like to zero in on stocks that "beat by a penny" (per share) because that is often evidence of some kind of accounting shenanigans to just get over the line.

I don't follow Tesla stock much, but it looks like there was a significant bump in mid September, perhaps on some of these earnings forecasts being updated, and now the price is just falling back in line with reality.
"starts"

2001.
Don't worry too much about becoming obsolete. Frontend web development is my field and it moves faster than any other single area of programming. I took 5 years off due to burnout and it only took me a month or two to get back up to speed from a technical perspective. Putting up with the bullshit interviews is another story. I freelance now.
My ~65yo mother is single and although she has a good group of female friends she regularly meets with, finding a mate is much more elusive. I'm wondering how/if an app like this could eventually help this demographic find friends or partners of the opposite sex?
Ask HN: How do you define market size when creating a new catogory
We're creating a new type of media and solving the issues consumers face when taking quality photos and video.

Instagram solved the problem of making photos captured on mobile devices attractive by creating filters.

We're solving the problem of failing to get the best angles or failing to capture the context you want to capture and resorting to selfie-sticks, drones, or just accepting that the photos you take are limited to the fixed frame of what is captured by the camera.

We are looking at all sorts of adjacent markets to define our market size, such as Volumetric Video, etc.

I'm trying to think of something like GoPro, and before Action Camera's were a thing, how would they have defined that market size to an investor?

Any suggestions?