skysight-inc/HackerNews huggingface dataset:
It's not 1992 anymore.
https://youtu.be/8Fb5Qgpr03g?si=Jc7dpuVgws3POiXA

It may upset someone's sense of "purity", but the SQL standard and thoughts about the relational model have long since moved on from this dogmatic view of atoms, and no, foreign keys can't perfectly model what folks need. Eventually the rubber hits the road, theory and practice diverge, and different approaches are clearly needed.

There is a place for a document atom in a database (JSON, XML, etc. that don't map well or efficiently to a traditional relational model). For arrays. (Putting in a separate table with its own PK to join is somehow more flexible? Just use unnest(…) for that.) For label trees. For geometries (GIS). For references to tables on other servers (SQL/MED). For tuples. For UUIDs. For ranges. For intervals.

You may call Date and Darwen's work fan fiction, but I have seen tremendous efficiency gains over the last few decades from engines drawing upon their insights without compromising data integrity. In fact, exclusion constraints with timestamp ranges is one area where the old strict relational model would be wholly ineffective for data integrity and avoiding race conditions cascading out to the application level.

https://www.cybertec-postgresql.com/en/postgresql-exclusion-...
> It likely includes many issues which most people probably wouldn't think of as being 'intersex'.

Most people know pretty little about most things. You could view this as meaning that those things aren't really intersex, or you could view this as meaning that human sexual development is just another topic that most people know pretty little about.
That’s not the only thing that maintaining consistent style involves. For example, we have an auto linter at my job, but there have been a few (bad) engineers whose code I can recognize even after it’s all auto-formatted.

Plus, when you’ve spent enough time with the code in varied environments, you start to internalize what it should look like. Seeing something that doesn’t match the style guide will stand out as looking funny.

I don’t think they were suggesting that you need to memorize every minute detail of your prettier config to be a good engineer. Rather, a good engineer has focused on writing clean-looking code so intensely for so long, to know it automatically.
Ask HN: Undergrad who wants to do part time research
I’m an undergrad in the UK who wants to do part time ML research, how likely is it that a lab/college in the US would be willing to supervise me and what projects would showcase my ability to do research?
I was thinking of cold emailing some professors and implementing some random papers/reading one of their papers beforehand, is there anything else I could be doing?

Another follow up question, how did you manage to write a paper (in ML/not in ML) as an undergraduate?
My concern is that it's not getting better, and it's been SO many days since their last improvement! ;)
We have gotten to the point where they admit to the presence of UAPs, now they need to release data of those sightings so that third parties can analyze it and the academic peer review process can begin.

Anything else is speculation, one way or another, and that won't lead to a broad consensus.
> Movie theaters don’t emit tons of CO2

Perhaps not directly, but in most of the USA, everyone in one drove a car there. The energy use from those same people streaming the movie at home would emit much less.

I'm not for a ban on any of those, but very few activities are truly carbon neutral.
Edit: To allow the corrupted object to be pruned, you should also run `git reflog expire --all --stale-fix`.
If they impose too high prices the ships go elsewhere, either a different city or they buy their own land and build their own port on it. While those options don't always exist, they are real enough that most cities dare not push to hard.
My opinion is that LGBT rights shouldn't be considered a political position, but is simply an extension of human rights. Politicians should never be getting involved in people's private lives unless there are people being significantly harmed by it. It seems that it's largely "religious" people that seek to impose restrictions on how other people live their lives and that's been demonstrated by several wars between religions to be incompatible with multi-cultural societies.

Obviously, I don't believe that there should be any intersection between religions and politics, or at least if religions get involved in politics, then they should lose any protections that other religions get and be taxed like other businesses.
It’s easy to host nice fonts on your website. You don’t have to send your visitors data to Google or adobe or whatever CDN.
Automated irrigation with a rain barrel pump
What if public transit was like Uber? A small city ended bus service to find out
The absence of evidence is not conclusive proof of non-existence; rather, it may highlight our limitations in comprehending or addressing the topic. Just because there's no evidence currently suggesting an extraterrestrial origin doesn't rule out the possibility.

Testimonies and indications of concealed information suggest that any existing evidence might be hidden or suppressed. Such revelations should intensify scrutiny on NASA's handling of the matter.

There are accounts, and possibly some tangible evidence, of encounters with non-human entities, with some testimonies claiming that these beings identified themselves as extraterrestrial.

While numerous skyward sightings exist—some dubious or misidentified—there remains a portion that defies explanation.

NASA's commitment to empirical research is commendable. However, in light of the allegations, it would be prudent for them to conduct an internal review to ensure there have been no cover-ups or destruction of evidence in the past.
Thank you.

