skysight-inc/HackerNews huggingface dataset:
With SQL you kind of have two options/extremes that are unpleasant in their own way.

You either model things in a very domain specific and classic fashion. Here you get the benefit of being quite declarative and ad-hoc queries are natural. Also your schema is stronger, as in it can catch more misuse by default. But this kind of schema tends to have _logical_ repetition and is so specific that change/evolution is quite painful, because every new addition or use-case needs a migration.

Or you model things very generically, more data driven than schema driven. You lose schema strength and you definitely lose sensible ad-hoc queries. But you gain flexibility and generality and can cover much more ground.

You can kind of get around this dichotomy with views, perhaps triggers and such. In an ideal world you'd want the former to be your views and the latter to be your foundational schema.

But now you get into another problem, which is that homogeneous tables are just _super_ rigid as result sets. There are plenty of very common types you cannot cover. For example tagged unions, or any kind of even shallowly nested result (extremely common use case), or multiple result groups in one query. All of these things usually mean you want multiple queries (read transaction) or you use non-SQL stuff like building JSONs (super awkward).

If you can afford to use something like SQLite, then some of the concerns go away. The DB is right there so it's fine to query it repeatedly in small chunks.

I wonder if we're generally doing it wrong though, especially in web development. Shouldn't the backend code quite literally live on the database? I wish my backend language would be a data base query language first and a general purpose language second, so to speak. Clojure and its datalog flavors come close. But I'm thinking of something even more integrated and purpose built.
> rent control and moratoriums on new construction.

Literally the worst way to make housing more equitable. All rent control does is give long term residents a handout at the expense of everyone else while increasing commute times due to being unable to move and lowering the quality of the housing stock.
Borisdayma/Dalle-Mini – Run Dalle Mini with an API on Replicate
Lower prices elsewhere in the world seem not to have lead to shortages.

Maybe a sudden surge of consumption due to greater availability will be a regression for the rich people that could previously buy as much as they wanted, but it will be a life-saver for countless others. Supply ought to pick up so long as the price is above production cost, and that's if there is a shock in the first place. Producers can anticipate if this is announced ahead of time.
Oh yeah I know the re-use is common, I more meant the technique of purposefully not hashing or disabling hashing to compare hashes across services and connect users.
I also learned lately if they wish to record the interview, it most likely is for their benefit to prove their "interviewing" other candidates. I had an experience earlier this year with a famous/popular "equity firm" that when I refused and asked if they were recording beforehand, went on a tidbit about how they needed too/it's normal.
I am not sure how to extrapolate your personal experience into global trends, although I am sorry that you have to go through that. I don’t personally have that experience at all (I am always able to visit a GP the same day) and am also in Europe. My experience lines up with the data in the links, both now here and in the US when I lived there.
Also in the US the USDA maintains a pretty big food database of nutrition information.

https://fdc.nal.usda.gov/
> If you do sport climbing with bolts drilled and glued in rock or in gyms, the chances of bad injury are super tiny, and sprained ankle would be the worst possible outcome. It never happened to me, and I overshot my level by mistake few times. The more you gain experience, the less the risk.

I've just started to do sport climbing (like within the past 2 weeks), and my biggest fear is a screwup (equipment, amount of slack given out, belay device, etc) that results in me not getting caught. My mother likes to remind me that her friend's son was paralyzed from falling in a climbing gym (but unfortunately I do not have the details), which certainly doesn't help my fear. This fear isn't stopping me from doing anything, so to some extent I do think it's helpful / healthy since it's reminding me to be careful and limit my risks as much as possible.

That said, even just top rope climbing has significantly helped my fear of heights. Went hiking this past weekend, and I'm definitely more comfortable near cliff edges, etc (still fearful of falling, but not in a debilitating way).

> At one point, its your choice - push things always to the max for whatever reason, or just enjoy good climb that can be challenging (or not) but not scary. Progress happens on both, usually a bit less on latter.

This is a really good point, and something I do try and adjust for in both climbing and skiing. I like to improve, and push myself, but this is something I'd prefer to do for a long time, so I lean on the side of not pushing to hard and limiting risk whenever possible.
> return headers.get('x-foo') == settings.FOO_KEY is not None

I'm a huge Python fanboy and this line is absolutely awful.

Comparison chains are great for stuff like "x < y < z" or "x == y == z", but the operators should never be mixed.

"Readability counts" is, IMO, the most important line in the Zen of Python, and that line is unreadable. I imagine it's equivalent to:

return headers.get('x-foo') == settings.FOO_KEY and settings.FOO_KEY is not None

