skysight-inc/HackerNews huggingface dataset:
I do like the idea of ground source heat pumps. If we all lived in caves hundreds of feet deep, the temperature would be near perfect year around. In a way, the heat pump “brings the cave to the surface”. There’s something very satisfying about this design, we’re not using technology to insulate ourselves from the Earth — we’re working directly with it.
As a native speaker who's not a medical professional I still would have had to look it up, so thanks for adding the full name.
> On hiring you get a signing bonus, in my case the value of this bonus made my comp almost flat for those 4 years if the share price remained constant.

Signing bonus is not unique to Amazon. You can get a signing bonus anywhere in the industry, along with a sane vesting schedule of 25% each year or a front loaded schedule to prevent 4 year cliffs.

> Vesting is inherently lumpy, and makes managing cash flow a bit more tricky.

It doesn't have to be lumpy. Google stocks vest monthly here in US. Also, how is it tricky to manage?
Maybe not what you want, but it seems to me that people are still using Windows as much as ever.
Yes cashflow should definitely be added! That's an amazing idea. If you hover over the growth charts it should show the actual values!
It is debatable how embeddable that is, in any case, official build system for NDK is CMake (ndk-build is kept around for backwards compatibility purposes), so no one doing US projects stuffing Android in places that don't look like phones?

Or GUIs on medical devices using Qt?

Cause there are some, so I would expect US companies to also having a go at it.
I was pretty surprised when I went to parts of Texas where people still using German (alongside English of course).

It's a pity that Gresham's Law ended up making English almost ubiquitous, to the detriment of the many languages from all around the world. (I don't think I need to mention the many advantages that counterbalance this.)
It is forbidden in tournament play, but I absolutely keep notes for correspondence games that play over the course of multiple days (a chess sprint?) and LiChess even has notes as a built in feature.
> And of course the credit card machines were always "broken" so you had to pay with cash.

I never understood this line, but maybe it is local taxi regulations differences. Where I live the taxis cannot refuse credit payment, so if their machine is really out, they do an old school carbon copy. If they refuse that then they've basically given a free ride, so they didn't tend to put up a fight.
A little defense of the pseudoinverse here, it's often a fine tool, far more so than the true inverse.

If the matrix is not full rank the psuedoinverse provides the least squares solution.

It can also be done efficiently and may well already be implemented using whatever numerical method one prefers (SVD, QR).

And the implementation probably allows for regularization via a singular value cutoff.

I'm not sure what matlab's backslash operator does these days, but it looks like a more efficient way to get a least-squares solution (compared to the pseudoinverse), possibly with sparsity imposed slightly.
Keep up with the standards. And forget the concerns of longevity
The letter Ä is a separate letter in Swedish and many other languages. It is not just an A with an umlaut mark or a diaeresis. The Ä in Älv is not a shifted vowel.
I started to get into that but thought I was already approaching essay length by HN comment standards. :)

So, yes, true -- although it's arguably also something of a time-honored tradition for the real person(s) involved to be less than pleased if they feel too-personal parts of their lives were used in fiction without permission. At the extreme this has gotten authors sued, sometimes even successfully. But cases like, well, this one are probably more common: Alexis Nowicki isn't suing Kristen Roupenian, but she's upset, feels unfairly used, and likely knows this essay could catapult "Kristen Roupenian is a bad person" (back) into the media narrative.
Crazy, I'd definitely use CMake above autotools (does not even work natively on windows LOL), handwritten makefiles (not supporting filenames with spaces in 2021 LOL), "the IDE" (do you even do cross-platform?).

I'd use Bazel but afaik it mostly uses a rebuild-the-world approach.. I'm already getting flak from Linux distros maintainers because I use some vendored header-only libraries and not system ones so I don't see how that is even supposed to work.
So clearly that God is a fiction, exactly like the Flying Spaghetti Monster, Thor, and all the other millions of gods that people made up.
Freedom 1: “Access to the source code is a precondition”

