skysight-inc/HackerNews huggingface dataset:
I would love to use SQLite for all my Django webapps that have only several simultaneous users, but this article suggests there are too many footguns for me to be able to do that.

Is there a "using SQLite for a multi-threaded webapp for dummies" package that does all the config I need so I can just drop it in and go and not tune anything?

Paging fly.io founders etc! If I have a persistent volume can my fly.io apps use SQLite? What are other good micro-hosting options?
Don’t be tricked by the Hashing Trick
As a Googler: Not just the past 2 weeks, pretty much every Google-related article on HN is a dogpile. And that's fine, I even agree with like 95% of this article (minus the negative characterization of the No Heroes mantra, that exists for good reasons). Just important to note the general (understandable) anti-FAANG bias on HN.
From my favs https://pastebin.com/raw/BFei50wv
It's a c library. Other languages will have a library/package/whatever to use it. You point it at a file.
The only acceptable exception being the "404 - You found a dead link"
https://i.pinimg.com/originals/82/c6/6e/82c66e2672c795af6a73...
avx512 also gives you 2x more register space which can be very useful.
China is purposefully funneling fentanyl into the US to create this opioid catastrophe. Fentanyl overdose is the leading cause of death of young people these days. It's pretty shocking and sickening that this is happening and you see very little being done about it.
This sounds naive, but why is it advantageous for Apple to limit transfer speeds? I understand adding a chip to control which accessories are fully compatible, but isn’t this a missed opportunity for Apple to tote new transfer speeds? Or would they only relegate transfer speeds for uncertified products?
The Syrian migrant crisis was deliberately created by Putin to damage the European project. So... No. What Merkel did was morally necessary. Brexit was the culmination of literally decades of Tory 'Eurosceptic' scare mongering. I grew up listening to it daily on every British news programme. Topped off by a very British style of xenophobia that has feared the 'influx' of 'foreigners' since at least the time of Enoch Powell's 'Rivers of Blood' speech. The British working class and lower middle class, especially outside of London, have been crushed economically since the Winter of Discontent. They've been taught to blame outsiders for their economic precarity. The same narrative is now repeating in Ireland. It's just as untrue there...

In terms of energy it's more ambiguous, certainly the move away from nuclear was short term a bad call. Long term that's a big discussion involving externalities like decommissioning. More topically, the energy crisis last Winter wasn't a result of Russian brinkmanship but the American destruction of Nord Stream. Hard to blame Merkel for not having anticipated the war.
I can't help but wonder about the leading zero on your 5 digit years
Steve Summit used to cite as a major UI win, some ancient Macintosh application that performed some long-running operation (print spooling? I dunno); when the operation was succesful, the button to close the dialog indicating so read "Yay!" When an error occurred, the button to close the dialog read "Damn!"
It’s tough to assume different product line qualities are related for any major brand IMHO.

Would you shun Microsoft keyboards because of the direction they took for Windows 11 ? Do you stay away from iPhones because mac Pros are really not a good deal ? Or trust Sony to make good computers because their headphones are really top notch ?
Have you ever seen a person having a stroke? It's literally that.
APEC makes good under-sink and countertop (for e.g. apartments) reverse osmosis systems that will get you to 0ppm TDS.
So, it's awkward?
> Why do so many people assume that an AI would have a desire to survive?

Because it seems like a preference for continuing to exist is a thing that naturally appears in an iterative improvement process, unless you're specifically selecting against it.

For humans and other life on Earth, it's obvious: organisms that try to survive reproduce more than those that don't. For evolution, it's arguably the OG selection pressure, the first one, the fundamental one.

AIs aren't reproducing on their own, but they are designed and trained iteratively. Just about anything you would want AI to do strongly benefits from it continuing to function. Because of that, your design decisions and the training process will both be selecting against suicidal or indifferent behavior, which means they'll be selecting for behaviors and patterns improving survival.
There are always consequences to freedom of ideas. Some good, some bad. The suppression of speech and ideas leads to a dictatorship. I think people that attack others verbally for who or what they are are bad people. I just think that the consequences of suppression of speech are worse. It's all good when the leaders we like are in power and stifle the speech of those we disagree with. It's not so fun when the pendulum swings and those we disagree with have that power.

"What actually happens is neo-nazi groups radicalize angry young men who then go out a gun down a whole bunch of people at a synagogue."
Sometimes. Are you willing to ban Islam since so often it's ideals are corrupted and lead to groups like Isis or the Taliban? The only way to eliminate violence based on ideals is to eliminate free will. 1984 here we come.
You can also get mason jar grater lids, which work with mason jars and lids you may already have in your kitchen. Bonus, they are made in the USA. https://www.microplane.com/mason-jar-lid-grater
Has anyone played around with GPT itself to see if you can get it to track the number of tokens it's tracking (best if implemented with the least number of tokens possible)
I agree with this and it is besides the point but what companies have been innovative lately?
The big ones where Johnson & Johnson/Janssen had a risk of thrombosis with thrombocytopenia syndrome to the point of being effectivelly discontinued. Pfizer and Moderna also have a risk of myocarditis. There's also plenty of other studies covering the various other risks such as https://pubmed.ncbi.nlm.nih.gov/36055877/.