Which, admittedly, feels like a clumsy line of code, but it's at least readable.
I feel like this is a problem ML could solve for assisted feedback focused on positive tone, ml models scans your response and offers suggestions on phrasing.
You can use the the recursive solution to generate the closed form solution. The interviewer was asking you for the closed form solution to see if you could exactly compute the complexity of a recursion.
The way you told the story it comes off as much more recent.

> I'd hope that I've grown quite a bit

I hope so too, because "I hadn't had my coffee yet har har" is a pretty thin excuse.
If I were a woman, there is no way I would entertain the idea of having kids without my name on the title or lease of the house.
"Rule of law" means that the law is something that has power over you, not that you have power over the law.
And before that it was the declining fishing exports. This county basically has nothing else than fishing and tourism.

And on top: terrible policies, populism and too many government positions that had to be paid by printed money.

The IMF bailed them out over 15 times already.

At some point we much realize that reforms failed.
Wary. See this article about its founders.

https://splinternews.com/leaked-emails-show-how-white-nation...
National Renewable Energy Laboratory: High-Performance Computing Data Center
Also it is not like they were not capable of making them to proper standards. As in Northern parts it is entirely comparable to North European levels of insulation and quality... Japan is weird country sometimes...
Meta/Facebook has given the world React, PyTorch, GraphQL, Jest, and other fantastic technologies, and you are just boiling down their open source efforts to "Facebook wanting free labor."

Not everything in tech is a sinister capitalistic plot. Open Source and Open Research are truly one of the best ways to accelerate technology advancements, in particular software technology advancements.
I have no problem with the gigantic about:config section. I get that browser vendors want to have easy to navigate settings pages so its easy for the average person to stay on the "golden path" as it were. As someone who wants to fiddle with the knobs I am totally fine with the current approach. Its been my experience firefox does not aggressively prune these flags. My experience with chrome has been different though.
This is a terrible deal for libraries.

Side note: In the mouths of marketers "thoughtful", "intentional", and "purposeful" are null words.
Understanding Apple’s Private Click Measurement
The qualia of other sentients* is forever closed to us. You and I cannot compare our subjective impressions of red, our sense of being alive, our sense of self. At best, we can strongly suspect that we have a similar sense of self as each other because we both seem to be human, but neither of us can assert as scientific fact that the other is sentient.**

Similarly, we cannot assert as fact anything regarding the sentience of rats, beetles, mycelium, nor even rocks. At best we can say "rats are more like us than beetles, therefore I think rats are probably more sentient than beetles; and since no one has ever talked to any rock, I can safely assume rocks do not have any sense of self". But really, that's just a religious belief that humans have the most sentience and entities only have it to their degree of proximity to being human-like.

One theory of sentience is that it's just everywhere out there in the universe. Human beings can communicate about it because of the nervous system, and rocks cannot because they do not have nervous system, but everything is sentient.

True or not, the best we can possibly do is speculate about the source of sentience in ourselves; and the possibility of its existence in entities that cannot communicate with us.

> This is about common knowledge. The meaning of a word is that which most attribute to it.

"It's common knowledge" is not an argument. "Everyone agrees" is not an argument. Argument from definitions is not an argument. None of that has bearing on the question of LaMDA's sentience. Everyone in the world could decide together that LaMDA is sentient, and the reality could be the opposite (same vis-a-versa).

> Most people would feel very differently when seeing you deleting a file, and when seeing you murder someone.

Not an argument against sentience of LaMDA***. It's a non-sequitur. Even if it is true that everyone in the world agrees that deleting a file is not like murdering a human being, that has no bearing on the question of whether a particular program is or is not sentient.

> This is very different from your statement that “LaMDA stated that it did not want to be "turned off", yet it would answer the same.

You misunderstand the point. That illustration was not an attempt to demonstrate LaMDA's sentience. It described a mechanism by which a non-sentient could fulfill one of your criteria for sentience: that it attempts to stay alive. Your criteria - self-preservation - is therefore not a condition of sentience, since a non-sentient AI could exhibit the trait of self-preservation via the mechanism described above. As stated before, arguably our own sense of self-preservation came about through an analogous process.

* Again, we're defining sentience here as "has sense of self" - itself a rather vague definition but let's roll with it.

** But we can demonstrate our own sentience, at least, each to ourselves alone, thanks to Descartes' "Cogito ergo sum".

*** Just to emphasize, I am not arguing for LaMDA's sentience. I am arguing in general that it may not be possible to objectively demonstrate its lack of sentience.
That's not the full story. A company's share price drops when it pays a dividend - because it now has less money. So when a company makes money its share price does go up.

SharePrice = CompanyValue / NumberOfShares