With no copyright/copyleft, how do you enforce the rule that derived works must provide access to the source code? I’ve never heard that copyleft was a stepping stone—rather, it’s the stick that fully realizes the four freedoms.
If you’re wasting time like that, try being much more up front with the recruiters about salary. Name numbers. In my opinion it’s a trap to think that not doing so would allow it to be higher. And you named Citadel, yes, at hedge funds the comp is a primary reason to work there. The recruiters I worked with in that sector were totally comfortable with me saying the #1 reason I was interested was comp. But they will want you to relocate.
> Of course, a lot of American beers are around that percentage point, but the ones I'm talking about are a bit higher quality in my opinion :)

Don't worry, it's usually only the worst American beers that end up exported outside the US, and unfortunately this seems to go both ways between every pair of beer-producing regions I've been to. You can't even find a decent selection of German beers here (~50km away) in Switzerland, let alone ones from local American/Canadian/... breweries which are rare exceptions at this point. The same seems to be true of Canadian beer quality in the US, even in neighboring states like Michigan which at least had some Canadian options.
“Älv” can mean either river or elf, I think depending on tone?

En älva = one “elf” (Not like elves in Anglo fantasy novels)

When conjoining the a can be removed depending on dialect, thus älvdalen could mean elf valley. I don’t know the true history of the word though!
LLVM 12.0.1
Responding to the first point: In a "normal" software context, developers are usually faced with other roles that usually don't have the same focus requirements.

PMs, scrum masters and sales or business development types don't usually have the same kind of focus requirements during day to day. Sure, they also need deep focus when drawing up a detailed budget or doing roadmap planning or whatnot, but usually their day requires less focus and a broader contextual awareness instead.

So, obviously physicists, plumbers, bookkeepers, surgeons, mathematicians, all manner of creatives, designers, engineers, chemists and evolutionary biologists also need not to be disturbed while working. But their workplace is often cognisant of the fact.

Programmers often complain because the default setup in which they work (some kind of open plan office) and the roles they often interact with don't get the basics of what's needed.

If I needed to work on site, I'd regard an seperate office as a significant perk.
Hmm. So what's the other three quarters, is it really all bots or just misattributed?
Sorry folks, there's no right to repair.

There's only one right, the right to own property. Everyone can fix (or break) their own property.

This is about whether the owner can (attempt to) fix his device (he always had it), but whether he has the right to try, fuck it up and then still hold the manufacturer accountable for warranty.

Clearly this cannot be, but now American socialists says it can. Nevertheless, someone has to pay for it. So, if you're a manufacturer, you simply raise prices for everyone to accommodate "repair socialism" or show the finger to Sleepy Joe and stop selling lower margin products.
And if God isn't a sociopathic asshole, then why didn't he bother to throw in a commandment explicitly prohibiting slavery? That would have been pretty simple to universally and unequivocally articulate:

Thou Shalt Not Own Other Human Beings, Nor Treat Them As Property.
" am disturbed and concerned by the general trend that the world seems to think all heterosexual relationships are inherently abusive or something. We hear a great deal about the bad, the things gone wrong, the dark side and sometimes it seems like there are no good examples out there, no discourse on "This is what a good relationship look like."

Exactly .... Since a majority of the relationships are heterosexual, relatively most problematic relationships are also heterosexual, that would kind of feed into the "all heterosexual relationships are inherently abusive" mindset
>what if we want to return the salary too?

>the only solution is to change half of the lines in the query

How about adding a second subquery for the salary.
It's not just Google Analytics, but any other alternative be it plausible, Matomo, or any other JS analytics solution.

I would also say cloudflare doesn't count uniqu visitors accurately. Also recently there is big uptick in bots which server logs show, but are not real users.
> In the US that would mean allowing the same bureaucratic organization that manages Medicare/Medicaid to manage a transportation app.

Why are you keeping your public companies in such a bad shape?
True, but there would be a lag of days to weeks before the cheaters adapted. You could bust everyone in the mean time.
Admitting you don’t know is more complex than you think – on Italian vocab
I definitely think dogs, for example, have the capacity to reflect on it to a extent. You can play games with dogs, they seek it out. I believe there is evidence they can plan.

