skysight-inc/HackerNews huggingface dataset:
> Should I write this logic in the DB itself ?

Yes?

If it sounds impractical, it's because the whole industry got used to not learning databases beyond most basic SQL, and doing everything by hand in application code itself. But given how much of code in most applications is just ad-hoc reimplementation of databases, and then how much of the business logic is tied to data and not application-specific things, I can't help but wonder - maybe a better way would be to treat RDBMS as an application framework and have application itself be a thin UI layer on top?

On paper it definitely sounds like grouping concerns better.
There are some with good color rendering (CRI over 95 - 98), but they are hard to find and much more expensive than the average LED light bulb (many doesn't even have their CRI specified so probably below 70).

AFAIK None of them will ever have continuous spectrum (like the sun or incandescent bulbs), that's a limitation of the physics how they make light.
Intel Co-Presents Cooperative Vectors with Microsoft at GDC 2025
It's not about being young or old, search engines have moved away from pure keyword searches and often typing your actual query gives better results than searching for keywords, especially with Google.
I don't find this as a grave problem, since I see the folder as an exposed database which I shouldn't muck with. What's your gripe about it?
Nope.

https://thetrek.co/a-german-thru-hiker-has-been-detained-dep...

They didn’t even look at the documents she provided.
This. The barrier of entry is too high. Feels like the Indieweb is stuck at the protocol layer and an abstraction above it is badly needed.
> disbelief that this is the new status quo

This is called denial or shock, which is a natural result of grief.
Apple will still go out of their way to make sure these changes only stay in the EU.

E.g. changing default navigation app: https://mjtsai.com/blog/2025/03/14/dma-compliance-default-ma...

--- start quote ---

> The upcoming iOS 18.4 update introduces an option to set a default navigation app, other than Apple Maps, but unfortunately this new setting is limited to users in the EU.

This one seems kind of spiteful. I get that Apple doesn’t want to make sideloading available throughout the world just because the EU and Brazil have mandated it, but they’re going to hide the very useful maps setting in countries that don’t have a DMA?

--- end quote ---
And from the reports, a lack of rights for detainees to reach out faster to their relative, lawyer or just a translator. Due process is out the window, what the King says is law. It sounds cynic, but with many detentions centers run by private operators, and expanding[1], there's just no interest for those companies to get rid of their guests quickly. Why won't they get every detained person before a judge within 24 hours, especially if they are move to another state? Is paying corporations for more beds really the preferred solution over appointing more immigration judges?

[1] https://www.nytimes.com/2025/03/07/us/politics/private-priso...
Hosted, past tense. There won't be 35 million visitors this year.
The situation is not good but let’s not lie. Green card holders returning from overseas have always been at high risk of encountering issues upon reentry. Overseas visitors working informally have likewise always risked detention and deportation. The gentleman in Boston was treated very badly, but his detention lasted hours, not days. Ordinary tourists are not being detained. I am a US Citizen who worked in the EU for some time and was detained upon initial arrival into the Schengen area while they checked into my work visa. The French scientist situation - very concerning, but they were just sent home. Hardly a reason to withhold a visit “unless your life depended on it”
Earth's gravity is too strong and human energy exploitation isn't large enough to allow for such reusable rockets. The rockets we humans fly look massive and shame to discard, but they're more like liquid fueled balloons than proper spaceships for their scales.

e.g., the Al-Li metal layer of Shuttle ET was 0.1" thick at thinnest points yet those ET were 150ft+ tall. iPhone back covers are thicker than that. Rocketry gears are infuriatingly flimsy relative to their size, but they have to be because that's what it currently takes to fly to space.

If we could build ships on the Moon from Lunar rocks out of a grinder, or if we could build an all-fusion spaceships, we can (relatively)easily have 2m thick radiation shielding, or 8km wide hulls, or anything we want.

But we're not doing it, but are stuck with lox-fuel chemical propulsion, so we can only make them so durable.
https://www.wmur.com/article/german-national-fabian-schmidt-...

Maybe you don't consider being violently interrogated to the point of being hospitalized torture?
And even that doesn’t protect you

https://thetrek.co/a-german-thru-hiker-has-been-detained-dep...
True, but you never need 200F for DHW. This is even dangerous (scalding) and harmful to the piping. Typical temperatures for heat pump derived DHW are around 120F (45-50C), with some (bi)weekly cycles to avoid legionella build up at 150F(65C). Your statement is generally true, because a heating installation that is optimized for heat pump works at 85-100F, however in practice not many installations in old buildings are like that.
I don’t know if that list is exhaustive. Besides, it’s only fines. I think everywhere I’ve worked has had requests (“what information do you hold on me and what do you do with it?”) that haven’t resulted in any punitive action. I’m not completely sure what you meant by investigations but I’m just trying to point out that GDPR certainly isn’t toothless.
> People that are learning the current tech ecosystem are absolutely not learning web fundamentals. They are too abstracted away

This hit hard.
I had to try to believe and I'm baffled.
The government employees at these border crossing definitely feel too confident that whatever they do will get covered up or ignored by the people above them. And all trust I ever had in the forth estate - nationally and internationally - has gone with this entire mess of a presidency too. They mostly seem to parrot each other's assurances that things that are happening are completely normal, or at least understate heavily. I'm happy outliers exist, including some unexpected ones like Wired Magazine.
Did you complain about using the word avatar when you found out they weren't an actual embodiment of a god?
More accurately, people who travelled to the US in recent years were fine. The assumption that will continue to be the case is something every traveller needs to consider for themselves. It's not unreasonable for people to choose not to travel, just in case.
It's the same issue that killed the image-based programming in favor of edit-compile-run cycle we're all doing. "How do I test? How do I do version control? How do I migrate?".

These are valid concerns, but $deity I wish we focused on finding solutions for them, because the current paradigm of edit/compile/run + plaintext single source of truth codebase, is already severely limiting our ability to build and maintain complex software.
Why would a startup do that? Hardware is low-margin difficult, capital intensive, long sales cycles, long rampups until revenue, volume sales are very trust-based (hard to get in when not established), expensive recalls, product compliance, etc. In addition the trend for the last 30 years of electronics is integration, completely opposite of modularization.
I am very pro open source hardware and software (and contribute to both) - but I find it completely understandable that there are few startups/companies in this space.
A significant part of the economy perhaps, but 'national security threat' is a somewhat higher bar IMHO. LHR has a role of convenience, but not necessity. If JFK was shut down for a day or two and had limited operations for another week it would be inconvenient but would barely register in the national economic stats. I am on a flight heading out of Heathrow on Sunday for work travel and have booked an alternative out of Gatwick just in case. Inconvenient, but not a massive problem.

What will be telling here is how quickly things adapt to the disruption. I expect to feel more impact from the loss of power to businesses in the surrounding area that are involved in air shipment than in the flight disruptions (e.g. cold chain logistics and inventory management for just-in-time processes that warehouse near the airport.)
Gitlab is sued by its own investors over misleading AI hype
Mocktail: HTTP and gRPC server mocking for Rust
You're both right. It was an issue before. It's an issue now too.

It might even be less of an issue now, practically, because of budget cuts.

But it will be perceived as a bigger issue than whatever the reality is because of the rhetoric.

Incidentally, when the ICE deportations started, the heated rhetoric was an explicit part of the strategy to spook people into "self-deporting".

I have no idea if this worked or not, but I believe the reason was due to not having enough budget or staff to do the scale of deportations that the administration wanted to do.
I can confirm this: I downloaded the old version of the app (on a Windows laptop), isolated it so that it would not auto-update, and then used it to download all my books (after the deadline had passed) and convert them with Calibre, which got rid of the DRM crap. You have to do both the downloading and the conversion on the same computer -- other than that, it worked perfectly for my more than 100 books.
> Oh good, another pop-up dialog no one will read that will be added to every site.

> no one

i go through every cookie pop up and manually reject all permissions. especially objecting to legitimate interest.

i actually enjoy it. i find it satisfying saying no to a massive list of companies. the number of people who read these things is definitely not 0.

my question to you is, why does compliance with regulation make you so … irritated? you don’t think it serves a purpose. but it does. there’s an incongruity there.
At which level? And pure mathematics or engineering or other?
Since you tried it, you now have now developed some skills to be able to raise some vegetables if you're in a real pickle (ha!).

Maybe that is the most valuable thing from such a garden: not being totally helpless if the need does arise for some reason.

And when that does, there are probably more people around to trade different foods with, perhaps.
I was wondering when StumbleUpon would be back ;)
Surely the US customs etc can still find a way to intimidate and screw you over.

