skysight-inc/HackerNews huggingface dataset:
Correct, a common mistake people make is conflating these things. I wrote this several years ago about MongoDB:

One thing that helps is if people stop referring to things as SQL / NoSQL as what ends up happening is various things get conflated.

When talking about stores, it's important to be explicit about a few things:

1. Storage model

2. Distribution model

3. Access model

4. Transaction model

5. Maturity and competence of implementation

What happens is people talk about "SQL" as either an NSM or DSM storage model, over either a single node, or possibly more than that in some of the MPP systems, using SQL as an access model, with linearizable transactions, and a mature competent implementation.

NoSQL when most people refer to it can be any combination of those things, as long as the access model isn't SQL.

I work on database engines, and it's important to decouple these things and be explicit about them when discussing various tradeoffs.

You can do SQL the language over a distributed k/v store (not always a great idea) and other non-tabular / relational models and you can distribute relational engines (though scaling linearizable transactions is difficult and doesn't scale for certain use cases due to physics, but that's unrelated to the relational part of it).

Generally people talk about joins not scaling in some normalized form, but then what they do is just materialize the join into whatever they are using to store things in a denormalized model, which has its own drawbacks.

As to the comment above you, SQL vs NoSQL also doesn't have anything to do with the relative maturity of anything. Some of the newer non-relational engines have some operational issues, but that doesn't really have anything to do with their storage model or access method, it just has to due with the competence of the implementation. MongoDB is difficult operationally not because it's not a relational engine, but because it wasn't well designed.

Just like people put SQL over non-tabular stores, you can build non-tabular / relational engines over relational engines (sharding PostgreSQL etc.). In fact major cloud vendors do just that.
Did you read any of the attached? They have banned people for no reason and decided the money in their account was forefit as a result, all of these things they have "actually done", I'm not sure what more you'd hope for them to do before declaring it bad?

Updating user agreements with nonsensical statements, threatening users with "fines" without involving the court system at all? Declaring themselves capable of deciding what's acceptable internet conduct for their users to engage in?

If these and all the attached threads don't seem like a red flag to you at all, I'd question what the hell does?
Maybe 9? If you find yourself making a lot of jigs, small thingies to hold one thing to another, or little mechanisms, it's a huge timesaver. Making a nice adjustable mount for a camera goes from being a lot of machining to a few hours design work.

Basically, it's very good for making things for holding awkward pieces in place while you machine them, or for holding a tool in place while you make something. Or like, all the little cable clips and bits of plastic you use to hold other components in place.
CLI utility and python library for manipulating SQLite databases
Can we fold this comment? :)

And to be constructive...

1) Yes, this is why for example Codeberg exists.

2) Kudos to Gitea.
FYI: After reading your post I installed it and found this AWS how-to:

https://github.com/jameswmccarty/aws-socks5-proxy

...since I'm already using an EC2 instance for my own personal stuff.
The problem with ISRIB is that it isn't water soluble. I'm not convinced that people who take it (usually subcutaneous injection or snorting it) aren't just experiencing placebo. I don't know of any way of actually getting the molecule to your body's cells in a consistent manner.
That's nonsense. The crisis in France is because of aging reactors needing quite more maintenance.

The reactor France builds is many years late and extremely expensive. France has for decades extremely nuclear friendly governments. The actual problem is money, number of engineers, technical capabilities, ...
So you don’t actually know how ancient or medieval markets worked. That explains the confusion.

Generally people couldn’t arbitrarily start a business without permission. Rulers would limit who could say sell salt and permission it’s self was quite valuable. Think Arrakis being handed over in Dune, only one house had the right to mine spice and that would change based on politics not just competence.

And that’s just the start as slavery, guilds, gender, etc all limited markets.

Throughout history you can track a huge wealth boom whenever places opened up their markets. England’s wealth traces back before the industrial revolution to the early dissolution of serfdom relative to most places. It was actually far more influential than inventions like the early steam engine.

