skysight-inc/HackerNews huggingface dataset:
Many popular NoSQL DBs do support joins now. However, the fact that with NoSQL, you tend to structure your data so joins aren't necessary IS one way of solving the problem relational DBs have with "join performance".

The problem is basically:

- Say you have a query filtering on 2 fields, e.g. `WHERE x = ... AND y = ...`. If you have separate indexes on x and y, if both filters return a lot of records, you'll have perf problems. Internally, the DB needs to fetch all of the records where `x = ...` AND all of the records where `y = ...`, them and then combine in memory. This is very, very slow with large data volumes, even if there are very few records that satisfy the combo (e.g. lots of records where `x = ...`, lots of records where `y = ...`, but few records where both `x = ... AND y = ...`)

- The same is true for many related problems, like filtering on 1 index, then sorting on another (e.g. the common `WHERE x = ... ORDER BY y LIMIT ...` queries)

- If your data is all in a single table/collection/whatever, then you can fix these performance issues with a compound index on (x,y), which allows you to efficiently filter/sort on the combination of x and y, without having to fetch huge intermediate record sets. But if your data is in different tables/collections/whatever, I'm not aware of any popular DBs that allow the creation of cross-table compound indexes, so that's out

NoSQL's hierarchical, join-free approach means you CAN create that compound index most of the time, while with relational DBs, you much more often can't. With NoSQL, it's much more likely that when these slow queries emerge, fields x and y are already in the same "collection". Traditionally, with relational DBs, people have solved these perf issues via denormalizing - if fields x and y live in different tables, you decide to keep a copy of field y on table x as well, to allow you to speed up the query with a compound (x,y) index. Works, but denormalizing sucks. NoSQL DBs are another approach, basically eliminating joins with more hierarchical data, but that has issues too (including, very often, requiring you to denormalize!).

"Worst-case optimal joins" are a way to have relational DBs solve this for you, without needing to resort to denormalization and compound indexes, which is very exciting! Instead of saying "fetch all the data where x = ..., and all the data where y = ..., then find the intersection in memory", they try hard to avoid this. e.g. intelligently fetch a little from x, a little from y, see if that's enough. It's a great concept, but only recently seeing much serious attention, and most big relational DBs don't support them yet.
Thank you. That was bugging me.
Nixon was quite a fellow. I recently learned that Henry Kissinger reversed a drunk Nixon's orders to start a nuclear war.

https://www.warhistoryonline.com/cold-war/richard-nixon-nort...
Hugo is not made for minimum viable blogs. Its advantage in performance only becomes important for bigger websites or blogs with thousands of articles. But especially for bigger websites it should be possible to auto-generate a good archive. However the developers of Hugo stubbornly refuse to fix this very important 8 year old issue: https://github.com/gohugoio/hugo/issues/448
That is quite unfortunate, because it makes Hugo "the worlds fastest framework for building huge websites without a useful archive".
> these services have recurring costs in the form of infra

Only because these companies have forced us onto their cloud platforms in the interest of justifying/enforcing continuous payment. I don't want to use Adobe's crappy "infra", for example, and neither do 95% of their customers.
CDC puts it at over 40 million in the USA, so over 10%. https://www.cdc.gov/parasites/toxoplasmosis/index.html

Edit: here's that paper from Tenter et al. https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3109627/#__ffn_...

As a consequence, no two tests produce the same results in all cases, even when carried out in the same laboratory [45–54]. In addition, prevalence rates vary over time and with the age of the individuals included in the study [55–68].

The strongest thing they were willing to say is that it's higher in Latin America and west Africa, and lower in colder climates. Here's a direct link to Table 3 https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3109627/table/T...
It is extremely hard to make two pdfs have the same output binary, especially on CI vs local.
from reading the comments here, i get a sense that most people on hn assume that a cs degree is just for entering the software industry.

