skysight-inc/HackerNews huggingface dataset:
I see posts like this and I can't help but think: This sounds exactly like something an academic would recommend, and then you hit the reality of industry engineering.

Its a similar take to a lot of the negativity surrounding Next 14's stabilized server actions. The negativity is academic; the productivity is industrial.

Here's my counter-hype take: SQLite actually kind of sucks. It has a place, but that place isn't significantly different from where it was five years ago despite all the "serverless read replicated VC funded hacker news hype startups" work that's happened since then.

If you're in crazy-enterprise hell-engineering; no one is going to reach for SQLite when more robust alternatives like Postgres exist.

If you're trying to get something out the door fast, you've got Postgres on Supabase, you've got MySQL on Planetscale, you've got Firebase, fifteen years of database-platform development, all of these aren't just cheap, they're free, and zero maintenance, you're not going to pay more money to do more work for a worse product by setting up SQLite on your single DigitalOcean VPS. You probably won't even reach for something like Cloudflare D1; sure, its interesting, but why? Its just Planetscale, but not better in any way and worse in plenty (its not even really much cheaper).

SQLite doesn't support alter table. It doesn't have a date-time type. It doesn't enforce columnar types outside of strict mode, which isn't enabled on e.g. Cloudflare D1. Someone stop me. Everyone says "KISS, you can get so much performance out of one application server with SQLite running locally" but you can get the same f^cking performance out of one application server, and a DBaaS, like Planetscale, and its easier, and its cheaper, and you get backups, and you get full MySQL, and you get a paved-road to actually paying them $30/mo if you need to instead of hitting a bottleneck and suddenly having to wonder how the hell you're going to scale SQLite beyond this one instance ("we need VC funding for more engineers", you'll think in that moment)

Kent's statement "However, SQLite is capable of handling databases that are an Exabyte in size" actually makes me mad. Its so ridiculously academic I'm aghast anyone takes this seriously. "Oh, well, hc-tree uses 48 bit page numbers so its an exabyte, and you'll hit other application problems first anyway". No; you'll hit problems with SQLite first, ten times out of ten, it'll be long before you hit an exabyte, it'll be before you even hit 100gb.*
> getting all the coaching he could use from his lawyers

I imagine he's had good legal advice from good, smart lawyers. But I doubt SBF thinks they're as smart as he is - oh, no!
If content is this good, I will allow it. Manipulation is good if the end result is in my favour.
Outside classical C UNIX applications, most language runtimes are multihreaded anyway.

Windows has been multithreaded for decades across all layers, even classical Win32 written in C is using multiple threads.

Android, ChromeOS and macOS likewise.

In the end, single core performance being that relevant is quite niche case in modern software stacks.
That was an interim state. It is now approved for all type-certificated spark-ignition piston engines.

https://www.g100ul.com/faq.html#testing
NFT Refresh
A single EMP event, like the Carrington Event, or just a single launch of something like Starfish Prime, could wipe all of that out in the blink of an eye.

Something like this occurring seems inevitable given a long enough timeline, and 500 years doesn't seem that far away.
> with one enterprise grade SSD for OS and ZFS cache. All that Jellyfin data doesn't have to reside on any SSD

lately I've been experimenting with just putting the OS on spinning rust too. It seems like it's just so ingrained in us to put it on flash because of the order-of-magnitude gains in boot time, but for servers, is bootup time really a factor (damn supermicro motherboards take 1 minute+ post...)? Once your services are loaded to ram, how much does the OS actually hit the drives? If your OS supports ZFS-on-root, then you have one less point of failure.
It's strange to think about Consoles, PCs, and Ports. Consoles were nothing like PCs for a long time, so ports took actual effort and reduced cross-platform releases a bit. Then consoles started to look and act more like PCs and porting was relatively easier until the hardware started to diverge into the powerful, combined SoC systems we have now compared to the sturdy-but-separated PCs that haven't had a major form-factor change in 20 years.