You at least tried to explain the scenario. However, I don't believe that the volume of dirt and rock expelled by the impact is enough to engulf the entire planet.

It could cause heavy local damage. But it can't cause global extinction, unless the volume of dirt is the size of a continent.
Because that won't happen unless you massively mismanage the company. The coordination problem between the company employees is very hard to solve.
I’ve never been on a cruise and I don’t ever particularly want to go, but these activists sound like a bunch of miserable bastards who hate fun.
> "Natural" aristocrats are still aristocrats, and being aristocrats it is their "natural" inclination to take power in their own personal and (when they are numerous enough to be organized in a coherent group) institutional interests.

There is one sustainable solution to that: make sure that holding power is inconvenient and uncomfortable, something that brings disadvantages rather than inherent advantages to the power holder. Much like how jury duty is viewed today, and perhaps with similar mechanisms involving random sortition. "Natural" aristocracy works well with this, because one defining characteristics of a virtuous, talented, meritorious person is that she has way better things to be doing with her life than holding tyrannical power over others.
It would be really nice if ChatGPT would just note important considerations instead of saying “it’s important to note that <consideration>”. The frequent occurrence makes that wording quite annoying.
Its called Attention Theft.
Comp.sys.sinclair crap games competition (2021)
> Predictions. You know, the heart of a testable hypothesis? Science?

I think, getting a Ph.D. in a field that calls itself a science from a top university should have given me a passing familiarity with that thing called science.

Environmentalist "prophecies" may be intertwined with pieces of science that have implications on what to expect for the future, but they add an element of psychological framing to the facts that does not itself stand on scientific ground but is instead culturally ingrained and ultimately simply "made up".

One possible framing might be "nature wants me dead": You can think "With all those cold nights, lack of food in the winter, pathogens, etc. it looks a lot to me like nature wants me dead, and I'm lucky to have civilization to protect me from nature's violence." You can emphasize to yourself that nature has been there for billions of years before man came around. Now, for what is just a brief blip in natural history called the "anthropocene", man has become a weirdly dominant force, and the anthropocene will very likely end by man making the planet uninhabitable to himself in some way or another. The question is not whether it will happen, but when and how exactly. But regardless of the specifics of the when and how, the duration of the anthropocene will be dwarfed by the billions of years that the planet will happily go on producing life after man is long gone.

Another framing might be the "mother nature" framing, where nature is a fragile harmony, and any disturbance of that harmony cuts life off from what nurtures it. You can further go on to think that all life is sacred, and killing a fly is not morally any different from killing a man. Currently, the greatest disturbance to the harmony of nature is man, and it happens every time you turn on a light bulb, for that consumes energy, and takes something away from nature that would otherwise sustain life somewhere on the planet. Wasting energy, even if it's just a light bulb that you don't strictly need, is therefore a great sin.

Now, both of these framings are compatible with the same scientific facts about nature, but under the "mother nature" framing your behaviours will start to look like those of an environmentalist, while under the "nature wants me dead" framing, they will not. Neither of those two framings are themselves in any way grounded in science.
Munich and Berlin (as well as Hamburg and I personally know people from Cologne that move away due to rent increasing heavily) are really expensive for German standards though. They're almost statistical outliers.
Okay? The elephant in the room is that bad urban design is bad for your health: Car centrism, parking lots, stroads, endless sprawl, etc.
The contrarian is not wrong, but neither is the OP. At least from my perspective.

When we moved to our current semi rural property there were birds and squirrels even flying squirrels all over. Our property is a ranch but out house sits in a woodlot.

Then a new neighbor moved in next door. I use that term loosely, but close enough that their 3 outdoor cats were frequent visitors. Now we have no squirrels but we also have very few birds that visit.

I did not mind the squirrels aside from thier attempts to get in the house. Before our new neighbor we would pay a trapper to come get them a few times a year. Since the cats though we no longer see any squirrels or chipmunks at all.
It's just syntax, it compiles to SQL and runs on today's DBMS. It has no difference in speed or functionality.
Speaking as someone in a similar position, it’s not possible. You can have young kids or have time. Not both.

Which, sucks, given that what it sounds like you actually want rather than time to grind leetcode and do side projects is to find a different job.

But the way the industry is set up effectively precludes you from doing that, because as you’re aware, you need to have time to do stuff outside of work to get and prepare for interviews.
Natural Deduction in Logic (2015)
Virtually none of this is true of Grusch.
Indeed - I did a double-take at the notion that creditors often wanted a borrower to default so they could then collect payment in the form of the debtors labor, basically debt-slavery.