not to discount the initiative itself, but bachelors in cs is more about the core cs theory that will be valid decades from now, unless the entire paradigm changes.
I was annoyed by the key bindings/controllers at first as well. But once i found the section that shares community created controller mappings, i have only ran into one game that didn't have a controller config that worked well.
Someone has to sign the cheque. That number is going to come off of their results. The tragedy of the commons happens within companies as well.
GDScript is a bad idea as a teaching language because it's so niche, practically a DSL. You really want people's first language to have broad applicability. Yes, Python has deployment problems, but so does Godot.
I think that kind of understanding of “sex is a human right” is one step away from “woman is an object/a service”. And also this “human right” is usually applied to men, but not women. What about woman’s right to have a very attractive sexual partner? Now if have two rights simultaneously, you have a contradiction.
Many companies require receipts for anything > $50 on an expense report. Under that and employees will buy/try tools that help them with their job, and not have to justify it to anyone.
Amazon doesn’t care. There will always be another author. It won’t cause any difference in how many kindles and books they sell.
> If you expect me to keep paying for your software then I expect you to keep providing value.

If you make paid software part of your workflow, you're going to keep using it whether they keep providing value or not. When someone else captures your workflow into their own infrastructure, there tends to be a high cost associated with extricating yourself.
> write all your programs with the mindset that you are given X amount of memory, and you use it as a cache or buffer like they did back when computers had 64K or whatever

Even better, cache-oblivious data structures & algorithms avoid the needing for picking/knowing X, and will essentially auto-adjust to near-optimal regardless of the cache size or pressure.
People said the same thing about abolitionists, suffragists, anti-segregationists, etc, etc. It's certainly possible that this time will be different, but I wouldn't wager money on it.
They're available. The male-to-female ratio drops precipitously as you increase the age band: https://public.tableau.com/views/PNWMatch_com/Match-PNW-Dash...
I'm wondering if they controlled for cat ownership (as a likely source of infection), or if any of the variation can be attributed to the types of people who own cats.
If it's true that toxoplasmosis is is present in 1/3 - 1/2 of the population, I immediately find any specific findings like this dubious since the scale of confounding factors must be enormous. Yes, they controlled for some, like malnutrition, but that's hardly the whole story.

It's way more likely that there is something else (maybe many other things!) that explain the correlation.

It's one of those sexy findings that is probably bullshit.
When they've already lost most control and are panicking, yes. But it's completely normal for cyclists to wear reflective clothing to make themselves visible. Even cars have retroflectors on their taillights for this purpose. No road user is trying to hide in the dark in the hopes that drivers won't get fixated on them!
Example generations are shown on pages 19 through 27
In many games there is a "Final Destination effect" where the maps people end up playing are the most simple
This is such tired, trite, and inaccurate take on the dating market. Talk to more young men. If you think 60% of young men are nasty/abusive/unintelligent/ugly to the point of not deserving any partners - you're clearly insane.
We can comment about it here?
Since about 2005 only listen to mix shows because to me that became the best way to find new music in a curated way. Radio 1's Essential Mix just perfect in every single way for example
Ok, sorry, I did not fact check my comment. I just remembered my French teacher from school making fun about L‘Académie with regard to this and other weird French terms like „baladeur“ instead of Walkman (tm).
Irrelevant to the point. If the south of Italy is different geologically, the size of Italy vs anything else doesn't matter.
What about a VM with GPU pass-trough? Let's say I have plenty of storage and just create different VMs with selected distro or winXI that have certain games. Could that also be an option? Just drag and drop the appropriate game in the VM storage?
From a consumer perspective, I disagree.

If a program costs $200 but is something that is used very infrequently and doesn't worth $200 to me - then it's poorly priced or best sold (or re-sold) as a service rather than a program. Subscription here is just a service fee in disguise, so why not make things straight? Let me pay $20 one-time to process whatever I want it to, and be done with it.

