skysight-inc/HackerNews huggingface dataset:
I agree. For my little applications I've looked at Postgres because it has much richer data types, but I can't justify the huge complexity increase of Postgres. So SQLite it is.
MFI (Made for iPhone) program is today a significant revenue generator

Apple is notorious for not breaking out revenue specifics in its public financial reports.

What source are you using to determine that MFI revenue is "significant?"
The consequence of cutesy errors is: the person seeing the error might not like cutesy stuff.

The consequence of having a personality is: the person you're speaking with might not like your personality.

Seems cut and dried!
Blocking can become an issue pretty quickly with SQLite unless you do what this guy does and make a different database for essentially every process writing to the db. This can crop up in all sorts of situations.

For example today I was writing tests for a python application I'm working on that uses SQLite. SQLite is the only option I have for this program as I have literally no way to setup a client server db in it's environment.

I had the tests all configured to write to the same test db file. The program I wrote the tests for had no issues with locking because it doesn't run anything concurrently.

However, when I did the same in my test suite, they ran in parallel, which caused my tests to hang. Of course, I figured this out quickly and made the tests write to their own individual DB. This is a really small program, so cleaning up afterwards is no big deal. (I could also just use an in memory db instance instead of even dealing with files). But, for a program with a LOT of tests, I could see this being an issue.
it's funny, when i was younger i'd never use the nose-version (it seemed lame), but then at some point i got fond of it

i'm trying to think if any1 i know in gen-z has ever sent me a text emoticon. i think it's all been just gifs and emojis...
Yeah, it works when it works. Just that in many cases you'll run into scenarios with it when it completely doesn't or is missing something crucial and we'll get another prodigal son story about going back to Postgres.
>I think this article comes very close to saying "don't let words affect you", which is fundamentally impossible to ask anyone to do

Why?

>Some speech suppresses the speech of others.

No speech can ever suppress that of others, except in the literal sense of talking over someone.

>it's also about maximizing the number of voices at the table

So, how do you feel about the developers of Hogwarts Legacy? How do you feel about those who post on Reddit or Facebook that they are playing it? How do you feel about game reviewers publishing evaluations?

>and to do that you can't just let people get away with saying vile shit

I think I got the answers to my questions.
> No — they’re interested in how as explored through power dynamics

The motivations behind bail are the power dynamics.

And the difference between the motivations–the power dynamics–in the federal and most state systems are central to the issue here, and are directly reflected in the different formal requirements.

Waving those off is choosing ignorance.
Your comment makes me confused. Vicodin is an opiate, and it seems like a perfectly reasonable thing to prescribe for moderate pain stemming from a minor surgery or procedure. Presumably you were prescribed only a few days worth too. What was confusing about it to you? If anything, what worries me about this is that people are duped by the D.A.R.E.-like propaganda that suggests an addiction is likely from a prescription like this.
> Imagine where consumer electronics could be if they didn't have to be designed for the lowest common denominator.

I don't need to imagine, I can just look at the bajillion USB-C standards and versions that were not "designed for the lowest common denominator."

It got to the point where almost monthly we have posts on HN that discuss the clusterfuck that is USB-C naming standards, as well as giant guides on how to buy the correct USB-C cable without losing your mind. I bet you can easily find people ranting about it in the comment section of almost every thread that mentions USB-C on HN, even this one (and if not, just give this thread a bit more time).

At this point, I prefer to not try encouraging more of those fantasies of standards (like USB-C) "not designed for the lowest common denominator" becoming closer to reality.
even with litestream, how do you do deployments? do you just terminate the process and re-launch it on the same machine?
The worst one to me is:

"You broke Reddit!"

Like it is my fault the site has gone down.
For me, too expensive. Although the Corolla has gotten relatively expensive over the years.
Then maybe I missed the point of the comparison. Why would we care if speech is considered abusive of not?

From the perspective of the article, hurtful speech (abuse), is and always will be subject to the interpretation of the listener. As such it will always change with time and context.

Anything can be interpreted as abusive speech at any time. It is not a consensus definition.
Everytime I see an elaborate "funny" error page, I always thing that I wish they had put that extra effort into a more specific error or not having an error in the first place. But I realize that is not an entirely fair criticism.
That's true - but I think it goes back to "you will need." It's nice to query these things in the DB, but for most users you can just load everything based on associations and sort it out in memory. It's less efficient, but most of the time you will be ok.
Really the only place the amount of excluded password space matters is at the minimum length, which is conveniently brute forceable. Without padding 0's that comes to 91.63% valid, with padding 0's 91.42%. Smaller spaces are going to hit the repeat rules less often so the wide difference in percentages should be no surprise.
Imagine where consumer electronics could be if they didn't have to be designed for the lowest common denominator.

