skysight-inc/HackerNews huggingface dataset:
You may know this already but the postgres extension[1] may help:

If I understand it correctly, when you use it it:

- Pulls the minimal data required (inferred from the query) from postgres into duckdb

- Executes your query using duckdb execution engine

BUT, if your postgres function is not supported by DuckDB I think you can use the `postgres_execute` [2] to execute the function within postgres itself

I'm not sure whether you can e.g do a CTE pipeline that starts with postgres_execute, and then executes Duckdb sql in later stages of the pipeline

[1] https://duckdb.org/docs/extensions/postgres.html#running-sql...
[2]https://duckdb.org/docs/extensions/postgres.html#the-postgre...
Could you name some of those crippling regulations you're talking about? Just so Im better informed as a european
2 phones, ~4 tablets, ~12 PCs.

Looking at sales, looks like about 10x the phone volume of s24 (and pixel 8 doesn’t register on the chats).
I think if that was the real reason, then the feature would be available but default to off on the non-pro version
Do you not remember Edward Snowden? Eg this sort of info:

> The scandal broke in early June 2013, external when the Guardian newspaper reported that the US National Security Agency (NSA) was collecting the telephone records of tens of millions of Americans.

> The paper published the secret court order directing telecommunications company Verizon to hand over all its telephone data to the NSA on an "ongoing daily basis".

https://www.bbc.com/news/world-us-canada-23123964

You seem to think that 10 years, under cover of secret orders, that this is NOT going on now. Not Apple!

People's lovely trusting natures in corporations and government never ceases to amaze me.
The README says:

> Can resume if process exit, save checkpoint every 250 urls
I think you mean that he is mainly a linguist.
This applies to the entire BEAM family. HN loves to sign praises to it yet never looks into the detail nor has performance intuition to know that the use of predominantly interpreted languages is frequently inappropriate (note how Erlang is next to Ruby):

https://benchmarksgame-team.pages.debian.net/benchmarksgame/...

With that said, I had no idea it could target JS and will need to look into that, thanks (V8 is surprisingly competent at number crunching if it can inline everything, otherwise still subject to harsh limitations of dynamic nature of JS).

Also, F#, building on top of .NET, has rich ecosystem and a set of its own async abstractions with all kinds of actor patterns being popular (within very small F# community that is). It’s fast, and so is its networking stack.

Why am I criticizing Gleam? Because we had two decades of programming languages built on slow foundations imposing strict performance ceiling. There is no reason for nice languages like Gleam to be slow, yet they are. I’m not sure why, maybe because of the myth of compiled languages requiring more effort and interpreted languages being more productive to write in?
I love the prospect :D

If cable holds you have gravity, if it fails you risk being slingshot into deep space
the 1password search is horrible, it does fuzzy search and not match exat results etc

there is more, too lazy to write
Very little of the “AI” boom has been novel, most has been iterative elaborations (though innovative nonetheless). Academics have been using neural network statistical models for decades. What’s new is the combination of compute capability and data volume available for training. It’s iterative all the way down though, that’s how all technologies are developed.
> it becomes very recognizable and same-y after a short time.

Yeah, I'm starting to get that too already. :(
I also really appreciated that magical window with my 2018 iMac Pro at work! Never going to be able to justify a Studio Display…
See `man ld.so` for the search behavior.

Note that there are inconsistencies between glibc and musl when it comes to rpath and runpath.
Local community? the deterioration of everything has happened. Somehow all the rich people figured out that if you keep them isolated, then the people are easier to control. This happened intentional or just by measuring "what works" (for them).
On the contrary, it's worrying to wonder what Apple gave up to make OpenAI accept those terms.
A yes, a "clear blow". Because we can definitely deduce it from... an over-produced video with sloppy AI-generated images and some heavily edited actions/responses from a product that will not be released until fall (and even then, not with all features).

What other "clear blows" have there been so far that this one is "yet another"?
Right - you fail at leetcode interviews despite your high abilities, and leave programming behind in anger to become a gardener.
Alternative title: Train Yourself To Only Work On Low Hanging Fruits
Some bot keeps resubmitting it.
> Why exclusively fund RFERL for a foreign audience if you do not fund your national public broadcaster?

