skysight-inc/HackerNews huggingface dataset:
I sure don't use dubious WhatsApp mods, but in general, the advantage of updating through a website rather than through an internal update, is that you're much less likely to receive "customized" updates; it's more likely (though of course not guaranteed) that what's distributed through a website stays always the same, for everyone
"Sandworm" by Andy Greenberg gave me the chills.
> because it goes against the current dogma.

That's not the issue. The issue is that it's reporting results from self-experimentation, which simply from an objective results perspective has many conflicts of interest and accuracy.
It’s a few gens old now.
But my ryzen 9 5950x blew the doors off anything (consumer desktop) intel by an exponential difference
Github should provide a certificate when binaries are built from source with their tools.
This is the first time in a while I've experienced someone else making a design I have been thinking off, have it even somewhere in my ideas list, newspaper but a more "brutalism" design. I love this, great job!
Maybe it will run on modern Macs once again :)
All of it. With a checksums-of-checksums scheme like a Merkele tree, you can effectively and efficiently checksum all the data and keep incremental changes cheap. You only need to update the checksums of the data blocks you touched and their ancestor nodes in the tree.
Overall I agree with this. For dumping just the schema definitions, I'm not that happy with it. My primary use-case for a schema dump is to run it after applying migrations in dev/ci, so that if two engineers each open their own branch with incompatible schema migrations, someone gets a git conflict.

In this situation, pg_dump is really annoying because it will give you a schema-only dump, but that dump is not "stable". In the sense that

- dump the schema
- create a new database from the schema
- dump the schema again

often gives you two different files in the two different schema dumps, due to minor re-ordering of tables/statements.

The other use case I rely on is just having a single place where the schema is defined is actually super helpful for debugging, and can be an entrypoint for other tools. Sometimes it's nicer to be able to open that up in your editor rather than have to explore through `psql` or read through many smaller migration files.

Because pg_dump does not generate a stable dump (same schema == same file contents), you're constantly getting noise or irrelevant changes to the file, which makes it essentially unusable or at least very annoying if you keep that file committed.

> Now, I expect that somebody is going to point out that pg_dump does not solve the dependency problem 100% reliably in all cases. And that's correct. However, I think that complaint just shows how spoiled PostgreSQL users are. Recreating a complex database schema without a dependency-aware tool like pg_dump is an absolute nightmare.

If you're interested in a tool that is dependency-aware, AND allows you to explicitly specify dependencies for the cases that pg_dump doesn't handle (primarily between functions and other objects, iirc), check out my cli tool pgmigrate [0]. You don't need to use it to manage your migrations, you can just use the `dump` subcommand. It's a little under-documented, and it's missing some obvious improvements (can't handle multiple postgres schemas (namespaces) right now, only lets you dump one at a time), but I've been relying on it and using it with pleasure.

[0]: https://github.com/peterldowns/pgmigrate
Which apps use it?
> I remember reading somewhere that heart transplant recipients have random memory flashes that are not their memories, and sometimes they develop new personality traits.

Wild. Doesn't necessarily surprise me too much that the body stores some memories outside the brain, but it seems _very_ surprising that another body/brain can read and understand ones created by another. I'd assume that the whole mind and memory system is one big correlated mess, not essentially composed of data files in a ~standard encoding.
I'm doing this with clickhouse querying parquet files on S3 from an EC2 instance in the same region as the S3 bucket (yes DuckDB pretty similar). S3 time to first byte within AWS is 50ms and I get close to saturating an big EC2 instance's 100Gb link doing reads. For OLTP type queries fetching under 1 MB you'll see ~4 round trips + transfer time of compressed data so 150-200 ms latency.
"Most databases (except a few) assume that the OS, filesystem, and disk are sound."

The Oracle "dbv" utility will verify all checksums by file that compose a table space. This includes the free XE edition.
There are ways that this would not happen. There are ways to not have cars and cyclists on the same level as each other for example, then you don't have to worry about that. Or just kick all the cars off the street.
We definitely do things wrong in this world.
It's not hope. It's knowledge.

In a few decades or even maybe a century, your loan to the dog walker will be denominated in bitcoin.
ClickHouse uses and validates checksums for both compressed blocks of data and uncompressed data; it also checksums and validates data during network transfers. Additionally, every replica validates checksums with other replicas when doing deterministic computations.

It is the only reasonable way to work with data, and if someone thinks otherwise, I will happily provide motivating examples.
ScummVM adds support for Castle Master (1990)
It doesn’t matter who anyone believes the burden falls on… that’s my point.

Edit: If there’s no desire to write anything, there’s no force chaining your hands to the keyboard… and even if there was, no other user is obligated to do this or that.
Lose weight while floating sedately...sounds good to me
You and I have a fundamentally different view about how to optimize education. Your view is probably great to cover the base case of people “checking out” of their children’s education, but my individualized view doesn’t care about the 90% but the child in front of me.