My limited experience is that they either train their staff for it, or pick people who enjoy it. Or both.
weird that the economist uses the word 'reclaim' instead of 'invade'
What port of entry is not US soil? You can be detained in an US embassy and sent off somewhere. In fact the US doesn't even have a problem with kidnapping people in the middle of a European city sending them off for torture[1].

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

[2] https://en.wikipedia.org/wiki/Khalid_El-Masri
Yeah, I would have expected to get my ESTA denied, or denied entry at the border and shipped back. It would have never occured to me that I would be arrested for weeks. It's insane to me, it can't make economical sense, it must be cheaper to just deny entry than arresting people.

Unfortunately I need to travel to the US soon for a company (on?)off-site, and the thought is in the back of my mind. Getting off the plane and getting sent back would be annoying but whatever. Getting detained would be a nightmare.
Agreed, we're working on this type of additive search at the moment. Just did a bunch of user testing on it yesterday.
No one has fought a war with the other side explicitly using human shields before, so you have nothing to compare to.

Also: citation needed.
Not to mention that many farms will be lacking migrant labor due to mass deportations.

"Work will set you free from your addiction."
I don’t think the latter is happening. The multi-day detentions have all been related to actual immigration violations. Again, something I oppose very strongly but the notion your life will be severely negatively affected if you show up at the border as a normal tourist with normal travel documents is just incorrect. The worst thing that will happen is they send you home.
Seriously! Although I’d say the most undervalued is wet processing. It’s incredible how much art and science go into not leaving water spots. Not to mention cleaning up other people’s messes.
Thanks, appreciate the kind words
oh, I thought it was cooperative. Well that makes much more sense then.
> Can you give pointers about who gives away hydrogen generation systems for free?