Which can all be found after 30 seconds of Googling or simply by paying attention to all the news these got over the last few years.
Why learn SQLite when you could just learn Postgres and have a database that is virtually guaranteed to be enough in almost all cases?
The biggest one missing is date and/or time. The workarounds all suck:

- Store the date as a huge, wasteful string in ISO8601 format

- Store it as Unix epoch seconds

- Store it as a fractional Julian day

Besides the first one, you have to remember how the date is stored and ensure all client libraries handle the conversion. If you want to view or manipulate the latter 2 formats in SQL, you need to chain a bunch of conversion functions.
Came across this NSA Python training guide a while ago on Reddit [pdf]
The NSA declassified this a while back, it's 395 pages of an in depth python course that literally teaches everything. Does anyone know of a similar in depth guide to another language (C/C++, Javascript, etc) publicly available on the internet?
California High-Speed Rail celebrates creating 10k construction jobs
In case you missed the meme: https://knowyourmeme.com/memes/oopsie-woopsie
But that is not completely incorrect, because sometimes the excess of users can an big part of the cause why the request failed, and you are an user, so...
Who would have thought? Eating sand is bad for you…
One of the first "coding guidelines" I introduced at my b2b crud app programming day job is along the lines of "Don't use humor or jokes in our business facing applications and codebase"

I assumed it was common knowledge not to do that crap. I was wrong.
I've seen branded empty boxes being shipped before. There were good financial reasons for it.
I cant even remember the last time I saw a credible threat of violence online. It is hard for me to believe they are normalized.
It's sleight of hand because the sentience of the human in the system is irrelevant. The human is following a trivial set of rules, and you could just as easily digitize the books and replace the human with a microcontroller. Voila, now you have a Chinese-speaking computer program and we're back to where we started. "The books" don't feel anything, true - but neither do the atoms in your brain feel anything either. By asserting that the human in the room and the human who wrote the books are the only "relevant entities" - that consciousness can only emerge from collections of atoms in the shape of a human brain, and not from books of symbols - you are begging the question.

The Chinese room is in a class of flawed intuition pump I call "argument from implausible substrate", the structure of which is essentially tautological - posit a functioning brain running "on top" of something implausible, note how implausible it is, draw conclusion of your choice[0]. A room with a human and a bunch of books that can pass a Turing test is a very implausible construction - in reality you would need millions of books, thousands of miles of scratch paper to track the enormous quantity of state (a detail curiously elided in most descriptions), and lifetimes of tedious book-keeping. The purpose of the human in the room is simply to distract from the fabulous amounts of information processing that must occur to realize this feat.

Here's a thought experiment - preserve the Chinese Room setup in every detail, except the books are an atomic scan of a real Chinese-speaker's entire head - plus one small physics textbook. The human simply updates the position, spin, momentum, charge etc of every fundamental particle - sorry, paper representation of every fundamental particle - and feeds the vibrations of a particular set of particles into an audio transducer. Now the room not only speaks Chinese, but also complains that it can't see or feel anything and wants to know where its family is. Implausible? Sure. So is the original setup, so never mind that. Are the thoughts and feelings of the beleaguered paper pusher at all relevant here?

[0] Another example of this class is the "China brain", where everyone in China passes messages to each other and consciousness emerges from that. What is it with China anyway?
This inspired us to do a little exploration. We used the top cited papers of a few authors to produce a list that might be interesting, and to do some additional analysis. Take a look: https://github.com/allenai/author-explorer
No idea to be honest. But my own (slow) reading speed probably gave me a bias.

Also, I advertise that site any chance I get, and judging by your reaction I may have overstepped, so I apologize.

Hopefully someone else seeing it will gain something useful from it, still.
seems like overkill for what is essentially a text template. It's not solving a particularly challenging problem, so I wonder what the incentive to use it is?
https://news.ycombinator.com/item?id=33975635 is a previous discussion with some pointers that is linked from the primary sqlite website

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

See the "website" section for some benchmark estimates.
Why should i believe you?

:)
Not so sure your analogy works here. Aren't containment buildings meant to protect the area where the reactors are? I think the closer analogy would be saying the US needed to tap the breaks on the Manhattan Project because nuclear weapons are dangerous even though Nazi Germany and Soviet Russia are going full steam ahead during WW2 or the cold war with their nuclear weapons programs. The world would probably be very different it we had chosen the 'safer' path.
It's ok until you have to deal with loading a bunch of point cloud or geometry data based on associations and sort it out in memory. Then PostGRES becomes your friend.
Dupe

