skysight-inc/HackerNews huggingface dataset:
Great job, XTDB's utilization of Apache Arrow for in-memory columnar data structures is highly appreciated. Polars dataframe library in my benchmark is also based on Apache arrow. Thank you for the reference on XTDB benchmark datasets. How can I import `tsv` and/or n-triplets file into v2 XTDB so I can run a couple of queries on WatDiv ? It worth mentioning here that there is a growing interest on extracting subsets of data from large knowledge triplets bases and there are specialized tools for this (e.g. KGTK). I guess v2 XTDB with datalog will make this process a lot easier.

Well, regarding the "one size fits all" database engine, I would rephrase this as "one size fits the most" :-). Your reference about SingleStore (it has a remarkable performance similar to ClickHouse), Rowstore and Columnstore engines in one DBMS, fits the most if not all the cases. But in my opinion, the ideal solution to the DBMS-database challenge resides at the application level and within the realm of database modeling. I would contend that in today's landscape, it's the (V)ariety dimension of big data, that poses the most significant challenge – specifically, the seamless integration of data from various sources. And of course if you manage to lift the heavy load (ETL), as Stonebraker said, you run into the graph/traversal problem.

If you take into account the extensive and continuous development efforts spanning many years, along with the evolving trends in the realm of database query languages, all aimed at enhancing the often troublesome SQL and its numerous alternatives like SPARQL, graph query languages, noSQL, and newSQL, you'll begin to grasp that there is a fundamental issue underlying all of these approaches.

Primarily, it's the lack of a distinct separation between the logical and computational layer and the storage (physical layer). Only recently, this crucial aspect has begun to take center stage in the development of DBMS systems featuring multiple storage engines. Was it Datomic that played a pioneering role in this shift ? The second equally import aspect that it is still heavily underestimated nowadays is the principle of compositionality both at the level of the query language and the data types. Datalog, especially if it is used in a logic programming environment like Clojure, is in the right direction. I will argue, that several Datalog systems, which exclusively adhere to the EAV/RDF data model, lack a crucial element. They are forcing users to create queries and data models through the cumbersome process of breaking down and building n-ary relations from triplets. I believe that the remedy lies in developing robust transformation functions capable of handling input and output across triplets, tabular, or nested data structures.

PS: About Logica: The only columnar DBMS that is supported is BigQuery and it is available as Google proprietary cloud service. As it concerns in-memory processing I could not find any reference on what kind of data structures it uses.
A video about how “Grown in Argentina, Packed in Thailand” actually ends up making sense

https://youtu.be/0aH3ZTTkGAs

The summary is that pears must be picked 1-2 weeks before they are ripe and are allowed to ripen under refrigeration (otherwise the inside ripens first and they get mushy). Instead of running air conditioners, a ship running in cold water provides “free” air conditioning. The biggest market for room-temperature stable fruit in syrup is south east Asia, so packing in Thailand is closest to the biggest customer base. And with the scale they have there, it makes sense to just pack the fruit for the smaller markets like the US at the same place instead of creating secondary supply chains for each market.
> You aren't distributing either of them. When you run code on your server and people interact with it over the network that's not a distribution. If it was a distribution there would be no need for AGPL. GPL would be sufficient.

I think you’re misreading this part of my comment: MongoDB is (or at least, was) AGPL, and AGPL defines network access as distribution. So I would have to justify whether offering my proxy service to network access counts as distributing MongoDB, or if laundering it through a proxy works around this. Remember that in my example, I did modify mongoDB. But I’m not technically offering this modified mongoDB as a service, I’m offering my proxy as a service, and hoping that it doesn’t count as “distribution” of my modified mongoDB. (i.e. I’m not distributing mongo, I’m distributing my proxy, and my proxy is not AGPL.)

> AGPL would protect MongoDB in that scenario because you are allowing remote users to interact with MongoDB over a computer network. That this interaction happens to be taking place through a proxy shouldn't be relevant.