If you don't care about efficiency (because the electricity is free), a 9 year old can make hydrogen generators out of old pencils and jam jars.

Citation: me, I did that.
I used to, interesting people there, but stopped when they brought in fingerprinting ...
Germany is joining that list by destroying their economy to satisfy those who will never be satisfied with Germans.
If you’re saying that being able to legally bring cannabis into a country is a test for whether the IETF can host their meetings there… I don’t know if that is accurate.

Sure, Singapore has draconian laws when it comes to narcotics. But surely everyone attending will be aware of this? It’s been widely reported over the decades how foreign nationals have gotten life sentences or even the death penalty for drug running. What I’m saying is that Singapore are up front about it and it’s not enforced arbitrarily. Leaving your personal stash at home and abstaining for a few days should hopefully not be too difficult for the attendant engineers.
I don't, Meta discussions like this have happened since forever on HN. And attempting to curb them is a good thing.

OPs "comment" on what should be correct behavior on HN is now the top comment and surpasses by far the few people that he is critiquing. And hence our discussion now is all about this meta thing, which means we are not talking about the article.

that is not new
Yes that is a misconception: https://data.worldobesity.org/country/mexico-139/#data_preva...
> And as with everything related to the environment, that's because the profits are centralized while negative externalities are socialized. We all pay the price of the reservoirs depleting and the aquifers running dry - maybe not monetarily, yet, but in the form of LA needing to ration water in homes, and in the form of possibly causing earthquakes [1] - but only a small handful of people collect the benefits. And because water is available in practically uncapped quantities for such an incredibly cheap price, they have no incentive not to do so.

Exactly. Capitalism is already a contestable proposition, but capitalism with infinite money cheats for some?

Without proper accounting of externalities, capitalism does not work even in theory. This means water and all natural resources, it means pollution, it means harmful products like tobacco or social media, it means big cars... So on so on
Why he haven't implemented a full Datomic Peer for his DataScript I never understood.

Having a datalog query engine, supplying it with data from Datomic indexes - b-tree like collections storing entity-attribute-value records - seems simple. Updating the local index cache from log is also simple.

And that gets you a db in browser.
Mexico is outside the US. My guess is she fibbed on the form in some way. Or they thought she did.
We are masters at the moment?

Nobody told me I was one!
Funny how we’ve come full circle—LLMs now search the web to answer queries, which is what search engines did originally. The difference? Now the hallucinations come with citations. Curious how long until "web search" just means summarizing Reddit threads again.
https://www.theguardian.com/global-development/2022/nov/04/s...
It certainly would be cheaper, but then how would the people running the arbitrary detention centers get paid?
TidesDB: A fast key/value store for modern hardware
Hey hackernews! I'd like to share a project I've been working on for almost a year now. It's an open-source storage engine similar to that of LevelDB/RocksDB but written entirely in C.

The storage engine is called TidesDB.

TidesDB is an open-source storage engine similar to LevelDB/RocksDB but written entirely in C. It's designed as a fast, transactional key-value storage engine built on a log-structured merge-tree (LSM-tree) architecture.

My journey with TidesDB began nearly 2 years ago while I was experimenting with various data structures and databases in Go. When I encountered the log-structured merge tree concept, I was initially overwhelmed by its complexity after reviewing other implementations.

However, after studying the original paper, I realized I could potentially simplify the design by focusing on just a 2-level approach(memory level and a disk level). This was challenging at first, and I scrapped many ideas along the way, but over time I discovered how powerful this design could potentially be.

The beauty of this architecture is its extensibility. Since the disk level contains many SSTables (Sorted String Tables), we can efficiently pair and merge them in various ways - whether in parallel for speed or incrementally to minimize resource impact.

What began as a challenging learning process has I believed evolved into a unique engine design and library.

You can check out TidesDB code here: https://github.com/tidesdb/tidesdb

Website here: https://tidesdb.com

Currently TidesDB is nearing its first major release, we are still in beta development :)