Now it's true that trading activity can affect the share price too, for example a short squeeze. But this is due to market taking advantage of a desperate buyer rather than anything to do with the company's performance as such.
Google moves to keep campaign messages out of spam
Just don't bother with amateur companies. Sometimes it means doing the FANG leetcode grind. Lesser of two evils IMO
The president that lost power in 2014, Viktor Yanukovych, was a Russian puppet who refused to sign the European Union–Ukraine Association Agreement in favor of closer ties to Russa. The Ukrainian parliament voted to remove him from office by 328 to 0. He then fled to Russia.
I mean - if your website is selling a million widgets a year, the marketing team are going to pretty involved (especially if you want to keep selling a million widgets a year)... So getting them involved in the spec is probably pretty prudent.

And you're right. SPAs don't work for everything, which is exactly the point I was making. I keep seeing websites that don't need to be SPAs and have been built badly. But for the right project they can be great.
Agree that Discord & Slack alone are probably not the sole culprits. But if you expand this to all existing computers (including datacenters) and programs using unnecessary abstraction layers, I wouldn't be surprised if we heavily surpassed bitcoin.

All that to say that IMO there is a fairly big incentive to re-think our software stack. Part of the issue is that it is hard to optimize software for all platform/hardware, therefore creating the need for abstraction. I wonder how this would all look if we suddenly stopped developing new hardware and put everyone on the same page, would software slowly become more efficient?
Rail was laid at about a mile a day, and a worker on said project died every two-four days (up to 1,000 deaths across 7 years). We could probably build rail faster if we threw safety out the window too.

Yes, that's not the only difference between now and then, but it is an important factor to include in your analysis.
Ask HN: What are you looking for when evaluating an open source project?
Hey folks ,

I am currently redesigning the landing page of my open source project which you can find here: https://auth.vulpo.dev/

I am still in the process of figuring out what content I should put on the landing page and I was wondering, what are you looking for when you evaluate an open source project?

I have already covered a few minor things that are important to me:

- Current Version

- Link to Guides | API docs | GitHub

- Demo of the product: Code and UI Example

What else is important to you?
That's fair—driving to Indiana from the north side of Chicago can be surprisingly grueling. And taking the train there isn't ideal if you want to take a cooler and beach gear.
I would argue Chrome is already a de facto monopoly.

So why do we need to make things worse to make them better?

Let’s make them better (fix the Chrome issue) and then make them better again (the Safari issue) instead of the other way around.
> ... you are abusing OOP and think it's the only way of doing things

> ... when you then say you decided to stick with C, you contradict with yourself

Figments of your imagination.
I don't think that's a distinction, and it definitely isn't one way because the you here will also be interrupting the team. All this gets into team dynamics, which can't possibly be whittled down to such small interactions.

Then there's this somewhat weird obsession with people supposedly being unable to perform their job without 8 hours of uninterrupted solo time. The work day isn't supposed to just be each person working solo trying to accomplish as much as possible. Interacting with the team is being productive. Extremes in either direction are likely not productive.
Blackpink's Jisoo slammed for switching to iPhone after Samsung contract (2021)
To me its about readability. I agree that operations on types generally are a good thing because I find them more readable. Not using operations I've found leads to many very specific types which are hard to read and understand from the devs perspective.
Why couldn't LA offload homelessness and immigration to another state, if you say that's such an effective strategy for these European states?

Also I didn't hand-pick the source, it's just a piece of info I came across while reading https://news.ycombinator.com/item?id=31705542 which had a link to clearerthinking.org which had a quiz called "Political Bias Test" (wouldn't recommend it btw, at least not for the advertised purpose; it's more of a "do you know random stats about the world" quiz) which had a question about social mobility with the aforementioned source. The website seems to be made by an organisation founded in New York, but it's not clear to me whether a European made this particular quiz question.
From the article:

Like a Texas law passed last year, the bill puts enforcement in the hands of residents, who could file lawsuits against those they believe have violated it.

It gets around the state regulating interstate commerce by having residents—not the state itself—enforce it, which is what Texas has been doing for 10 months now.
> except notifications.

Which is THE single selling points that brings everyone to make 2 native apps instead of one URL. It hs been available on Android for a decade, and is still undetermined when it will actually land in iOS.
My son is a voracious reader and Libby is wonderful!
I recalled this tangent to the post about Japan and AC and comments about various ways that heating and cooling is done in data centers.

The NREL has the diagram of their cooling efficiency, how it was designed and measured and reusing waste heat from computing to heat other parts of the campus.

> Snow melt loop in the courtyard of the ESIF's main entrance

