skysight-inc/HackerNews huggingface dataset:
To be honest I’m quite surprised it’s already 20 years old.

The first time I ever encountered SQLite was when poking through what made the very first iPhone tick, “way back” in 2007 (a whopping 13 years ago).

Before then it had never occurred to me that one might use a database-as-an-executable as the generic information storage back-end for pretty much any application... I thought of SQL and databases as enterprise-type deployments and thought of applications as having custom data formats.

Looking back, Wikipedia tells me that Apple had made CoreData available with Mac OS X 10.4 ‘Tiger’, released in mid-2005, so I wasn’t exactly up-to-date at the time... but still, it feels like a remarkably modern development. And an impressive one in any timeframe.

EDIT: Grammar.
I feel like it's more important for step 3 to come before step 2 now, although I understand this will not be possible for some business models. But that being said, in most of such cases it's actually questionable whether these business models should exist in the first place and are a good use of capital since so few of them workout
Asymptotically, I believe. There were a some people a few decades ago who tried to use training methods which had improved human running times, only to discover that horses' cardiovascular systems were not the same bottleneck that humans' had been. (bottleneck is with tendons and bones; racing breeds are already morphologically quite different from the wild types)
Absolutely, many of the plasma companies have joined a coalition to streamline donations from COVID-19 positive patients in the US. The US supplies the majority of blood products derived from plasma (in this case antibodies) overall, to the rest of the world. The US is literally the OPEC of plasma donations, although there are serious ethical concerns about how lax the rules are regarding donation frequency and how it is monitored. There have also been recent scandals. See: https://www.propublica.org/article/pharmaceutical-companies-... (specifically watch the video)

Some of those companies believe that they will have a hyper-immune (A shot that is given to somebody that is COVID-19 positive, to help them recover. It is literally pooled COVID-19 antibodies from several donors, so antibody levels are as not as big of a deal compared to getting an "infusion" of convalescent plasma from a single donor. But antibody levels still do matter!) COVID-19 product to use by July, although it will still need to go through clinical trials. We are literally one of the few countries in the world equipped to do this and scale it, due to our plasma donation infrastructure (however, it exploits the poor, and that is tragic).

As somebody who takes a plasma product containing antibodies from thousands of donors (subcutaneous immunoglobulin) due to a rare chronic health condition , I would be surprised if the hyperimmune COVID-19 product was found NOT to be effective.
I don't think I've seen anyone with their fingers stretched out or diagonal like that as a 'home row' position, though. It makes much more sense to 'default' to having your hands somewhat straight and on the keys you're likely to press more regularly (the (center) letter row).
For consumers you’re definitely right, but I don’t think this is true when buying by the truckload. Paper manufacturers produce both very high-density products (office paper) and very low-density products (toilet paper). Office paper is so dense that you have to ship it in trucks that are half-empty due to safety regulations on truck weight, so I’d expect a customer that needs both products can receive toilet paper in the same truck without much marginal increase in fuel consumption. I don’t work in the industry though, so I admit I’m mostly speculating.
Mark 'em up to your liking (at least that's my interpretation of 1.E.6) https://www.gutenberg.org/wiki/Gutenberg:The_Project_Gutenbe...
Aloha
Thanks for the detailed reply, I found it very informative. I work on a small team developing 'private cloud' infrastructure for a large company, so I usually find myself on the opposite side of the arguement... trying to highlight the virtues of on-prem hardware and the downsides of 3rd party cloud providers.

We've had to work very hard to allow for developers/sre/ops folks to be able provision vms and bare-metal machines in our datacenters the same way they would in the cloud provider that we use. Obviously its not as fast, seamless or feature-rich as it is with aws/gcp/azure et al, but I'm proud of the progress we've made.

What really kills me though, is that a huge chunk of our engineers seem to think our work is a complete waste of time in the first place. We have several physical dcs, and tens of thousands of machines... but since most engineers don't have to think about costs, or about workloads other than their own, they think of us as out of touch and clinging to the past.

Nothing worse than getting snark about our platform from an SRE who spends their days in a web app glueing together the ready made services of google and amazon while acting as if they're building the world of tomorrow :)
Malaria prophylaxis is pretty rough in and of itself, and it's not really recommended unless you're going to be in high-risk areas (source, tried to get it myself when going into Mozambique from South Africa, was told there that unless I was planning to stay "in the bush" for a few weeks, it was a bad idea)
I'd rather have 80 columns on a 4:3 ratio than 120 columns on 16:9. "A wide monitor is for" watching video, playing games, and putting larger diagonal numbers on the box. I miss turning one monitor sideways to nearly fit an A-sized document. And I miss those 120 extra vertical pixels from before 1080 became the standard. I think the only good and common option right now is 21:9 in a large size and resolution, you still won't get 1600 vertical pixels like with a 3:4 but 1440 is still useful and there's enough horizontal space you won't get distracted over nonsense like how many characters wide a line should be.
Stupid question but what does IC mean?
Aren't all definitions arbitrary? If we would only go by how words are used 'in general', who would want to be a 'hacker'? ;) And I don't think the definition of 'hacker' in The Jargon File is just... arbitrary in the context of Hacker News? However, I am guilty as charged of making a very free, playful interpretation. Also, I am guilty as charged for trying to have a title that makes some people curious. I am sorry you did not like the post, but that's life! Cheers and thank you very much for reading!
> As long as it's only happening to "thugs", why should we stick our necks out on the line and make noise?

