skysight-inc/HackerNews huggingface dataset:
SQLite has runtime-pluggable VFS support, i.e. you give it a struct with functions for opening a file, reading some bytes, writing some bytes, synchronizing file contents, closing a file. This project provides such a VFS module, that, because it actually runs in the browser, performs HTTP requests to read data. Emscripten provides a way to run a mix of C/C++ code in the same environment as some JavaScript code inside the browser. The reason SQLite has this pluggable VFS support is to properly support embedded systems, different locking APIs, and things like database encryption.

https://www.sqlite.org/vfs.html
Using HTTP range requests like this is just SO clever.
If you are interested in full-text search on the client, Lunr is also an option: https://lunrjs.com/docs/index.html
Google does this even more egregiously with Android - my default browser is Firefox, but any links from Google News, Google Assistant and other Google software open in Chrome.
> New influenza vaccines (using cell lines) were approved after use in 15,000 people

The are several important differences: (1) it took 4 years of data, not 6 months of data like Pfizer, (2) using mature, well known technology.

Now, let's compare to a flu vaccine approved with an EUA after 6 months, shall we?

https://www.bmj.com/content/362/bmj.k3948

https://www.sciencemag.org/news/2015/07/why-pandemic-flu-sho...

(Both articles describe the same vaccine, pandemrix)