Because the US media market is quite saturated and developed (or at least was when any of this was made into law) compared to countries where media is actively supressed.
This, but on a per user basis would be great.

But uwsgi performance overhead is a concern. Altough last time I've done anything with uwsgi that was probably over a decade ago.

And last time I checked, Go required to import the uwsgi package, maybe not anymore?
Or is uwsgi used only for Python here?

Also I wonder how to define nginx routes aka locations?
This isn't right.

If you trust math you can prove the software is what they say it is.

Yes it is work to do this, but this is a big step forward.
Ask HN: Dealing with Back Pressure in Messaging System
How do you guarantee throughput performance while facing back pressure in a push-based messaging system with failing downstream destinations? e.g., webhooks
Nuxt 3.12
You are so clever.
I'm confused. My understanding is that they didn't drop support for all Intel Macs in Sequoia. My 2018 MBP for example is still supported. The last Intel Mac Pro in your example is also still supported.

My MBP hasn't hasn't been _fully_ supported for many years. The M1-specific features started rolling out in 2021 - ability to run iPad apps being the most obvious one, the ability to get the globe view in maps being the most questionable. IIRC, my MBP did not yet have a M1 Pro/Max version available for sale when they announced the M1-specific features.

The point being, having AI features unavailable doesn't make the Mac unusable any more than it makes an iPhone 15 unusable. Those parts should continue to operate the way they do today (e.g. with today's Siri).
Battery-swap networks are preventing emergency blackouts
You could fix iy by saying "this is exactly what > 90% of people want"
A lot of the credit here is owed to Edgar Allen Poe for writing lyrics that are so damn catchy.

But yeah, Suno managed to do a decent job setting it to a poppy beat that is well-suited to the poem
I am speaking more generally of the industry. You can look at my profile and follow the bread-trail to see whom I work for. It is not insurance, we are a client of state systems, and I work to do the opposite of what you suggest (identify fraud/waste/abuse in insurance claims).

I do not know the chances that any individual provider uses a system to identify what codes to tack onto your bill.
July Newsletter Ideas and Examples
Researchers make a supercapacitor from water, cement, and carbon black
Probably 25 or so years ago I created my first render ever, in POV-Ray of a LEGO character's head using a hypercube.

I only had a ruler to use for measurements of the head shape and the face and it took me quite a while, but it came out better than any other LEGO render I ever saw during that time. I was quite proud of it for such a simple thing.
Nice, anyone using this? Have practical feedback?

Does this have potential to grow, or would most people just say 'use lisp'.
OpenAI also just published similar work, though Anthropic did beat them to the punch.

https://openai.com/index/extracting-concepts-from-gpt-4/

https://news.ycombinator.com/item?id=40599749
It prints a DAG as a tree: every line is an edge, identical nodes are repeated. With `-vvv` it prints all possible paths as a tree.
Jumping in here.

Do you home school? Because if you don't home school, surprise! "Bad" kids are everywhere, including in any school that exists.

The best you can do is talk about bad influence. Peer pressure. Tailoring that conversation to the child's personality.

My thoughts on this are, the time to teach self-control and responsibility is when young. It won't take completely when young, as the brain is literally not fully developed in that capacity yet, but the lessons can stick, and be known when older.

Those lessons are action->consequence outcomes, and in a sense, borking up responsibility at times becomes a leaning moment. Put another way, mistakes are how we learn, and small mistakes when young, are better than massive mistakes when 20.

Yes, bad habits are a worry. I don't think there is any simple answer here, except independence is important for any adult mind, and that flows from independence in youth.

And of course, this all depends upon the child too. Some have more sense at 5, than others at 50.
OSS Pledge
I keep reading it and it keeps getting crazier and crazier. Feel free to tell me what specifically I interpreted incorrectly :)
I think not everything can be pure science. It would be hard to write anything. It is still better than most of stuff on the Internet, and that is a good thing.