I’d also posit that this approach to education reduces overall attainment by dulling the edge of what the margin is capable of.
SQLite is a (maybe unexpectedly) powerful database. I would not be surprised at all if it’s used for financial data in at least some capacity.

I’m also not sure every “proper” database has application layer checksums, as that seems like a lower layer concern costing performance and possibly providing a false sense of security (it can’t help with durability at all, for example).
Optimal glass shape for preserving chill in beer glasses
SQLite is not a single connection database
The most commonly used filesystems on Linux, etx4 and XFS don't do checksums.
The underlying reasons have to actually be written out though in the first place and viewable on a screen… I’m not a telepath, nor likely is anyone else.

And after all that has been demonstrated, along with some other necessary features such as logical consistency and so on, then it’s definitely more than an opinon.
NHTSA: Tesla's social media posts falsely implied that its cars are robotaxis
This is the epitome of self-reliance and kickassery. Respect.
GPT has some self understanding. On asking why it uses that name, it at least gave the type of qualities correctly.

> It sounds like you're referring to a story or narrative that I've generated or discussed involving a character named Aldric. If this is the case, Aldric would likely be used as a character who embodies leadership, wisdom, or noble traits due to the name's meaning and historical connotations. Characters named Aldric might be portrayed as experienced leaders, wise sages, or key figures in a fantasy or historical context.
You'd know exactly how it was going to happen if you could review every line of code, every comment, and every bit (byte) of data involved, and make sure it was meaningful.

So you could precisely pinpoint the exact data path that would carry out such a deed, and how it got that way. And be able to follow the trail of bits throughout the entire chain-of-command and arrive at the root cause quite logically.

Oh wait a minute . . . I was thinking about an accidental killing, my bad.

For a deliberate killing you don't need any of that.
The problem with btrfs is that is does not work well with databases without careful adjustment.

https://archive.ph/dqFgh
Yes, we've all become so emotionally invested in the idea of the inevitability of technological progress that we've blinded ourselves to the fact that much of what we experience is a technological regression buried under layers of gleaming chrome. Just because something takes a lot more effort to achieve doesn't inherently mean that it represents progress.
Time to add to the resume: improved Linux kernel performance by 3888%
This is bullshit, especally since she also got "traditional" therapy after. This is just a statement by someone that is desperately looking for a negative point. You have to have access to equipment and skills that not many people have. And then if they have it, that's one more thing to try, the effects are quick if it works and you can revert to radio/chemo therapy if needed.
> The worst use case for SQLite that I've seen in production was a shop using it with some minimal UI on top as an order tracking system. Even in that case, the orders were accepted on paper, they just used the SQLite db as a way to track material usage so they knew what to order from the suppliers.

This doesn't seem particularly egregious.
Same for me.
I don't know, delta seems more like a chaos I can't make sense of than default git diffs
If you're interested in trying out `pgmigrate dump`, consider going through the quickstart example --- it should give you a decent starting point https://github.com/peterldowns/pgmigrate/tree/main/example
Support in rsync seems to be lacking, unfortunately: https://github.com/RsyncProject/rsync/issues/499
Why?

SQLite has a very well defined and documented set of abstractions about what can and can’t go wrong on the layers of abstraction it relies on. “Out of two writes, at least one will be successful” is not part of that, and doesn’t make sense to me.

Second-guessing the storage layer like that will never be able to catch all problems with it (e.g. drives or file systems lying about the durability of write commands).
Which part? Every part is truthful.
This is an old favourite of mine on the Amiga.

It was mind-blowing at the time.
Incorrect - the term inflation is rooted in the inflation of a money supply, which leads to devaluation of the monetary unit and therefore a rise in prices.

Bitcoin is deflationary as at some point in the future the total supply will decrease each year (through people dying with their money etc.)
Therefore…? Is there some other point your trying to prove?
> What Haskell allows you to do in practice is defining required and missing control flows

It allows that in theory, at least, certainly. That's the whole reason for its existence. But in practice, developers become enamoured with the language and start to forget about the problem. If that weren't a problem we'd all be using Haskell, but back in the real world.
> People would just create an addon or find a way for uBlock or userScripts or greasemonkey to check the box.

Again, that's a lot of effort for people who won't even make the effort to read the article.

To be clear, checking the checkbox would not be required to add a comment. The checkbox is entirely optional.

> The only way to know someone read and understood the article

I'm not even expecting understanding. I can deal with people who misunderstand something they've read. Many issues debated here are complex. What's not helpful is for someone to just read the headline and then start spouting off about whatever comes to the top of their head, without reading anything.
> which is why VCs swept in to try to corrupt open source into a twisted product lead growth strategy

