skysight-inc/HackerNews huggingface dataset:
I recently took a part time role at Oracle Labs and have been learning PL/SQL as part of a project. Seeing as Niki is shilling for his employer, perhaps it's OK for me to do the same here :) [1]. HN discourse could use a bit of a shakeup when it comes to databases anyway. This may be of only casual interest to most readers, but some HN readers work at places with Oracle licenses and others might be surprised to discover it can be cheaper than an AWS managed Postgres [2].

It has a couple of features relevant to this blog post.

The first: Niki points out that in standard SQL producing JSON documents from relational tables is awkward and the syntax is terrible. This is true, so there's a better syntax:

CREATE JSON RELATIONAL DUALITY VIEW dept_w_employees_dv AS
SELECT JSON {'_id' : d.deptno,
'departmentName' : d.dname,
'location' : d.loc,
'employees' :
[ SELECT JSON {'employeeNumber' :e.empno,
'name' : e.ename}
FROM employee e
WHERE e.deptno = d.deptno ]
}
FROM department d WITH UPDATE INSERT DELETE;

It makes compound JSON documents from data stored relationally. This has three advantages: (1) JSON documents get materialized on demand by the database instead of requiring frontend code to do it, (2) the ORDS proxy server can serve these over HTTP via generic authenticated endpoints (e.g. using OAuth or cookie based auth) so you may not need to write any code beyond SQL to get data to the browser, and (3) the JSON documents produced can be written to, not only read.

The second feature is query change notifications. You can issue a command on a connection that starts recording the queries issued on it and then get a callback or a message posted to an MQ when the results change (without polling). The message contains some info about what changed. So by wiring this up to a web socket, which is quite easy, the work of an hour or two in most web frameworks, then you can stream changes to the client directly from the database without needing much logic or third party integrations. You either use the notification to trigger a full requery and send the entire result json back to the browser, or you can get fancier and transform the deltas to json subsets.

It'd be neat if there was a way to join these two features together out of the box, but AFAIK if you want full streaming of document deltas to the browser and reconstituting them there, it would need a bit more on top.

Again, you may feel this is irrelevant because doesn't every self-respecting HN reader use Postgres for everything, but it's worth knowing what's out there. Especially as the moment you decide to paying a cloud for hosting your DB you have crossed the Rubicon anyway (all the hosted DBs are proprietary forks of Postgres), so you might as well price out alternatives.

[1] and you know the drill, views are my own and nobody has reviewed this post.

[2] https://news.ycombinator.com/item?id=42855546
I complained about hardware perf and viability in another thread.

However, there are enough options for enthusiasts / early adopters, including budget HW. I don't think e.g. PINETAB-V[1] is a desirable/useful general purpose tablet, but it's there if you want to bite. If you're going after an SBC, STAR64[2] also looks OK.

[1]: https://pine64.com/product/pinetab-v-10-1-8gb-128gb-risc-v-b...

[2]: https://pine64.com/product/star64-model-a-8gb-single-board-c...

Just adjust your expectations. x86-64 is the architecture of yesterday, ARM64 is for today, RISC-V looks like the future.
Tortured?
I know right. :D
Given how many underhanded sites are out there, 2560 is pretty modest for the EU?
What was wrong with the guy at Logan who they beat the shit out of?
Thanks for sharing—your point about emotions is spot on. I started focusing on decision paralysis in ADHD, but excitement, anxiety, and boredom are clearly major hurdles. I’m thinking about incorporating subtle mood check-ins, quick breaks, or nudges to help manage these feelings alongside task prioritization. Do you have any specific features or techniques in mind that have helped you overcome these issues? I'd love to hear more and see if we can integrate them without making the app feel too heavy.
yes but I went on their Discord, and the AI thing is more an "extension" of the CI/CD thing, it's just marketing-speak for the investors, they are still building the CI/CD tool
> ChatGPT can just send you something that is completely wrong, and you have no way of knowing.