As to penicillin, invention is onky part of the story having a society where people had free time and resources to do research was it’s self a major hurdle. As would having surplus labor to manufacture such complex medicine.
I love you saw a train a while back because of your site
Tether volumes on Tron and Ethereum would suggest that perhaps you may be incorrect. Probably not hundreds of millions of dollars at once if you aren't working with legitimate OTC desks who can handle that size but even if you work with the more sketchy p2p types it is possible to do 7-8 figure transactions.
Firebase is super convenient and works very well for the most part but my heart races every time I receive an e-mail from them. A silly mistake can cost you so much money and they tend to word the e-mails strongly.
As a regular programmer, I got really into queuing theory thinking I was going to learn secrets of performance tuning, then was slightly disappointed.

But it turns out the simple parts of it go a long way! Eg at work we have a single deployment queue for a monorepo. At first approx this is an MD1 queue (deploy job takes roughly the same amount of time every time, though arrivals are actually way spikier than poisson), and realized that wait time was inversely proportional to total utilization.

While the infra team was saying “we do X deploys per day out of 4X and are only at 25% capacity”, I realized even hitting 2X would more than double the already bad wait time.

What happened is that a few initiatives were under way to increase capacity, but then out of nowhere the queue got log jammed (bc of high arrival rate variability) and we had to switch to Gitlab merge trains, which run CI concurrently on the optimistic result of merging. I wrote about it here: https://engineering.outschool.com/posts/doubling-deploys-git...

I’m planning on writing a blog post about the math of CI/CD deploy queues as G/D/1 queues.

For a programmer’s view of queuing theory and great performance testing foundations, I highly recommend “Analysing Computer system performance with Perl:PDQ” (don’t worry about the Perl, the book is very relevant) http://www.perfdynamics.com/iBook/ppa_new.html, which shows examples of queues inside computer systems and how to model them.
The author has a nice little library to model different computer systems you come across.

I liked realizing that the dreaded “coordinated omission” problem in load testing (when you can only generate X rps and the server can handle more than that, your numbers are bunk) is actually when you think you are modeling an open system but you don’t have enough resources and end up seeing the closed system behaviour.
My recollection is that progress on Firebase stopped when Google bought it, and I haven't followed it for almost a decade. Does anyone know if these basic features were ever added?

1) It used to download the whole state (write history) upon startup. Did they ever update it to send a snapshot, or a partial view of the data with lazy-loading for additional nodes?

2) Did they ever provide a simple push notification service? That was pretty much the only thing missing to be able to run Firebase without another server.

3) Were node aliases/shortcuts ever implemented, so a node could be a reference to another node? That would have greatly reduced the need for a SQL JOIN alternative.

Also, after having done some cloud dev ops work, I can't endorse it from any provider at this time, as the burden of securing things like user permissions is beyond what humans are generally capable of, so I consider them an anti-pattern. A better pattern is token-based authentication for everything, using standard web metaphors and REST APIs, so that every service behaves like a sandboxed root user with limited abilities granted. I also wouldn't use any cloud service without Terraform or a similar declarative infrastructure manager. Meaning that the best cloud service is basically the best Terraform configuration, providing a higher level of abstraction like Heroku, which largely defeats the purpose of direct cloud hosting in the first place.

So.. the cloud is no substitute for Firebase, and if it goes that route, it will be no surprise if customers jump ship.
Sorry I worded my previous response poorly.

> The 8.8cm german flak gun WAS a radar-guided AA gun.

The Kommandogerat 40 was a rangefinder/computer, not a radar. It had the capability of being radar-guided, but was not necessarily radar-guided by itself.