It caused narcolepsy, a few hundred cases of it. That's a debilitating, life changing disease; by all estimates I know, much worse than the flu it was supposed to prevent. It's not the only case (though there aren't maney - 1976 flu vaccine causing guillan-barre, dengvax worsening dengue, israeli anthrax vaccine causing harm, probably a couple more I'm unaware of; the vast majority of vaccines -- all that I'm aware of that got full approval rather than an EUA - have a 1:1,000,000 or better adverse event profile).

And it isn't even perfectly clear why. The science article says it's likely because there's a similarity between some viral protein and some brain protein -- but that's not clear that's the reason. According to the BMJ article, basically the same vaccine but with a different adjuvant caused none of the issues.

How long did it take to figure this out? Approximately one year of data.

I urge you to read the BMJ article - it eerily describes exactly what's happening now, 11 years ago - some of the names (e.g. Fauci) haven't changed; some have.

> Are you overestimating the safety testing done on other vaccines?

I don't think I am. That's why we have VAERS and a European equivalent. You might notice that a lot of the touted efficiency and safety data is coming from Israel. Well, Israel has no VAERS equivalent, hardly tracks any adverse events for this vaccine (likely on purpose), and decreed that vaccinated people are not to be PCR tested unless they show obvious COVID symptoms, whereas unvaccinated are required to have negative test from the last 48 hours for many activities -- which means the data will show it's working even if it doesn't. Israeli data is rubbish, other data is hardly available. (I currently live in Israel and track this; It's been politicised in Israel to the point that no data coming out of Israel is trustworthy)

So, regardless of safety of other vaccines, we have very little reliable data about the new guys.

> but I wonder how you've gone about assessing previous safety proofs.

By waiting enough time to get data accumulated.

You know why we ddin't have any corona virus vaccine before 2020? It's not for lack of trying. They all failed at various stages, all of which were skipped for the SARS-Cov-2 vaccines.
Isn't there a literal "Compatibility" section in the App Store listing where it tells you if the app will work on your device or not?
I’m not saying that we will get this outcome, just that it’s the outcome that we need. Unfortunately I agree with you that we won’t.
I don’t think we can generalize that, because it depends on where the hunter-gatherer lived.

https://www.cnn.com/2017/07/05/health/hunter-gatherer-diet-t...

It’s a three day sampling, but fruit and honey make-up a non-trivial portion of their caloric intake.

Inuit diet, of course, was mostly fat and protein
out of necessity
Tariffs usually
There's a "Compatibility" section under each app which tells you whether it works on your device. You can also click on it so it tells you exactly which OS versions are supported.
I'm reminded of Chris Wellon's "Prospecting for Hash Functions", where he randomly generates hash functions and then runs them through a couple of tests.

https://nullprogram.com/blog/2018/07/31/

Out of curiosity, is running the state through a hash a reasonable rand strategy?
Basically, they assume you’re using a retina quality (aka HiDPI) display where each virtual or abstract pixel maps to four physical pixels in the display.

For example, you have a 27” 4K display, but set the resolution to 1920x1080 in System Preferences.

Mapping each virtual pixel to four physical pixels lets you render curves really crisply. However, on non-HiDPI where you don’t have pixel doubling, you have to use sub-pixel rendering to approximate curves.

One technique is playing with slightly shading adjacent pixels so that at a distance curves appear to be smoothed out. But for some technical reasons, Apple dropped support for sub-pixel rendering. It was too hard to do and the future is HiDPI anyway.
But how do you then use the resulting compost?
You can't deny the utility of a modern phone is high despite this.
Online Game Boy Tetris
Has anyone else had issues using Archive on mobile browsers? I always see a CAPTCHA that renders off screen, with no way to pan it into view or react to it.
I'd pay good money for a phone with an updated version of Windows Phone.
Slack has a fun dark pattern - they purposefully remove functionality from their web app to make you install their native app.

The web app has a workspace switcher sidebar, but it only appears on ChromeOS, where you can't install the native client.

https://webapps.stackexchange.com/questions/144258/slacks-we...
A Growing Problem of ‘Deepfake Geography’: How AI Falsifies Satellite Images
The demo here uses a 670MB database file.
I was shopping on Eddie Bauer about 15 minutes ago. They have a great deal on t-shirts and shorts, which they plastered all over the page. It works like this - the more items you buy, you get a bigger discount.

Great - that makes sense. But there’s a catch. If I shop in a store, I simply go to the counter, get the discount upon checkout, pay, and I’m on my way.

On their website, I have to use a promo code. So I have to remember what the promo code was and enter it at checkout. Okay — that seems kind of like a dark pattern.

Here’s where they lost my trust. By the time I got to the checkout page, they asked for all my shipping and billing details and then gave me the final purchase button. I just happened to then realize that wait — I was supposed to enter in a promo code! So then I had to back out to find the promo code again, and on checkout, I have to scroll down a full screens worth of real estate BELOW the purchase button to enter the promo code.

So they advertise the discount up front but then use shady tactics hoping I either forget to use the promo code or even if I want to, I give up trying to find it and just pay full price.

Needless to say I decided not to purchase from them. It’s dishonest and not worthy of my business.
It theoretically should also work with Firefox, but for some reason that I haven’t yet discovered it’s not working. It requires SharedArrayBuffer to be enabled on the browser and that’s currently only Chrome/FF.
I do the same thing, except my bar is "could this help someone else?"

I don't collect visitor statistics nowadays, but those posts tend to bring hundreds of visitors per month, so they're certainly worth something to someone.
I'm really hoping AirTags put some downward pressure on the tracker industry. There's an outrageous markup on most other trackers like Tile. Maybe if people can get AirTags for $30 Tile will stop pretending their $3 plastic squares are worth $25.
If it is glossing over implementation details, why does it mention the stack? That _is_ an implementation detail.

AFAIK (I never looked at an official standard, only at drafts) the standard doesn’t mention the word “stack” at all

A C++ compiler is free to allocate environment frames for every block on the heap.
https://money.cnn.com/2014/08/04/news/companies/facebook-out...

I always wanted to apologize to Sgt. Brink for having to take my calls that day.
Don’t you think it’s unrealistic that all effort is put on #1 topics? What if people genuinely care about problem #3 and #12? I don’t think it’s a wasted effort. Or maybe I’m misreading your comment?
If Microsoft can't hire people to be able to design a webpage that renders in all web browsers, then they have fallen much further than I would have even made fun of them.
It’s fun to imagine the implications of dramatically raising the standard for commercial speech, such that statements which intend to mislead are prohibited.
Well, given that some sites employ hundreds of trackers and other barely-above-malware stuff, it does make sense for these requests to take ages.

Unfortunately, many people simply click on the "accept all" button and don't care about their privacy that much.

The idea of GDPR was that consumers would be hesitant upon seeing the massive amount of third parties that use your data and demand change from the providers, turns out people don't care / providers rather let privacy-oriented customers suffer than to take a hit on their advertising profits.
It's "just" TEMPEST in the nth iteration.

https://en.wikipedia.org/wiki/Tempest_%28codename%29
I do not know how it is in the US, but where I live those automatic subscriptions are cancelable (and usually refundable) by the user via the bank or credit card company if the company collecting it is not responding. This is very easy in the first 56 days and a bit harder afterwards. They can retry to collect but you can keep doing it. The idea is you send them a official letter telling them you revoke your authorization which they have to do, not adhering to that request is their problem not yours. Depending on the contract this might trigger fines or require you to front the entire bill at once but for normal recurring subscriptions this is not an issue and otherwise should be reasonable (paying a 'fine' higher than the total sum is not allowed for instance).
Execs decide what viewpoints to punish and what viewpoints to promote and this decides the culture.
So they are filing a document with SEC, it has a"Risks" section. They mention as a risk that the full self-driving might never work. I'm surprised if they had never mentioned that risk before, but the article seems to suggest that.
No one ever asks how to exit emacs because there is no need to exit emacs.
C++ Fundamental Types: Data Models: C++ Standard, LP32, ILP32, LLP64, LP64
It doesn't matter though. The AirTags' tracking (on a map) actually works, while Tiles' doesn't.
April 29TH, 2021 Development Update
Constantly. Her list of banned medications is huge. Each time she’s prescribed a medication, she has to decide if the “rare side effects” are worth risking or are worse than going untreated.
Mexican avocados were banned from import to the United States for over 80 years until 1997. Before that, the supply of avocados from California was seasonal and limited which discouraged restaurants from putting them on their menu and generally kept them more a novelty. Ironically, having a strong consistent supply increased demand. Also, Mexican avocados are generally far superior to those from California.

I remember avocados from the 90s as being rock hard and mostly flavorless. Perhaps they were better locally, but I never had a tasty, buttery soft avocado until the 2000s.
The problem is their competitors manage to accomplish opting-out near instantly.
> I remembered the w3w immediately.

But in what situation is this useful? How is it more convenient or useful than a regular address? Even if you’re somewhere where there are no addresses, and you need to describe a location that has no other descriptive characteristics, isn’t it a lot easier to just drop a pin/bookmark on the map in your smartphone? Especially considering you can’t reasonably run the algorithm without a digital device of some kind.
Wow, that is pretty blatent. When EU stomps on them I'm sure someone else will pop up. Any chance the companies employing trustarc could be liable?
And these experiences usually can't be reduced to the symptoms list in the dsm. These lists are very simplified models that are useful for certain things.
Disclaimer: I am not qualified to interpret this study and have no experience in this field.

So the study indicates that the Spike Protein binds to ACE2 that is found in the membranes of cells located in the lungs, arteries, heart, kidney, and intestines, and down regulates them to the point where it damages your mitochondria in those organs. So according to the research they did, it's not just the virus that can hurt you but the mechanism (Spike Protein) the virus uses to attach to your cells and replicate that can cause this damage.

It is likely that the vaccine itself which holds the mRNA and not the actual Spike Protein or Virus (just the instructions on how to make the Spike Protein) is administered in a intramuscular area of the body (Shoulder Area), never able to live long enough (mRNA dies off quickly) to enter these areas where ACE2 is found (Heart, Lungs, Kidneys, etc). The muscle tissue/cells in the upper arm create some Spike Protein and your immune system basically say WTF is that and kills it long before it can ever reach these organs or areas of the body.

The real Virus typically enters the body through the nose and mouth and heads directly into the sinuses and can spread very quickly to lungs and then move on from there into other organs. If you're someone who is one of the folks (Metabolic Disease, severe autoimmune dysfunction) who might be susceptible to what this study suggests, the vaccine is the way to go since it might give you a better chance to avoid the negative outcome from the Spike Protein affecting ACE2 and then damaging the mitochondria in your Organs cells.
There's a setting to change that.

It shouldn't have to be a separate setting from the overall default browser, but at least it's relatively easy to change.
> The future can look pretty grim when you start considering how rapidly quality of life can shift upwards even for huge populations, and how many people on earth have nowhere to go on that scale but up up up.

The future looks grim. Because life is getting better. for lots of people?

Take this anti-humanistic garbage elsewhere. We can solve problems and make a better world without having to decrease, or even slow the increase, of quality of life around the planet. Lab-grown meat. Spacefarms. Whatever. I can think of many ways to
increase quality of life universally, and this pessimistic, anti-human sentiment is actively getting in the way.

I think at least some of this comes from the new environmental movement, which tends to be much more anti-human than pro-fixes.

I just want you to read your first sentence there, and really internalize what you said. How absurd is that?
This is peak Hacker News right here lmao
How a dev or PM can live with themselves while implementing that I have no idea.

Dev builds it the user-friendly way. PM uses Google Tag Manager to inject JS that changes the stylesheets to the evil way.
You know why we ddin't have any corona virus vaccine before 2020? It's not for lack of trying. They all failed at various stages, all of which were skipped for the SARS-Cov-2 vaccines.

You can't run a trial if there aren't any people getting infected.

By waiting enough time to get data accumulated.

This isn't a mechanistic explanation of how you've arrived at a stronger level of comfort with earlier safety trials, unless your evaluation criteria is literally just that they took longer.
Hah. Literally an hour ago I fat-fingered the “Sign up to Amazon Music!” button in the Amazon Music App on my phone whilst putting the phone in my pocket.

To be fair to Amazon though, they do let you cancel the subscription online with no bullshit & you still get to keep the 90 day free trial -- presumably they hope you’ll like the service enough to decide to pay for it anyway.

(The worst example I know of this “single button press sign-up” pattern was Nassim Taleb accidentally signing up to pay for a software upgrade to his Tesla in the Tesla App that cost $1000s & having no way to undo it except shouting loudly at Tesla / Elon Musk on Twitter.)
The majority of food waste however is fruit and vegetables (about half), some meat is still wasted but is among the lowest category in food waste.
I'm not saying it's untrue, because I certainly don't know for sure, but what evidence is there that "tiger" was pronounced like "tigger" in America at a time that overlaps with the appearance of the children's rhyme?

The article presents evidence that "tiger" rhymed with "vigour" in Scottish, but perhaps they both rhymed with "eager", not with "bigger". In Scotland. In the 18th century.
I actually had a pager add-on PCB in my Palm Pilot. Worked great.
> every time I see a python talk (pycon or else), with fancy tricks like metaclasses..

All I can think of is what a mistake those features were in python. "Fancy tricks" are generally the author trying to be clever (in the Kernighan sense) and ends up obfuscating the result. Not saying it works this way in CL, I don't have the experience to make the call, but in Python it was (and probably still is) prevalent.
This particular demo page actually makes queries against an almost 700 MB large (fills one CD!) SQLite database. Because the amount of data read is almost negligible (few hundred kB), performance is limited by latency (as you say). However, high-latency links also tend to be slower, so downloading the entire database a-priori would almost always be much slower.

For example, on a 1 megabit/s link with 300 ms RTT, one example would take about 2 seconds for the data transfer itself while spending another 3 seconds or so on waiting. Downloading the entire file would take around an hour and a half.

For your 10 MB database, transferring it as a whole would take 80 seconds. Assuming this solution instead needs to read e.g. 250 kB (taking 2 seconds to transfer), it could still bounce around 250 times to the database before those 10 MB are fully downloaded. (This would be a really odd query, since it would only read on average two pages per read request)
Maybe? We'll see what happens when/if they actually try. Lobbyists' phones are probably going off right now with big tech trying to spur them into action.
Act! back in the 90's right around the time Symantec bought them. Seemed to be just about perfect for what most small businesses would need. Out of nostalgia I did some searching and the amount of times it changed hands and what they are charging (per month!) for it now I can only imagine - it's probably as heavyweight or more so than SalesForce.

Salesforce just has a weird flow. I think I have the gist of it, but man do you have to use it for quite a while before it starts to make sense - all while you wait and wait and wait for anything to happen after you submit something. Ugh.
now if only tabix and most hokey bioinformatics formats would die and just be replaced with a formal schema spec in SQLite...
Link to the European Commission's press release (2019) for anyone interested: https://ec.europa.eu/commission/presscorner/detail/en/ip_19_...
Choose 3 and then watch the consultants build the custom software using a low/no code platform. Now you are still in the slow and poor user experience and no customization options and more expensive and worse support ;-)

I think it’s pretty sad that enterprise software is mostly stuck the way you describe. There are companies willing to invest in fast and user friendly custom software though; the company I work for is pretty successful at doing just that.
> Even if the phone was thicker, people would be using cases if they bought it, right?

People started using cases for most part after the iPhone came out. Older phones were almost never used with a case, except perhaps for use case requiring a ruggedized enclosure.
Another one:

> the exact order that C++ evaluates expressions is extremely complicated and not always defined, ... "

"(Un)defined" and "unspecified" (which order of evaluation of fun-args really is) are two distinct terms in the C++ spec meaning different things, they cannot be used interchangeably.

But I guess it's just yet another thing of "Pedantic assembly-code analysts"...
I opened this ticket 3.5 years ago and they still violate GDPR https://github.com/docker/for-mac/issues/2122
The dark pattern I've been seeing a lot lately is billing services trying to make you go paperless. I've seen all sorts of dark patterns around it, from subtle things such as it being the second of three options where you need to check options 1 and 3 every month, to it literally being checked by default and buried in the middle of a "we are just checking up on you to make sure you have all your options set correctly" splash screen.
“Intro to Human Behavioral Biology” Needs Critique
Maybe.

http://blogs.ifas.ufl.edu/animalsciencesdept/2016/06/22/cows...

Bison in particular have such a beneficial effect on soil retention, aeration, and quality, that some scientists view them as part of the solution as opposed to part of the problem. Their grazing patterns literally turn everything they touch into more efficient carbon sinks.

If this idea is to extend to other livestock, it would do wonders for swine, chicken, sheep, and goat carbon intensity as well, but it probably will never be enough to compensate for cow methane emissions.
At least theoretically yes. One of their main purposes is to establish regulations to protect customers.
So instead of filtering it out or graying out the "get" button, I need to click on the link in the app store and find the compatibility section (the last part of the page) to find out if it's compatible?

That's a dark pattern.
Perhaps, I couldn't find reliable data, and apparently neither do the people doing the Israeli study (that much is stated in the copy of it that was leaked ; it's in hebrew).

However, their metric was IIRC "within 3 days of first or second dose"; so 6 days worth of myocarditis compared to your full year number, so a factor of 60 (assuming uniform distribution over the year) to put on same scale.
Everything you said is true but it still has no bearing on the fact that it's a dark pattern to make it inconvenient to have an old device. They have the means and technology to filter out incompatible apps, but they've decided not provide it.
An alternative approach would be to learn enough to make mRNA “programs” that once inside a cell could determine cancerous vs healthy cells. There’s been research on computations using DNA, and many natural pathways do similar “calculations”, that it seems feasible to create a “if specific xyz protein/carbohydrate/etc in cell exceeds threshold trigger cell death pathways”. Then injection in a tumor mass should be sufficient. The mRNA program might only need to be partially accurate to be more effective than many chemotherapy’s.
It’s not hilariously wrong or wrong at all that over high latency links this would be virtually unusable.

It’s certainly possible that people are using SQLite databases with sizes on the order of gigabytes but in my experience those are the exception not the rule.
Although given how we've squandered (and continue to squander) antibiotics, future generations may view bacterial diseases the way past generations did.