skysight-inc/HackerNews huggingface dataset:
It is possible to construct a worst case scenario for bytecode execution, for example very complex expressions in the WHERE and/or SELECT clauses that compute values, and a query plan that performs a full table scan over a table with say 100 million rows that is cached in RAM (or maybe use generate_series, whatever works best).

Computing the expressions should dominate execution time, right?

Then, to compare against the best possible case, we can write a custom C program that uses sqlite internals to perform the same task (full scan of the table, extract values from row) and does not use the bytecode VM and computes the complex expressions in regular C code (e.g. a function that accepts floats and returns a float or whatever).

Then comparing the two implementations will tell us how much faster sqlite can be if it had a "perfect" JIT.
I started with Jekyll's default, Minima[1], to get something working right away. But then i tweaked lots of stuff, copying things i liked from other blogs[2], so it no longer resembles that default look.

[1]: https://jekyll.github.io/minima/
[2]: the sidenotes are stolen from Tufte CSS: https://edwardtufte.github.io/tufte-css/
While publishing the data, he also published part of his home folder (containing his personal files). Although he cancelled the torrent before anyone could download the full version, the partial torrent could still have data extracted

https://krebsonsecurity.com/2023/11/alleged-extortioner-of-p...
I've always found it remarkable that the evil doers of Comcast will say that they can't provide faster Internet to a certain area, until competition appears. Then, as if by magic, they can offer faster speeds.
I'm not sure it can replace non-trivial setups - sudo/doas looks set to stay.

e.g when you need to restrict a set of users to run only certain applications with certain other users. sudo can do this (even if the config format can be painful).
No, I meant to ask HN, but didn’t realise that if I put a URL it doesn’t start a discussion.. and now there is no delete button
Go to https://react.dev/?uwu=true for a surprise.
uwu=false to turn off.
Did you try increase the information a bit, like: can you give me more information about the GitHub project xxx written in xxx?
All compiler outputs are understandable. I suppose you mean with the intent of it being a one-time translation? As in, like when the Go project converted the original C codebase into Go source with the intent of having developers work in the Go output afterwards and the C code to be never touched again?

What is meaningful about such a distinction?
what else is systemd going to eat :/
I suspect a relatively large number of people on HN will read the headline that way.

My initial reaction was “oh that’s seriously cool. I wonder what TCP/IP stack they’re using and if they got CSS working or just HTML”
The website does not even explain what Arc Browser does.
Copyright is ownership of information, data. All information is bits. All bits are numbers in base 2. Therefore copyright is ownership of numbers.

You can even figure out how big the number is.

digits = ceil(bits * log10(2))

For example, a 20 kiB picture is just a number with 49,321 decimal digits.

All numbers already exist. All intellectual work is just number discovery. Drawing? Music production? Editing source code? Fancy ways to enter numbers into computers.

This comment is a number.
Show HN: We made Trellis – a way to run SQL query on your unstructured data
Hey HN — We're excited to share Trellis — a snowflake for unstructured data.

We've built an AI engine that turns unstructured data into structured SQL-format based on the schema you define in natural language.

We spent a lot of time building ML infrastructure and realized that most data warehouses and data pipelines are not designed for unstructured data (documents, PDFs, calls).

While something like a Vector database and RAG are great at search tasks, they really struggle with aggregation and SQL type queries such as

1. How many emails in the past 6 months contain complaints about the product?
2. What are the top 3 features from feature request tickets?

Check out the sandbox (no sign-in required) at https://demo.runtrellis.com/

Some interesting results from analyzing Enron email can be found at https://demo.runtrellis.com/showcase/enron-email-analysis

You can also run the transformation on a larger amount of data

*by signing up here* https://dashboard.runtrellis.com/

We would love to hear your feedback and the different use cases that you come up with.
Maybe we need to approach this a different way to get through to you.

