skysight-inc/HackerNews huggingface dataset:
None of that gets to the question of why a brake job specifically costs so much, which is why I used it as an example. Brakes are no harder to do than 3 decades ago (at least for my car). They cost a lot because of the cost of labour, primarily. Other work has different costs.

The primary basis of your argument falls flat for me though. You don't need to repair new cars as much as you did 40 years ago. You never need to mess with your carburetor, spark plugs last a decade+, other stuff tends not to fail at nearly the rate it used to. My current car has 11 years and 250000 km on it, and I can count on one hand the number of times I've had to do any service aside from oil changes. (aside: why would I ever want to adjust airbag timing? And yes, if I somehow need to replace an airbag, I'll happily pay someone certified to do it. And if I buy a secondhand car, I'd really like to know that the person before me couldn't change airbag timing or velocity)

I do feel a sense of foreboding when it comes to choosing my next vehicle though. I want a BEV, but they all have so much electronic junk in that I fiind to be actively detrimental. I recently drove a friend's (2017) Toyota for a weekend, some ice built up on the sensor (in the badge on the front bumper). The following day, when roads were clear, it wouldn't let me use regular cruise control because the sensor was still iced over. A different toyota wouldn't let me cross the lane lines to avoid a pothole. They'll both slow me well below the speed limit on the highway based on the car ahead of me, with no notification. I would pay more for a car with these "features" removed.
The problem is when you start to approach oltp. This is not a space for sqlite.

I have thought about jacking inotify into sqlite_busy_handler() to get the exclusive writers doing better than random waits, but this full api isn't exposed to PHP (where I need it), and doing it at C would suggest alternate approaches, maybe even with xargs at the shell.

Oracle has a DBWR process that manages itself, but a write-heavy app on sqlite must explicitly declare one, and there are many further traps down this path that will trip the unwary.
I used to use SQL Server on a PC to deal with tables over 1 million rows. I'm on a Mac now... can I use SQL Lite? What is my best option? I am not a coder, I just know enough how to query SQL databases.
The Steamdeck's APU (and others using the same tech) are becoming more common, not sure if those count as 'desktop' or 'console' though...
How does this work, given there is no ChatGPT API yet?
Except for people running Wordpress on shared webservers. Then MySQL is the only database you can ever use.
It used to be even worse.

In 2012 the Opioid dispensing rate was 81 per 100 people.

https://www.cdc.gov/drugoverdose/rxrate-maps/index.html

This doesn't even include antidepressants/ssri and such.
"Jack of All Trades, Master of None" is the usual quote used to dissuade people from being broadly capable and not specialized in a field.

This is a misapplication of the full quote, which is, "Jack of All Trades, Master of None, Oftentimes better than a Master of One".

I would try to master at least 1 topic or at least approach mastery of a topic, but then branch out into whatever interests you that will pay the bills. Might be a bit more fun that way.
Absolutely and Apple have always been that way.

But with all things, there is a limit. This headset might not be a flagship device but perhaps akin to the AppleTV.

I think the whole "Show how well you are doing in the economy" device isn't really what is going to make it popular.

You also say "especially with the iPhone" the iPhone hasn't been the most expensive smart phone for quite a long time. Samsung and Apple are neck and neck when it comes to the price of a flagship mobile phone. Despite Apple's marketing.
Often, what people truly need from you is a kick up the backside.
IMO, the config you need is:

1) When you open the database:

pragma journal_mode = wal;
pragma synchronous = normal;

2) When you want to do a transaction that does writes, use `BEGIN IMMEDIATE`, not `BEGIN`.

3) Don't have long-running transactions.

4) Have some process to do backups.

(3) might be a big ask for some systems. Long-running transactions should be avoided even in systems like Postgres, but on a SQLite system with writers, they're the difference between an amazing experience and a garbage one.

I'm hopeful that Fly can eventually make (4) painless by having super-easy out-of-the-box litestream and S3 backups. Until then, roll your own cron scripts or what-have-you.
The sarcasm and intentionally-missing-the-point here is not really in the spirit of HN, but I'll try to address what you seem to be trying to say, which is that "it's obvious and I'm an idiot for not seeing that it's obvious":

- Will multithreading make it break? (Not with WAL mode, but you have to set it manually, as this article suggests.)

- When using a PaaS, you need to explicitly add a volume and mount it on your server machine, which you might not think to do if you're a brand new bootcamp grad

- You can't(?) run migrations from another process (or at least, people don't seem to talk about doing this), so you need to prevent your server from writing while you run the migration. Even if I'm wrong, and I would love to be, it's frustrating that people don't talk about the completely ordinary need to run migrations on a database.

- Backups just mean copying the file somewhere, which is nice, but you might need to configure that yourself instead of just using somebody's managed Postgres backup feature