I wouldn't call it 'corrupt', but rather a by-design "feature" of open-source: https://www.gnu.org/philosophy/open-source-misses-the-point....

> I just get bristly at anyone who claims maintainers wanting to focus on their passions are "profit-driven"

The person you replied to never said that.
I'm having a hard time matching these with some of the 3D things I've done before. As in, little vendiagram overlap.

What I'm used to, using hardware APIs, or software rendering:
- Nodes
- Edges
- Triangles
- Meshes
- Shaders
- Matrices
- Quaternions (Or bivectors etc)
- Projection (3d state to 2d screen)

I suppose I'm confused because the basics don't seem cosmic. It's a straightforward application of considering the state you need to store your 3D model in, then some linear algebra and quaternion operations to convert that 3d state to a 2d screen.

For quality level seen in media, it's different; all the additional techniques that make things realistic or have effects that get complicated. I suspect this is where the disconnect lies; if so, I suppose my point is that it's not 3D that's complicated; it's realistic 3D.

edit: I Looked up Gaussian Splats: Very cool!
Writing a slow incomplete impl of something is 0.1% of the progress of building an actual one that you would use in production.
Unfortunately, I don't feel confident humanity has the ability not to destroy the environment that sustains our life. We are simply too selfish, unable to adjust our thinking to new information sufficiently, lack compassion for others, and/or just don't care about things that don't affect us directly.
there's an interesting trauma release meditation where your limbs are asked to remember things. It's pretty interesting what comes up, then you're asked to let it go and when you do, some weird extra deep relaxation sets in
I tried one for a while and it just made me sore. It forced me to think of what I would probably actually benefit from both physically and psychologically.

My preference would be a mini-office or POD that has user-definable LED lights brightness, 2200K to 6000K color, fully sound-proof, a surround sound system, a studio microphone and camera for conference calls, a variable speed/friction treadmill or bicycle, OR a standing foot massage that can vibrate and use ultrasonic emission for the entire body or a back and leg massage with IR heat, a HEPA and activated charcoal air filter to I do not have to smell my coworkers. The enclosure should double as a safe-room rated a body armor level 8 from UL 752: 7.62 FMJ 3025 FPS. Level 10 for government offices. Between the sound proofing and armor I should be able to focus on my tasks even if the building is being raided. There should be an optional monitor that alerts me if my posture or exercise levels are sub-optimal.

Cue the Ooompa Loompa song
Worse still "this change has been shown to regress some workloads significantly".
It would be nice if these hobs had both temperature and intensity settings. That way it would turn up automatically in the situation you describe.
MySQL does it by default (or at least InnoDB does).
Above a certain company size however I think what he’s describing is not avoidable. In a less than 0.5k person company you’ve very close to the company. In a > 10k person company there’s no way: there’s a lot of layers to the company and often can’t “touch” the customer as an employee. The nature of the job is mediating how the layers interact: you can’t reduce that complexity out of it.
5-10% gains are not massive gains. They're small gains that look massive because so many districts are evenly balanced.

Ask the Tories in the UK what massive gains look like.
Wonderful project. Built video games and music visualizers that I never thought were possible on web.
It would be hasty to assume that any memories would be transferable in such a way. If your hypothesis is that transplant recipients can have their memories altered by interpreting information carried by foreign organ cells, start by assuming they're reading junk data that they cannot decipher. Brains are great at turning junk data into something that feels real.
My money is on automated AA systems near some inland border where commercial flights just so happen to never go nabbing a crop duster, surveying aircraft or SAR/med chopper because some comedy of errors resulted in the device getting put on way too hair trigger of a setting.
Sqlite is the wrong layer at which to care about storage hardware failures. That would be the job of the disks themselves, the hardware or software volume manager, or filesystem.
Money not being the goal is the norm for these good projects, I hope one day to find out for my favorite project money is actually the end goal, that'll be fresh.
The first step in the growth of any medium of exchange is to prove itself as a stable store of value. Otherwise it can't be used as a unit of account. And the first step in proving itself a stable store of value, is to begin storing value which is where bitcoin is at right now.
I don't have any problem with the Kurds selling their oil to finance their fight against Assad. He's a murderous tyrant and if it weren't for Turkey's objections Kurdistan would already be an independent state.

As for "well-known facts" on the Syrian street, it's a "well-known fact" among Americans that their economy is trapped a disastrous inflationary spiral, it just happens not be a true fact.
Well, sqlite is certified for avionics via do-178b.

What interesting things could it do in an aircraft?
https://pubmed.ncbi.nlm.nih.gov/38694651/
Good idea.

> Case is important in the header signature, there can be no whitespace or other characters in the file before the 'S',

Much as I dislike BOM... maybe a BOM could be permitted with “a run of Unicode whitespace is permitted before the `S`”.