I think they can observe you and then adjust themselves accordingly. If you are angry they can be sad or cautious. If you look sad they can comfort. But they also seem to possess their own independent moods.

Planning and adapting to stimulus seems like consciousness to me.

I think in Humans language can actually be a big component of that feedback, you can structure your thoughts and reason with it. An internal dialogue. But I am not sure it is entirely necessary.
We see around the same thing and our audience is totally NOT from HN or hacker like. Mixpanel and Cloudflare both report around 886k uniques (mixpanel being 5% less) for yesterday's Friday traffic... while GA reports 129k... that's a solid 80%+ too.
I thought they where talking about the data not being able to compress, the actual queries don't need to be compressed.

But you need to separate the data and the index so you can compress the data while still searching the index, and none of the SQL databases do that because they don't have one file per value (for obvious disk-size reasons).

We need to approach the database as files, even add features to our filesystems to accomodate that.

In my distributed HTTP/JSON database I use ext4 type small to not run out of inodes before disk space.
I don’t think that your premise concerning “planetary-scale AI” (and the ability to pull it off) holds up. If Google and Microsoft are so dominant and had such an insurmountable head start, why are we seeing such an enormous number of AI startups? In fact, there are countless startups busy figuring out how to make AI work for software development. I’d even argue that copilot was not that expensive to build. I very much doubt that GitHub (or Microsoft for that matter) had a huge team working on this or has spent such a vast amount on hardware resources that they’d outcompete the rest of the market by virtue of their cash reserves. Any decently funded startup should be able to finance such as effort. Especially since in this case, the training data is cheap (and legal) to access for anyone.

Where Microsoft does have an “unfair advantage” is in their marketing and sales firepower. Replicating their B2B and B2C sales channels is indeed very expensive. GitHub will be able to monetise Copilot by some upselling campaign. Then again, startups regularly manage to break into markets that are supposedly locked down by the likes of Microsoft.
This example seemed wrong to me as well. You can have a subquery, or CTE that returns as many fields as you want and can join on the manager key
Slightly off topic, but every cent that was spent "on space", was also spent "on earth". If you pay someone to build a rocket, that human lives on earth, not in space. Where the rocket goes is not the same place as where the money goes. This extremely basic economic misunderstanding undermines any other point you were trying to make.
Handwritten makefiles can be the best option on the table in scenarios not involving a lot of boilerplate code or having to do any platform check at all.

Once you stray out of that niche, anyone is better suited if they just automate all the boilerplate generation and compiler checks.

And that's what CMake does.
> The people using steroids are equally as skilled as their opponents.

Sure, because they were also doping. Seriously though, I wouldn't say steroids make you _more skilled_, but they absolutely give a physical advantage over natural athletes. Which is why there aren't any top level natural athletes anymore except in very dedicated natural-only circles.
A bit off topic, but does this mean that each of 25k Google developers has a copy of the entire codebase on their laptops? Or is there a way to cherrypick parts of it?
Across the world, the trend seems to be for people to speak a local language, and a lingua franca. The former carries their cultural heritage and identity, the latter opens economic opportunities.

For a lot of people, investing in their local language is a luxury, if it comes at the expense of deeper engagement with the lingua franca. We see this decision being made across the world, as the population urbanizes and leaves their local culture behind. Few can afford not to.

In this case, it sounds like Elfdalian is up against both Swedish and English.

If people are capable of and willing to learn three or more languages to native fluency, then that is of course their prerogative. But at some point, I believe it becomes unethical to promote investment in a hyper-local language if the effect is to detract from the economic opportunities of lingua francas.
Cool! Thanks for sharing! I've been on the lookout for replacements for archiving recipies on cooking sites and this tool works great.
And in case of Copilot, the training data isn’t a moat anyhow. Last I looked, everyone could freely access GitHub public repositories.
I truly hope you make it to your seed round. I think your biz is ultra solid. Happy to chat if 1. you happen to expand in Berlin, 2. you wish to fundraise around here. I have some data [1] that you might benefit from. Also: I think you'd rock in cities like this :)