I'd love to hear your thoughts on the library. I am very open to discussions, we have weekly code dives and reviews and yeah. Looking forward :)
Very nice to see this on the front page!
> I just don't understand why some people are so blind to the ongoing abuse of power. What a shame!

They're not blind to it. They either like it and want it (sometimes because they benefit from it), or they're indifferent to it because it doesn't affect them personally. I know — it's really hard to appreciate the mindset of people with no empathy.
The current crackdown is absurd. But let’s be honest - this specific situation with the German backpacker is nothing new. If you show up at the border for an extended trip with no money, you are subject to extended examination. This happens all over the world.
I just replaced two OSRAM LED "bulbs" in my bedroom, and paid 15 euros each for them. 30 euros for two lights feels insane, and yet I know I paid something similar for the previous ones about five years ago.

My issue with LED bulbs is that they don't fail per se, instead they get progressively less and less bright over time. It's a slow fade rather than a sudden explosion.

(I've gotten into the habit of writing the installation date of all new bulbs on the stem as I insert/install them. Just because I want to track how long they last.)
Was actually planning to be at GDC this week & while there were other factors at play, the clincher was a feeling that there’s now a non-zero risk of getting caught up in some serious nightmare scenario like this. Seemed pretty self evident that the new administration’s rhetoric even a couple of months ago was paving the way to fascist authoritarianism & I don’t see that changing any time soon.

Tbh, even having a post like this in my user history is apparently the sort of thing that could cause complications at the border! So much for “free speech absolutism”. Makes me wonder how many others will stay silent to minimise that risk & whether that’ll lead to an illusion of support for these policies…
Ironically, the fact that the IndieWeb hasn’t taken off is exactly why it matters. Mass adoption would kill the point—turn it into just another algorithm-driven wasteland. It’s for the stubborn ones who still give a damn about owning their corner of the internet, not chasing dopamine hits on rented land.
4GiB
Returning green card holder, who have always been subject to scrutiny. His treatment was absurd and unacceptable, but not a situation that would be faced by an ordinary tourist or business traveler.
That's in some sense a "Swiss cheese security model". It's not that databases should, in principle, never be directly exposed. It's that they rarely are designed for it security-wise[0]; meanwhile, adding whatever complex assembly of containers and applications written in random languages and frameworks, to sit between users and the database, introduces a swamp of better-secured systems that attackers also needs to get through. The more cruft you pile on, the more annoying it gets for attackers and users alike.

In fact, there are many benefits of directly exposed databases - many of which would remove the need for applications normally sitting on top of those databases, which are strictly inferior and less ergonomic and overall more shitty than a generic database browsing interface. But that's another reason for why things are the way they are: people wanna make money, and having your application be a toll booth between useful data you own and the rest of the world, is tried and true way of making money.

--

[0] - Because they're not normally exposed, because they're not designed for it, because... it's a self-reinforcing loop.
Thanks to the wonders of UB, the sample on the article when compiled with optimization on, it actually reduces to,

//clang -o null_dereference null_dereference.c
#include <stdio.h>

int main() {
int *ptr = NULL; // Initialize a pointer to NULL
int value = *ptr; // Attempt to dereference the NULL pointer

printf("Value: %d\n", value); // This line will reached, because the previous will be optimized away.

return 0;
}

Example, https://godbolt.org/z/Kv3rcz1ch
So much for the “RISC-V isn’t ready” crowd—this is exactly how niche architectures survive: stubborn devs, a loaned Milk-V box, and a middle finger to pragmatism. Honestly, dropping it now would’ve been a waste. If anything, this feels like a test run for how the indie Linux world will carry RISC-V until the big players stop waffling.
Why don't you play Go instead of Minesweeper?
Robotized packing tape dispenser. Maybe this way duct tape can albo become a proper build material?
I don't think permanent residents have ever faced this level of blatant harassment from any administration.
Nvidia GTC 2025 – Built for Reasoning, Vera Rubin, Kyber, Jensen Math, Feynman
Avatar is used synonymously with profile picture. If I said I had an "avatar," the last thing you would think of is a fully rigged and mocapped 2d/3d avatar. Notice how I had to qualify the word avatar there ("animated avatar" is hardly specific enough), hence why it has its own name: vtuber.

Get over it. You keep complaining about the word vtuber in this thread, but it's an extremely common and popular term with a whole damn industry behind it.
Precisely. The hype articles write all about the journey to The Wall, and then leave out the bit where you smash headfirst into it.
Last two collect water inside the button. Can't switch them off. One more expensive set had the rubber casing peal off because the strap is gently pulling on it. My current expensive one had its button drop into the casing. I bring it inside now as it obviously can't get wet.

The amount of light is great but we have a lot of "narrow" bike paths and people point them forwards blinding the opponent.