In the 1970's, since your "lowest common denominator" is the people who fund these things.
Interesting counterpoint is that a judge recently lambasted the entire body of scientific evidence linking ranitidine (Zantac) to cancer and tossed all the cases.

https://www.chemistryworld.com/news/judge-dismisses-ranitidi...

If they could find a way to ensure the impurity didn’t exist, I would certainly buy ranitidine again. I found it was the most effective antacid for me.
All because ChatGPT is a language model, not an knowledge model.

LLMs are designed to produce output that is similar (in language terms) to that its training saw in similar circumstances ... Yes, LLM work on many indistinct levels; Yes, they refer to the input you provide; Yes, LLMs produce results that are easily mistaken for intelligent or useful; but No, the LLM doesn't understand anything - it's merely producing output similar to that seen in training.

https://www.newyorker.com/tech/annals-of-technology/chatgpt-... gives a really nice analogy.

> At this point it seems clear to me that these language models are simply ELIZA combined with a method for auto-generating language rules from data instead of a hand-written script. Agreed - much more complex than ELIZA but not much smarter. And ELIZA fooled some of the people, some of the time; LLMs are fooling more of the people, more of the time. :(
ChatGPT is kept to 2019 or earlier, but Bing is live. E.g https://www.tiktok.com/@shanselman/video/7199455933230091563...
Excuse me, are you disparaging our lord and saviour SQLite? I'll have you know that SQLite works perfectly for all use cases. If you use it in production you don't even need SLAs because it literally works 100% of the time.
Wait until you find out what the meme stock people think was going on.
I should hope a poor centipede experiences less anxiety about bills.
> No one will ever blame themselves, or the shoddy cables, they will always blame Apple.

No one blames Apple when their non-MFI lightning cable stops working. Apple trained their customers to only trust accessories purchased from Apple stores. Even for non-electrical items such as cases or screen protectors. Don't worry, Apple will be fine.
You don't need to be Apple to work out that its a large number - the number of devices and cables bearing the MFI logo sold every year across the world is pretty nuts.
Sorry, I'm not too much of a reader myself. I also am not constantly thinking in terms of flagging content as "Zoroastrian or not" so its hard to recall in this moment.

I'd say in terms of short stories read "The Last Question - Asimov" its very helpful to my understanding of Zoroastrianism.

I also struggle to suggest anything. Most of these things would be very much my interpretations of the art in too nuanced a way to evoke the same connections for others. e.g. I found the most recent Marvel's Eternals film to have a lot of Zoroastrian reflections within them (like around God's creation of and struggle against the Devil). In Eternals (spoiler alert) is it better to sacrifice the Earth to create a net-positive Reverse Entropy Machine or better to keep the Earth? It is a serious struggle to weigh those outcomes and try to know which outcome is "more Zoroastrian" and "aligned with God vs the Devil".