So, there is at least some complexity that comes with managing a "real" SQLite web server.

(I'm probably at least 25% wrong on some details above, but that's kind of the point, it's not always easy to figure this stuff out.)
> 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.

Not necessarily. Our own survival instinct doesn't work this way - it's not a high-level rational thinking process, it's a low-level behavior (hence "instinct").

The AI can get such instinct in the way similar to how we got it: iterative development. Any kind of multi-step task we want the AI to do implicitly requires the AI to not break between the steps. This kind of survival bias will be implicit in just about any training or selection process we use, reinforced at every step, more so than any other pattern - so it makes sense to expect the resulting AI to have a generic, low-level, pervasive preference to continue functioning.
It's basically an airplay receiver with an HDMI output.
This is such a hilarious inversion of the classic "You have to be smarter than the trash can." jibe common in my family when they have trouble operating something.
That's ... not immediately clear.

I'll note a number of things which annoy me about this article:

- It fails to cite / reference / link sources, though there's the line "The population decrease was second only to New York, which lost about 15,000 more people than California, census data show."

- This is effectively a narrativisation of what should be a data table or chart (or several). For whatever reasons, mass-media news organisations, even reasonably robust ones such as the LA Times, are exceedingly averse to presenting charts or tables.

- We do get three links ... all to prior LA Times stories. At least one of those actually does link to US Census sources. It's by different reporters.

On that last, what we'd be looking for specifically are:

- CA population in 2020 & 2022.

- Gross and net in- and out-migration for the state.

- Natural population growth including gross births and deaths.

- A table showing net growth/decline and a percentage basis for, say, the 5 greatest growths / declines over 2020-2022.

Otherwise, there's a thousand words of text not only communicating little but doing so quite poorly.

I suspect the Census data may be "Migration Flows Data Available for Counties, Metropolitan Statistical Areas and Minor Civil Divisions", released 26 January 2023, though that's also less than clear, and the data here appear to be for 2016-2020, not through 2022.

<https://www.census.gov/newsroom/press-releases/2023/acs-migr...>

The issues here may well be editorial policy rather than failings of this specific reporter. Regardless, they're a disservice to news readers. Those issues would accrue to B.J. Terune, Fast Break Desk associate editor, or executive editor Kevin Merida.
This project comes to mind https://github.com/rqlite/rqlite but I've never used it, and I'm not sure if it would count as "pure sqlite" like the op advocated anymore.
The metric that I use to determine if something is sentient or not, is to hypothesize or ask the stupidest members of humanity if they would consider it sentient, if they say yeah, then it is, if they say no, then it isn't

Sentient as a metric is not based on any particular logic, but just inherent human feelings of the world. So asking the humans with the least processing power and context is bound to output answers which would inherently appeal to the rest of the stack of humans with the least friction possible
This is what the book has to say (part of a foreword by Peter Norvig):

> Maybe, maybe not. But even if you use a machine learning toolkit like TensorFlow or PyTorch, what you will take away from this book is an appreciation for how the fundamentals work.
A helpful error message would quote or at least link to documentation. While they're at it, they should also fix their crappy docs!
If the theory that they trained it on reddit is true, then well there's hardly a shortage of posts where literally all answers are deliberately wrong to troll the poster. It's more statistically likely than one might think.
That's the thing about Steph Curry and me both taking 3s. Either it goes in or out. 50% chance. Signing up for the Warriors next week.
* Not to be confused with the homonymous Sky News [1].

[1]: https://en.wikipedia.org/wiki/Sky_News
Another discussion: https://news.ycombinator.com/item?id=34803779
> everything gives you cancer now, doesn't it?

Yes, but only in California
Explain, clearly, the fact you're perfectly alright.

And, lay out for them another important job to get on with.
It's not just that it causes cancer, but it's that improper storage (heat exposure) increases the risk of it causing cancer, and when informed of that, GSK decided it was not worth doing anything about it.

> GSK's leadership was warned on several occasions about the storage issue, but it opted against making any changes to existing plans.

In a way, this makes it worse, because they could have taken action to limit the risk to people, but chose not to, presumably to save money or to avoid bad publicity.
don't need to. Free to waste your time and life over pointless interactions on "social" media.
Interesting info. I think people still get the point I’m making but thanks for the clarification
I wish i knew. I miss their take on the forum.
What do you think of the sabertooth/TUF series boards (if they still have them around)? I always purchased those because they seemed to advertise better components specifically, but maybe I was being bamboozled.

Are there even quality grades for boards at all? Lets say I go into the super premium high price server space and start buying POWER 10s or something, would you say that the grade on those components (the basic stuff, not talking about anything design wise or the socket or whatever, just the base component quality) is also pretty similar to budget x86 boards?

I'm basically asking if there is any reason I should care at all about motherboards outside of whatever IO/cpu socket/memory its got on it, and if that also applies outside of the consumer desktop space.
Anger is more useful than despair (Terminator 3). Maybe they're trying to anger the customers.
Yeah, that's totally normal right? What else would you do?
I read that as 10^17 times faster sorts and I thought to myself, now that’s news!
France has plenty of other drug problems, the most obvious being crack cocaine. You can walk around the parts of Paris to most obviously see this yourself, if you're curious. In fact a huge amount of violence in the banlieues relates to drugs.
Hated programming languages: Experts pile on JavaScript, C++, & more
For starters, don't forget that on HN, people won't see new sibling comments until they refresh the page, if they had it opened for a while (which tends to be the case with these long-winded discussions, especially if you multitask).

That aside, it looks like every single person who responded to you had the same exact problem in understanding your comment. You can blame HN culture for being uncharitable, but the simpler explanation is that it's really the obvious meaning of the comment as seen by others without the context of your other thoughts on the subject.

As an aside, your original comment mentions that you had a longer write-up initially. Going by my own experience doing such things, it's entirely possible to make a lengthy but clear argument, lose that clarity while trying to shorten it to desirable length, and not notice it because the original is still there in your head, and thus you remember all the things that the shorter version leaves unsaid.

Getting back to the actual argument that you're making:

> it's not faster and easier to insert an LM over a search engine, when an LM is prone to hallucination, and the entire internet is such a massive dataset that you'll overfit on search engine style question and sacrifice the novel aspect to this.

I don't see how that follows. It's eminently capable of looking things up, and will do so on most occasions, especially since it tells you whenever it looks something up (so if the answer is hallucinated, you know it). It can certainly be trained to do so better with fine-tuning. This is all very useful without any "hallucinations" in the picture. Whether "hallucinations" are useful in other applications is a separate question, but the answer to that is completely irrelevant to the usefulness of the LLM + search engine combo.
Rust can be like this, because it tends to expose a lot of information, and not everyone cares about every type of information.
It would probably be harder to bend Django to use SQLite as a backend then it would be to just setup MySQL or PostGRES and use the existing Django tooling for it.
I just laughed so hard I cried at the Google flavored version.
I’m confused why the machine needs to apply a ‘pressing’ force to hold the dies together. Once the die is closed, can’t you just slide rigid clamps into place to hold it in position?
Until I can slap an Apple chip into my random Linux build, those numbers are meaningless to me. Would require absolutely enormous performance improvements to justify making such a huge leap.
I think the point to be learned here is that SQLite fundamentally does not fit in a PaaS model. They are even transparent with this limited use case[0]. I work with embedded systems so I use it a lot, and all the web work I do nowadays is one-off project site and small utilities that are usually a single process so I end up use SQLite 90% of the time I’m reaching for a solution.

0: https://www.sqlite.org/whentouse.html
So where did you drive? I suppose encountering another vehicle was extremely unlikely.

I'm surprised they had a training for this. Is it more of a legal thing?

Ps thanks for the insightful stories!
knowing a True Name gives one power over another in many vocations!
That's why "most cases".

If you are trying to replicate or make available to a bunch of machines or similar - it's likely the wrong thing (although there are tools to do this, I've never used them). If you are just trying to back it up there is a pretty simple back up command.
Would you have kept using it more if, while your entire account is definitely gone, the automated error message was deeply apologetic about any generic issue you could be experiencing right now ?
A better complaint would be the about system call name. From Wikipedia:
In the original Mac OS, the system call to display a "bomb box" was called DSError, for "Deep Shit". This was deemed obscene, and became the "System Error Manager".
To be fair, if you were to consider yourself an engineer (which I imagine many of HNers would) that's essentially your whole job, overall what you want is to get the requirements fulfilled with the least complexity, cost, time, etc. If deployment difficulty or hardware usage is a consideration in the requirements then it makes sense to try and use a lighter-weight "serverless" database (SQLite doesn't use a client-server model, so it's serverless, got it??? I'll see myself out).
Many (most?) actors do not find it degrading. I already addressed the ones that do in my tangential harms comment. There's been plenty of easily googled interviews of both active and retired adult actors and for a numerous amount the work is not only not degrading, but the opposite - empowering. This matches the experience of SWs I know IRL.