As you said, fascinating stuff.
I suspect ports need the cruise ships more than the cruise ships need ports.
Wing IT – Blender Open Movie [video]
This looks amazing! Just installed.

One thing if I may: I can't figure out how to use it. Like: The bottom right says "1 remaining", but I don't know what that is. I can't figure out how to run `rg` or `fd` from within Yazi.

Is there a user manual or a tutorial somewhere to read?
> Java I would still call verbose, it's more verbosity than I tolerated when I was greener but I have come to appreciate a certain amount of ceremony isn't necessarily bad - if it helps to efficiently communicate the intent of the programmer.

In my experience the trick with Java is to use a purpose built editor like Eclipse or IntelliJ. Once you've achieved competence with an appropriate tool the syntax kind of fades from your attention and you focus on the important parts. Kind of like how experienced Lispers using an appropriate editing mode don't really pay much attention to the parentheses.
You said "right" at the beginning then got reproachful at the end.

In between there's a lot of material and references that won't be obvious to other people.

So I'm confused.

But I'm pretty sure they'll be just fine, as long as the reptilians continue suppressing the truth.*

* my understanding of why people get drawn into these nothing-burgers is you see new info, you think somethings around the corner where all those skeptics are proven wrong. years pass, and people either acknowledge it was a nothing burger or escalate claims to explain away why there's all these aliens bouncing around, everyone would want to hear that, Congress is demanding anyone who claims such be given a wide bearth and credence and yet....still nothing.
“Human-caused climate change is a myth.“

What makes you think exactly the global scientific consensus would be wrong in this matter?
Yes, Swype keyboard fail.
> I’m tired of this. I think we overvalue thinking and undervalue taking action on that thinking. It’s easy to discuss ideas, which is one reason I think I’ve done so much of it and used to find it appealing.

> Lately, though, simply reading or thinking about ideas feels inadequate, even a waste of time. It feels wrong to me, because it goes against some of the things I value deep down–things which don’t have a specific word for them (that I’m aware of, with my non-native knowledge of English).

> It’s the value that seeks to do things, see the results of doing those things. Ideas made tangible.

This resonated with me a lot.

I've written before about how I ditched over-the-top all-in-one bookmarking, highlighting, annotating and read-it-later platforms for a single fuzzily-searchable database of highlights I take from anywhere (comments, articles, books, blogs etc.) and how much this has improved my life flow in general.

I don't think it's a coincidence that since that mindset shift, I've gone on to create a modest-but-profitable SaaS, a category-defining piece of open source software with a vibrant and active community, and that after a lifetime of watching from the sidelines, I have finally learned to dance to the level that I'm regularly referred to as a "good dancer" (still working on being able to accept this compliment, though)
only if you care about what happens to the next generation
It’s a system font on many devices but Roboto is a nice default.

https://fonts.google.com/specimen/Roboto

I also like IBM Plex Sans.

https://www.ibm.com/plex/
There are lot of resources you seek. Few to get started.

Books - Michael Lopp presents his full arc of transition in his book Small Things Done Well
https://www.amazon.com/Art-Leadership-Small-Things-Done/

Newsletter - Louis Bacaj transitioned from SW Engrr to CTO. His newsletter can help.He is helpful over twitter DM well

Courses - David Kline runs a cohort course on maven.com on management. Worthwhile but expensive

Mentor - seek a mentor inside and outside the company.
None of this supports their argument, which is that academic cryptography has been subverted, not that NIST has.
Did you double check and confirm that it is declared (in fact) by all participants to be a right rather than simply a good idea?