And if something works for me today and I don't foresee any need for updates then what exactly I'm paying for? Developers will to continue development, that I may or may not need and may or may not care about? Doesn't sound right to me, unless I feel benevolent and charitable for some reason. I get the subscription model if something needs active regular maintenance. Drivers do (heck, I'd buy that rather than seeing companies "we no longer support shit, go buy our new hardware instead"), financial software does, a weather app does. But, say, a camera or note-taking app would certainly continue to work without any maintenance until I upgrade phone, or OS, or want some new features (and then I can buy an upgrade or figure out how to fix it on my own), so I won't buy a subscription (or very much hate doing so if it's my only option besides simply not having something I need at all).
It's the entire reason people want to study Toxoplasmosis. If it affects anything, that's going to mean a lot of people.
Sure, that's correct, but that's absolutely unrelated to what we were talking about; your example is about the general concept of transfer learning to task-specific annotated data, not about domain-specific pretrained models.

For example, if you want a domain-specific model for the legal domain, then you can pre-train a large self-supervised model on every single legal-related document in the world you can get your hands on, instead of a general mix of news and fiction and blogs and everything else - and that might be a more efficient starting point for however many(few) annotated examples you have for your task-specific classifier than the general model.
Exactly - IMO any subscription service that is seeing flattening growth is likely focused too much on "growth hacking." Changing the text on your paywall can only do so much, as those subscribers will still churn if the product doesn't improve to meet their needs over time.
Did not control for cat ownership AFAICT.
Your job is not a family, and employees aren't children (I assume you're talking about the non-democracy w.r.t. minor children, because otherwise that's fucking weird).
The Crowd: A Study of the Popular Mind (Gustave Le Bon) (2021)
I wouldn’t know, for Gitlab disabled my account name of 7 years due to inactivity.
Hosting your own infra is still a recurring cost given that hardware has an end of life. These servers also need employees to maintenance then and electricity to power them.

There's really no such thing as pay once use forever for anything physical.

You're just paying an estimated lump sum for the subscription revenue it would produce over it's life time
From Clicks to Code: Using Deep Learning and Bioacoustics to Study Orca Whales
See my other reply. GOTO is the generic type because it can be used to jump anywhere. BREAK/CONTINUE are sub-types because they are limited in where they can jump. BREAK/CONTINUE can be always implemented using GOTO, but not the other way around.

I agree that BREAK/CONTINUE are not syntactic sugar in languages that don't have GOTO.
I think the place for this would be on colonies off Earth.
> But criticizing them for "not picking up the phone and talking to existing operations" is kind of missing the point. Of course the existing operators are going to say it won't work.

This is true but irrelevant. The important part is asking them why it won't work and then seeing if that's correct. VCs are supposed to invest in risky things, not futile things.

Of course, as with WeWork, there's a big gap between what VCs are supposed to do in terms of due diligence and what they actually do.
Because another person is not an object, a service or an opportunity, for someone to be able to limit certain group’s access to it.

What about “human right” to have friends?
I'd rather news organizations focus on their core competencies. When you allow comments, you're now in the business of spam filtering and social media moderation - neither of which are easy. Better to allow discussion boards to host discussions and news organizations and blogs to host articles.
So like a decade ago I hated using MOC because it would mess up auto-formatters and source code parsing in all editors, but since clangd/clang-format and its LSP friends, working in Qt and having stuff like the autoformatter work perfectly has since alleviated any problems I have with using the MOC.

Now they're just equally as annoying as any other macros are, which is to say, a lot less annoying than it used to be.
Bep is rewriting the docs because are really incomprehensible. I do agree with you.
Why did these companies start with boring stuff like lettuce? The article says that indoor growing like this could allow growing delicate plants which don't travel well - why wouldn't they start with that?
> I don't understand why this conceptually is so hard to understand

I understand it fully:

> If you put out a req with that experience as a requirement, you're not gonna find people for it

You're making _my_ point, dude. That's a stupid req.

You said it yourself that the N-months-to-productivity problem (which is par for the course anywhere) is not actually a consequence of language but rather of domain familiarity or business processes or whatever. Again: not a surprise. So whether/if it takes two to ten months to see productivity from your hires no matter which language you're working in, then it's silly to lament the difficulty of being able to hire developers who can write Delphi on day one. You don't even need that!
<<No, there is no reason for me to tell you if you don't have an idea already.