This is true, if you decide to take a ChatGPT answer at face value without any further work. Personally I find it useful sometimes to ask an LLM a question, get an answer and the verify that answer for myself. Doing web searches and pulling together relevant information to get the answer for a question can be harder than getting an answer and then looking to verify it. Perhaps something like that was going on here, impossible to know of course.
"A criminal conviction in the United States, false information regarding the purpose of stay, or even a slight overstay of the visa upon entry or exit can lead to arrest, detention, and deportation upon entry or exit," information on the ministry's website now explicitly says.“
Trump talked about "Shithole Countrys" on 1/12/2018. I am sure he talked about the future of the USA
The Foreign Ministry of Finland issued an advisory that ESTA and visa rules have been changed to require that the gender entered must be the assigned-at-birth one (for the obvious discriminatory reasons). If you current travel documents don’t match that, well, good luck.

(Edit: Heh, apparently this comment is downvoted for stating facts.)
The New International Zero Trust Reality
There was a bunch, a lot of them (most?) due to noyb: https://noyb.eu/en
I did ask you on your Discord, but perhaps you could summarize here / ELI5 why Dagger would be a great fit for a kind of "MCP-like" operating system?
How is this a perception issue? It’s a real issue.

Even if the chances of getting detained on bullshit charges are slim, the behavior of the government is now so erratic and hostile that people who care will actively avoid going to the US. And for what exactly? Does anyone still wonder? Or do they just accept that the government constantly does stupid things for no real reason?

If my country behaved like the US for just one hour, the press would find enough scandals to talk about for a year. But the US manages to make the press move on to the next scandal. And the next. And so on.
In defense of unpolished personal websites
Looks pretty cool. Will give it a go with work stuff on Monday. TUI apps rock.
"A criminal conviction in the United States, false information regarding the purpose of stay, or even a slight overstay of the visa upon entry or exit can lead to arrest, detention, and deportation upon entry or exit," information on the ministry's website now explicitly says.

That’s the updated guideline if you’re only reading titles
China's military is going to war against itself
On another note, I'd love if you open-sourced your timeline / log UI component :) it's quite pretty, and could be useful in many contexts haha

Or I'll ask v0.dev to reimplement it, but I think it'd be more complete if you did it
Technically if you’re Venezuelan you could be sent to be tortured in El Salvador
I think you can use Calibre-web as a "store" for Kobo devices pretty easily (basically swap one URL in a config file on the device).

I gave up on the synced reading position at the same time I sold my Kindle, but I can live with that.

Getting stuff on the device is a bit of a hassle too, because I can't exactly go plug it in to my NAS, but exporting 50+ books to a directory and copying them manually takes a few minutes and I'm set for a year or more - so it's time well spent :D

Having everything (except for comics) consolidated in one place is the main reason I tolerate Calibre's quirks and eccentricities. It's ... opinionated, but it's still by far the best tool available for the price.
For the average European there was never a risk of getting detained for weeks in a prison facility where the lights are never off and your only comfort is an aluminium foil blanket.

It's not just rhetoric. I agree that the risk isn't particularly high, but it did seem to have gone from 'negligible' to 'possible'.
Well, then it can go to hell, even if the idea isn't necessarily bad. Atom/RSS are fine formats that work with countless small clients, what about hFeed?
Can you show these numbers are significantly higher than the previous years' average? If you can't then it's perception
where do I add my name?

of course it turns out that the delay was doing everyone a favor
White, from Canada, and even female: https://www.theguardian.com/us-news/2025/mar/19/canadian-det...

What a horrific ordeal, and the Latin American women she met are having worse time. The worst of it is the "just following orders" robots (the foot soldiers of fascistic 1940s say hello) having no answers to her question of "How long will I be here?".

I wonder how it'll end. Trump/MAGA/Project 2025 can turn the country into a police state (Russia-style) with even more rigged elections (Russia-style) and the populace will probably just submit (and about 50% will defend it, some of them because of ego protection (1)). They are already ignoring judges' orders, basically saying "What are you going to do about it?".