Some people complain about something not because it is lacking, but because they struggle internally with the results. "You didn't run tests 50 times, you run them only 20". I see some parts mentioning religion, and I can guarantee that some people with have problem with only that, as it can often be as a red flag for a bull.

I do not also need complex studies to see effect of games, TV on my kids. I can simply observe them.
Here's the iCloud Passwords extension for Chrome -- works on my Mac happily, and also with Arc (which means I now get to use it just as much as Safari)

https://chromewebstore.google.com/detail/pejdijmoenmkgeppbfl...
I once saw a F-150. It needed 3 parking spots at my eastern european local mall :)

And I don't mean the driver was an asshole, it simply wouldn't have fit in otherwise.
I'll always slightly regret not getting a Mini, but 2020 was a really bad year for it to launch (when I didn't feel like the extra work needed to see one in person) and 2021 I actually needed a better camera.

In retrospect though, it may be best that I don't know what I missed.
Musk warns that he will ban Apple devices if OpenAI is integrated
SBAWE32 + YAMAHA XG-50 was the burner at that time for me.
You're Doing State Wrong
Apple's AI promise: "Your data is never stored or made accessible to Apple"
To spare people, this is code from Nuvolaris which is a distribution of Apache openwhisk

https://github.com/nuvolaris/nuvolaris?tab=readme-ov-file

Now I’m confused
Also relevant:

If you try to encourage non-screen time socially, their friends stop coming over.

At best, your kid will just want to leave the house to go watch tv/play video games over at the friend's house, but just as likely is that the kid stops having a friend because they're not mindshared in anymore.
Yep, but on the other hand aren't there regions where you'd get arrested for letting your kids go to school alone?
Great to see charities bringing their charitable goods to the stock market.
Nice! Thanks for your answer. Wish all the best to both of you!
I once went to a talk by an SOM architect (SOM is the firm that does the engineering work on nearly all supertalls). He said that on a cost of construction versus land value basis, even in the most expensive markets, it makes no sense to go above 60 stores or so. Every building built taller is built for some other reason, usually to turn it into a "prestige address" that can charge premium rents.
The news coverage discusses it a bit. The police identified the body by DNA analysis, which presumably took a while after the car had been located. Reading between the lines, I think there may be some details that the author didn't want to get into. The victims have living relatives who don't need the gruesome specifics to be dragged out.
This reflects my own changes. Me at 25 and me at 35 are completely different when it comes to code. I'd rather finish early, spend time with family, and come back tomorrow with a better solution than keep on hammering away on an overnighter to try and hit some arbitrary metric.
Ask HN: Have you had to design a distributed circuit breaker in production?
Have you had to design a distributed circuit breaker in production? What technologies did you use, and how did that work out?
How Apple Intelligence Works?
> In order to make sure the commit message are correct, and in fact that the entire commit looks correct, we merge pull requests manually.

I thought maintainers can edit pull request? Why is that not used here?

The also say they don't want GitHub dictating them how to use git. I'd say, don't use GitHub then. Not pulling someones PR also means he does not get any public attribution to it. He doesn't show up as a contributor, too. I find that problematic and would say, there are simple ways around all the issues that have been listed, but the maintainers are just too stubborn to implement them.
Health Benefits and Chemical Composition of Matcha Green Tea: A Review (2021)
The original joke was to define an alias

alias libtree='curl -LfSs https://raw.githubusercontent.com/haampie/libtree/master/libtree.c | ${CC:-cc} -o /tmp/libtree -x c - -std=c99 -D_FILE_OFFSET_BITS=64; /tmp/libtree'

so any time you invoke `libtree` it downloads the latest version, compiles it, and runs it.

With a stable internet connection, it is still faster than pax-util's lddtree, which is written in Python.

C is an excellent scripting language.
Probably your browser isn't using the gpu correctly (example if it was an ubuntu snap)
Our customers want release notes and time to test features so we have a monthly cadence.
iOS 18 you can now control the width of the flashlight
Used to use this and moray to make "cool" 3d graphics for clients around the early 2000's, such fun