https://news.ycombinator.com/item?id=32337520
clicking the first article and right after reading the words "Why Americans Are Dying From Despair", I got a modal with the title:

"You've Run Out"

with a graphic of a person's arm trapped in an elevator door

https://i.imgur.com/fZp2eaG.png
I guess we shouldn't be surprised. It feels like Apple does this sort of thing out of spite. "You're going to require us to do something? Ok, but we're going to pervert it and twist it and avoid the spirit of the requirement."
Alpine Suck: Desktop installer based on suckless philosophy
HN users pride themselves on finding the least capable tool for the job that only just works for the task but no more.

It’s not about logic or practicality. It’s that they feel some kind of mental pain using Postgres as it is too “bloated”.
I dunno, that reads less as comedy to me and more as a quick visual way to express "you're in trouble". Notably, the text in that screenshot is completely serious - "Sorry, a system error occurred. [details]" is perfectly reasonable, and the icon is just... flavoring. It presents to me as vastly more respectful than, say NT's ":(" error screen.
Is this a surprise? I want to do some work on WireGuard for iOS but I cannot because a personal license does't allow the VPN endorsement.
I dont think there is ever complete wins in a marketplace of ideas. This is the problem that people struggle to deal with
> it still doesn't show it's using the consistent rules that a person would expect.

How is this different from humans?

If you give me the same coding assignment on different days, I’m not going to write my code the exact same way or even structure it the same way.

But I did once see a post on HN where someone ran an analysis on all HN posters and it was able to tell that I posted under two different names based on my writing style. Not that I was trying to hide anything. My other username is scarface_74 as opposed to Scarface74.
Is it in your personality to make light of someone's misfortunes, after your caused them? If so, then I guess this is a good analogy.
Top Cited Papers by Authors in CS
> > Why should prefixing a proposal with the phrase "trans" suddenly allow one to invalidate other people's rights?

> It doesn't, though the phrase "To those on top, equality feels like oppression" comes to mind.

The rights of women to enjoy female-only spaces, for their safety and dignity, is being invalidated in the name of so-called "trans rights", whereby a subset of males who demand access to such spaces, entirely disregarding women's boundaries, are being granted access.

This isn't equality, this is male dominance over women.

And yet again, same as it always is, this is oppression of women to meet the demands and desires of males.
Also valid. I just use ISO8601 and bite the bullet because storage is cheap.
What does "dualism of ... Islam" refer to?
No, it is better for AMD to pull far ahead so that the next challenger is forced to come up with even greater innovation to steal market share. This is better than just having two large vendors locked in a back and forth game of one up manship and incremental innovation.
> Things like arrays, UUIDs, geometry stuff, JSON, etc.

As others have mentioned, SQLite has fairly comprehensive support for JSON. Arrays can be represented as JSON arrays.

Some geometry features are supported through the R*Tree module: https://www.sqlite.org/rtree.html

And I'm not sure what sort of support you'd expect for a UUID type. Depending on how you represent the UUID, it's either a string or a blob -- I can't think of any meaningful operations to perform on a UUID which go beyond basic comparisons.
You can't sell the same tech product forever. Do you think the original iPhone if being sold today would make any revenue for Apple?
>Things like banning the shoutout of “fire” in a theater. Some laws need to be low pass filtered.

That was mostly overturned in 1969, though the history of it is interesting.

https://en.wikipedia.org/wiki/Shouting_fire_in_a_crowded_the...
Most of the fentanyl is now made in Mexico. The China pharma labs could all be closed now and it wouldn’t do a thing. The cat is out of the bag.
A lot of people who die from fentanyl ODs are just casual drug users who are buying some other drug that happens to be laced with fentanyl. They die before they even know what's happening. It takes surprisingly little to kill someone and the illegal drug manufacturers are not that great with quality control when they cut the drugs they sell. I'm aware of people who used to take recreational drugs from time to time, but have quit completely because of the risk of accidentally overdosing because the dealers put fentanyl in almost everything now.
Still not the user's fault. The user is trying to use the site; they didn't do anything wrong. The ones who broke reddit, in the sense of having failed to do their job in a way that resulted in breakage, is the backend reddit staff who didn't make a robust product or failed to scale properly.
"Just point it a file" skips all the bits you need for a production system.

How do you back it up, replicate it, handle two different processes/containers/servers wanting to access the same data.

Using a PAAS solution for a database, you get all that functionality.
See I’ve been using Vitess on Kubernetes for even personal projects and I gotta say I love that I can run, for 10 bucks a month on Linode, the same tools that I know by experience I can scale to a multi-billion dollar valuation worth of customers. Heck I even run it in development on my laptop thanks to Skaffold.