Will someone in the military lead a batallion of tanks on Washington DC?

1) https://www.technicianonline.com/opinion/opinion-admit-you-r...
"Sex" is a disguised query [1]. I would not agree with you that the plain and common meaning of sex is that it's the reproductive role (which for many trans people is "permanently sterile" anyway). If you run a clothing store, you don't care about reproductive role, you care about whether someone wears men's or women's fashion. In daily life, a stranger's sex is entirely their appearance: we make a snap judgment to classify it as M or F, and most people will agree for any given person whether they are M or F. It's quite easy to see why that's what matters: if you get a public safety alert on your phone about, say, an "asian male, middle-aged last seen at ..." do you think, in the rare cases where they differ, that this refers to reproductive role or appearance? Let's hope it's appearance!

In daily life, outside of dating perhaps, most people generally don't care about someone's reproductive role. In a public bathroom, most don't really care what's actually between someone's legs so long as the individual looks like they belong. The authorities almost always care about sex only as a visible characteristic for distinguishing people. When you say the common meaning refers to reproductive role, you are probably saying that only because it's a proxy for the aspects of one's sex we actually care about.

This recent obsession that when we talk about someone's sex we obviously mean in a reproductive capacity regardless of context is a totally political fabrication in my opinion, and there's no good reason for a passport agency to prefer that definition. I believe the information on a passport is meant to help identify an individual -- so common-sense sex, i.e. appearance, is most important. (Similarly, requiring trans people to use the public bathroom they don't visually look like they belong in is only going to cause chaos, if they obey such a law.)

[1] https://www.lesswrong.com/posts/4FcxgdvdQP45D6Skg/disguised-...
Everything has changed in practice, when people are detained at the border because they posted something on social media which was critical of Trump, in a country which prides itself on having "freedom of speech" in the constitution. When denial of entry means weeks in detention rather than an expedient flight back to where you came from. When going to speak at a conference can get you detained for violating a visa which has always been fine for that before. When people with green cards are getting arrested and sent for deportation... everything has changed.
I really love to hear about details. I have plan to build a RAG based on regulations. It is very hard because source are different and reading and interpreting legal documents completely different area of expertise. I can't answer some questions?
- How can I start small in very specific area?
- How can I grow it?
- How to validate and measure success of the RAG solution?
- How to feed with data continuesly?
Sure, my point is that it's not a majority of organic hatred but artificially inflated instead.
What is your country? Curious to see its border laws to see if I can be denied entry or deported if I break the law, which is clearly erratic and hostile behavior.
>It's not like we can go to Hetzner and rent a RISC-V server or go to AWS and provision a RISC-V VM.

You can go to Scaleway and provision an RISC-V instance

https://labs.scaleway.com/en/em-rv1/
Honestly this seems to be a really short sighted view, none of the people that got arrested there really had reasonable grounds to be arrested, although I guess that legally they are "in the clear", but I am no expert, and this is high profile only because of the situation is absolutely absurd, and we are only two months in.

How many cases are not reported and as bad as this or worse? Am I willing to be gambling this?
Schengen is different from EU.

More importantly, and according to your link, only Estonia rejected 50+% Indian applications, everyone else rejected less than 50%, with only 2 others anywhere near 50% (Malta and Slovenia).

So out of 29 countries in the Schengen area only 3 were anywhere near the 50% mark and all 3 are tiny countries as far as both area and populations are concerned (those 3 combined account for only 4 million people in total).

Also, just to take one of those 3, Estonia has an overall high rejection rate in comparison to all the others, and that started happening after the pandemic.

Details are important
Next year it will be rated electoral autocracy instead of democracy if nothing changes.

https://www.cbc.ca/amp/1.7486317
Saw this thread and thought back to that thread as I hadn't heard of Chimera Linux before you mentioned them.

Glad to see that they're not dropping RISC-V support for the moment - not that I'm a RISC-V user yet, but I agree that it's the future.
Interestingly, the Buran’s Energyia launch vehicle could possibly have been made reusable exactly because the tank and the engines were one unit. At the expense of payload capacity, of course. And anyway the Soviets were confused about the whole shuttle concept because it didn't seem to make economical sense, reusable booster or not – but they assumed the Americans knew something they didn't.
China is developing some startling new kit in its quest to invade Taiwan
Western people are more likely to make noise about it when it affects them. No surprises there.
Absolutely. Trans people should absolutely not consider travel to the USA at the moment.
There is indeed a difference between specced for "incandescent bulbs wont start a fire" and "it's warm enough to cook the electronics of your led bulbs"
>Flying model rockets is a relatively safe and inexpensive way for students to learn ...

according to the current laws - it isn't, and may be even more dangerous than walking to the school on your own.
> It's hellishly inefficient, but I repeat: the energy is free.

Can you give pointers about who gives away hydrogen generation systems for free?

Because the cost of energy usually factors in the cost of amortizing equipment required to produce and distribute it.

> The nice thing about going all the way to synthetic fuels and not hydrogen is that long term storage becomes trivially cheap

Once you've financed all of the horribly expensive capital expenditure, and provided you disregard that operating costs actually require paying people to monitor, repair and operate that infrastructure, the rest is basically free.
"In our niche hobby we call it a singlyjack, what is there not to understand?" and then it turns out a siglyjack is more or less the same as a regular flathead screwdriver just painted with a purple color.

I am not to judge slang here, but animating character pictures between two states has been around for ages. Especially in animation (before computers existed), but also more specific in games (e.g. early Metal Gear Solid games, Doom, come to mind).

When this image (animated or not) represents a person online it was called an avatar since the dawn of time. Indpenedent of wheter it was realistic or just depicted the insides of a gearbox.

Now I am not against niche slang terms at all, but if your description of what it is hinges on understanding the slang term that you used for the title, that is a self-referential loop that doesn't help anybody: Snaglyjack is a snaglyjack-tool made from hardened steel

So with a short non-niche-focused phrase like "a lofi two-state avatar, animated by audio levels" most people would be able to imagine what it is the thing is doing. If that is not the goal, that is okay, but since it was posted on HN..
Hmmmm... so I think the crux of the matter is here: that you clearly articulate why your platform (for both containers and agents) is really helpful to handle cases where there are both states and side-effects

I can understand what you're trying to say, but because I don't have clear "examples" at hand which show me why in practice handling such cases are problematic and why your platform makes that smooth, I don't "immediately" see the value-added

For me right now, the biggest "value-added" that I perceive from your platform is just the "CI/CD as code", a bit the same as say Pulumi vs Terraform

But I don't see clearly the other differences that you mention (eg observability is nice, but it's more "sugar" on top, not a big thing)

