skysight-inc/HackerNews huggingface dataset:
Apt is one of the most used app distribution methods on Linux, and is what Maemo and Meego used. It was even ported to macOS as Fink and, before Homebrew was popular, millions of macOS users ran apt without being exposed to abuse or malware. Billions of machines run Linux using package managers like apt, and abuse and malware are minute.

The App Store model is about profits, and security is an afterthought that makes for good PR.

Apple is responsible for letting scams and fraud flourish on the iOS App Store[1]:

> That man’s name is Kosta Eleftheriou, and over the past few months, he’s made a convincing case that Apple is either uninterested or incompetent at stopping multimillion-dollar scams in its own App Store. He’s repeatedly found scam apps that prey on ordinary iPhone and iPad owners by luring them into a “free trial” of an app with seemingly thousands of fake 5-star reviews, only to charge them outrageous sums of money for a recurring subscription that many don’t understand how to cancel. “It’s a situation that most communities are blind to because of how Apple is essentially brainwashing people into believing the App Store is a trusted place,” he tells The Verge.

Apple is also responsible for distributing 500 million copies of Xcodeghost to users via the App Store[2]. Despite claiming that Android users are protected by Play Protect, the Play Store is the #1 vector for malware on Android[3].

It isn't 2003 anymore, operating system vendors have been taking security seriously for a while now. Abuse and malware are not a problem on macOS despite barely anyone using the Mac App Store to install apps. Same goes for Windows, it isn't Windows XP anymore, and despite nobody using the Microsoft Store, abuse and malware are much less of a problem than they were in the past.

The App Store model isn't necessary for security, it's only necessary to secure profits.

[1] https://www.theverge.com/2021/4/21/22385859/apple-app-store-...

[2] https://www.vice.com/en/article/n7bbmz/the-fortnite-trial-is...

[3] https://www.zdnet.com/article/play-store-identified-as-main-...
You are right about transactional differences between ClickHouse and PostgreSQL but you are comparing apples and oranges. ClickHouse prioritizes speed, efficiency, and scale over consistency. These are reasonable choices, especially in the largely append-only use cases which dominate analytics.

1. I've seen relatively few messed up source tables and mat views over thousands of support cases. When they happen they can be bad for some use cases like financial analytics. They simply aren't very common. And for use cases like observability or log management it just doesn't matter to have a few lost or duplicated blocks over huge datasets.

2. ClickHouse overall is eventually consistent. There are generally differences between replicas when load is active, yet it causes relatively few practical problems in most applications as they load balance queries over replicas. Serialization is expensive and simply not very highly valued here.

3. ClickHouse uses other mechanisms than ACID transactions to ensure consistency. One good example is discarding duplicate blocks on insert into replicated tables. If there's any doubt whether an insert succeeded, you can just insert the block again. ClickHouse checks the hash and discards it. This is incredibly efficient and works without requiring expensive referential integrity (e.g., unique indexes).

4. It's just about always possible to get ClickHouse to boot even when you have corrupt underlying data (e.g., due to file system problems). I don't know how you define reliability but at least in this sense ClickHouse is extremely robust. I've never seen a server fail to start, though you might need a bit of surgery beforehand.

5. ClickHouse doesn't have transactional DDL. What it does have is features like altering tables to add new columns in a fraction of a second without locking regardless of the size of the dataset. Its behavior is close to NoSQL in this regard.

I could go on, but I think these points illustrate that ClickHouse has a different set of design choices for different problems. I would never use it for eCommerce, but it's great for analytics.