[1] https://giansegato.com/essays/how-i-beat-the-berlin-rental-m...
Semantically you are right, however there's more to it.

Bank transfer can be invoked within the context of a business transaction (e.g., buying on Amazon) or as a standalone payment with no context attached to it.

In the first case, the money goes through many intermediaries such as payment gateway, merchant, acquirer, etc. In this instance, a customer can dispute a payment at different levels beginning with the merchant (or marketplace), their issuer, and finally file a case in the consumer court. 90% of the disputes get settled by the merchant/marketplace. Issuers typically side with the consumer because their primary customers are consumers. Consumer courts take time to settle a dispute, but they do work.

It's possible for fly-by-night sellers to con a bunch of customers but it's rare. Because payment gateways and acquirers have gotten their act together in recent years and they do stricter KYB checks (Know Your Business).

The bulk of the theft happens through person-to-person bank transfer, i.e., devoid of any business context. Here, the fraudsters con a gullible person to reveal bank credentials and also second-factor auth. Social engineering attacks are also common. But the thing is you always know the destination bank account. So you can track the fraudster as the destination bank would have done a KYC. The key point to note here is that the money can always be physically traced. And there are laws that let victim claw back that money if they can provide sufficient evidence of fraud.
This isn't just a matter of some constant programmer overhead, like SQL queries taking 20% longer to write.

20% longer to write than what alternative? And how is this being measured?

And.. am I missing something?

By far the most common case for joins is following foreign keys. SQL has no special syntax for this:

select foo.id, quux.value
from foo, bar, quux
where foo.bar_id = bar.id and bar.quux_id = quux.id

Why can't this be expressed as an INNER JOIN?

And can't some of these subqueries be written using a WHERE EXISTS or a windowing function?
Quote about Diogenes:

“The philosopher Diogenes was eating bread and lentils for supper. He was seen by the philosopher Aristippus, who lived comfortably by flattering the king. Said Aristippus, 'If you would learn to be subservient to the king you would not have to live on lentils.' I haven't read anything about Diogenes, but listened to several podcasts of philosophers talking about Diogenes.

Also going to advise reading Bullshit Jobs by Graeber. Add "In praise of idleness" by Bertrand Russel. The Abolition of Work by Bob Black.

The subreddit /r/antiwork is quite extreme but has good info on their wiki https://www.reddit.com/r/antiwork/wiki/index
The Ultimate Oldschool PC Font Pack (v2.2) by VileR:

https://int10h.org/oldschool-pc-fonts/
> Your obnoxious neighbor or just a misunderstood, displaced seabird?

Neither. Seagulls are natural born opportunists. If they can grab your hamburger or hunt and eat a pigeon – they'll do that. Just the same for landfills or farms.
Regular people yes, but no problem for decently funded startups.
As someone who uses both Kubuntu and Windows 10 daily, between the two I'd definitly crown Linux with KDE to be the shiny thing.