For the Kommandogerat 40 you needed a direct line-of-sight (they were still used in overcast conditions though) but it would compensate for the velocity vector of the incoming targets, altitude, wind, and would relay fire controls to all the flak pieces in the battery. Not as nice as a radar, but it was able to be fielded in mass quantities, and I think it deserves its place as 2nd most devastating weapon of WWII. Especially since towards the end of the war, the Germans were the ones playing defense. It made the strategic bombing campaigns of the allies very painful. The RAF bomber crews had a 44% death rate. That's deaths, not casualties.

It also excelled in direct fire roles against ground targets.
> if he comes for my family and home, I will fight for them fiercely

But why not compromise instead? It’d be less violence for your family.
Michael Levin: Intelligence Beyond the Brain (networked daptive morphogenesis~)
Because half truths like your statements bother me? Yandex is a large investor in clickhouse Inc. (at last as far as public record shows). Have they forced Yandex to divest their holdings?
Literally all those countries threatened world stability by invading their neighbours or attacking the US and others directly or indirectly.
If you are looking for a cognitive enhancer then caffeine and modafinil / provigil have been proven to enhance focus. I believe that latter of those is used extensively by fighter pilots and other military to stay alert; and the former is used by pretty much everybody for the same purpose.

I know drink a cup of coffee is probably not the answer a lot of the nootropic heads are looking for; but I don’t think there are any silver bullets here.
Windows swap never worked well. The OS was always famous for trashing constantly, and only started to lose that fame when computers started coming with way more RAM than any sane OS could use.
Added terms in parenthesis because the video title seems too generic. The content is somehow disturbing in its findings.
2 things about this.

1. The user was led to their misconception because the ui did not provide any better conception.

Perhaps the label should add the words "... by a repo admin" or something.

2. This still does not explain why there should be any difference between an anonymous and a logged-in user for merely reading.

If the repo owner is to be given the power to hide comments, why should a logged-in but otherwise unspecial user be able to override that? If a logged-in but otherwise unspecial user should have the option to unhide, why only when they are logged in?
Q: How many operators I need to have at the same time when my telephone center receives 10 calls per minute with an average duration of 30 seconds so that the wait time won't be over 5 minutes?

A: X, and then the operators will be busy Y% of their time.

Especially if Y is low, many callcenter operators will rethink what SLAs they want to give callers.

Many call centers optimise for keeping their operators busy aka paying as few operators as possible (and some of them then show their personnel the queue length or average waiting time and expect them to more rapidly kick out callers when that gets too long)

For most people, it’s the same with doctor visits. There is no inherent need to have to wait at a dentist, for example, but if dentists plan to have their day filled with paid work, there has to be. They may even schedule their first patient (possibly even the second) at a time before they plan to start working.

It’s different for people whose time is worth (much) more than that of the dentist. They (effectively) pay their dentist to wait for them.
Runnning lambda functions on a specific thread with Qt
What no cats?
Not an astrophysicist, but I think the assumption is that all of the photons are emitted at once in an explosion, and of course they all travel at the same speed. So if the burst is two minutes long, the near side of the explosion was two light-minutes closer than the far side of the explosion.
Also the game Zeek the Geek [1] which was a fun part of my childhood

[1] https://archive.org/details/ZeektheGeek_1020
Imagine observing a lightning bolt strike the ground. The bolt travels through air almost instantly and emits sound in every direction throughout its path. First you will hear the sound waves emitted from the point that it touches the ground, because that is the closest. Then you will hear the sound waves from 1 cm off the ground, 2 cm, 3 cm and so on all the way up to the lightning bolt's point of origin in the sky. By measuring the duration of the noise you can tell the length of the lightning bolt (assuming it's perpendicular to the ground).
It's interesting that the ostensible reason for serializing the parts is of great benefit to Apple by basically killing off second-hand parts and third-party repair shops, much like its ostensible privacy-related reasons for locking down ads in the App Store have massively enhanced its own Ads business while crushing its competitors.

In this case, Apple has forcibly become the gatekeeper for all parts, both used and new, and has plausible reasons for why this is good for the customer. It's really quite brilliant.
Meta: Kind of a dupe, here [1] is the discussion from 7 days ago when this was a LWN subscriber-preview.

