MurphyA/hacker-news huggingface dataset:
by DecoPerson | 2025-06-16 00:39:28+00:00
One huge benefit of using SQLite over a traditional server/client DBMS is the ability to easily add SQL functions that call into your host language and memory-space.

For example, we’re using better-sqlite3 which has a convenient API for adding SQL functions [1], and we have dozens of helper methods for dealing with time using the temporal-polyfill module.

We have custom JSON-based serialisation formats for PlainDate, PlainTime, PlainDateTime, ZonedDateTome, etc. Then in SQL we can call ‘isDate_Between__(a, b, c)`.

a, b, and c are deserialised by the JS (TS) function, the logic is run, and the result is returned to SQLite. We’ve had no performance issues with this approach, though we’re only dealing with simple CRUD stuff. No big data.

You can even use these functions with generated columns and indexes, but I haven’t found a proper use for this yet in my work.

[1] https://github.com/WiseLibs/better-sqlite3/blob/HEAD/docs/ap...
by FreakLegion | 2025-06-16 00:40:35+00:00
If https://site.warrington.ufl.edu/ritter/files/IPOs-VC-backed.... is right, the last time there were 150+ tech IPOs in a year was 2000 (1992-2000 were all anomalously high). 2021 is the only year to break 100 since then, and only three other years cracked 50.
by smeej | 2025-06-16 00:41:11+00:00
Thanks for the suggestions. I've done extensive trials with the minerals and vitamin D, and both hair and serum tests keep saying that's not the problem.

I'm on NAC too, but oregano oil gave me the worst heartburn I've ever had in my life. Do you think the black seed oil might neutralize it on that front?

I did carnivore for about three weeks before my body was absolutely shutting down. It was catastrophic for me. I did spend 20 months on an elimination diet of slow-cooked meat and boiled vegetables (exclusively, without a single cheat, which was pretty brutal), which helped clear up some intestinal issues that were misdiagnosed as ulcerative colitis, but it didn't do a thing for the headaches.

It's somewhat reassuring that most of the out-of-the-box suggestions people have are things I've already tried, because at least it does confirm for me that I've done a decent job of covering my bases, but alas, the pain persists.
by majormajor | 2025-06-16 00:41:14+00:00
I think a lot of the responses to this are ignoring the things that were popular in the 90s that don't see a big spike of demand more recently.

Bob Ross was popular. Thomas Kinkade was popular. IMO it's doubtful Ross would've been as popular at retail in the 90s as Kinkade. One was a nice cute little educational show. One was "the painter of light" with a marketing engine around him. Both also had plenty of detractors from the "serious" art scene.

Why did Ross get positive associations through 2000s internet culture that Kinkade never did?

Which would you rather go buy now?

Was it just nostalgia, since he was relevant much more to the lives of the kids that grew up to create a lot of the internet culture of the time? Probably a big chunk of it.

But there's also just a certain right-place-right-time. Like, nobody seems to be going nuts about re-buying their childhood Pogs or even Beanie Babies. Ok, those were readily available at retail; Bob Ross wasn't. But Pokemon cards were too...
by sasaf5 | 2025-06-16 00:43:20+00:00
Up to now, my attempts at doing what the author claims to be possible ends up in a broken piece of code that the agent only makes worse when asked to debug, and finally it wont even compile. There seems to be a threshold of difficulty above which the agent will go bug-runaway. I honestly haven't seen this threshold going up. If anything, it seems to be saturating.
by nikcub | 2025-06-16 00:44:17+00:00
~~Counter~~ add to that - Armin Ronacher[0] (Flask, Sentry et al.), Charlie Marsh[1] (ruff, uv) and Jarred Sumner[2] (Bun) amongst others are tweeting extensively about their positive experiences with llm driven development.

My experience matches theirs - Claude Code is absolutely phenomenal, as is the Cursor tab completion model and the new memory feature.

[0] https://x.com/mitsuhiko

[1] https://x.com/charliermarsh

[2] https://x.com/jarredsumner
by smeej | 2025-06-16 00:44:22+00:00
I can definitely say that the couple cycles where a NaPro doctor had me supplementing both estradiol and progesterone at different points of the cycle led to the most incredible pain I've ever experienced. I fired the guy rather shortly thereafter when he ignored my existing meds list and wrote me a prescription for the headache that would have landed me in the hospital were I not a careful reader, so I don't know if it might have gotten better if it were tuned in better.
by AlotOfReading | 2025-06-16 00:45:03+00:00
As an example, see this issue opened against keepassxc saying that if they continue allowing plaintext passkey export, they're at risk of being blocked once attestation is standardized:

https://github.com/keepassxreboot/keepassxc/issues/10407

The goal here isn't maximizing user choice, it's to enforce minimum agreeable standards by the major vendors. It's up to you whether your personal needs wholly align with what they want to mandate, forever.
by throwaway2037 | 2025-06-16 00:45:38+00:00
First, I never heard of CCPA before this post. Wiki tells me: <<The California Consumer Privacy Act (CCPA) is a state statute intended to enhance privacy rights and consumer protection for residents of the state of California>>

Reading that Wiki page also taught me about the follow-up act passed by ballot prop: <<The California Privacy Rights Act of 2020 (CPRA)... The CPRA took effect on January 1, 2023, applying to personal data collected on or after January 1, 2022. The law cannot be repealed by state legislature, and any amendments made must be “consistent with and further the purpose and intent” of the Act.>>. (Wow... pretty strong!)

I like your idea. I think it would be a worthy experience for someone on HN to contact Waymo after taking some rides and ask about videos taken during their ride. Do they have a system to request removal? Also: What are their rights under CCPA?

Finally, here is a help page from Waymo about the issue: https://support.google.com/waymo/answer/9190819?hl=en

Last FAQ has the key:

> Can I remove my data from Waymo’s system? > You have many choices regarding how your data is used, such as viewing and editing trip history in the Waymo One app, updating your account information, deleting your account, changing location permissions, and opting out of receiving promotional messages. > California residents have the ability to delete personal information associated with their Waymo One account or download a copy of it. If you have questions or requests related to your rights under state privacy laws, you (or your authorized agent) can also contact Waymo using this help article, Exercising your California privacy rights, or by calling us at 1-844-261-3753. See more information about these tools in our Privacy Policy.
by judge2020 | 2025-06-16 00:46:01+00:00
I was going to call this anecdotal evidence based on it never appearing in the top 100 (or so) Nielson rated TV shows for a year, based on the lists for 1984-1995 here[0].

However, it looks like PBS never signed up for Nielson until 2009, so we have limited/no public data on viewership of The Joy of Painting (or Sesame Street, etc for that matter).

http://www.thetvratingsguide.com/2020/02/tvrg-ratings-histor...
by rendx | 2025-06-16 00:47:28+00:00
> But Netscape in this instance acted like kids

Oh, please.

https://en.wikipedia.org/wiki/Criticism_of_Microsoft

The "velvet sweatshop" one is sufficient, but plenty of others to choose from. Don't have a source at hand but I remember it was known for its "work 3 years there and then you need to retire early from burnout" culture. There's also a really good (and highly depressing) 2001 German documentary around that "feature" called "Leben nach Microsoft" (Life after Microsoft).

And the classic https://en.wikipedia.org/wiki/Microserfs

There was really less than zero reason to trust M$ in the 90s and early 00s.
by footlose_3815 | 2025-06-16 00:49:05+00:00
Have anxiety. Got sick when working for FAANG. Had to take disability as a result.

Your guts are VERY tied to your brain, and your gut biome WILL change if you are stressed enough. When your biome goes off, LOTS of bad things can happen to you.

I was in constant pain and had IBS-C for two years until I learned how to manage by stress. But it came at a terrible cost of having to flounder a bunch of opportunities as a result.

If you have lower-left gut pain, talk to your doctor, but for me it was all stress and anxiety.
by dps | 2025-06-16 00:49:23+00:00
Author here… I wrote it, I used Claude for proofreading/editing as mentioned at the end. Anyway point is, real human here!

I do still read the code _except_ when I am consciously vibe coding a non production thing where I will know empirically that it worked or not by using it.

I’m definitely not using agents to do all my coding (as I hope is reasonably) clear from the post. But they have crossed this line from pointless to try to genuinely useful for many real world problems in just the last couple of months in my experience.
by muglug | 2025-06-16 00:50:29+00:00
Really depends what you believe.

If you believe that agents will replace software developers like me in the near term, then you’d think I have a horse in this race.

But I don’t believe that.

My company pays for Cursor and so do I, and I’m using it with all the latest models. For my main job, writing code in a vast codebase with internal frameworks everywhere, it’s reasonably useless.

For much smaller codebases it’s much better, and it’s excellent for greenfield work.

But greenfield work isn’t where most of the money and time is spent.

There’s an assumption the tools will get much better. There are several ways they could be better (e.g. plugging into typecheckers to enable global reasoning about a codebase) but even then they’re not in replacement territory.

I listen to people like Yann LeCun and Demis Hassabis who believe further as-yet-unknown innovations are needed before we can escape a local maxima that we have with LLMs.
by imiric | 2025-06-16 00:51:05+00:00
I'm personally still in the "smarter autocomplete" phase when it comes to LLMs, as I don't trust the vibe-coded "agents" and the outputs they produce to control my computer. But that aside, this part stood out to me:

> I don’t even look at the code anymore - I describe what I want to Claude Code, test the result, make some minor tweaks with the AI and if it’s not good enough, I start over with a slightly different initial prompt.

Honestly, does the author and anyone else using this workflow find this way of working enjoyable? To me programming is not entirely about the end goal. It's mostly the small bursts of dopamine whenever I solve a particular problem; whenever I refactor code to make it cleaner, simpler, and easier to read; whenever I write a test and see it pass, knowing that I'm building a safety net to safely refactor in the future. And so on.

Yes, the feeling of accomplishment after shipping a useful piece of software, be that a small script or a larger part of a system, is also great. But the small wins along the way are the things that make me want to keep programming.

This way of working where you don't even look at the code, but describe the system specs in prose, go back and forth with an extremely confident but highly error prone tool, manually test the result, and repeat this until you're satisfied... doesn't sound fun or interesting at all.
by throwaway2037 | 2025-06-16 00:52:59+00:00
First, thank you to share you first-hand experiences. This is one of the best features of HN discussions.

I promise that I am not trolling with these follow-up questions:

Have you ever ridden in a "super car" (Ferrari, etc.) that also has very fast accel/braking? Do you experience the same?

If a Tesla driver just drove a bit less aggressively, would you not get car sick? Did you ever try "FSD" on a Tesla on regular streets? Is the accel/braking still strong enough to make you feel car sick?

I ask all of these question honestly. If I was an electric car maker, I would definitely be concerned about it. To me, it fits the same problem of VR headsets where some people get "VR sick" (like car sick) when using them. They probably spend an enormous amount R&D trying to reduce this effect to a minimum for as many people as possible.
by GoatInGrey | 2025-06-16 00:53:34+00:00
That's because very few people are being meaningfully affected right now. For most, climate change exists as an abstract idea and not an immediate, physical problem. It doesn't help that claims like those made by Al Gore about the polar ice caps being gone by 2016 turned out to be untrue.

I wouldn't expect society to transform itself if told that an asteroid may impact Earth in eighty years, for similar reasons.
by notnullorvoid | 2025-06-16 00:53:43+00:00
Can't blame Mozilla and WebKit for being against this API. Permission prompts are supposed to be controlled from outside the page so users can trust them. This proposal is very dangerous, and it's surprising Google doesn't see why.

This is the opposite direction permissions should be taking if anything they should be more prominently disconnected from the page, and browsers should improve their UI so multiple requests can be surfaced in a single prompt window.
by nyanpasu64 | 2025-06-16 00:56:39+00:00
I have (too much) experience in EDID editing. My suggestions:

- AW EDID Editor as you mentioned.

- CRU is a Windows-only tool, and will modify the EDID files it dumps from monitors (removing serial/etc. descriptors to make room for detailed resolutions), but will work. It does not run under Wine.

- 010 Hex Editor has an EDID template.

- On Linux you can install wxEDID from Flatpak (IIRC the distribution packages would crash in WxWidgets). I don't think it can create sections though.

- v4l-utils has edid-decode (which can be used as a git diff textconv tool), though this does not help you encode EDID files.

I found that HDMI EDIDs have a CEA extension block while DP EDIDs have a DisplayID extension block. I haven't done any work in multi-page EDIDs with over 256 bytes (and don't know what EEPROM chip you'd use to emulate them, nor the protocol or APIs to read and write them).
by jjk166 | 2025-06-16 00:57:44+00:00
> IMO the simpler hypothesis here is that this isn’t anything adaptive, it’s just another example of how biology is like spaghetti code; changing one chemical signal will affect an essentially random set of downstream systems, some of which can be causally connected to psychology/behavior.

That's not a competing hypothesis. Obviously the change to the gut affects other things, some of which happen to impact psychology and behavior.

The question is why does this particular change to gut microbiome have such a similar impact on two different species that diverged many tens of millions of years ago? "It just does" is not a very satisfying answer.
by achillean | 2025-06-16 00:59:11+00:00
There are still more than 300,000 services on the Internet that support SSLv2:

https://www.shodan.io/search/report?query=ssl.version%3Asslv...

And a trend line of how it's changed:

https://trends.shodan.io/search?query=ssl.version%3Asslv2#ov...

It has dropped significantly though over the years but it will continue to stick around for a while.
by jitl | 2025-06-16 00:59:25+00:00
Shouldn’t lisp macros make it easy to present such a nice syntax? Perhaps the author could easily implement that bit, if not the wide rows. Or is that the point you’re making?

There is a dl-rule here: https://github.com/deosjr/deosjr.github.io/blob/15b5f7e02153...
by sirgallo | 2025-06-16 01:00:15+00:00
Performance comparisons are made against go sync.Map, with cmapv2 on par or sometimes exceeding is on different workloads. It is both lock-free and thread safe, using atomic operations. It also supports sharding out of the box. cmapv2 with 10m k/v pairs where keys and values are 64bytes was able to achieve 1.5m w/s and 3m r/s.
by kragen | 2025-06-16 01:01:27+00:00
Basically Datalog is much less verbose than SQL, imposes much lighter tariffs on factoring out views, and supports transitive closure enormously better. I started http://canonical.org/~kragen/binary-relations off with a simple nonrecursive query for which the SQL translation (given below) is already criminal and whose properly factored SQL solution merits the death penalty.

Recent additions to ANSI SQL have added the capacity for recursion, so it's no longer completely impossible. But they have three big disadvantages:

1. They accidentally made SQL Turing-complete. Datalog queries, by contrast, are guaranteed to terminate.

2. They're still extremely clumsy to use.

3. Because of #1, they're often not implemented fully, so they are hard to rely on.
by actinium226 | 2025-06-16 01:01:33+00:00
You seem awfully quick to indict them. While honesty is definitely a virtue, too much can hurt. They wanted to avoid causing a panic, and they monitored risk carefully. Presumably they had time to issue evacuation orders in the event the storm turned towards the city. In the end they completed the repairs and no one had to panic.

Compare that with the evacuation of Fukushima after the incident at the nuclear plant, which released a very minor amount of radiation. Many people suffered severe psychological stress at not being able to return home and not knowing when or if they'd be allowed to go home. Some to the point of suicide. In that case the issue was more about unnecessary evacuation as opposed to messaging, but the point stands the unnecessary panic can cause real harm.
by nyanpasu64 | 2025-06-16 01:02:38+00:00
Do any monitors use the I2C multi-peripheral feature to allow both DDC communication and an I2C EEPROM to exist at different addresses on the same bus? Or is it cheaper to integrate functionality into a controller chip? (Though DP tunnels EDID over the aux bus, and (I assume) doesn't use an EEPROM to begin with.)
by squircle | 2025-06-16 01:02:57+00:00
Thanks Dustin. This would be acceptable... however, this is an interdisciplinary effort and, perhaps ironically, absolutely requires mentors and peers to fill in the gaps (because my knowledge is inherently imperfect.) I could use LLMs to help with the research but... what to do about the matter of provenance, tradition, and lineage? Is this not the spirit of the thing?
by lucas_membrane | 2025-06-16 01:02:59+00:00
This may be good news. Some people will want to consume more real natural music. The best way to make this happen with minimal incidence of fakery will be very small-scale cottage-industry performance venues, 10 to 50 people in a room, including both musicians and performers, voices, instruments and no wires, wireless, computers or electronics involved. Do the math, and you can see that a few musicians should be able to make a pretty good living performing that way with ticket prices no higher than what millions are now paying to sit in crowds of 10,000 or so. Of course, there will be an adjustment period as the mass-production of culture and art declines, and small-scale decentralized production becomes the norm. The media moguls will try to convince us that art made by machine is superior, and their opinion shaping conglomerates will keep manufacturing superstar icons to deliver it. But cottage-industry music will be almost as hard to control as cottage-industry terrorism, and underground cooperatives of radical musicians and listeners will pop up and start making and sharing music with each other for free. As anything free is not counted in the Gross National Product, this will be terrible for the economy, and it will also distract people from all the other distractions to which we are supposed to addict ourselves. Use your brains; lose your chains!
by aspenmayer | 2025-06-16 01:03:21+00:00
https://en.wikipedia.org/wiki/Marine_protected_area

> A marine protected area (MPA) is a protected area of the world's seas, oceans, estuaries or in the US, the Great Lakes. These marine areas can come in many forms ranging from wildlife refuges to research facilities. MPAs restrict human activity for a conservation purpose, typically to protect natural or cultural resources. Such marine resources are protected by local, state, territorial, native, regional, national, or international authorities and differ substantially among and between nations. This variation includes different limitations on development, fishing practices, fishing seasons and catch limits, moorings and bans on removing or disrupting marine life. MPAs can provide economic benefits by supporting the fishing industry through the revival of fish stocks, as well as job creation and other market benefits via ecotourism. The value of MPA to mobile species is unknown.
by kragen | 2025-06-16 01:04:00+00:00
I don't think you need Lisp macros for it; you could use just a regular Lisp function. I don't think the standard R5RS macros are powerful enough to grovel over the query expression to make a list of the free variables, but then, standard Scheme also doesn't have records. I think Guile has a procedural macro system that you could use, but I don't think it would be a good idea.

Yes, I think the semantic divergence is more fundamental. Triple stores and graph databases and binary relations are awesome, but they aren't what Datalog is.
by throwaway2037 | 2025-06-16 01:04:20+00:00
In 2025, source code version control is incredibly complex. Hell, it was already complex 15 years ago, but the tools were probably worse! Have you ever seen the full manual for GCC/Clang? It is nuts. FFmpeg is legendary hard to use from the command line (no hate on Fabrice Bellard -- you still the man). Same for ImageMagick. I don't fault Git for it. If you want fine-grained control over every single possible action... well, you will wind up with a command line tool with an insane number of options.
by nyanpasu64 | 2025-06-16 01:04:48+00:00
You can override EDID in the kernel options (https://foosel.net/til/how-to-override-the-edid-data-of-a-mo...), but I don't know if you want to add a virtual monitor (unsure if https://askubuntu.com/questions/453109/add-fake-display-when... works).
by MangoToupe | 2025-06-16 01:05:03+00:00
I understand quibbling about specifics, but I'm still unconvinced "free speech" is a meaningful term or that it's necessary for industrialization with private investment. It's a bone given to morons to get them to not demand real rights. I would also not ever willingly live in a society with truly free speech.

> Yes, in the US you absolutely are allowed to say what you want with no state-sanctioned consequence.

When has this ever really benefited us? We complain endlessly but fix nothing. What value have unanswered complaints?
by somat | 2025-06-16 01:08:47+00:00
sqlite is pretty great, but I have to admit the main reason I keep using postgres, even in situations where sqlite would probably be a better fit, is that I like the postgres standard function library better.

But I also use postgres as a sort of better excel, so what do I know. My desktop instance has a million silly small tables, you know back of envelope ideas, exploratory data, to do lists, etc
by esperent | 2025-06-16 01:10:42+00:00
> Athletes consume 50g of fructose (and 50g of glucose) per hour

...while actively competing in endurance events. They don't do this while sitting on the couch in the evening. And it's very specifically only endurance trained athletes who do this, sprinters would never need to consume that much sugar.

It's a valid point though, a sugary snack or sports drink directly before hitting the gym for a hard workout session is probably fine, as long as your blood wasn't already saturated with glucose from earlier sugary foods, and as long as you don't have insulin resistance.