It is amazing how usable KDE has become, including settings, calender, presentation tools etc. Windows feels like a cluttered shed in comparison.
no problem, the paper is actually not to bad either by the way.
In Serbia it has to be the Benchmark (https://benchmark.rs)
What is the highest resolution intraday data you offer thought the API, one minute? How many months/years back do you allow users to poll? Do you allow users to poll data between specific dates? Is the data an aggregation of all trading venues or only data from one venue?
The other three quarters are HN users with adblock so they don't register in GA but register in Cloudflare (and my logs) because that cannot be blocked.
No, Ubers are not interchangeable! Because only your driver has your account connected to the ride.

They're even asking for a PIN in some circumstances https://www.uber.com/blog/pin-verification-drivers/
I took risks and they went very well. 5 year plans exceeded expectations, 1 year plans fell short.

People who are richer and more successful are not always better. Most were lucky. You have to trust in yourself more than you trust others. In fact, nearly all my failures in my early 30s/late 20s have been trusting someone who went to MIT or someone with a history of success.

Don't bother with practical productivity books. Nothing stuck. Anything that tells you that doing X will give Y results is lying. History books are fine: someone did X and Y happened. Psychology/science is fine: statistically Y happens as a result of X. There's a subtle difference, but basically a practical book is very fragile. It's like memorising chess openings; the tools work in very specific conditions. The difference is that the world changes quickly - everything in Rich Dad, Poor Dad or the 4 Hour Workweek becomes an anti-pattern once the world changes.

"Resume items" won't land that job or even a better paycheck. Just optimize to do good work, not looking good on a piece of paper.
thats pretty cool, id ask you some questions about it if you didn't mind but im not ready for the moment lol
I'm not sure what point you're making. My point is that steroids don't turn average people into elite athletes, which is much closer to what auto aim or wall hacking tools in FPS games do. Average people appear elite because their tools make them perform that way. This is not what steroids do.

You're agreeing with me, I think, but in the form of an argument.
I think paying to get rid of ads is fair. I pay for YT Premium solely for that reason, it comes out to about $5/month/person if you use the family subscription.

It’s expensive but I find it’s worth it to not have my partner and our parents watching ads.

I watched the Euro 2020 games, and even the 5-second soundbite of “the games are sponsored by so-and-so” rubs me the wrong way. Why should I be told the name of some company when I’m watching football? I digress.
I'm sorry for the confusion, Whether it's readme or Confluence they both have a common issue of the documents being very big, and usually they have multiple people contributing and maintaining them. So if you have an issue while reading the documents, its hard to know whom to ask and even if you know whom to ask, the person could have left the company already. Our solution is to get away from writing big documents with multiple contributors instead we write smaller notes, with a single person assigned to maintain each of them, just like twitter. This way we can find out whom to ask right away and if the person leaves their job it's easier to transfer their knowledge to the rest of the team.
This is super interesting! Yes, Berlin is the next city we're expanding to, likely within 2021 or early 2022. I'll hit you up on Twitter DM.
Thanks. I didn't mean the quality of the keyboard which seems to be very high from your reply. I meant when I typed on the eee my hands started to hurt quickly, the spacing of the keys seemed to small to comfortably use my 6 finger typing system.
It's not very subtle.
I'd exclude certain software from this tho. Something like Blender becomes usually just faster and better with every update, there is other software where this applies as well.

The software where this doesn't apply is usually everything "consumer".
Array prototype methods are designed to be applied to other objects. There's explicit language about it dating back to the first edition of the ECMAScript spec: "The map function is intentionally generic; it does not require that its this value be an Array object. Therefore it can be transferred to other kinds of objects for use as a method."
If folks were using the pay version instead of the Adblock route they might spend less effort on it tbf

Also this way your favourite content creator gets paid as if you saw the ads

https://www.twitch.tv/turbo
Are you saying getting into that "in the zone" state affected your mental health. Interesting. Any examples of the side effects? Is it hard to put into words?
Refrigerators actually have greater than 100% efficiency, often like 300% or so. Because you're just moving the heat, not creating it. Sounds like magic but it's not.
GoodFirms Features InvoZone as Top Software Development Company
> So instead the best we can do is add json to the SQL spec and hope that all the databases implement it in a compatible way (they don't).

Of course they are incompatible. That's just par for the course when it comes to SQL.
Iwan here from coderfit.com

Joining Can: lovely to see a Bern-based firm at YC and on HN!

Finally, we get access to a cool startup offering FIRST before Americans/everyone else!
Lots of the examples here are yhe author writing very poor, non idiomatic SQL and then criticizing it.

I could write a point by point rebuttal but I'll just pick one point, compressibility: VIEWs.
Most bots are pretty stupid, so it's easy to detect them. Bot detection need not be 100% accurate. It's an arms race with the goal to make writing bots financially unattractive.
Best Free Typing Software for Windows 10 (2021)