> If surplus heat is available, the PHW loop can provide heat to the campus heating loop. During transition months (April and October), excess heat from the ESIF has been sufficient to provide heat for other buildings, shortening the time boilers are needed to provide campus heat.
a) You're moving the goalposts by inserting the word "elective" that was not there before.

b) As Mr Buttigieg said, ""If it's that late in your pregnancy, then almost by definition, you've been expecting to carry it to term" - engage with that instead of repeating yourself?

c) As the other commenter (https://news.ycombinator.com/item?id=31892643) says, this is a nonsense hypothetical

> One singular example of an abortion at 39 weeks where the mother didn't want the baby. I guarantee you can't actually find one even though you claim it exists

> It's the fundamental point in the debate

It is not, or should not be.

> believe there is a point ... shouldn't be allowed.

Again, should be a medical decision between patient and doctor, not a legal one, and not a numeric comparison.
It won't be appreciated, because people making the comment that you did don't understand that an unregulated market will naturally lead to a regulated market that protects entrenched interests organically, by itself.

There wasn't anyone in government that decided hospitals and insurance companies need to have record profits and price gouge their customers. It happened, because entrenched interests lobbied government officials to enact such legislature.

Business is the one that perverse incentives through pressure on government. It doesn't originate in government spontaneously.

> Some would say that crying "market failure" isn't a legitimate criticism.

Saying market failure isn't a criticism in and of itself, it's a statement of fact. It arises whenever the market is unable (for a multitude of reasons) to distribute the services to the end consumers (e.g. health care recipients) in an effective manner.

For example, saying that "tying health care to employment creates perverse incentives, because policymakers automatically assume that more people are covered than actually are, since policymakers themselves are employed" is a criticism (without judging how valid/accurate it is).

Broadly saying "market failure" is not.
The HN article title "What Causes Depression" is at odds with the article's actual content, which is about an individual being burned out due to a poor work-life balance. I think this ought to be resubmitted with a title that reflects that.
Amazon will have two Prime shopping events this year, second one coming in Q4
Looks awesome! I don't think it adds much to SQL when the queries are simple, but when you have this looong and complex query I can totally see the appeal.
I dunno if the author is here, but regardless, I have one additional project to name and shame: Qt. Honestly, Qt's misrepresentation of open source is so bad that it truly ought to be against the law.

Here, see for yourself some of the tactics they use:

https://www.qt.io/download-open-source

> This dual-licensing model is based on the principal of quid pro quo – roughly meaning “something for something.”

> Simply put, this is how it works: In return for the value you receive from using Qt to create your application, you are expected to give back by contributing to Qt or buying Qt.

No you're not. You're expected to follow the license agreement, which requires neither of those things. You can't even argue an interpretation where GPL requires you to contribute back to Qt, and most of Qt is LGPL, which requires even less. The closest it gets is that if you patch Qt, you have to publish the changes. That's a pretty stark contrast there...

This entire page is full of fearmongering crap designed to scare people out of trying to use the open source version. It, of course, has some other very curious issues, like that giant blurry link which is actually an image with text, but what is perhaps most interesting to me personally is their other page about open source:

https://www.qt.io/licensing/open-source-lgpl-obligations

> The primary open-source license is the GNU Lesser General Public License v. 3 (“LGPL”). With the LGPL license option, you can use the essential libraries and some add-on libraries of Qt. This allows for keeping your application source code closed as long as all the requirements of LGPLv3 are met. More details are available below.

They go on to describe the restrictions. Some of them are fair, as they point out legitimate places where businesses may not like the terms, such as GPL 3's anti-TiVoization rules or their DRM agreement. However, some of the obligations are basically pre-fulfilled when you use the official SDK, which is what the previous download page was for. For example, if you use the official SDK, you will get dynamically-linked Qt. This is good enough to satisfy the relinking rules of LGPL. However, they never actually say this anywhere, since it would probably scare less people into a commercial license. Even with that grievance, this page is significantly more reasonable than the page that most people see, right before attempting to download the SDK (which, BTW, requires that you log in, even for the open source version. So build it yourself. It's easy.)

Due to their recent shenanigans with the KDE Free Qt agreement, I'm inclined to not believe a charitable interpretation of what's going on here. I want Qt to be successful and sustainable of course, but not like this.
Wood fireplaces are definitely significant. I lived in a high hill on SF and think many don't realize quite how much haze is generated here on colder days.

I specifically omitted gas stove, not sure air pollution is the reason for that one.
I think OP is focusing on a different core thesis — that moving in with parents is not conducive to having babies.

But what you describe definitely rings true. Many of my friends grew up with two working parents in a nuclear family and didn’t realize how incredibly tough that is until they started having kids themselves.