> The hex value in the signature happens to be the MD5 hash of the string ".IsCacheDirectory". This signature header is required to avoid the chance of an unrelated file named CACHEDIR.TAG being mistakenly interpreted as a cache directory tag by data management utilities, and (for example) causing valuable data not to be backed up.

Nice use of a “magic string” for the format. But (for extra magic) could have just picked a UUID. Just any random one.
As an aside I’ve yet to come across anything more technically complete than ClearType. Bitmaps/Textures done via some janky early-2000 NeHe tutorial inspired thing aren’t even on the table. Yeah people will hate on Microsoft and Windows and bicker and whatever, I don’t care because of all the shit I’ve dealt with trying to use freetype and additional libraries, ClearType has never let me down. I’ve used D2D with D3D in conjunction with shared surfaces and other hacks to join the two, and it’s pleasant enough that the final product is well worth the programming agony.
Sorry but bit errors happen all the time at scale, and most commonly in controllers. SQLite is used in so many environments for its robustness rather than actually for SQL. Seems odd to argue agsinst it actually

Drives, controllers, and file systems lying about write durability is another great reason to add more robustness, good point
I think you’re starting to conflate emotion with senses.

Yes pain is a form of sensory experience, but it also has affective/emotional components that can be experienced even without the presence of noxious stimuli.

However, there are people that don’t experience pain (congenital insensitivity to pain), which is caused by mutations in the NaV1.7 channel, or in one or more of the thermo/chemo/mechanotransducers that encode noxious stimuli into neural activity.

And obviously, these people who don’t experience the sensory discriminative components of pain are still capable of cognition.

To steelman your argument, I do agree that lacking all but one of what I would call the sufficient senses for cognition would dramatically slow down the rate of cognitive development. But I don’t think they would prohibit it.
BB(5) is known to be 47,176,870, or 10110011111101110010100110 in base 2.

https://wiki.bbchallenge.org/wiki/BB(5)
> I’m not requesting anyone to reply to me nor prove anything to me

I mean... everyone can see that this claim is false. Earlier:

> So can you actually write the argument here?

> That supposedly proves it’s impossible for A to have affected B… even with 6 degrees of seperation…

That was a request for a reply and a proof.

Of course nobody has to accede to your request, but it's undeniable that you made a request.
> That's wildly incompatible with my experience there in the previous decade

Yes, there have been some very signficant changes over the last few years. Promos are decided in-org. Managers play a much more important role. There are promo quotas along with associated pressures (felt more acutely in some orgs compared to others).

But, putting that asides, a manager who doesn't have any idea of what or how their reports are doing is clearly failing at their job under any of those systems.
As someone who's just watched from the sidelines, I found the article and papers really interesting. I found the iterative alpha blending/de-blending to be better explained in the paper though.

Took me back to my path tracing days, with things like importance sampling[1] and Metropolis-Hastings[2].

[1]: https://en.wikipedia.org/wiki/Importance_sampling

[2]: https://en.wikipedia.org/wiki/Metropolis%E2%80%93Hastings_al...
Scientists are working on it. They're not done turning this approach into a generic, off the shelf treatment, though. As the article states, this isn't necessarily new technology.

Having access to a lab and being an expert in the subset of virilogy used as part of the treatment definitely made it easier for this specific scientist to get her hands on this treatment. For someone else to get the same, they'd need to hire scientists dedicated to curing them, and that just doesn't scale to the amount of cancer patients in any normal hospital. Even then it didn't entirely cure her; the tumors were reduced in size but normal cancer treatment took care of the rest.

Give it a few years, maybe decades. A lot of research is being done in this area of medicine and I can't imagine such biotechnology not becoming more widespread in the future.
My Go driver adds support for this by default, and I provide a simple API to enable it.

I'm of the opinion that the VFS shim should ship by default, certainly on the CLI, because it still needs to be enabled for each DB, and all it takes is one instance that doesn't know about checksums to modify a checksummed DB for it to appear corrupt.

https://github.com/ncruces/go-sqlite3/tree/main/vfs#checksum...

Weirdly, databases created with the macOS version of the sqlite3 CLI reserve 12 bytes, for some reason, so you can't ever enable checksums on those DBs.
If you really want to do that, both zfs and btrfs can do it at the filesystem layer.
Ask HN: What is your one-person-SaaS project?
I guess that depends on how this whole thing plays out over the long run.
Why it's so hard for parents to let their kid quit
Why gossiping at work is good for you
ask where?
Application level checksums aren't for when the hard drive fails -- the OS will catch that, as every single operating system is already assuring hard drive blocks.

Application level checksums are for memory, driver, subsystem faults. And many enterprise database systems still do it by default, regardless of how redundant it might seem. Even though your NAS, file system, OS, and even the individual drives are computing it too, systems like SQL Server, Oracle, DB2 and others default to calculating and verifying checksums on all pages.