Sounds like a good question for philosophy, too bad we live in a world where it plays little role beyond amusement/mockery.
Don't forget norovirus, the gift that keeps on giving
That would seem to be an exaggeration. Wikipedia says 1.7% of the population could count as intersex, but: "Of the 1.7%, 1.5% points (88% of those considered "nondimorphic sexual development" in this figure) consist of individuals with late onset congenital adrenal hyperplasia (LOCAH) which may be asymptomatic but can present after puberty and cause infertility." (https://en.wikipedia.org/wiki/Intersex#Prevalence)

Are they including people with an asymptomatic condition in the 1.7%? It's not quite clear but if they are that's very strange. Even counting people who have some medical condition related to sex hormones but remain unambiguously male or unambiguously female as "intersex" is arguably misleading for the general public.

In any case, those "late onset" people are not intersex "babies"!
When I looked into running it locally on my own server, I couldn’t get it to work because it required https. I connect to my local server with WireGuard without exposing it otherwise to the internet, so I don’t have a need for https. There’s probably a way to set up https, but I gave up after a few hours trying various workarounds while the rest of my local services continue to work via http and WireGuard.
You mean apart from the massive pollution?
NPM has lost download stats for the last two days
Extra dimensions are just scifi stuff. Physics would break appart if there were any "big enough" dimensions. Gravity & electromagnetism would not behave the way they behave (inverse square laws).
To a casual developer who wants to implement a simple fun idea it’s overkill but if you love making games it’s essential. You can learn stuff from using video game frameworks too.
This is harder than it seems, there are international treaties that "regulate" (read: de-regulate) what companies can do regardless of the country.

Also in many cases a particular city, say Barcelona or Venice, may want to regulate, but pollution laws are typically at the regional or national level.
Maybe we count in series a lot more than you think.

https://www.youtube.com/watch?v=WO2X3oZEJOA
Agree. Italy has in the past deployed the military to keep cruise ships and their tourists out of Venice. Because even if you deny them from docking there, they'll just dock somewhere close by and charter a bus. Lots of 1-day-tourists means lots of dirt and trash and dangerously crowded roads in and out of the city. And since most cruise ships are all-inclusive, those tourists pretty much won't buy anything. They stay exactly 1 night at each location, so they cannot even afford to buy a meaningful souvenir because then they won't have budget left for souvenirs at the next 10 stops.

So yes, "cruise ship tourists ruin the economy" is probably the best argument for getting the locals on your side.
Another book in this vein is The Price of Time: The Real Story of Interest by Edward Chancellor if anyone is looking for one.
Seems amazing! Can't wait to try it!
The dams were unmaintained for years before the Qadaffi government fell.
Realistically, given the tiny size of that table saw and the small parts needed to cut, what other way would there be to use it?
For a startup you need to convince them that you can help them 1) solve their problems in the role they are offering the job 2) you can wear multiple hats and do things that are on the periphery/adjacent of the role they are offering 3) you are willing to given them an almost unlimited amount of your time and energy towards their day to day needs. You can’t do this thru your resume. You have to do this via your interview and other interactions with them. The resume, then, is simply a tool that allows you to potentially interact with them. Degrees from prestigious universities, or prior jobs at impressive companies or roles etc all are proxy mechanisms of signaling to your potential employer they should have a “interaction “ with you.

I know this sounds extremely cynical, but most(not all) startups are somebody’s grand efforts to make a shit ton of money for themselves (and smaller but meaningful sums for some people who join on that effort). There is nothing wrong here inherently just calling a spade a spade and if
You are failing to see this reality you may not understand how resume is just a tool that allows you get to a starting point of convincing someone that they should go be you some amt of money in return for your experience, skills etc. they are going to give thst money to someone and there are many takers. So they will try to maximize their ROI by giving it to the person who is most promising for “their endeavor “. As such while no two startups are alike you can abstract out the common needs across them and optimize your resume (and your interactions) to that end.
How do any of us know that info about "cammikebrown"?

I think you're describing specifics of David Grusch.

I'm a little surprised at how retributive you want to get if he's exaggerating. (he is)
I'm not familiar with the web space but from my untrained eye these sorts of projects are more like modernized V8 wrappers than runtimes in the traditional sense.
Depends on the port. It's not like there are two Venices in the world.
The beauty of housing going up is the “work hard” in tears wages which then increased the price of housing.

The land owners take all the extra work and laugh all the way to the bank.

Of course if people collectively decided to work half as hard there would be less money for housing and then prices would come down. Workers wouldn’t lose out.
Paraphrasing here, perhaps the best way to maintain a conspiracy, in the non-pejorative sense, may be to classify the evidence and run a systematic campaign of ridicule and misinformation so that whenever a whistleblower comes out they can be rapidly labeled as a kook regardless of their bona fides.

I'm on the fence on this subject, finding both some merits and demerits to the arguments of both detractors and supporters of the NHI hypothesis. Until we have publicly available concrete data to analyze, all we are doing is speculating and slinging mud at each other.

The difference being that the proponents of the NHI hypothesis are all for obtaining and releasing such data, while the critics appear to be very comfortable with the status quo of secrecy.
Show HN: A selection of generative art coded in p5.js
CTEs and query pipelining are not sufficient?
Owning code would be akin as owning language.
This makes sense to me as an argument. People downvoting this because they disagree is pretty sad.
1Password stores data locally and syncs. So, this wouldn’t impact 1Password as far as I am aware. They use AWS, not Azure though.
The example is given for the `react` package, but any package shows 0 downloads for 2023-09-13 and 2023-09-14.

I raised the issue with them on 2023-09-15, and it seems to have been resolved since, but it looks like the data for these two days has been lost.