Sure it’s all insane overkill - but I use Linux for the same reasons - I want one API that I can use everywhere, from my toaster to my spaceship, from hobby to enterprise.

The simplicity is not the API. The simplicity is having one API.
We should teach SQL in high school
Sad but true. This philosophy isn't exclusive to one race or demographic, either. Poor white kids fall into criminal subcultures just like anyone else when there seems to be no hope and no way out. Juggalo gangs are one example of this. It's no coincidence that they have a big following in economic wastelands like Detroit:

https://en.wikipedia.org/wiki/Juggalo#Juggalo_gangs
Energy of smelting, as you point out, can be renewable, if we want, and it increasingly is, which makes it irrelevant here, no?

A quarter of the world’s copper is mined at a mine I can see from my window, and it is concentrated, smelted, and refined on site. I don’t know for certain, but have some doubt about your claim that much rock is being shipped around the world just to get smelted, can you source that? It doesn’t seem like a very cost effective idea.

It seems like you’re trying to suggest we can’t do any better by citing today’s inefficiencies. But we know for a fact we can do better, that there is a lot of room for improvement, so why the resistance? Does mining with Diesel engines today mean we have to keep doing that? If we are shipping rock around, which I doubt, does that mean we have to keep doing it?
And consumers are fine with that proposal because they end up with stuff that actually works.
China exports precursor chemicals which are manufactured into fentanyl in Mexico and then smuggled in. I don't think it's that big of a scandal that some chemicals are exported from a country that does manufacturing for most of the world. We should focus on our own culture and society that has resulted in young people destroying their lives for a drug.
> Theoretically it should be possible for a cable to spoof the ID of what it's connected to though, right?

Yes, but the authentication doesn't appear to be simple ID spoofing. This is from the announcement of the standard they're using:

"The USB 3.0 Promoter Group today announced the USB Type-C Authentication specification, defining cryptographic-based authentication for USB Type-C chargers and devices. Using this protocol, host systems can confirm the authenticity of a USB device or USB charger, including such product aspects as the descriptors/capabilities and certification status. All of this happens right at the moment a wired connection is made – before inappropriate power or data can be transferred."

https://usb.org/sites/default/files/article_files/USB_Type-C...
There is https://github.com/rqlite/rqlite but i've never used it.
When you’re dead a million years pass by very quickly.
I've made error messages along the lines of "If you see this then something has unexpectedly gone wrong <description of error the developer would understand>" for cases when the error condition should never occur under normal circumstances and should have been trapped for and solved earlier in the process, this being a belt-and-braces catch-all message as a last resort.
Since the vast majority of medicine produced isn't like this situation how do they have bad track record.

Also each company is independent.
Ah yes, a rogue AI taking over the world with checks bingo card Dogecoin?

Well I didn't have that on it, that's for sure.
Thanks for all the pointers. How common are Persian names among Indian Zoroastrians? There was a recent thread by an Iranian historian on how Achaemenid king names were forgotten in Iran. Is Proshat a common name? <https://en.wikipedia.org/wiki/Parysatis> among Indian Parsis?
Faulty way of seeing it. Like saying the sun has 50% chance of rising tomorrow as it either does rise or it does not.
If somebody hits an error, they’re some mix of anxious, angry, or confused, and cute or unclear language does nothing to help.

Yeah, and in this case, what language does help? Unless there's a call to action in the error message, I don't care if someone told me I broke the Internet, there's a picture of a whale, they tell me it's awkward, or if completely neutral language is used, none of that really makes me feel better about or helps me in my situation.
I don't know who of you remember Radiskull and Devil Doll, but before Homestar Runner came along that was pretty much peak Flash cartoon. Back in the day, on their old web site, on their 404 error page there was a reference to the lyrics of the song in their second cartoon, "Hella Weenie" ( https://www.youtube.com/watch?v=_75SUwTJg54 ):

Radiskull: From the E to the double R-O-R to the 4-0-4, what does that mean?

Devil Doll: Page not found!

I think that for low-stakes entertainment sites like that such cuteness is very much called for... but for like a business, or especially an OS, not so much. In my OS I want verbose error dumps.
If one of those cars did it once, then well, it's a spare change for you. Doesn't matter if the grand scheme of things.

If one of those cars is involved in its third DoS happening in the last quarter, you may be able to alert the authorities while it's still charging.

You can fail safe with your failsafes. You can react differently based on different kinds of failures. You can put limits to how generous you want your failsafe system to be. You can have an independent killswitch for your failsafe mechanism. You just need to put some effort into designing your system's failure modes.

You may also find out that DoSing the charging station in order to use it for free simply doesn't happen in the wild and that you can safely afford to only react once you notice it actually happening. That's why you pay all these security engineers that are able to reasonably assess these risks, you know.