[1]: https://news.ycombinator.com/item?id=33131840
If your issue is that you find the title racist, then your issue is with the Saudi Arabian government, not Ms. Smaker. The filmmaker accurately named her documentary after the subject of the film, which was a Saudi government program. If you read the article instead of immediately having a knee-jerk reaction to perceived "wrongspeak", you could easily have ascertained that information.
Based on the explanation in the documentation <https://docs.kernel.org/admin-guide/sysctl/vm.html?highlight...>, I set 'swappiness' to 100. I figure that SSDs are fine with random IO, so swap isn't likely to be much -if at all- slower than pulling pages back in from disk.
>Firebase stopped when Google bought it

I duno about that. I've seen lots of new features for Firebase for a number of years now.
> No one “powerful” can stand up to a mob for long.

Interesting theory, but how does it match reality? Donald Trump, Joe Rogan, JK Rowling, Dave Chapelle, Louis CK... these are powerful but "cancelled" people. Why aren't they out of the public sphere despite years of "the mob" being against them?
How to Brine and Cure Your Own Olives
Isn't that the purpose of Billionaires, to control and 'disrupt' as much as possible in their game of monopoly while normal people pay the price?

If you ask me 100% of income, assets, and total net worth should be taxed once you hit 999,999,999 dollars. Congrats you win monopoly, now everything else you contribute helps other people, you can choose to retire so you help less people, start a foundation so you can help people in your own way, or just keep working even though you don't get extra points.
Read the article and maybe you'll find out
> Your personal definition of cancellation does not match what is “normally” understood nor what is documented https://en.wikipedia.org/wiki/Cancel_culture

Well, if you're going to cite Wikipedia as documentation, I'm going to cite it too: "Criticism of the concept" https://en.wikipedia.org/wiki/Cancel_culture#Criticism_of_th...

I get the impression that the term "cancel culture" can mean anything that anyone wants it to mean, and it ends up becoming amorphous complaining about random grievances real and imagined. (Kind of like the imaginary "War against Christmas", where Christmas is cancelled because some people choose to say "Happy Holidays".) Regardless, I would personally make a distinction between "I was fired because of X" and "My friends don't like me anymore because of X". I don't think it's useful to have one term that covers these two very distinct things, and also I don't think the latter is worth having much of a public debate about.

It's difficult to take "cancel culture" too seriously when many self-described victims of cancellation were simply criticized. They seem to think any form is criticism is bullying and ostracism, and that everyone has to duty to be accepting of their obnoxious opinions.
You can use Sketchup as well, it has high usability
Didn't know about that, thank you! (Their terminology is confusing though: a "VST" that only works in Reaper is a Reaper plugin, not a VST proper...?) But anyway, will try it!
I always felt this was obvious, what did people think incognito mode was? It literally says "Now you can browse privately, and other people who use this device won’t see your activity." when you open an incognito window. It doesn't claim to be a VPN or anything.
On android when you open an incognito tab it very clearly says that this mode will not store browsing history, cookies or form data.

And does "nothing" to stop ISPs or websites tracking you.

Not sure how anyone can misunderstanding what data is or is not saved when it's stated on every new incognito tab.
Sometime words can mean multiple things. Pimp to mean cool as been established for atleast a few decades at this point.
Thank you for pointing this out. It's strange the contortions other posters here are going through to pretend that a normal person wouldn't understand that when Google tells you're in incognito mode, Google still tracks you. If I put Firefox in private mode, I'm pretty sure the Mozilla Foundation doesn't get to see a bunch of my activity. It's pretty simple.
They have done something to speed up Openscad quite remarkably. https://ochafik.com/jekyll/update/2022/02/09/openscad-fast-c...

Most of the problems with complex objects have magically disappeared.
Technically the Surgeon General played a big part in muddying messaging on masking [1], but the CDC takes full responsibility for the PCR fiasco.