Because this is a pretext to create infrastructure to go after you and your family.
> I am not aware of any restrictions on hugging your family.

If your family lives in elder supportive housing, there has been plenty of no visitor policies. Regardless, if you don't live in the same house with your family, visiting them may not be following the policies.
While doing small project sqlite is a very good tool. Thanks to sqlite team for making such a great software.
I'm surprised this hasn't encouraged more aggressive antibody testing of random people to better estimate the virus's spread and source more blood.
in line with Make America Great Again..
Agreed with all your points, I wouldn't want us to return to more burning of wood. I was just pointing out the categorical difference to burning fossil fuels, which even theoretically aren't part of the same life cycle and cannot be offset in the same way -- we can't grow back forests from millions of years ago.
Circle Packing
Covid-19 study on hydroxychloroquine use questioned by 120 researchers
thank for this article
If you do not mind a bit of setup, I have found Vim in combination with VimWiki (https://github.com/vimwiki/vimwiki) a very good fit for this scenario.

It supports markdown formatting, does hyperlinks pretty well (even jumping back and forth is quite nice), is as cross-compatible as Vim and stores the notes in future-proof .md files.

I suggest you give it a shot.
Myths about Web Scraping Services
I thought about this more than I probably should have, and I'm fairly sure you can't pull off a C sleep sort that sorts in place and is nearly as compact as the programs in the article.
The problem I see with raising money is that, practically, you’re giving away your business a piece at a time.

Sure, by raising money you’re going to grow your business more easily, but you’ve also compromised your ownership of it.

Obviously, if all you think about is cashing out after the company’s IPO, raising money makes sense. Especially, if you don’t have a sustainable business in the first place, and you’re losing money.
Also questioned in Andrew Gelman's statistics blog:

https://statmodeling.stat.columbia.edu/2020/05/25/hydroxychl...
I'm not quite sure I understand? Isn't what you're citing a case of people continuing to be quiet in the face of executive overreach?
The United States never was, nor will ever be, a democracy. It is a republic.
Nice analysis of the complexities in play.
Has there been much agitation for (or serious attempts at) forking SQLite? That's probably the real test of the stewardship of an open source project.
Back when I was doing a lot of Python work I was a big fan of Flask. The reason is that it really just provided an integration layer for existing stand alone libraries; it didn't feel like I was buying in to some massive framework, just leaning on Flask to get rid of some of the boilerplate glue code that is otherwise need to write to e.g. find a jinja2 template, render data with it and then turn that into an http response. Just `return render_template(...)`. But if there wiring became inappropriate it's ultimately not doing that much, and it's easy enough to take that template and use it in a different context.
Indeed, I should have mentioned that too.
> This new line of argument is akin to saying that HN should be directly responsible for all users' comments because dang downvoted a post. It's nothing more than a hamfisted outburst by Trump trying to remove the protection from a company as some sort of summary punishment because the executive doesn't like what the company itself has said.

How is wanting twitter -- who is now scrutinizing and editing their user's posts -- to now be held up to the standards of a publisher (which is literally someone who publishes information written by others after having reviewed it) a 'new line of argument'? If HN were to actually start to modify user's posts, not because of voting but because of internal processes, then yes, HN should probably be held to the standard of a publisher. You can't just decide that regulations don't apply to you because you have more writers than the standard publisher.
You could do that, but why? Just use k8s and move on.
Thoughts of Jumanji come to mind... "Don't open the ancient Norweigian burial mound!" <g>

No, but on a serious note:

>“These are status objects that testify to contact with the Roman Empire, where they liked to enjoy themselves with board games."

and:

>"People who played games like this were local aristocracy or upper class. The game showed that you had the time, profits and ability to think strategically,” said Ramstad."

Fascinating! Makes sense, too...
This distinction means literally nothing and its utterance has never once contributed positively to a discussion.
This isn't the one you're thinking of, but it has similar conclusions: https://www.technologyreview.com/2020/04/27/1000569/how-long....

"They found that people frequently got reinfected with the same coronavirus, even in the same year, and sometimes more than once. Over a year and a half, a dozen of the volunteers tested positive two or three times for the same virus, in one case with just four weeks between positive results."
They have pages on this.

https://www.sqlite.org/famous.html

https://www.sqlite.org/mostdeployed.html
Yes it does, I mostly use pocket for tts, but the ui is worse. If you use android's local you can only skip forward and backwards 15 seconds, and it frequently loses your place if you pause it. @Voice allows you to tap on the text to seek.
> I'm 38, rocking a 43" 4k monitor. There's so much room.

There's no more room on a 43" 3840 x 2160 monitor than there is on a 32" 3840 x 2160...
Can't argue with that! Certainly wood would last longer as a resource in the long term.

A book on energy once classified energy as new (biofuel, solar, wind, hydro), old (fossil fuel) and really old (nuclear, geothermal, tidal). I kind of like that. Of course all of the above are derived from nuclear fusion in stars if you track it back far enough.
In your mind, sure. Anything is possible.
We just spent months at my workplace working on a system to reliably define and configure a set of parallel silo'ed integrated datastores, services, and network stack within Kubernetes/ISTIO (and AWS), and to reliably upgrade new software revisions within those silos and to account for the changing "shape" of the configuration/content in these silos. It's repeatable and safe now, but it took a lot of effort.
Why would they have to disclose all the tests they do?
Yes, cybercrime is boring, just like security is boring, or app development. The article is focusing on the mundane parts of the business side of certain enterprises (cybercrime-as-a-service), not the individual thrill of discovering something new & exploiting it or selling it to be exploited. Obviously being an article literally written by the opposition would mean it is going to paint their adversaries' life choice as one of a bored drone...
I didn't understand your reply at first, and then it dawned on me that the linked page wasn't handwritten to celebrate the milestone (which is what i thought at first), but rather just today's version of a programmatically generated "today in history" type page. Ignore my misguided complaints :)
There’s an old story about a guy taking a smoke break with his non-smoking colleague.

“How long have you been smoking for?” the colleague asks.

“Thirty years,” says the smoker.

“Thirty years!” marvels the co-worker. “That costs so much money. At a pack a day, you’re spending $1,900 a year. Had you instead invested that money at an 8% return for the last 30 years, you’d have $250,000 in the bank today. That’s enough to buy a Ferrari.”

The smoker looked puzzled.

“Do you smoke?” he asked his co-worker.

“No.”

“So where is your Ferrari?”
You don't have to use two way binding binding in Svelte. You can bind to change events just like in React and update your reactive variables directly. The primary downside is enforcing it in the code everyone else on your team writes.
This may not work for your requirements, but one approach worth considering is to create your instances without a key pair and then leverage Systems Manager to push your ed25519 keys to the system.

This can be done with RunCommand, a manual Session Manager connection, or by storing your public keys in parameter store and pulling them in via a startup scrip in Instance Metadata.

To take advantage of SessionManager or RunCommand, you do need to have the SSM agent installed along with an IAM role. This isn’t a fit for every set of requirements.

The latter approach can be accomplished with a minimal IAM role and the AWS CLI. In the event your subnet doesn’t have NAT, you will need an SSM endpoint in your VPC.
Has anybody used Sqlite in a server side, production level capacity....

I know it works great on embeded cases, but how about server side with a decent user load?
Another turn the wrong way issue that happened was on the early versions of the 737. It would cause the rudder to go hard-over to the other direction it was commanded. It happened so hard it was difficult (if not impossible) for a pilot to counteract it using the pedals (they would basically have to stand on the pedal).

It killed at least 157 people. The culprit in this case iirc was a combination of a flaw in the hydraulic cylinder design with large temperature swings. The story of the guy who finally figured it out is a fun one.

https://en.wikipedia.org/wiki/Boeing_737_rudder_issues
Brex, the credit card for startups, cuts staff amid restructuring
Again I love SQLite! https://github.com/zubairq/pilot Would not be possible without it! Why? SQLite works on the server, in Electron (barely), and purely client side on the browser, and is fast!
Sure it does! You can `POST` the buffer that backs the database to your favorite blob store, and read it back when you're done. You can write to it as much as you like when the page is active.
I get how there's a fear that paid donations would encourage people to either over-donate or people who shouldn't donate to donate, but it also feels sketchy that between patients, hospitals, middlemen, and collectors, money's exchanging hands at every level except the donor.
For my personal / side projects?

Sure I'd love to make money doing the type of stuff I do there, but I'm initially driven by curiosity.
Yes! The comments on this thread made me think of Philadelphia instantly!

I have Bruce Springsteen’s Streets of Philadelphia (the titular song of that film) playing right in this instant.
Doing a monthly direct deposit with no strings attached seems like a pretty un-invasive way for the government to support its citizens. Agree with you on universal healthcare, though.
The issue here is not "considered not true" but promoting illegal violence which I think Murdoch also probably avoids.
You can actually partially persist data on the client side in SQLite, as you can embed the data in you html, which is exactly what we do with our product
> By raising money ... You can now pay your employees a salary

This author possibly lost "contact with the earth". Especially early on, most people will not join and work for free (or on the sole promise of equity down the road). Not all startups are simple CRUD apps, many require significant R&D or marketing investment upfront.
Ahh, I should have made that more clear in my comment. Definitely frustrating, as those dang keys aren’t cheap!
I feel like this would leave me with my bare hands fighting against the mighty dragons of DOM and state. Now I have to roll my own two way data binding and redux clone? Maybe try optimizing with my own virtual DOM? I’d probably sink into the mire within minutes from the cognitive overload alone.

I mean, yes maybe my framework is actually a badly designed weapon that is too complicated and overburdens me. But it solves my dragon problem. With my bare hands I am no longer overburdened, but now I’ve traded that advantage for much worse problems.

Which is why I figure, on balance, I do need frameworks.
Sweden’s coronavirus experiment has well and truly failed
SQLite is for use cases where a dedicated DB is overkill/impossible. Considering the limitations it has, it probably isn't usable for most production DBs.
That sounds more dangerous than this one, but flying the wrong missed approach or departure is far more dangerous than any display/instrument failure because the crew wouldn't be aware of the problem. If the flight display fails you look at the backup instrument and keep flying, every crew is trained for that.

But if the missed approach or departure procedure is wrong the crew has a high probability of not noticing it (this all happens in a very high workload situation). If you don't notice you can't fix it. What makes it worse is that this bug happens in situations whether the procedure requires a turn "the long way around", they wouldn't design the procedure that way unless it's really necessary. So there is a big chance there is terrain or an obstacle on the other side.

Source: I'm a commercial pilot
Did you mean black and brown people?
And why are you doing this to them anyway?
> Sometimes these plasma companies do test regular donors for certain (often rare) antibodies, such as for whatever shot that is given to Rh negative mothers who are pregnant with a child that could be Rh positive.

https://en.wikipedia.org/wiki/James_Harrison_(blood_donor)

This guy is in Wikipedia for being a blood donor. He's estimated to have saved 2.4 million lives.
> You don't need to be an aerospace engineer to be aware of the spaceX R&D strategy which has been spelled out pretty clearly by Musk and others in various interviews.

This baseless assertion makes no sense. Your personal interpretation of cherry-picked PR talking points do not trump basic engineering practices.

I mean, just look at the facts. The company was planning on flying the thing after the static tests, and now it can't because it exploded. Does that seem to you something that's part of a strategy? Failing milestones because things explode unpredictedly?

If you are not an engineer, let alone an aerospace engineer, then please listen more and talk less.
NSA warns of ongoing Russian hacking campaign against U.S. systems
I was about to ask what the use-case would be, since I assumed server SQL databases would use Paxos or Raft or something, but apparently I was wrong! I guess durability is done through persisted volumes, storing tables in files and being deliberate about journal structure and fsync?

In that kind of world I guess sqlite is as good a choice as any if you don't need a SQL endpoint.
I believe it's the same with lua
If you are employed by a company to write code, all of the code you are writing should be business logic that helps the company achieve their business goals.

Everything else is masturbation.
It's also important to mention the Black Codes[1], which were, effectively, a reimplementation of slavery that just didn't use the word "slave".

Many of these laws existed before the Civil War, and were simply "updated" to replace the word "slave" with "freedman".

Other laws cleverly redefined common terms, introducing technical language, so that they could claim that a former slave, forced to work for little or no pay, was "serving an apprenticeship" or "being punished for vagrancy". E.g., a slave in reality, but "on paper" an apprentice, a volunteer, serving a criminal sentence, etc.

Black Codes also severely limited the ability of black citizens to gather and organize, required impossible "literacy tests" to vote, and prevented black citizens from owning any type of weapon, either outright:

Louisiana: "No freedman shall be allowed to carry firearms, or any kind of weapons."

Or via a "may issue" licensing scheme:

Alabama: "Freedmen must not carry knives or firearms unless they were licensed so to do."

[1] https://en.wikipedia.org/wiki/Black_Codes_(United_States)
I haven't wrapped my mind around scoped styles. You generally want a consistent UI, meaning mostly global CSS. And, you want the option of easily adjusting a global aesthetic/behavior.

Scoped styles seem like the framework version of the style attribute.
> The whole fundamental concept of innovation is that there is no plan.

This assertion is utterly absurd. These guys aren't the jackass crew just figuring out what to blow up next just for kicks.

Please, do not add more noise to the discussion.
K-8 is when you get formally or informally put in a track for math, and most probably in an enduring way.