Well, that’s the thought experiment that my example is intended to provoke… it seems obvious that my dumb proxy is a way to work around the AGPL, but what if we tweak the example? What if I make a web UI where you type mongo commands and it gives you the result? (Still pretty obvious, no?) What if I make a simple dumb CRUD app that happens to use MongoDB? (Less obvious…) what if the CRUD app is itself an extremely thin wrapper, and although it doesn’t implement any MongoDB protocols, it leverages built-in mongoDB functionality for 99% of the logic?

The point is, it’s not hard to imagine a legal theory that says “if network access equals distribution, then network access equals a derived/combined work”. It’s the theory that the legal departments of several companies I’ve worked for have taken. And I’d argue that if you have a proprietary product that uses an AGPL service as part of the backend, you have a rather large reason to be worried.
The way to kill open source is by first killing faith in it.
MS: we like "open standards", here is our implementation specific stuff.
Amazon: we don't care what would be with a project. If it is open source - we host it and get money. If it dies - people will use our closed source solutions.
Google: XMPP is soo open, we like XMPP. Oh, now Web is soo open, we like Web (we even have a browser, wondering what would happen once everyone is using one browser).

And now everyone loves open source to train AI. We would see less and less open source projects.
This is very fascinating. Is there somewhere a review of Cyc regarding its abilities compared to other systems?
“None of My AI-Generated Articles Ranked for SEO Keywords”
My grand parents refused to sent my severely autistic aunt to such an institution. In 1960 Germany, a Country without mentally handicapped due to the euthanasia programs a few years before, this decision ruind their lives.

The social pressure to commit your child to such institutions was very strong in addition doctors told them that it would be for the benefit of the child and they were acting selfish.

We need to be careful when passing judgement on those who did listen to why society told them.
Relevant, using ZK SNARKs to authenticate edits without reliance on a central point of trust[1], blockchain in this case would be optional but perhaps appreciated for distributed & decentralized storage and verification of ZK proofs.

[1] https://medium.com/@boneh/using-zk-proofs-to-fight-disinform...
Stop Overusing Lists: Navigating C# Data Structures – By Alex Maher – Aug, 2023
I contacted the moderators and they were happy with the post, sorry if I stepped on any toes, was not my intention
currently there is not build flag to statically link libc manually (it is planned though). Regarding startup time, it all comes to ASDF:

$ time ecl --eval "(quit)"

0.052 secs

$ time ecl --eval "(require 'asdf)" --eval "(quit)"

;;; Loading #P".../lib64/ecl-21.2.1/asdf.fas"

0.301 secs
There are other starting points besides 3D printing, arduino/microcontrollers and spark fun sensors.

If you just need an enclosure for a product there are ready-made ones that you just drill and cut as needed. And for anything to do with sensing or automation look into industrial PLCs (automationdirect.com is the cheap supplier) before you start re-inventing the wheel.
Issue 1: How to Read a Research Paper in Psychology
Show HN: The Cloaca
Command Line Optimizing Assistive Code Agent. A GPT-4 agent; a unified backend-only CLI tool; solves any programming problem from your CLI.
$4 to play a sound on every keystroke, how deep did we sink to not realize the state of software development?
Helion Energy https://en.wikipedia.org/wiki/Helion_Energy :

> They are developing a magneto-inertial fusion technology to produce helium-3 and fusion power via aneutronic fusion, [2][3] which could produce low-cost clean electric energy using a fuel that is derived exclusively from water. [4]

Here's the part of the Real Engineering video where it is explained how 3He and 4He Helium isotopes are fusion byproducts and fuel used to generate electricity with nuclear fusion:
https://www.youtube.com/watch?v=_bDXXWQxK38&t=12m40s