Am I expected to keep track of the entire internet and its comings and goings? While I am aware of the story, clearly my interpretation is different from yours. Is it not a worthwhile endeavor to seek how other people perceive the same even? If not, why not? Or am I already labelled for having dared to defend a person deemed 'bad' by Twitter squad.

There is a reason. One is that I am unable to visit people's minds and hearts, but it is telling that you can't seem to be able to articulate the exact reason you acted this way.

<<Maybe he Tweeted about how foie gras is so amazing, and I am an animal lover.

Maybe. Was that the reason?

<< It doesn't really matter; and leads to a ton of unnecessary small arguments which I'd rather avoid.

edit: removed last paragraph. did not fit what i was trying to say
> You are, of course, correct. It can be difficult to tell when somebody is stupid, or an asshole, or merely pretending to be a stupid asshole.

It could be the case that somebody is stupid or an asshole. But you've left out one of the most important possibilities: maybe the other person is dead right about something that you're dead wrong about.

> It's all the same to the person on the receiving end. It's not worth engaging with people who don't listen. Whether they are deliberately trying to aggravate, or are merely too stupid to know that their arguments are tedious.

Using a phrase like "people who don't listen" seems a little problematic to me. That's not the kind of phrase that somebody who is a genuine knowledge seeker who is willing to consider the full diversity of human ideas would ever consider.
I've been using Revolut and their disposable cards for over two years now, but I never liked it as much as Privacy.com since they didn't allow you to set a spending limit.
And well, if it wasn't for your comment I would have never discovered that Revolut actually implemented said feature. Thank you!
Thanks for much hoped for context )
"[...] but in the real world, you sometimes have to employ extreme and extralegal methods to preserve the very system whose laws you’re violating."

This is what everyone tells themselves when they flip on their own morals, or "it's for the greater good" with the trolley problem.
> anyone doing R&D in northern climates?

Mercedes [1]. They, together with Waymo (and maybe Tesla and Cruise), are at the vanguard of this technology.