Disclaimer: I work on ClickHouse at Altinity.
Or at least: someone writing in Lesswrong, a not particularly reliable site (to put it mildly, but I don't want to get into an argument about it), claims this.
By "poor rural" areas you mean the people that grow the food you eat?
Not the original commenter, but I’ve heard, and somewhat observed, that Dutch people are generally more fluent in English than other Europeans; and I’ve heard this attributed to Dutch television, where English shows are generally presented in English but with Dutch subtitles, unlike other European nations where such shows would be dubbed into the local language.
Do you have a handle on how efficient these systems are and how much energy it really costs to reuse a glass bottle? Or how to find out?
South Korea Unveils Hydrogen-Powered Cargo Drone
This is why in my new project I decided to use prepared statements wherever possible, it seemed like simply the best choice because sanitizing is never perfect. Here's the article that convinced me in case anybody else wants to read: https://kevinsmith.io/sanitize-your-inputs/
Chinese Android TVs don’t have such problems, because you can sideload any APK and boom it works.
He said he was wearing N95 masks for a week before the 26th. Wuhan locked down on the 23rd.

Ebola was a large and growing problem in Africa in 2015 which covered a larger swath of the population, had nearly identical messaging from the Government, and would trigger a lockdown in Sierra Leone. Lots of folks regularly travel between the west coast of Africa and major American cities. I'd argue it would not have been prudent to start wearing Ebola PPE at that point, either. Of course, because it was Africa and not China, it only got marginal news coverage compared to the enormity of the problem on the ground, and much less traction on technology platforms because to this day, 25% of Sierra Leone's population has internet access. Epidemiologists were every bit as concerned about Ebola as they were about COVID before COVID's higher initial R0 number was released.

I'd like to hear the justification for not donning Ebola PPE given what was ostensibly a nearly identical situation that fortunately ended up being handled a whole lot better. Or maybe he did and he left that one off?
Link is now fixed.

Yes, 1A is overkill, 100 mA would be plenty (and likely still too much), but the Bosch BMS has maybe 1 mA balancing capability and that's too little for a pack that size so I decided to throw in something beefier and this was the smallest one that had bluetooth out so I can monitor it, a pack that gets unbalanced too much is a good indication that something is wrong, for instance a weld that's not done well, or a cell that is on the blink. Those things are best caught early with homebrew packs of this size, you really don't want to have a battery fire.

A good, new pack stays within a few mV over a whole charge/discharge cycle. The reason is that if you start off with a balanced pack the laggards during discharge will be the first ones to be topped off so it all balances out in the end modulo the difference in internal resistance, and this leads to the various cells dissipating a bit more or less heat (as well as the cells on the inside of the pack being better isolated). That's cumulative and over a longer number of cycles you'll see the pack drift more and more out of balance.

So it's not so much a matter of me being skeptical as it is knowing the exact limits of the Bosch BMS and the fact that if the pack ever goes out of balance more than that that it will brick the BMS, and that's a nuisance, coupled with the fact that this particular balancer had some more useful features.

16 cells in parallel, and you're right that the cells tend to self balance to a large extent. But it's also a really good way to monitor the pack so it's dual duty for me, wear monitoring (which has safety implications) and balancing all in one for less than $100, which on the total cost of this project is quite doable. The cells I'm using are $6 a piece (Samsung E35s, 3450 mAh) and 160 of them is already quite the outlay.
It's been discontinued, but the ODROID-GO was this as a handheld:

https://www.hardkernel.com/shop/odroid-go/
If you are interested in this subject, I think the free courses offered online from Santa Fe Institute, under the name Complexity Explorer will really interest you. I took their Origins of Life course and consider it to be one of the best courses I've taken for any subject. It answers your question from the point of several different kinds of scientists - different practices, from chemistry, to astronomy, to geology, etc.

They just started a new session of that course, but you're probably not too late to start it. And they have a lot of other courses (a lot of which are free) along the same theme. If anything, you'll come out with even more questions, but they'll be really complex questions.

https://www.complexityexplorer.org/
I have another machine for mobile app development. It's also used for consuming multimedia and gaming. The low spec machine is mostly for web development and my main Linux terminal for managing other local/remote machines.
Sanitize Your Inputs?
> There is no justification for Truth Social to continue violating Mastodon's AGPLv3 license.

What proof do you have of this?

Personally the fact hackers have become copyright police ready to jump on people any chance they can get is quite embarrassing, but how have they broken the licence anyway?
I should also note that Bernstein was widely known to be a complete asshole.

I think this is partial confirmation of pg's observation that independence of thought is important for creativity: if you are both arrogant and independent, you have all the ingredients to be an asshole.

If arrogance is orthogonal to creativity, as I suspect, but independence of thought is not, then we would see a disproportionate number of assholes among those with new ideas.
I certainly don't read the article most of the time. The comments here are more interesting than the post. They're what I come here for. Besides, it's nearly certain that any important information will be directly quoted here in a comment.
The normal phone-controlled Chromecast definitely doesn't have ads (but ads will play when watching YouTube unless you have premium obviously)

I feel like that experience is optimal. I don't want any launcher experience on the tv, much less any ads.
this was kind of a let down i watched until the end and was expecting something more.
https://www.fastcompany.com/90683033/the-post-office-is-fina...

“According to a 2019 report by the Federal Reserve, 22% of American adults, or 63 million, are either “unbanked” or “underbanked,” meaning they don’t have easy access to a financial institution to do things like cash checks or save money.”

“At the same time, millions of people who live in “bank deserts” are in need of banking access. Post offices seem like an apt solution: 59% of them are in zip codes that have no banks at all.”

And smartphones as a requirement for neobanks or online only banks is an equity issue. Not everyone can afford a smartphone, even one as inexpensive as $100. A debit card can be issued for a few dollars, and postal workers are already working the retail counter.
Great example with Silesia. Funny thing about "worthless zlotys" is that "zloty" is the name of a currency, as well as literally meaning "gold". In this historical case, the latter would have certainly been a more stable store of value.
This is a good balanced article.

What is often missing from these goto discussions is the dialog between Knuth and Dijkstra on this topic.

There is another discussion between the two of them about a problem requiring no less than four stacks to understand.
While that plays a role, it's a bit odd to single out Dutch for that - far from the only European country where that is the case.
I too have a drawer of various currencies, some of them even since retired, or issued by governments/nations that no longer exist.

However, given that international travel took a nosedive in the last 18 months whilst banknote production continued to stampede, I'd have to suggest that hoarding by globetrotters doesn't account for any current discrepancy in production vs use in observable trade.
I want to like mastodon, but it needs a single sign on feature and usually every server I look at it is totally dead.
I'm not sure, but I think it was Nabokov where I first saw the distinction between genius and intelligence most clearly articulated. The defining characteristic of genius is right there in the Latin root[1], it's fundamentally original. One could have Von Neumann tier intellectual horsepower and waste it all solving sudoku puzzles or something. Or one could have a much more modest intellect, and yet make utterly original and lasting contributions to human knowledge.

[1] "generative power"
I think there are hard problems and easy problems, and smarts reflects ones ability to solve hard problems.
So, the question should be how does one solve hard problems?

The solutions to any problem can trivially be found by searching through the possible solutions and checking which solution works. The problem with this approach is that it is intractable space. Thus, the main ways that we traverse the search space of solutions is limiting the search space and by pattern matching. [Think in terms of chess where the search space is large to find the best possible move...The way they get around it is by simply reducing the search space and pattern matching.]

Consequently, a smart person would be one who has developed intuition about a problem enough to limit the search space of the available solutions and has a vast collection of patterns to draw from that will aid in the problem solving process.

He did touch on one point with all extraordinary genius, they were all obsess. I think this fosters having enough intuition about a problem and having a toolbox of patterns necessary to solve hard problems. Is there any genius without a vast toolbox of techniques to solve problems? Is there any genius without a supreme understanding of his problem area?

Having intuition and huge toolbox for solving problems we know are necessary conditions for solving hard problems, but are they sufficient conditions?
I get the point, but I was answering the question of "why do people compare this with desktops". Because people compare them with everything.

You're totally right that they are impressive in their own right, especially in their category. I'm not arguing that.

Also:

> How much fan noise does your desktop produce

Basically none since modern high end air cooling is essentially silent. Water cooler pumps are noisier though.
Even if Google decides to become the exception, there are other stores on other platforms using 30% commissions for it to still be considered the standard.

https://www.ign.com/articles/2019/10/07/report-steams-30-cut...
Oh no, people get to explicitly define their list instead of some overseers tweaking the algorithm to show them what they need to see.

At least one is explicit
At some point you have to start asking yourself, why do I tolerate this stuff when there are better alternatives elsewhere?

Ditch Microsoft. Ditch closed computing.
How does pg still not have SSL on his website?
I think you just reinvented fiberglass and carbon fiber
Just the kind of thing I've been looking for!
Yes, they're crazy. Batteryhookup is an interesting company, they're very well known in the homebrew powerwall scene.

Here's to hoping that the next battery revolution will come in on time and that we'll see some real economies of scale here.
Almost all US banks have had upside down Texas ratios since 2000. Used to be savings accounts paid the rate of inflation, but not paying inflation and driving investments into riskier classes is the way they are driving revenue to pay off their bad debts.

With covid, the likelihood of bank failures has risen considerably as the savings money is drying up or moving out of cities and investment risks have raised considerably. Historically, whenever banks got systemically over-levered and they try to avoid a systemic banking collapse, they come for the commoners assets. Last time around they did gold confisaction. I remember in 08 they were talking about confiscating 401k money into the stock market.

This is no different. This is a creepy article full of trite anecdotes and observational BS that demonizes anyone that uses cash as a drug dealer or sex trafficker and doesn't mention the root issue.
I want exactly this but with an official format.
That seems like exactly the sort of behavior citizens would want to minimize.
You get to learn about the the Defense Switched Network[0] today. The US military does have an internal phone network, but the unclassified side can be reached from the normal telephone network just fine. One of the fun things is that if the network is busy, certain phones can do priority calls and kick lower priority calls off to get the bandwidth freed up. The red buttons to the right of the key pad allow that phone to do that.

[0]https://en.wikipedia.org/wiki/Defense_Switched_Network
But why did he want the smallest box?
1. Consider any money you spend as lost, with a chance of being recovered when it's converted back into your local currency. The ongoing Tether scam is a huge risk, especially in the less than 10 year time frame. There are many ways to lose everything, as this is a new thing society isn't used to.

2. Dollar cost averaging, don't jump in at the market rate, unless you're just making lots of small bets. You can place orders that get filled when the price drops below a certain point... you effectively have money waiting to buy a dip in that case. You can also do the reverse, sell at a certain point. Learn all the different transaction types.

3. Start small... do some small trades to see how things work, and make sure everything is as expected.

4. There is a very strong element of Ponzi scheme in the crypto space... if you can, watch the inflows and outflows in the meta.

5. Never panic sell, or buy because of fear of missing out. Play it for the long term. In the stock market, emotions lose money, the same is true in crypto.
I'd just note a full read of the article shows that the origin of the bills is apparently quite murky and North Korea is just one of several accused sources. Israel blames Syria, some US media blames the CIA. Nothing is proven and nothing is certain.
I think pg is right that less responsibility leads to new ideas.

Since having kids, my ability to pursue my interests is severely curtailed. My kids are just now at the point where most of them are sufficiently independent that I'd have less responsibility, and now my in-laws need care, with my parents probably not far behind.

It seems likely that I won't have significant free time and mental energy until my parents are dead, which is a bit of a depressing thought...
First time I can remember them down.
I just watch YouTube with ad blocking. I do feel slightly guilty, as it means my favorite channels don’t get paid for my views, but I justify it by telling myself that most of them have sponsors that they mention in-video.
And these are places that have Post Offices?
Imo, one of the hallmarks of superoganism is the propensity to sacrifice ones existence for the survival of the superorganism. Humanity in this sense fails this test because of a strong sense of individualism amongst us.

I do believe we do have a bunch tribal behaviour up our sleeves, but it pales in comparison to what other superoganisms have developed over millions of years of evolution.
No isn't good enough here. Their whole 'Democracy dies in darkness' thing happened in sync with a huge push to get people to subscribe. Now that may be coincidence but I highly doubt it was.
Hugops, attacks are never fun.
> most small (by transaction volume) startups could get away with being on a managed platform like Heroku or Google App Engine.

BTW what's wrong with this? Honest question!
HEPA filters work really well, it's worth just buying a few big ones and running them inside.

I got a few in CA because of the fires, but I run them all of the time and they work. I also have some AQI sensors and I can see the pm2.5 drop rapidly when the air filters kick in.
I can't comment on most of these. However, as a Mississippi native, I do have to comment on the "Mississippi Plate".

The steamers are known from the river that shares a name with the state. The steamers are not as much a part of the history or culture of the state itself.

The current (or maybe old) license plate references The Blues, I'm glad to see that. But a better secondary would be the Magnolia Flower (which adorned Mississippi's license plates for decades). People all across the USA tend to confuse the State of Mississippi with the river; we don't need that on our license plates.
But is this what preppers are really prepping for? Maybe I'm just too far into the conspiracy theorists and what not, but my personal experience with preppers are way way way futher than fears of social unrest.
All you're doing here is re-stating your original argument, seemingly without actually understanding my criticism of it. I'm not sure what you're hoping to accomplish by that, but it strikes me as very strange.