I have the feeling that indeed the clean handling of "state" vs "side-effects" (and what it implies for caching / retries / etc) is probably the real value here, but I fail to perceive it clearly (mostly because I probably don't (or not yet) have those issues in my build pipelines)

If you were to give a few examples / ELI5 of this, it would probably help convert more people (eg: I would definitely adopt a "clean by default" way of doing things if I knew it would help me down the road when some new complex-to-handle use-cases will inevitably pop up)
It's both. But the real issue also existed before, they just turned it up to 11 and will likely go much further.

I don't want to downplay this, the point I was trying to make is that the perception will have a much bigger effect now independent of how likely it is for each person to be actually affected. And the perception includes the expected further escalation by the current US government.

There's a lot of issues with how the US handles immigration (and other countries as well). It's essentially a lawless zone where you're completely at the mercy of the US authorities. But even if that isn't new, the rethoric and aggressive actions by the new government will make this a lot worse.
Still not possible to use your own directory architecture manifestly
where would one begin looking for SEA?
Why are people even considering an electric heating element, when you can get at least 2-3 times the efficiency of a DHW heat pump that would probably cost you ~ $4000. In my experience, I have found that for PV panels it is often the roof area / orientation that limits the energy capacity that you can install. Installing a heat pump instead of resistive heater can effectively reduce this 2-3 times.

Yes, heating DHW with a heat pump is not that trivial. There could be problems when the tap water is hard (limescale problems in heat exchangers), you often need 2-3 times larger tank in order to cover the daily cycle, but still looks more efficient than a big battery and an electric heater.

PS: I've accumulated lots of knowledge on the topic. DM me if you are interested in exchanging on this.
Too early for stats I think. But yeah, keep on denying the light of the sun.
Slight different to the previous MBA and MBP but not good enough to warrant as improvement. Frankly speaking still sucks.

The lid is heavy. Nothing much could be done on the bottom side.
I think that open-source modules are valuable even without open-source ICs. At least for may classes of genetic IC/modules there are many vendors of an IC, so one could have multi-source for the IC, to reduce reliance on a single vendor/source.

It is becoming more and more feasible to do things software-defined, with a generic microcontroller being the core IC. I would love to see some projects for DC/DC power converters for example around a microcontroller with open software. This is a bit tricky because it needs to be safe, but in theory doable. Also need to be EMC compatible, which will require a lot of testing.
Generally going beyond hobbyist requires much better QA than what most current open source hardware projects are willing/capable to do.
Environmental testing, EMC testing, regulatory compliance, etc. Some exceptions might be vendors like Olimex.
Only a problem when you're limiting yourself to resistive heating. Heat pumps can heat water, not just air, and are several times more efficient than resistive.

I've got a heat pump, and I'm in Germany.

Also, if you're in Germany, you can get a balcony PV system from half the supermarkets a few hundred euros, and those are designed to be installed DIY without needing an electrician. Limited power, sure, but way cheaper than €0.39/kWh delivered:

• https://www.lidl.de/p/vale-balkonkraftwerk-ecoflow-820-w-800...

• https://www.kaufland.de/product/502015379/?search_value=balk...
It’s kind of wild that local storage is still the go-to in most places. Just a single big string, and the only way to handle complex data is by endlessly serializing and parsing one massive JSON object.
The top level grid - yes. Regional operators are private.

https://weownit.org.uk/public-ownership/energy
This is travel advice I've been following for 25 years; because, as the article states, the rules are not new: Go through a port of entry that is not on US soil so being refused entry does not lead to incarceration and deportation. For people in the EU, Dublin is such a port of entry. Once on a plane from there, arrival in the US is the same as for a domestic flight.
is it just interest rates causing this? Seems almost impossible to be seen let alone heard. I've been thinking the ATS is causing lots of issues, but I've noticed how narrow roles and requirements have become.
> No commercialized LLM product released so far would meet Steve Jobs' standard for a high-profile Apple product

I can put words into Steve Jobs' mouth as well!

Steve Jobs would reframe LLMs (and other ML-based solution) as creative assistants, insisting that their job is not to get the right answer, but to help you get your creative juice running.
To get this to happen, he would have personally convinced engineers that have made cool AI demos to work for Apple to turns these demos into features that form a new Apple creative suite.
Do you read ‘wellness farm’ and think it is something literal?

If it was a well accepted term it’d be one thing, but when made up on the spot it very much sounds like “place we sen out undesirables” to me.
Cleaning, gardening and baking is proper jobs though.
The 'utopia' part was sarcastic (obviously, given the preceding paragraph). I'm sorry you didn't pick up on that.

> aligning himself with more radical western ideology

Such as?
that’s pure nuance, thanks
Alternative take, but I get a lot of value from gardening as complimentary to supermarkets.

I normally grow potatoes, carots etc, and have an apple tree, and several herbs like dill, mint, thyme etc that pretty much manage themselves. It's very far from meaning I never need to shop again, and like you pointed out, to get to that point you'd pretty much need to quit your job and work full time growing food.

That said, it does add a bit of resillience into the system (as well as being rewarding) in the same way having solar panels might shield you from energy cost fluctuations without totally removing your dependence on the grid. I save a lot of money on fresh herbs, and never need to buy apples during season.