So PC ports are less efficient because they don't have such continuous, low latency access to memory and the best solution (cheapest?) is usually to just dump everything into VRAM and require more memory. It's frustrating when you can buy a game on a PS5 and it plays great but the PC port needs at least double the specs to run well.

I guess PC gaming was kind of always expensive on the high end but the low end is just disappearing entirely when devs aren't allowed to spend time optimizing at all.
James Thurber
Sounds like your problem is with SQLAlchemy, not with SQLite.

My https://sqlite-utils.datasette.io library might be a better fit for you. It's a much thinner abstraction than SQLAlchemy.

Or just use sqlite3 from the Python standard library directly.
Authenticity often doesn't scale because authenticity requires a history that is unvarnished and informed by actual events and cannot be coerced
I find 90% of social media interactions to be inauthentic. Communication in massive free-for-all groups is weird. It causes people to want to be right, win, or sell you on something. It’s funny that people would look got truth on divisive argument websites.
It's actually quite easy with things like LiteFS Cloud.
https://fly.io/docs/litefs/
Because pollution is an externality cost that the market does not take into account. The only way to solve it is with regulation. These regulations are justified on the basis that it is wrong to poison others, or pollute their right to shared public resources.
High level is far far from low level, or at least that was my interpretation.
> half of "the people" are dumber, more simpler-minded than the average person.

Spiders Georg would like a word with you. And 99.99% of people have more than the average number of legs. And "the average person" is not something you can actually imagine. Think about "the average driver". You're actually thinking of an asshole driver, because asshole drivers are more salient. You don't notice "the average driver".
> If you define a table as strict, the data is coerced, and if not successful an error is thrown.

Coercing the data is hardly better. Now you have data integrity issues and you have no errors!
You need an extension, and making the HTTP call reliable with retry and jitter is going to be hard in pl.
The quest to re-create nature's strongest material
> (And shale gas is one of the reasons for the drop... gas power does better for CO₂ emissions than coal is, and the fracking boom basically killed a lot of the coal industry.)

Natural gas is better in isolation at point-of-use, but that assumes that none of it escapes into the atmosphere at any point along the (literal) pipeline - which, as it turns out, is not a safe assumption, due to shoddy pipelines. As a greenhouse gas, natural gas is actually a few orders of magnitude worse than carbon dioxide[0], so if even a very small amount leaks out it not only wipes out any gains you get from using natural gas instead of coal, but quickly becomes a solution that's worse than the problem.

We probably haven't seen the worst of it yet: in practice, companies have very little long-term liability for the environmental impact of the mining infrastructure as it ages and after it is abandoned, at which point it becomes an effective pump of greenhouse gases into the atmosphere. With nobody else responsible for the expensive task, it will probably be up to the government to clean it all up.

[0] https://www.reuters.com/article/us-usa-gas-climatebox-explai...
Fat parents often have fat children. There’s a strong correlation.
Arsenic levels in soil can naturally vary depending on minerals under the soil. So you can get more if say you are eating a root vegetable that you need to wash the dirt off vs less from an above ground vegetable.

Unfortunately I have learned a lot about this bc our region has unnaturally elevated levels of lead and arsenic die to pesticide use in the past. But can also just be bad luck and natural.

https://www.ncbi.nlm.nih.gov/books/NBK231016/#:~:text=The%20....
We explore the potential of AI-powered API integration platforms, an approach holding the promise of revolutionising how developers interact with APIs.
The change was being orchestrated from their desktop, and they noticed thing were going sideways, so they unplugged their desktop to stop the deployment. Aka "pressed the big red button".
Not only that, since 2019 Google have required apps published on play store to have 64bit variants, this should not be a problem.

However I suspect that the Xiaomi has to contend with the Chinese app ecosystem which may not be as strictly controlled, so probably has a decent number of legacy 32bit apps floating about.
G100UL, the current unleaded alternative to 100LL, has been tested to act as a drop-in replacement for any and all aircraft engines that run on 100LL.