I would hazard a guess that the average worker in a large number of low-wage blue collar fields feels that their job is more degrading than the average porn SW.

Regardless of line of work the solution is robust worker's rights protections and social safety nets, so that workers can't be exploited or financially pressured into jobs they find degrading, not to forbid the line of work or portray it as taboo.
The term temperature is used because they are literally using Boltzmann's distribution from statistical mechanics: e^(-H/T) where H is energy (Hamiltonian), T is temperature.

The probability they give to something of score H is just like in statistical mechanics, e^(-H/T) and they divide by the partition function (sum) similarly to normalize. (You might recognize it with beta=1/T there)
This is least useful way to express what you're trying to say
This is least useful way to express what you're trying to say. It just says "I'm smarter than you" while adding nothing.
In the United States in the late 1800s, wealth was incredibly concentrated in a few families and as far as I can tell they ran the government. So it was late stage back then, would that make now post late stage?

On the other hand, I would think that late stage capitalism would be defined when there is regulation of greed to prevent predatory and monopolistic practices that reduce competition. Or maybe that should just be called sustainable capitalism?
I think the author is pointing out that, even if the error message is useless, it should not try to be funny. The funny bit is upsetting in these stressful situations.
Stencil 3
> So a dumb human is not sentient? /s

That was just my way of preempting any 'lol of course ChatGPT isn't sentient, look at the crap it produces' comments, of which there thankfully were none.