(From "When Will Fusion Energy Light Our Homes?" (2023) https://news.ycombinator.com/item?id=34582798)

Doesn't this new nuclear fusion process also change the valuation of the Tritium in [Fukushima Daiichi,] heavy water? Why would you dump money into the ocean?
Ingraining ‘Nature’ into ‘Human Nature’
The BBC had multiple families living for a year in Iron Age conditions back in the 1970s:

https://en.wikipedia.org/wiki/Living_in_the_Past_(TV_series)

I can just remember watching it as a child.
Aside from the suggestions, sometimes having a third-party processor "visible" is kind of helpful in case your website is not super well-known, because it gives "trustworthiness".

I know it's 2023, but yeah, mistrust in online transactions is still alive.
E Fuel is just a fancy name for super inefficient creation of Diesel.
> I have been using Firefox since version 2.x and I never understood what downsides people find with it.

For some weird reason somes sites just dont open on Firefox on my work computer when I connect to the company VPN on it. Safari and Chrome can open all sites just fine.

I really want to use Firefox especially for the container feature but just cannot figure out why somes sites dont work when I on the vpn.
Django migrations have painful edge cases when you deal with data migrations.
Its probably pretty safe to assume they're just leveraged up
I'm doing what I think is right: spreading the word about the way they operate. I don't want people to be disappointed like I was. Disillusioned by false hope.

Maybe it will generate enough pressure to set them straight. Probably not.
How many flops for a full qcd atomistic simulation of a human in real time?
It doesn't really matter what Mozilla did. They never had the budget to compete with Google on browser advertising anyway.

If you look at the market share progression of the old opera and mozilla vs. internet explorer, and you compare it to the stellar rise of Chrome when it came out, it's really obvious that Chrome's success is due mostly to advertising.
Nuclear fission reactors can and have formed naturally
Show HN: A better way to read blogs
Hey HN, maker here. It was a serious 4-6 months of effort to build this. I have never poured as much love, attention and detail into a project before. So I really appreciate you having a looksie!

The homepage has a fresh list of articles every hour and is open to all. Still, I recommend signing up so you can add stuff to your reading list and follow blogs.

My initial plan was to monetize this with subtle ads, but that didn't work out as the traffic to the site isn't nearly enough for that. That said, I have a fair bit invested in this and I need your help figuring out a way to make this sustainability profitable. If this was yours, what bits would you charge for? Are there any features I could add to a "pro" subscription?

Appreciate any help and support!
It's one of those rhetorical tricks being used to manipulate public opinion, where any criticism of the status quo is branded as "un-American" and "un-patriotic". But in fact it's the other way around, we criticize and are angry because we care about the country and the values it stands for.

The sleight of hand, the sneakiness of how everything gets turned upside-down is impressive though, how quickly a hero becomes a villain, and the villains openly continue with their villainy as if it were heroic.
They explain that in their report:

> CTS has previously written about the phenomenon of “stochastic harassment” on Twitter, or how influential accounts act as nodes for harassment even when not explicitly directing their followers to harass anyone.

> CTS found 60 examples of direct replies to reinstated accounts and 127 examples of threaded replies (i.e., replies to tweets in the same conversation, but not directly replying to the reinstated account’s tweet) that our machine learning classifier assigned high antisemitism scores to during the period we collected data

So, they hate people who aren't actually harassing anyone, nor calling for any harassment, but who get replies that their machine learning classifier thinks are anti-semitic.

This is absurd. They literally call you an anti-semite if you say something mundane and then someone else replies with something that a machine thinks is anti-semitic, at any point in a thread, even if the reply is to someone else entirely. By that standard they deserve to lose any lawsuits heading their way, and lose them badly.

I thought they couldn't make themselves look any worse, but then they presented their examples of "anti-semitic tweets". It's a guy who was involved in conservative politics, who replied to one of the ADLs tweets and criticized them. The ADL post he was replying to was calling Trump an anti-semite. For disagreeing with this he himself is now supposedly an anti-semite.

This is a blatant attempt to shut down criticism of the ADL itself, as an institution. They aren't even trying to hide what they're doing here.

Unfortunately that is all totally standard nowadays. Many groups have complained about this. Left wing activist orgs go after newspapers, TV channels, social networks, all of it. Any organization that isn't explicitly left wing gets attacked like this. They have a goal of making disagreement either outright illegal or impossible via private sector control, hence why they always go after advertisers, payment processors and other "nodes" as they put it. Their goal is very clear by now, it is the obliteration of any and all ideological disagreement.

Am rooting for Musk in this fight.
Thank you for your kind words, very happy to have you as a long-term user of Supernotes!
Good list. I agree with all of them except LOC tracking. What you’re trying to accomplish should instead be handled by having excellent tech leads who can with a bird eye view assess each developers impact. This could be done on a quarterly basis. I know thats kind of subjective but if you can’t trust your leads then the team is kinda already going to have problems.
Why to Prefer `T.Cleanup` to `Defer`
It adds a layer of difficulty for fakery. At the very least, such a signed image is a better "source" of truth than an unsigned jpeg from Telegram. We will enter and perhaps are already in an era where you need to build a habit of verifying photographs that proclaim some form of truth.

> It’s trivial to work around this and create inauthentic signed images by staging a fake scene

I'm not sure what the implication of this is. Reuters is attempting a basic technological solution to a technological problems (images can be duplicated, altered and reshared by non-Reuters parties for malicious purposes).

Someone staging a fake scene is not a technological problem that can be solved (though I imagine some amount of depth information and geo-data in the image would help)
Not specifically what you're asking for but the Esoterica channel and Modern Hermeticist on YT may be of interest to you[0].

[0]https://www.youtube.com/@TheEsotericaChannel

[1]https://www.youtube.com/@TheModernHermeticist/videos

>I think it's weird that some people seem so ready to completely dismiss any interest in these magic systems while also being huge fans of stuff like Harry Potter and other fantasy series.

People dismiss interest in them as realistic and plausible models that actually work in real life (or they're an Abrahamist who believes any representation of the occult, even fictional, invites satanic influence.) People die because they would rather trust alchemy and crystal woo-woo nonsense to cure their cancer more so than chemotherapy. Folklore and fantasy is a different thing, though.
Why not rclone? It was discussed here yesterday as a replacement for sshfs - and supports GCS as well as dozens more backends.

https://rclone.org/

https://news.ycombinator.com/item?id=37390184
Systemd's All Systems Go Conference Returns Next Week
I have a similar issue with hardware accelerated videos in general that drops all my USB connections randomly when stopping or skipping in a video. I think it's a power state change issue with my GPU because it never happens if I have a video game running.
Regardless of what you think about ADL, he is now retweeting white nationalists like Keith Woods.
>upward 200k 8 years ago in medtech

Which UK companies paid 200k 8 years ago?
Fair enough. The configuration I use on my Corne Keyboard, which only has three thumb keys per side, allows for a ton of controls using just those 6 layers. I've found that it's remarkably useful for coding, writing, and manipulating the OS without needing to contort my fingers/hand in any way.
> The crux is that previously any user could modify these certs directly, even on vanilla OS images from Google themselves, without installing any tools at all - just by writing to disk - and that's both widely used and included in the setup guides for lots & lots of tools.

"Just by writing to disk" omits the part where you needed to unlock the bootloader (wiping data), flash a custom recovery, install a superuser implementation and remount /system as writable (or used an overlay do fake it). The only thing that seems to be changing is where and how these certs are stored, so the procedure will be exactly the same apart from the last step, which was never the hard part. By the time you set up a phone for root access, needing one extra app or overlay to add CAs is barely an inconvenience.
> These devices are designed to work for hours with minimal supervision.

I wish. A while back, I put some (food) stuff to dry in the oven on a very low heat, knowing it would take all night to dry fully. After six hours, the oven decided that I must have accidentally left it on by mistake, and switched off automatically, and that stuff was wrecked when I got up in the morning and checked on it.
Correct, collective bargaining is "collective" after all and should be the job of our unions who are failing to negotiate on our behalf.
I mean, all the attestation here does is say this photo came from this person / camera. Like a hardware-backed NFT. The trust ultimately lies with the photographer and, by extension, the org they're working for at the time. I'm not sure how different this is from Reuters just publishing the photo and archiving the link on wayback. Any future versions can choose to use that link as provenance, an eyeball is all that's needed. Complex technobabble won't stop screams of "fake news."
Am I the only one annoyed by those kinds of projects? "I build <something complex> with <hyped technology> (but I actually oversimplyfied a lot of things to make it look easy)"
The exact example you're describing is what the ActivityPub spec and the resulting "Fediverse" are aiming to solve. Mastodon and compatible microblogging platforms are distributed versions of Twitter, Lemmy & Kbin are compatible distributed versions of Reddit/HN style link aggregators.

Given the boost both of these parts of the fediverse have gotten from Twitter/Reddit's series of missteps recently, they're starting to look like they could become viable long-term alternatives.
> This is true; and I find it hard to understand.

Russia actually invading Ukraine full-on was the most irrational and self-destructive thing Putin could've done. By all measures it was and still is a terrible idea. Only if you thought Putin was a madman you could've predicted it but before the invasion that wasn't his reputation at all IMO. I think he was seen as relatively pragmatic and rational (for a thug).
Inflation is much worse in the Eurozone https://www.nasdaq.com/articles/eurozone-inflation-rate:-is-....
Because there's no such thing as a completely free society and those who believe there is or should be would be the first to be taken to the cleaners by unscrupulous or incompetent actors.

The condom comment is absolutely ridiculous because there are loads of regulations regarding condoms from the FDA. Unsurprisingly you aren't allowed to sell condoms that are likely to break.
how so?

i mean, the most esoteric ppl i know aren't even married
One game I really loved as a kid, sim coaster, has a nocd crack floating around, sadly it blocks some needed features further into the game.

And I can't find any non-crack iso to load into the VM. (Can't rip it myself, due to not having a cd drive anymore)
> One could presumably then archive the directory and go DRM-free

Bypassing Steam DRM requires just replacing a single DLL in the game directory. There's even whole full-featured Steam Emulator DLLs that you just drop in and get to play the game for free with working online play over Valve's servers.
Just a heads up but the super resolution example absolutely spams the history API in your browser if you move the map slightly. You could add a bit of delay before trying to save the new location in the URL.
https://www.g4media.ro/crucea-rosie-romana-cumpara-telefoane...

Of course, you can't help the Ukrainians unless you're sporting the latest iphone.
This is sad. She was omnipresent in the web development community, especially during pivotal moments for interoperability. Many of the things we take for granted these days we owe to her, the Web Standards Project, and people like her.
This is pretty cool. Reminds of an experimental sequencer interface I was messing around with a few years back.

https://michaelmior.github.io/rhythm-wheel/
I think it works best when the consumer gets to decide. If a car recall comes along because the seat belts in your car have been shown to actually kill people in accidents, would you blow off your weekend plans to get your car fixed as soon as possible or would you go to your thing then bring the car to the manufacturer on Monday? There will be people on both sides of that decision and, ideally, we should let them choose.
Toyota blames factory shutdown in Japan on ‘insufficient disk space’
Introducing DAYOSS
I am happy to introduce my fintech startup DAYOSS https://www.dayoss.tech/. DAYOSS's objective to make the experience of selecting ETFs and mutual funds personalized and quick. This short blog post explains more https://www.dayoss.tech/blog-posts1/crafting-an-investment-p.... DAYOSS is a big leap over current solutions, who are either complicated and require a lot of time and effort or they are too restrictive and simplistic.

DAYOSS is still in prelaunch and I would love for you all to test it and start a conversation about what we can do better, ideas about marketing, commercialization, partnerships and funding.

Thanks!
Counterpoint: the social contract (or treaty, or whatever term you want to use) protects both sides. It says that people or institutions that could otherwise crush you won't, in return for you following a set of basic rules and conventions. You seem very focused (to use the polite word) on how it's less freedom than you wish for, but it's also more freedom than you might have had otherwise. There's endless room to debate what those rules are or should be, but in general the social order thus created is better for everyone - including you. Cooperation brings benefits, and structured cooperation avoids the losses of endless bickering about the boundaries. The alternative to a social contract is "might is right" and it would be absurd for you to assume you'd be on the winning side of that.