[1] https://www.bloomberg.com/news/articles/2021-12-09/mercedes-...
On second thought we are likely talking about two different things.
Anyone who has spent time on OKCupid can speak to the correlation of cat ownerships and political perspective, and the more cats owned the more magnified the political/social passion.
Levine had a nice, and more detailed, write-up last week too (https://www.bloomberg.com/opinion/articles/2023-02-23/slam-d...), including this bit:

---
NBA Top Shot’s Twitter account promoted not the coolness of the highlight videos, but the amounts of money involved in Top Shots trading. The opinion quotes some of them, and adds:

Each Tweet promotes a recent sale or statistics of recent sales of Moments on the Marketplace. And although the literal word “profit” is not included in any of the Tweets, the “rocket ship” emoji, “stock chart” emoji, and “money bags” emoji objectively mean one thing: a financial return on investment.
---

Which specifically highlights the bit about where and why the emojis in question are financial advice, and why it meets the Howey Test.

If you tell someone (through emojis or otherwise) that they'll make a profit buying something, that's financial advice.
> Drug consumption is at least as much a demand side problem as a supply side one.

Perhaps you meant "drug importation is at least..."

The importation of fentanyl is not due to demand.

The importation of fentanyl is due to it's low cost (synthetic ingredients) and high potency (less mass, smaller volume when smuggling) - and its ability to be added as a potent adulterant to any other drug (can be used to cut any other drug, to increase dealer profits) - all without end consumer's knowledge or desire that it is in there.

> Bottom line is that you need centralised state intervention to eliminate dealers and distributors, coupled with renditions to remove the vulnerable from the exposure to opportunity, coupled with pathways out of poverty for those who wish to take a different life.

An overwhelming number of accidental overdoses begins with patients becoming addicted to pharmaceutical pain medications after surgery/medical-care. Those patients need continuous, unfettered access to both the medication they are addicted to, and no-cost medical care (and income replacement, if they are working), in order to allow them to enter inpatient detox programs. The FDA's approach to treating doctors as criminals if they provide long-term access to Rx pain medication is an injustice to every patient in need.

Patients that are unable to provide themselves with the pain medication they have become addicted to (through no fault of their own) will seek other sources, which is where non-pharmaceutical (black-market counterfeits) and fentanyl enter the picture.
To any Amazon employee at HN. My book is on Amazon [1], I at one point needed to click on "KDP Select" for some extra exposure.

And here it is free for H N. [2] feel free to kick me of your monopolistic website.

[1] https://www.amazon.com/Understanding-SEO-Systematic-Approach...

[2] https://gumroad.com/l/understanding-seo/hacker-news
Me too. How else am I to know how I'm supposed to react to the news?
Shortwave: A GPT-3-powered front end for Gmail
Dash for API browsing https://kapeli.com/dash

Flycut for clipboard management https://github.com/TermiT/Flycut

iStat Menus for system resource monitoring https://bjango.com/mac/istatmenus/

Kaleidoscope for file merging https://kaleidoscope.app/

OmniOutliner for note taking https://www.omnigroup.com/omnioutliner/
Yeah I know that.

So:
> This makes union types unsound in the presence of type parameters/generics.

Sounds a bit strange to me. Why would union types + type parameters be generally unsafe? I doubt that that's true.
Democracy from the Ashes: On David Stuttard’s “Phoenix”
And if it turned out not to be lab leak, would you say that clandestine gain of function lab research was fine?

Of course not.

It's bad, whether it caused COVID-19 or not.
Amethyst is a lovely tiling window manager for MacOS.

I don't know how people survive without TWMs.

[1] https://ianyh.com/amethyst
AI Art: Deep Dive into the $75M Category
Oh, I visit regularly, should have clarified, but would not move back there. I very much enjoy the lack of bureaucracy and the amount of open space here in the NW of the US.
Just Nixon?
For my business, if it’s a subscription, we actually invest money in building out the capability in house because subscriptions increase over time

Like GitHub for example, I love it, it provides value, but it costs a ton if you have a lot of devs, and you can spin your own git server
BECAUSE Firefox is the most configurable and the most privacy-secured web browser that also gave fork to SilverFox, Tor Browser, LibreWolf, WaterFox, PaleMoon, GNU IceCat, Mull, KMeleon, Dot Browser, Basilisk, MyPal and IceRaven.

Something that Chrome is unwilling to support.
Extraordinary claims require extraordinary evidence. Given that GPT3 has 175 billion nodes, how would you even begin to support the claim that it never (or sufficiently rarely) does things that are surprising to humans?
I'm a big fan of Atuin (fuzzy shell history search) and lately I've been using Helix for most of programming. Check out Btop or erdtree as well.

https://github.com/ellie/atuin

https://github.com/helix-editor/helix

https://github.com/aristocratos/btop

https://github.com/solidiquis/erdtree
Alfred, brew
Ask HN: What are the best 2022-2023 exploit walkthroughs?
No, I wrote it in exactly the order I wanted to. Because of the substitution property that you acknowledge, GOTO is a subtype of BREAK. BREAK is not a subtype of GOTO because it cannot always be substituted for GOTO. Thus, "GOTO is a BREAK, but a BREAK is not a GOTO."

A GOTO is just one possible implementation of BREAK, just as a cat is one possible implementation of an animal.

The practical impact of this is that it is incorrect to ascribe to BREAK the same weaknesses as GOTO, because BREAK is not a GOTO.
Honestly, is it really possible to secure copyright for digital books? It's been ~16 years since the introduction of the Kindle and pirated books are just more plentiful. Publishing exclusively on paper seems to be the only real solution (and even that will likely be only temporary while pirates manually copy the text).
this is true, if and only if public sentiment is an indicator of the direction of policy. There have been a number of studies that suggest this is not true [1]

1 - https://faculty.wcas.northwestern.edu/~jnd260/cab/CAB2012%20...