What is the advantage of asking, "Hi, are you free?" over asking, "Hi, are you free to talk for X number of minutes about Y?" Can you think of a single advantage?
Until systemd consumes the kernel and then it will be GNU/systemd
The only argument I’ll present for giving over CSV to those who want to flail at the idea of standardizing it: the name implies too much standardization already. Why “C”SV? Most CSV processing tools accept a delineator, right? They are just whatever separated values, use semicolons or tabs if you want.
I seriously thought they had ported some novel browser engine to Win16, but even that, Windows 1.0, which IIRC didn't even have overlapping windows, would be ridiculous.

And apparently it's based on Chromium. Porting a brand-new browser engine to long-obsolete Windows is probably plausible. Porting Chromium, a very large beast with a lot of baggage, is much less likely.
Our knowledge and ignorance are both astounding. But there's definitely more we don't know than that we know.
Show HN: LLM-powered NPCs running on your hardware
Hey HN,

My team is open-sourcing the inference stack and fined-tuned models we use to create LLM-powered NPCs:
https://github.com/GigaxGames/gigax

The generative agents paper [1] pioneered the idea of prompting LLMs to create autonomous NPCs. But existing implementations require multiple calls to an LLM to make the agent plan its day, chat with people, and interact with its environment [2].

Our approach allows NPCs to be stepped at runtime with a single pass on consumer-grade hardware, with reasonable latency.

To achieve this, we've fine-tuned open-source LLMs [3] to parse a text description of a 3d scene, and respond with custom actions like `greet <someone>`, `grab <item>`, or `say <utterance>`.
This simple whitespace-separated « function calling » format is less verbose than json and thus helps with inference speed. We're also using the Outlines library [4] to force the model to adhere to this format.

We're launching an API and we're looking for partnerships with studios to integrate our tech into upcoming games. Would love to connect if this is of any interest to you!

Thanks in advance for your feedback :)

[1] https://arxiv.org/abs/2304.03442
[2] https://github.com/joonspk-research/generative_agents/tree/m...
[3] https://huggingface.co/Gigax (phi-3 fine-tune)
[4] https://github.com/outlines-dev/outlines/tree/main
Maybe after the fact.

Running arbitrary code inside a financial transactions system isn’t the most obvious decision.
Indeed. I have been using Ubuntu 14.04 under ESM for the last 10 years. But that ESM support is ending in 2024. I've tried modern distros using modern Gtk3 and they're lousy with file chooser bugs. I've tried patching Gtk3 gtkfilechooserwidget.c myself but I can only fix it for the first file->open dialog, not subsequent ones. Attempts to get help in #Gtk over the last 5 years have been rebuffed in IRC and ignored/closed repeatedly on the issue trackers: https://gitlab.gnome.org/GNOME/gtk/-/issues/5872
You're probably right, but looking at Germany and most of the region around it, it's clear that a lot of different "tribes" lived in overlapping areas before and after the Roman Empire, at different times... there were the Goths, Vandals, Gauls, Celtics, Suebis, Franks, Synthians, Vikings, "Greeks" (or Helenics), the Rus, Tatars, lots of Slavic tribes that seem to have arrived in Eastern Europe out of "nowhere"... if you include the Iberic Peninsula, Arab peoples dominated for several hundred years, then "disappeared" again in the 15-16th centuries.

Most of these completely disappeared (though they obviously left genetic material in the local populations, their culture/language was entirely replaced and mostly forgotten)!