If you can run, 100LL, you can run G100UL. The main issue is with mogas (standard car gas) - many aviation engines can't run it.
I was a Java true believer in the late 90s/early 2000s, working on LimeWire, the most popular Java desktop app at the time (maybe of all time?). I thought we were close to a time when garbage collection was just as fast as manual memory management, and runtime re-optimization could make up for the extra time an ahead-of-time compiler could spend on optimizations. (Yes, I've read all of the Garbage Collection Handbook, and am aware of the speed advantages of bump allocation and the advantages of memory compaction. However, when it really matters, people still sidestep Java's GC using object pools and/or size their heaps such that they never collect while the stock market is open.)

Then, I started slinging C++ for the Google indexing system.

I still hope we get to a point where compiling to native code is as rare as hand-writing assembler is today. I hope we distribute code primarily in a format optimized for native translation, SafeTSA or similar. (Though, I'd hope we get install-time caching of native code generation, similar to AS/400 TIMI / current Android Runtime.)

However, until compilers get very good at statically inferring lifetimes and statically scheduling object collection, I hope garbage collection is optional and freely mixable with manually managed objects. (Yes, statically determining minimal lifetimes in the general case is equivalent to solving the halting problem, but we can be conservative and fall back on GC in the statically-unsolvable cases.)

The main drawback of Java for most applications is that with garbage collection there's a time-space tradeoff. As a rule of thumb in order to avoid frequent major collections, a Java program is going to use about twice as much memory as an equivalent C/C++ program.

When it really counts, we're still not at the point where Java is faster (even after warm-up) than expert-written hand-optimized C/C++ with profile-guided optimization.

Don't get me wrong. I understand the development velocity advantages of Java over C/C++ can often more than make up for performance differences, and good C/C++ developers (especially with domain-specific skills) are rather expensive to employ. I worked on equity trading systems in an interpreted language, where we replaced a lower latency system written in Java. The high-level interpreted language enabled a very rapid turnaround time and was easier for Statistics/Physics PhDs to implement models. The better models resulted in better average prices despite the system reacting more slowly to incoming data.

Ideally, I'd like to see something Elixir-like with good interoperability with something Rust-like for the parts that use a lot of CPU time and/or a lot of memory, all compiling down to a SafeTSA-like compressed control flow graph representation designed for fast native code generation.
Nicely presented data can certainly inspire confidence, which might or might not be justified, but I think attractive presentation can be more than just a sales pitch. Ultimately, we create these visualisations to convey information to someone else, so good presentation should help that someone to navigate and understand that information, and it should avoid introducing unwanted bias or ambiguity.

If that means creating an overview of the system architecture for new team members that uses pretty colours and multiple fonts and icons and shaded boxes but that helps them to understand the system more quickly and correctly than an overwhelming page of black-and-white text and arrows, the extra styling has done its job.
Video interview with the engineers (ads at beginning). Interesting, it's been a difficult problem for a long time.

https://www.worldsurfleague.com/posts/455501/full-report-202...
>> There should be a long and careful process before any so-called improvements from modern technology are forced upon us.

In this case, it has been a decades long process. But it's done now and the replacement fuel is available. Time to mandate the change.
I started a twitter a few months ago, and then deleted it after I realized the current meta is to say something extremely vapid and wrong to phish for annoyed engagement.

That is where we are at. Annoying people for follows.

I deleted it the next day.

Online culture is over. As people have improved at debating we have realized half the time you are shadow boxing with someone who doesn't even believe what they are saying. Or hell, anymore it could be a literal bot.

It is bad faith everywhere. It is all a waste of fucking time.

Not to mention the clear brigading and bot-nets on Reddit that makes arguing with the wrong person account suicide.

Just use the internet for what it was meant for: photos of cute animals.
Interestingly this is the exact opposite of the usual argument as to why Shakespeare is still popular, i.e. that his work speaks of a deep universal truth about the human condition.
Because Xiaomi cares about software backwards compatibility on its devices? Just because many people are now used to being told "this app developer hasn't updated their app in a few years so now you can't use it, tough shit" doesn't mean it should be the standard.
Even for low-end system, 100MB isn't much.

For my Arch system I have a 60GB (BTRFS, compressed) root partition, and I install packages very liberally, I have KDE Plasma, KiCAD (with the 3D library), FreeCAD (though I don't use it) and quite a few other packages and haven't run out of space yet (currently I'm using 79GB uncompressed, 55GB on-disk)
Planting more trees (and, more important, preserving existing trees) is an important tool in the toolkit, but shouldn't be overestimated, and I don't think the word "easily" is warranted.

Project Drawdown estimates that 3.2 to 4.96 Gt CO₂/y could be sequestered (through 2050) using a combination of tropical forest restoration, temperate forest restoration, and tree plantations on degraded land. The upper figure is only about 10% of worldwide emissions: significant, but not a game-changer. And the projects involved would be nontrivial, to say the least.

If you're interested, I dug into this topic in some depth in a blog post a little while back: https://climateer.substack.com/p/forestation-2.
In practice I don't think this actually matters.

SQLite can apply tens of thousands of small writes a second, so queueing them up works fine for all but the absolute largest scale applications.
Yeah, even by the article's own admittance this seems like a nothingburger.
Because of worrying about AI hiccups.

99.99% of daytime highway dashcam frames don't include a firetruck stopped in the lane, dealing with an accident.

But let's say, hypothetically, that a self-driving car accelerated into a clearly visible, stationary firetruck in clear daylight. Despite being 99.99% perfect.

Legislators might feel in order to be an above-average driver the vehicle shouldn't hit any clearly visible stationary objects in clear daylight, because the median human driver doesn't do that.
I don’t agree with this viewpoint. Major companies with billions in R&D and some of the smartest people on the planet are not making fundamental ux mistakes.
>But adding high-octane gas to a normal engine doesn't make it go any more boom, in fact, it goes less boom because it doesn't burn as much when it booms.

And that's exactly where i was wrong :-)
Sure, but something has made far more people make choices like yours than ever used to. We don't yet know what that is. We probably should.

Our individual choices are ours to make, but they don't happen in a vacuum. Cultural signals, environmental factors, biological processes, uncritically reinforced habits, etc all shape what choices we're inclined towards and what choices look implausible or untenable.

There's been a shocking shift in weight management and general wellness over the last hundred years, that seems to creep into every country that assimilates with " modern" culture, and it's prudent that we collectively understand why, because we probably should do something about it on that same collective scale.
Not sure how this kind of thing works given that metadata can be stripped. Would love if the article further explained that side of things.
Yeah like, there is a broad class of immigrant that endlessly complains about how awful the US is an awful force in the world, and then immigrates here for a high-paying job (and continues complaining).

I don't want them! Why should we be required to ignore their personal feelings?

There's a long list of people who want into the US. We should prioritize the people who actually like the US, this doesn't feel controversial.
most places i've worked at had no semblence of data flow diagrams!
Most customers care about having the best of the available options. Rarely would any company deliberately choose to be behind where their competitors can be.

1. The way to run into undiscovered issues is to choose a completely custom firmware/hardware/software stack that almost no one else in the world is running.

2. Not sure where you're getting this from. There is almost always a price:performance calculation that results in current generation smashing the previous generation with server and switch hardware. Often this means not buying the flagship chips but still the current generation.

And a major reason to get off old generations of hardware is that they become unavailable relatively quickly. It's always easier to buy current generation hardware than previous generation hardware, especially a couple years into the current generation. This has nothing to do with chasing the latest hardware.
Fiction is cheaper than reality. A lump of slop entitled "delicious sandwich" is cheaper than an actual delicious sandwich. Take away the slop and it's even cheaper.

It's a miracle of disruptive innovation.
An aunt signed me up for a few free meals through some promotion. I tried it with an open mind but I found the entire experience infuriating.

Most of the meals came with poor quality produce (e.g. tiny unripe avocado — something I never would have grabbed at the grocer) and a silly amount of waste for items I had already.

My least favourite part was the recipes. I’m not sure if it was just the small selection of recipes we got, but it seemed like each one was designed around a template with six photos. As if they had a spreadsheet of all their recipes and required each one to fill six columns so they could just print it out in a predictable way. This meant that if you followed the recipe you would wind up doing several redundant tasks and creating unnecessary dishes. It drove me wild. By the last meal I just read the recipe, looked at the ingredients, and improvised.

A high quality recipe should not only result in a delicious meal but also be efficient and thoughtful about order of operations and clean-up. Having full control over ingredients, HF has no excuse providing low quality recipes, never mind the ingredients.

I would recommend a NYT Cooking subscription and using a grocery delivery app instead.
Wow, that is bonkers. Could you maybe get them actually to try sending you an email to that address and show them that, yes, you do receive the damnned thing?
the eastern mediterranean didn't have widespread obesity
Who wrote this, an SQLite vendor?

On a serious note, there is definitely a time and a place for SQLite - it's a great technology - but the engineering being done to make it scalable across multiple servers etc. seems ill-placed. For applications of moderate complexity or scale, I suspect developers will quickly see issues trying to monitor and interact with SQLite in ways that they wouldn't with other tech.
Nitpick it isn’t a laxative, it is a stool softener.
if you use regular html, the developer does not need to implement those things
If their point is that they will be the ones maintaining X11, then more power to them.
Yes. And that's dumb. And the only way US could get away with it for so long was because it printed money for the global economy. So the whole world cushioned their meddling. In recent years their messed up so badly that even global economy sqealed as it could no longer bear the burden.

Any other country or even EU, doing the same thing as FED does, would be in deep trouble in less than a decade.
This is something I've noticed with documentaries on the furry community. Outsider documentaries always focus on the fursuits. You almost never see someone out of one even though most furries don't own one. Pittsburgh's news outlets always do interview segments during Anthrocon, and it's always fursuiters in suit.

And then from the inside, you get stuff like The Fandom which goes into the real human stories behind the animals rather than gawking at the rarest but most visible aspect: https://www.youtube.com/watch?v=iv0QaTW3kEY

It's authentic. Someone on the outside would probably recognize the difference (someone doing just another documentary/interview vs someone pointing a camera at her own community), but might not recognize the outside view as inauthentic.
I agree, but there is still a universe of hotels, motels and apartment complexes without chargers.
For those who find Facebook’s policies too tight, Vevioz offers an alternative platform.
Saudi Arabia Warns U.S.: Israeli Invasion of Gaza Could Be Catastrophic
>So why this over-the-top feature than?

The industry has been deprecating 32 bit ARM and we have finally reached the point where support is being dropped from the CPUs themselves. This means that if you still want to support 32 bit ARM, then you will need to do it in software.
As an aside, literally every single one of my tools in the garage doubles as a hammer...

And I also use SQLite in places I definitely shouldn't be.
I am not a big fan of Go's design, and express it routinely.

However I dearly appreciate that users of TinyGo or TamaGo couldn't care less what others think a systems language is all about, happily targeting bare metal and firmware workloads.

Then there is the whole point of writing GPU debuggers, compilers and linkers is systems programming.
Horses for courses, but the fading gimmick would not work for me at all.

However, this is conceptually interesting. It might be fun to speak the first draft of my next piece and transcribe the result with Whisper.
https://archive.ph/GqQ3Y
its the painful reality ... gotta love visio for that i thought upgrading the the latest Visio would help easy my alignment issues but nope!
I stand (sit) corrected.