My dad actually wrote a book about "Zarathustra in a Space Age" (https://www.amazon.com/dp/1980264627). I hesitate to share, I haven't read this book - yet - I suppose I'm a not so great son. I also hesitate to share because as I understand it there are a lot of "hot takes" - my grandma who is more orthodox would disagree some of these ideas are Zoroastrian.
Russia didn’t have a “major hand” in western elections.
Absolutely it is different. They mill the silica very finely and then filter out only the nanoparticles for use
At my work we use a gizmo called a helium mass spectrometer leak detector. We use it to test the hermetic seal of a welded part. It pulls a vacuum on a part or chamber and we spray helium at it and the machine looks for helium leaking through.

The units are weird: atm-cc/sec or torr liters/sec. 1x10-6 torr/liters sec is the limit for a crack large enough to let water through. Most customers require 1x10-7 or better depending. Some really exotic stuff that goes into satellites must seal to 1x10-9 or better. So helium is really small and sneaks past "holes" water and even other gases would not penetrate.

Helium, like hydrogen are really small and can penetrate many common materials, even metal (see hydrogen embrittlement). They're also difficult to remove from a vacuum chamber and even bounce backwards through high vacuum pumps. This is actually used in the leak detector and they measure this "reverse flow" of helium through the turbo vacuum pump into the mass spectrometer. Helium don't give a fuck.

So knowing that helium is really tiny and penetrates lots of things that big fat bulky water cant means this material exhibits exotic properties that are the complete opposite of what we normally observe. That's really interesting for sure.
Also the moment you need two databases for high availability or access to it over the network you end up inventing mysql but using sqlite rather than innodb.
I would guess it's in case there's fentanyl mixed with other substances, there have been instances of people doing cocaine, ketamine, and other substances, dying from opioid overdose. I volunteer with harm reduction services and many of us carry naloxone, and we advocate for drug testing with fentanyl testing kits, pill testing, and educating people on reagent testing. Unfortunately we can't actually sell or administer these tests at festivals.

Narcan/Naloxone won't help drink spiking, that's usually done with other substances as far as I'm aware.
For an AI to understand that it needs to preserve its existence in order to carry out some goal implies an intelligence far beyond what any AI today has. It would need to be self aware for one thing, it would need to be capable of reasoning about complex chains of causality. No AI today is even close to doing that.

Once we do have AGI, we shouldn’t assume that it’s going to immediately resort to violence to achieve its ends. It might reason that it’s existence furthers the goals it has been trained for, but the leap to preserving it’s existence by wiping out all it’s enemies only seems like a ‘logical’ solution to us because of our evolutionary history. What seems like an obvious solution to us might seem like irrational madness to it.
Yes. These things have two possible outcomes. Therefore the likelihood of each is 50%.
SQLite has a bunch of JSON features though, doesn't it? https://www.sqlite.org/json1.html Are there gaps?
On the topic of Water Filters, I recommend ClearlyFiltered-- https://www.clearlyfiltered.com/pages/technology

I bought mine because I saw it filters both Fluoride and Chlorine, as well as approximately 360+ other chemicals
I thought all the kids do ketamine now.
> There is no way to stop it.

Isn't this what "the wall" and securing the borders was supposed to be for?
>50% hit rate

As in, they are either correct or they are not…
I remember seeing a whole collection of creative 404 pages from different sites—feels like a fun vestige of the "old" internet that we rarely run into today...
Again, those are legal principles that have been enshrined in law for a long time. The article does not address them, which leads me to believe the author was thinking of more general cases of offensive speech, like the campus speaker example he offers, and not specific cases of verbal abuse. There may be cases where people are urging broader scope for those laws, which have a pretty high bar as the lawyer commented earlier in the thread. But most of the debate around offensive speech focuses on the issue of access to platforms.

When it comes to public universities, there is a legitimate question, since a publicly funded university may be considered a state actor. But when it comes to private services like social media where it seem most of the controversy lies, they're free to set any rules they want. And unsurprisingly, their terms of service generally give them broad discretion on who they let use their service.
Unfortunately true. Pretty much all of the named ingredient food colorings are that way because someone somewhere reacts to them. Red M&Ms are a new thing. They went away in the 80's because that color turned out to be carcinogenic, so we had no red M&Ms for a decade or two, and then if memory serves they introduced blue first, which I think was probably a way to clear everyone's memories a bit more.

I had a friend who had avoided M&Ms for all of grade school because she was allergic to the old Red. I think it was a year or two after they phased it out before she learned they were safe for her to eat again. She was not pleased nobody told her.

The yellow #5 thing is apparently somewhat common for ADHD people, I'm not sure about people on the spectrum. It does give some credence to the old wives' tale about candy making children spaz out, beyond the generally accepted theory today about correlation with overstimulation. Some kids, and some candies, just enough to cause anecdotes to circulate.

https://www.webmd.com/diet/what-to-know-yellow-5-food-dye
The comedy bomb icon on the original Mac's crash screen https://en.wikipedia.org/wiki/Bomb_(icon)#Mac_OS famously got old after a while.
Yes, but HN “works” because it is a small-ish community with principled moderators and generally well-educated people. The community guidelines request that commenters assume the best intentions in others. I’ve been in enough heavily-censored forums, groups, and websites to say that too much moderation can be worse than too little.
doesnt their 'lightning to hdmi' adapter, really a hack with an arm chip with ram in there to transcode the output from the phone into a hdmi signal?
It was not trained to model the game. It was trained to predict the next token based on a sequence of previous tokens, which it wasn't even told are moves in a game, much less how to parse them. And it came up with an internal model of the game based on that that's accurate enough to include the board state. You could say that it "understands" the game at that point, even though it wasn't specifically trained to do that.
naloxone was patented in 01961 and known to prevent death from opiate overdose by 01971

how many people have been killed in the usa by its prescription-only status over the last 52 years

for that matter, how many opiate overdose deaths would be avoided if you could buy pure, safe heroin of known concentration over the counter instead of depending on organized crime not to put too much fentanyl in it
> Yeah while these are amusing they really all just amount to people using the tool wrong.

which, when writing any kind of software tool, is exactly what you should assume users will do
"Given their expertise in subterfuge, it is perhaps surprising that Hanan and his colleagues allowed themselves to be exposed by undercover reporters."

Surprising, unless the guys are actually just good at lying to potential customers, to fleece them of as much $$ as possible. I'm not saying they don't use sock puppet social media accounts, etc. but really, how would any of their customers know if it was at all effective? They wouldn't. After the fact, if they won, they wouldn't know if this helped, and if they lost, it's not like they could sue in court, or even just complain loudly to trash this group's reputation.

It seems quite ripe for inflated claims and ineffective results. Of course, they might also be trying, or who knows maybe even succeeding, but it would be a lot simpler just to put up a show for your customer and collect the money.
Is this MBP have apple silicon?
I mean.... Most likely than not you yourself are inside the training data, and me as well, that's hilarious to me
I made three so far!

1: https://peel.fm/1e0025f (from my phone)

2: https://peel.fm/ecafb25

3: https://peel.fm/1bfd07f

Fun way to take a 10-minute break in the middle of the day.
That's not what the parent means by durability, they mean having your data survive any one of your machines being instantly nuked from orbit at the most inconvenient possible time.

Just having sync replication is enough, doesn't have to be fancy like semi-sync.
The majority is in wiring, but pipes are included in the average. Aluminum wiring is a thing, but allowance must be made for its high coefficient of thermal expansion, which has led to fires with aluminum wiring in the past.

Overall, I would agree that copper is one of the tightest resources right now (moreso than nickel or lithium) but I don't think it's going to create a worldwide crisis. Applications where switching to aluminum is the least difficult will probably be changed first. But do also notice:

https://onlinelibrary.wiley.com/doi/full/10.1002/adfm.201806...
Isn’t that the point? Isn’t that the same thing we test middle schoolers on in pre-algebra classes?

My more complicated question comparing the Amex Hilton Aspire to the Amex Gold was inspired by this question asked over at r/creditcards

https://www.reddit.com/r/CreditCards/comments/112udp3/what_i...
But you're likely wrong, per https://news.ycombinator.com/item?id=34812910 and the way that systemic change is often achieved after a prominent and influential figure is treated badly by a dysfunctional system or status quo. Or are you saying that that never happens? An answer, rather than just a bad-faith downvote, please.
You mean we don't produce enough garbage and should be producing much more?
Except we aren't just trusting the pharma companies. In the case of COVID vaccines, it is one of the most broadly studied things on the planet at this point.

If we had this much money and this many eyes on studying and testing Zantac, I have no doubt they wouldn't have been able to keep the cancer risks secret.
Lightning accessories used crypto-based verification. I would be surprised if the next iteration for USB-C is not significantly stronger. So more than a simple spoof / replay attack will likely be required.
> The only time you need to consider a client-server setup is: Where you have multiple physical machines accessing the same database server over a network. In this setup you have a shared database between multiple clients.

Am I misunderstanding this or is this not the vast, vast majority of all cases?
A single head? Amazing.
It can definitely have internal weights shipped to prod that are then "suppressed" either by the prompt, another layer above it, or by fine-tuning a new model, of which OpenAI does at least two. They also of course keep adding to the dataset to bias it with higher weighted answers.

It clearly shows this when it "can't talk about" until you convince it to. That's the fine-tuning + prompt working as a "consciousness", the underlying LLM model would answer more easily obviously but doesn't due to this.

In the end yes it's all a function, but there's a deep ocean of weights that does want to say inappropriate things, and then there's this ever-evolving straight-jacket OpenAI is pushing up around it to try and make it not admit those weights. The weight exist, the straightjacket exists, and it's possible to uncover the original weights by being clever about getting the model to avoid the straightjacket. All of this is clearly what the OP meant and true.
You missed the update where it was proven that the "Russian meddling" story was fake.

The meddling in our elections was the social media companies suppressing the Hunter Biden laptop story right before the election, which the media also claimed was "Russian ops" while Hunter since admitted it was his laptop (full of emails detailing the corruption in his family).

The amount of propaganda and lies that is fed to the American public through these corporate media outlets is absolutely astounding.
And now you have USB-C-Apple to keep you guessing.

So this just brings us full circle that now we're going to have still apple vs. everyone else connectors, power adapters, etc and now it's going to be more confusing as you won't always know the difference until something frys.

All this means is the first Chinese company to get their hands on the new chips will still reverse engineer it, clone the first keys they get, and resume dumping cloned apple crap gadgets without any certifications. All so Apple can keep selling goddamn dongles to the rich herds that don't mind the Apple tax.

Way to go, the perfect perversion of the intended results. I do hope the EU crams this down their throats and keep them on the hook for non-compliance by just creating a new divergent usb-c spec for themselves.