edit: moray is available on the wayback machine https://web.archive.org/web/20220331032107/http://www.stmuc....
Am I crazy to think that the claim of private cloud compute running M chips is marketing fluff? Is their ARM based SoC really as performant as a GPU at the scale they need?
> But you don't just have to trust Apple on this score, Federighi claimed. That's because the server code used by Private Cloud Compute will be publicly accessible, meaning that "independent experts can inspect the code that runs on these servers to verify this privacy promise."

How it's possible for world + dog to reliably verify the code running on a remote machine?
Author of Lustre here! Yeah I agree, lack of a robust headless component library like radix-ui or react-aria is such a mark against Elm. I think it's even more important for Lustre because really all our users are going to be backendy folks with little interest in the nitty gritty frontend stuff.

Lustre will eventually have a companion ui library to plug this gap but it turns out maintaining all this stuff is a bit of a time sink, so I'm taking baby steps ^.^
Funny enough, I drove my kid to school for 8 years in Eastern Europe. But that's because she wanted that school that was far away.

On the other hand, if i need groceries I just take a backpack and walk 5-10 minutes to one of the 5 different stores. I can even afford to be picky and get my butter from one, bread from the other etc :)
Most people don't realize this, but almost all research works that way. Only the media spins research as breakthrough-based, because that way it is easier to sell stories. But almost everything is incremental/iterative. Even the transformer architecture, which in some way can be seen as the most significant architectural advancement in AI in the past years, was a pretty small, incremental step when it came out. Only with a lot of further work building on top of that did it become what we see today. The problem is that science-journalists vastly outnumber scientists producing these incremental steps, so instead of reporting on topics when improvements actually accumulated to a big advancement, every step along the way gets its own article with tons of unnecessary commentary heralding its features.
For those who want to broaden their options and are not really constrained to only using SF2, the SFZ format has a similar purpose and there are many free instruments as they are easy to create (a text markup referring to the, typically WAV, audio files as is). Plogue sforzando [0] (freeware) is my favorite plugin for SFZ files. I learned about SFZ via an orchestra set called the Sonatina Symphonic Orchestra [1,2].

[0] https://www.plogue.com/products/sforzando.html

[1] https://sso.mattiaswestlund.net/

[2] https://musical-artifacts.com/artifacts/81?class=related-lin...
If you wanna merge the audio with some pics to easy shareable videos, you can use this tool: https://image-audio-video-merger.franzai.com/ coded by ChatGPT of course.
Indeed, and you cannot prove that a specific car crash would have been worse for the passengers without seatbelts, however a proper understanding of how seatbelts work makes the conclusion nonetheless fairly obvious.

Also, statistics are a thing; propositions like 'vaccination reduces severity of illness' can in fact be proven or falsified by studying a sufficiently large cohort, such as is readily available during, say, a pandemic.
Nothing is too far out, that it wasn't actually done:
https://news.ycombinator.com/item?id=40642801
Well, some idiot must have written that email!

...it might have been me, I was writing those emails in the year 2018. That was my first job there.

Jokes aside, we generated those emails largely from a template. If I remember right, "saw some real strength" was "got at least an OK score for code quality", while the negative feedback below was about number of steps. The number of mishaps with that system is part of why we do the feedback a bit differently [1] at Otherbranch, at least for now. I think we did revamp it very late in that team's lifetime, just before Triplebyte pivoted and laid off most of the team that did those (two of us, me + one of my colleagues, moved over to a different team, which is why I'm in a position to tell the whole story).

[1] https://framerusercontent.com/images/ARBLIder7AsO5KlaEpClZ3W...