Take the Vandals... they seem to have originated in Poland, migrated south pushed by the Mongol raids and later the Goths (themselves coming from Northern Germany or even Scandinavia), ended up in the Iberian Peninsula, then somehow moved even further to Northern Africa... They got their reputation which lives on today (in the word vandalism in case you didn't know) by sacking Rome when the Western Roman Empire had already lost most of its glory, coming from Northern Africa and a few Mediterranean islands, the most import of which was probably Sicily.

More recently, the Lithuanian people lost almost all of their territory when the Grand Duchy of Lithuania disappeared (it was subdued by the arch-rivals Russia, Sweden which at the time was nosing around in the area, occupying places like today's Estonia, and the Austrians)... Lithuania only became a country again, and a tiny one at that, after the USSR collapsed, something like 300 years later.

In the last couple of centuries the history is even more complex!! We don't notice in a lifetime but the map keeps changing and the previous century was no exception. Where are Yougoslavia and Checkoslovakia now? :D ... did you know that Kyiv changed countries dozens of times over its history? It was capital of the Rus, invaded by the Mongols, incorporated by the Grand Duchy of Lithuania, then Poland, the Russian Empire, then it really went crazy and switched back-forth between the earlier "rulers" and short-lived Ukrainian states multiple times (like 10 times, seriously), was captured by the German army not once, but twice (in WWI and WWII), before kind of stabilizing as part of the USSR, and then finally, a proper Ukrainian state.

I was in the area some time ago and it was mind blowing to learn all that.
'If everyone around me looks like me, sounds like me, and generally thinks like me I am not learning or growing.'

Two people can be of the same race and sex but still have very different points of view and skill sets.
It was cannibalizing a cheaper iPod for a more expensive iPhone. iPad would be taking from the more expensive MacBook market.
> You might want static linking

Personally, I really want to go the other way around, with microkernel-like userspace services. That way everybody can drop the pretense that the software author did any verification on his dependencies, and we can add real access controls to the ABI.

But yeah, the current situation is close to the worst possible one. It would improve if we change things on any direction at all.
The Chinese have more honor students than the us has students. I’m sure they can figure it out… it’s not easy sure but given the enormous amount of resources at their disposal it’s certainly possible
> “What’s Windows 1.0?”

It's a desktop environment for DOS that was released in 1985 :)
I care about dash because when I write for it, I write for them all.

The speed and economy of size are a side effect.
This alone is the entire reason I started working on pyinfra, loops in YAML is just evil.
Folks have suggested web-of-trust systems. I don't know how they would be implemented - for now, I guess this is already sort of a thing on any platform where users can "repost"/"retweet" things.
Congratulations for your first comment!

What I want to do is represent my tree-structure as a table in a relational database and then be able to efficiently get the tree structure back by transforming the table-representation back into a tree.

Further I would like to do that in plain standard SQL. This must be a common problem, any documented solutions out there?
They bloat webpages, take time from what you're actually looking for, and are a huge vector for malware delivery & social engineering. They literally take away from the programming you're watching if it's television, sometimes are even detrimental to the product that consuming.
We think about the Retool case a lot. User-defined database connectors were an initial inspiration to start building Riza.
Edison is just as much vaporware as any other of the small EV manufacturers. They built a single prototype. They haven't even begun to really deal with supply chain, labor, or service yet.
I live in a terminal, I do my work there, and I absolutely love everything about terminals!
But I've never found a simple habit tracker that captures the essence of tmux, matrix, and how 'top' displays CPU usage and other stats – you know, that Linux-vibe!

So, I created habitcracker.cc. It lets you add as many trackers as you want and adjust how they fit on your screen using grid columns (in "Settings").

Everything is stored locally in your browser; no APIs involved.

Please share your advice and suggestions on what else I can add to make it more user-friendly for everyone!

Give an upvote on ProductHunt if it's helpful for you https://www.producthunt.com/posts/habitcracker

Cheers!
> Musk needs to come back to earth.

The man doesn't even know where earth IS anymore.
Or they could be hundreds of priests of a mainstream religion congregation, and be protected by several Popes...
You can almost feel bad for VCs who think that their little startups will compete in the productivity space.

Amazon, Microsoft and Apple remove all enterprise barriers to entry, no startup can even remotely compete with this. They can take your ideas and implement them far faster than previously possible, why use some ambiguous startup when you can just wait a year for the Google integrated solution.

Combine that with Google and Apple's hardware dominance, companies like Rabbit and Humane are toast. They will make an app or hardware that out competes in a year. "Teenage Engineering" is cool and all, but a vibrant orange body isn't going to compete with a vertically integrated organization with true AI resources.
Does it matter? Whether it's instantaneous or happens over the course of hours, that type of communication contributes nothing to anything.
HN discussion [0] (91 points, 6 days ago, 37 comments), there's also a counter article European court favors strong encryption, calling it key to privacy rights [1] (266 points, 2 months ago, 22 comments)

[0]: https://news.ycombinator.com/item?id=40137783 [1]: https://news.ycombinator.com/item?id=39609846
An alternative (not by sawaratsuki): https://github.com/Aikoyori/ProgrammingVTuberLogos/blob/eafa...
I don’t understand this. Can you give me some pointers so I can research it myself?
I think it's rotating, but doesn't have a secondary camera as described above. Maybe he spent more than $500, but I tend to doubt it, but I'm also not sure of the specifics beyond he's using a crop-frame Nikon DSLR with a lens he already had for birding (I think).
I’ve seen tracking apps that prompt the user to enable a vpn on iOS so all their traffic is routed through them (this was not a vpn app, this was a user tracking app - not malicious. Now imagine a malicious one that doesn’t go through App Store review). The vpn thing on iOS is concerning. The user may not even know or remember they allowed it and it could just be sitting on their phone indefinitely.

I’d like it if Apple restricted VPN access for only App Store approved apps.

Again, it’s not you who I’m concerned about. It’s everyone else. It’s not hard, watch:

here you go dumb teenager, download this crypto app and hit accept on everything and get mining this new alt coin

Boom, vpn enabled and traffic intercepted.
So are automobiles and 120V AC current, but we use both because they are convenient.
I don't think that "hallucination problem" is a problem at all worth addressing separately from just building bigger/better models that do the same thing. Because 1) it is present in humans, 2) it is clear bigger models have less of it than smaller models. If at scale nothing changes LLMs will eventually just hallucinate less than humans.
According to the "15-Year Club" badge in my profile, I've been on Reddit for, well, 15 years.

It's gone from that weird little Digg clone with a tiny comment section (the good convo was on Slashdot #onionbelt) to a meme site and eventually (with the addition of subreddits) a genuine information repository.

The Blackout in 2023 hit the site in a bad way. Most of the tech subreddits I followed have sice dispersed to various Lemmy instances and fizzled out.
Tech convinced itself that a disruption is something positive no matter what.
Great! Something I've always wanted.

I'd love to be able to use a bit more type-y Go such as Borgo, and have a Pythonesque dynamic scripting language that latches onto it effortlessly.

Dynamic typing is great for exploratory work, whether that's ML research or developing new features for a web app. But it would be great to be able to morph it over time into a more specified strongly typed language without having to refactor loads of stuff.

Like building out of clay and firing the parts you are happy with.

Could even have a three step - Python-esque -> Go/Java-esque -> Rust/C++esque.
It doesnt need to become sentient to cause great disruption.

1. Bot swarms will simply disrupt everything about the Internet as we know it. Most people ALREADY barely scritinize chats and articles, so bots can EASILY produce those at scale to push opinion in any direction, or just sell shyt

2. Botswarms will outplay adversarrial games vs humans for karma / reputation points, as well as launch coordinated attacks on opponents organically trying to stop whatever viewpoint is being gradually pushed or sold, until they give up or are totally reputationally discredited

3. People start to PREFER bots to humans, just as they PREFER google maps to asking for directions etc. At that point most humans would be surrounded by 100-1000 bots and have no way of affecting other humans.

4. Physical world, cameras capturing all the info and cross correlating where you are. Maybe slaughterbots are mass-produced. Who knows.

When the costs come down and scale goes up, it doesnt matter about AGI, the entire society is disrupted permanently. And that’s what AI is on track to so. It’s far easier to continually create a mess than to continually clean it up.
I'd argue that profit margins are more to blame here.
Agreed. I use pydantic daily and I'm in the position to try this out... but why? It really seems to be a weird divergence from their core product.
I would think a lot of patents related to battery tech and the charging infrastructure.
Or it consumes every other part of the GNU runtime and it becomes systemd/linux
> the only informational resource on the web that's still unscathed is Wikipedia

Wikipedia is great as long as the topic isn’t politically controversial. In those cases you get the US State Dept/corporate media-approved perspectives with all the censored perspectives available in the Talk page.
I moderated one subreddit that was loved by users. It wasn't about anything that is illegal or controversial. The controversy came not from the content, but from how we were running the community -- we were breaking a reddit rule that was in place to prevent spam. I understand why they had that rule and I agree that it probably makes sense for most subreddits, but like any blanket rule: it doesn't perfectly fit every scenario. So, we had our own method of preventing spam and it worked.

The admins didn't care that we had a thriving community, no spam, and they banned the subreddit. They also blocked anyone from ever creating a replacement with the same name (still to this day). So, it definitely does happen. I'm keeping it vague here to maintain my anonymity.

Side note, reddit dropped that rule about 2 years ago so I suppose we could start one up again, but I've lost interest in that topic.
The Code whisper app got auto updated to this new Q app on my mac without any user interaction. I would call this a not nice move from Amazon.
The main site does.

https://arc.net/
I don't understand the point of creating an entirely new shell inheriting almost nothing. Seems like that would cause a lot of issues (i.e., sudo make install)
No, that is a reasonable way to ask for help.

What would be "selfish communication" would be to walk up to a group of people working at desks and just say, "Hello," and stand there awkwardly waiting for them to acknowledge you.

Same thing with a group chat. Asking, "Is anyone free to help me with X?" is a reasonable way to ask for help. Sending a whole group of people, "Hello," is a waste of everyone's time.
Well this was an unwelcome attack vector, since I wrangle a fair few S3 buckets. I hastily threw together an S3 bucket name generator in Bash under Linux [1] to create names that follow the AWS rules to start my migration to my new S3 bucket names, and welcome any help to ensure it creates names that are strongly resistant to this attack, and follow various S3-service-like vendor rules, so I can do what I can until AWS and others come out with a stronger defense.

[1] https://github.com/automaticit-anthonyyen1/s3-bucket-name-ge...
Why don't we talk about minifying CSS anymore?
Sorry to hear that. You have my sympathies.
I strongly recommend people give this a try. Its got so many quality of life features (like picture in picture).
Without looking at the he specific implementation

There should be a service running as uid=0 that exposes an unprivileged API.

This service then takes the RPC and does authorization with polkit.

I.e. the unprivileged part doesn't talk to polkit directly. But a privileged part uses polkit instead of a custom sudoers style config.
Agree with those saying the landing page needs work. But terraform/docker integration sounds interesting.. after many years of ansible you’d think there is a more comfortable way to replace a hundred lines of hacky bash in dockerfiles.

Also, can I just say that cm is extremely frustrating? Not sure this is the fix, but hopefully the story isn’t over. In my experience the maintenance of cm codebases never, ever stops. At first I thought it was a matter of expertise, but experts typically agree and just call it the cost of doing business.

Shelve something for three months and it will break on the next run, on the same os/host where it used to work. Blame the package manager, blame the os choice, or the cm tool. But it’s embarrassing and insulting for Devops teams after putting in the effort to do things right, and evangelizing to everyone else about repeatability. I’d rather just see tighter integrations with containers moving forward and never think about it again. Not everyone is using k8s but in the 2020s everyone probably should default to using docker before doing things of even marginal complexity directly on hosts.
> which IIRC didn't even have overlapping windows

that's why arc supports split browser tabs hahaha
It would be really funny if systemd tried to replace pulseaudio.
Such an underrated masterpiece, even with all of the praise it has gotten. Reading through the internals of the engine makes for a great evening.

Highly recommended Fabien Sanglard series on Another World: https://fabiensanglard.net/another_world_polygons/index.html
6 years is not enough jail time for this.
Something happened about 15 years ago, that began removing competitiveness for children. Everyone gets a ribbon. Standardized tests out the window. Elimination of gifted programs. Almost like a propaganda campaign to teach children that everyone's a winner, no one can be a loser, and everyone must get the same accolades no matter what. I think it's had a very detrimental affect instilling in kids that if they don't get something it's someone else fault.

The system of before was not perfect, and kids were unfairly left out, but the hard turn to "everybody's a winner" has done severe harm. There has to be a better way.