Look, let's say we observe an employee and employer undertaking a discussion that goes something like this.

"Take this medicine"

"No I don't want to"

"Take it or else you're fired"

"I'm not going to take it, fire me if you have to."

"OK, you're fired"

"That's going to turn out poorly for the people who must now suffer the consequences of not having people available to do my job"

I don't understand how you jump to the conclusion that the reason the employee refuses to take the medicine is so they can have that last line of dialogue, rather than that they don't want to take the medicine.

Enlighten me?
Please remember that the only thing which had any real volume in that time (1985 and prior) period was dynamic RAM. DRAM drove semiconductor process development until microprocessors eventually took over as defining the process capabilities (about 1990-ish).

The US DRAM manufacturers got absolutely destroyed by the Japanese ones. So much so that getting out of DRAM was an existential crisis moment for Intel.

One big point of the crux was scan lithography vs step and repeat lithography. You needed step and repeat lithography to get to the next level, but it was way more complicated than scan lithography. The US companies made the jump--the Japanese ones didn't. The Japanese companies clobbered the US companies in terms of profitability and production.

This is part of the origin of "never be first" in the semiconductor industry.

The US government then stepped in and pumped a massive amount of money behind semiconductor tech to stabilize that. Of course, once step and repeat (and some other related technologies) went online, the Japanese DRAM companies now got slaughtered and basically driven out of business.

Things don't always "just work out" and sometimes the game really does create "winners and losers".
>[...] clear writing is an indication of clear thinking [...]

I think this is technically true, but I tend to think of it more like "Attempting to write clearly will lead to clear thinking". It's hard to be sure you're thinking clearly until you've attempted to communicate it precisely.
You can see this play out in Texas, at the ERCOT dashboard.

https://mis.ercot.com/public/dashboards

Interestingly, you can see that wind and solar are anticorrelated there: wind tends to die down during the day, and spring back up at night.