(As an aside I wish Framer'd let me link images directly on the proper domain.)
The caveat being that the Bigscreen requires a wired tether to a PC and external Lighthouse tracking beacons, so you trade the clunkiness of strapping a computer to your face for the clunkiness of only being able to use it in a designated VR room. It's more comfortable for sure, but it's not for everyone.
I already limit usage very heavily. Just a few contacts left and I can remove it completely.
However this is not so easy in general, as others expect to be able to reach you on FB/WhatsApp/Instagram. And even worse - almost all the social/communications companies seem to be adopting a similar stance. So there are fewer and fewer places to go.

Social connections are very important to people, and these companies are exploiting our desire to stay connected with other people - and the difficulty of changing communication platforms when there are many parties involved.
> If the return type changes, the code using the function should definitely blow up until it's changed, don't think that's a bad thing.

This. The big upside of algebraic data types. The function won't blow up though, the compiler shows you every piece of code where the added type needs to be handled and therefore ensures the program runs correctly.
Superman's X-ray vision goes handheld
Siemens Gamesa Said to Plan 21MW Giant Wind Turbine
Science starts with discussion. If evidence accumulates and reasonable arguments are made then it may become possible to form a hypothesis or even a theory that might be tested with experimentation. Peer reviewed studies based on randomized trials only come about very late in the process once paradigm change is well under way.

What is happening here is some of the initial discussion of important emerging phenomena that we do not yet understand.
> 7100 rows

For analytic queries, I don't feel that is anywhere near what I've seen at multiple companies who gave opted for columnar storage. That would be at most a few seconds of incoming data.

With so few rows, I would not be surprised if you could use standard command line tools to get the same results from a text file of similar size in an acceptable time.
You're right. I have invested in Nvidia in 2016 and rode all ups and downs. I can clearly remember the drops in 2018 and 2022. In hindsight, I should have bought more Nvidia than Micron in 2018. I thought that my position in Nvidia was large enough despite knowing it being the better the company overall.

Concentration makes you rich, diversifaction makes sure you remain rich.
When I was a kid, there was a park near my house in California with a jumping maze of telephone pole segments of various heights in a sand pit. And, a park by my aunt had a decommissioned Korea War-era fighter jet in the sand pit and a steel plate and open diamond grate vertical 2D crawling maze for kids. Today, I checked on Google Maps, it only has some boring, circus-colored, perfectly-safe(-and-boring) play set you already know kids avoid. Not all change is positive progress.
56 not 59:

* https://www.youtube.com/watch?v=RXeOiIDNNek&t=56m32s
So, my kid lobbied for her own cell phone for a year or so when she was in primary school. We finally caved in and got her one.

Then she realized we can now call her and tell her to come home when she's out.

"I'll leave the phone at home, daddy, I'm afraid I'll break it while playing."
This rash of articles about AI compute clusters and carbon footprints don't make any sense to me and seem like clickbait from "journalists" dying for a story to write, but too lazy to actually get off their kiesters and investigat something in the real world.

Energy is energy. You can get it from relatively low-carbon emitting energy sources like Nuclear and renewables (hydro, solar, wind, geothermal). You may power your server farm with a diesel generator, but that decision has nothing to do with the AI sector (or crypto sector, as much as I loathe it) itself and everything to do with the energy supply sector.

It's well known that "Carbon footprints" were developed by the oil and gas industry to take the blame off of them as the energy producers and redirect it on us as the energy consumers [1].

1. https://www.theguardian.com/commentisfree/2021/aug/23/big-oi...
> Human (~86B neurons): 570,000 TB of RAM // 17 million TB of storage

Can't wait for 2040 to simulate a human.
Hey, it was discussed a bit some years ago https://github.com/jqlang/jq/issues/1892
Stop showing off, guys ... ;-)
About 30 years ago, I let my Atari 1040STF (8Mhz, no hard drive...) scratching a floppy disk all night long to render this very blob : http://csi.chemie.tu-darmstadt.de/ak/immel/graphics/povray35...
> Or Linux.

I guess Apple does not think that 2024 will be the Year of the Linux Desktop.
It's clocking in at 120MB on my machine and launches instantly. I don't get this blind hate for Electron, it has made software runnable on more platform than ever with less development resources.
Apple is odd in other ways. For example: Calculator on iPad. Once they had a few iPad releases without a calculator, they needed a sufficient _reason_ to release a calculator app for iPad. The product was gated by the narrative.

There was also likely no team on calculator at all (are there bugs that justify a maintenance team?), so it needed a big idea like 'Math Text' to be green-lit or it would simply never come. This is despite missing calculator being an obvious deficiency, and solving it via a port to be a relatively tiny lift.