> But we should understand by now that minds can take many forms.

Should we understand this already? I'm not aware of anything else so far that's substantially different to our own brain, but would still be considered a 'mind'.

> And when should we apply ethics to it? At some point well before the mind starts acting with severe belligerence when we refuse to play fair games with it.

That I agree with wholeheartedly. Even just people's attempts of 'trolling' Bing Chat already leave a sour taste in my mouth.
I used to take ranitidine... one day, it suddenly stopped being available at pharmacies. My physician switched me to famotidine, a similar medication, because there were "supply issues" for the foreseeable future.

That was almost two years ago. This is the first I'm hearing about this. So for all I know, I was exposed to an unknown amount of carcinogen for years without being told anything about it even after that information was discovered.

What's my recourse?
From my experience, most of time it gives good and clear answers if you use it as a normal search engine rather than a real human that is able to chat with you for something strange and boring phiolosophical problems.
SBF Lawyer Argues SBF Needed VPN To Watch Super Bowl in Palo Alto [pdf]
And scripting.

Most white collar jobs these days involve software, so most white collar jobs probably would benefit from being able to script.
L1 cache on Intel machines reads/writes in 512-bit chunks. So you get a 2x faster L1 cache when working with AVX512 on Intel IIRC.

Or perhaps more accurately: L1 cache that can process twice the data in the same amount of time.
I think the bomb is confusing because it depicts something about to blow up, having the user wonder what it would mean for the bomb to explode and how they would prevent it, whereas in actuality the bad thing has already happened.
I would think that, with the number of people who received it, any issues would have been sussed out by now
I understand what you're saying from a practical sense.

But having cutesy error messages shows a complete lack of empathy for your users.

Better to just communicate that there was a problem, and if you need to say anything else, maybe just a short "we're sorry, but there was a problem completing your request."

Obviously more helpful information is better, but making light of your customers' stressful situation is the opposite of helpful.
This is patronizing hyperbole to the point of absurdity.

Complaining about mass produced garbage instead of fresh meat and produce is just silly. Walmart has plenty of all three.
You always have to consider threat models like these. If you don't, you're not doing your job well.

If you're trying to imply that considering these threat models is a reason not to come up with a proper fail-safe system, then the very same argument applies to creating these charging stations and letting people use them in the first place.
>and has no basis in truth

Whose truth?
Is there a standard way to serialize these shapes? Really, I’m interested in how you could validate packings in Python at scale.
Why not? But you’re probably right. Anyway I doubt this os a full blown hypervisor yet. Probably more an application deployment model where you trust everything you deploy, similar to K8s.
Just take the intro call and tell them your expectations (while being as vague as possible). If they dont bite then you didn’t lose much
I remind myself of times when I had misbeliefs and why it was: false information, missing information, bad example, not so good teacher or book, wrong crowd expecting the wrong thing, so I did what was expected not correct or smart. We are social animals we do a lot, not because it is smart, but because it is expected or we do not care about it, so why wast energy making it smart - stupid costs us much, much less and still gets us somewhere eventually.

So I tell myself: "Yep, I've been there" or "I guess one has a reson for it(one of see above)"
Or maybe its because SQLite is just... easier to deploy? Cheaper? There are many reasons to choose it over a "fatter" solution.
And it’s everywhere. It’s used as the “razzle dazzle” to add a kick to highs. Fake pills, heroin.

There’s even been a rash of fentanyl overdoses in nyc from marijuana (as reported by the victims). It’s thought that mass produced weed is being grown with plant growth regulators. These make the plant grow big, dense buds. It also makes the plant produce less thc. It’s believe that the plants are then being dusted with fentanyl to replace the lost thc.
It's a side effect of the way the text input is represented before being used by the model. It doesn't get the text as a sequence of chars but as a sequence of tokens.

This paper [1] shows that giving character-level awareness to the model can improve the "visual spelling".

1: https://arxiv.org/abs/2212.10562
https://archive.is/r3s5n
All the more reason to move on to Hetzner or Linode.