[1] https://web.archive.org/web/20200301001854/https://twitter.c...
It would have been useful to put it on a scale to compare it against other measured GRB. It is hard to get a sense from the article on how much more powerful it was.
Sounds like a Fermi paradox related fact. Specially in the center of the galaxy, I suppose.
> Some of us also remember the health authorities promising herd immunity (and end of lockdowns) after X% get vaccinated.

Herd immunity was a key argument of the anti lockdown folks; the people responsible for the Great Barrington Declaration regularly claimed it was almost here. https://www.nature.com/articles/d41586-020-02948-4

"Despite widespread critique, the idea keeps popping up among politicians and policymakers in numerous countries, including Sweden, the United Kingdom and the United States. US President Donald Trump spoke positively about it in September, using the malapropism “herd mentality”. And even a few scientists have pushed the agenda. In early October, a libertarian think tank and a small group of scientists released a document called the Great Barrington Declaration. In it, they call for a return to normal life for people at lower risk of severe COVID-19, to allow SARS-CoV-2 to spread to a sufficient level to give herd immunity."

Fauci and others openly noted they didn’t know the exact amount of immunization needed to reach it - numbers given were openly stated to be an estimate - and we never hit the 80-90% numbers often speculatively thrown around. Variants then made things worse.
> I've talked with multiple ex coworker developers at Google about the 3 to 6 months it takes to actually figure out how to deploy something.

In typical developer environments, you end up with a bell curve of "easy things are relatively easy (host a static site, 30 seconds), but some things end up being totally impossible (build a global CDN with 99.999... availability)."

Developing at Google is not at all like this: building anything at Google is medium-hard. It takes longer to do simple things, but at the same time, basically nothing is technically impossible. In many cases, doing the hard things is much easier than elsewhere because, yeah, sure, you have to set up 20 different config files, but those config files abstract damn near anything a production system needs to operate.

Example: I wanted to add improved image serving functionality (e.g. imgix style URL params), and I was able to integrate the existing infra Photos uses in about 15 lines of code and a few hours. I don't think there are too many places in the world where it's possible to provide that functionality in an afternoon. Why it never shipped is a separate story involving non-technical reasons (cross-PA politics).

> Also the constant overhead of approvals and oddball systems (gerrit!) thereafter.

IIRC only the Android codebase used Gerrit, the rest of Firebase and GCP were on Google3. The approvals and other stuff... true.

> Eventually good DX seems unimportant and even associated with failure.

I think this comes down to a definition of "good DX". I think the HN definition (indeed by default one) is "how quickly can I solve for an issue using the happy path." Indeed, Firebase solves that for a good number of problems (why people use it, why there are people who love it).

At some point though, you can't solve for _all_ use cases along the happy path (see e.g. SAML, ABAC, any $ENTERPRISE_FEATURE). If you want to expand the business, you need to solve for some things that don't have a perfect happy path, and that's where things start getting messy.

IMO, the goal of Firebase's acquisition was to keep Firebase solving the 80-90% of things that had a happy path, and GCP was the remaining 10-20% where folks had to break out of to do arbitrary things. It seems like a lot of folks in other threads here are complaining about that because the abstractions leak out--I think it's a fair criticism, but I also am not entirely sure how to solve for that.
I think I do. I've been looking around for similar ideas. I've also been alienated many times by multiple workplaces because people gradually succumb to workplace politics and mind rot and any attempt at improving yourself or aiming at high perf is a massive threat.

Anyway if you know groups/sites to join, count me in.

ps: beside me or us, I think this could have deep implications to society. I believe the status quo (rot mentioned above) is a pain for many but culture made them forget how things could be, and they'd be healthier and happier going back to perf (and fun) oriented job life.
This is my dream! ( when I was 10 years old )
Hope more sensors become available
Does not explain why there is any difference between a logged-in user and any other for reading.