skysight-inc/HackerNews huggingface dataset:
Show HN: Cookiecutter for Postgres Extensions
Hi all,

Having written multiple Postgres extensions (some small and some bigger), I built a cookiecutter template to make the process easier and more automated.

This cookiecutter prompts for some basic extension metadata (e.g., name, Postgres version) and then automatically generates the necessary boilerplate files.

These include:

* Standard extension files (Makefile, .control, c, .h, .sql) pre-populated with stubs.

* Regression Tests

* GitHub Actions for building and testing on multiple Postgres versions

* Docker support

* pgxn integration

Demo video: https://youtu.be/zVxY3ZmE5bU

Hope newcomers to Postgres extensions find it useful.
"Ukraine would have had some sort of nuclear capability within the week."

For how long?

Nukes need maintenance. To maintain them, you will need to rebuild the entire supply chain on Ukrainian territory. Do you even have the necessary know-how? What percentage of GDP are you willing to spend on it?

Until today, Ukraine has lower GDP than Czechia. In the 1990s, it was even worse. With their economy destroyed by decades of Soviet rule, they were happy to survive somehow.

Tangentially, it is well possible that Russian nukes are actually under-maintained, for the very same reason: it is expensive to keep them in working order, and Russian economy is not very strong. Perhaps most of them would not explode. But we'd better not find out.
Show HN: One pixel for every food in the USDA database
Hey, just sharing a weekend project I worked on. The USDA has a lot more than ~300,000 foods, but this is a cleaner dataset without duplicates.

AMA - happy to share how I made it & how I kept it performant (rendering 300k foods can be slow)
if I want to use any modern styling solution (CSS modules, Vanilla Extract, Panda, any CSS-in-JS...) a bit of collaboration by the bundler is needed. I can generate CSS file(s) in any way I like but I would have zero integration with the templates
Well I live in a fairly small city with not a lot nearby, and it's showing me unremarkable nearby high schools
Worker attrition is way too high nowadays to keep deep knowledge in niche fields I believe. Old school seniors have retired and are being replaced by nobody.

You can notice this in a lot of hardware products with "noob" mistakes that the prior product generation did not have etc. Software is probably the same but the product is too opaque to see into so ot just feels crappy.
What way of thinking?

OP listed some untypical benefits that come with sex - I think we are all aware of the typical benefits. He/she didn't say "these are the reasons you should have sex"
Apple's whole advantage is owning the entire stack top to bottom. To achieve that with servers they'd need to develop their own server OS and perhaps app ecosystem on top of it too - that really isn't their focus. Or they could stop at "here's a machine, run what software you want", but that's completely antithetical to everything they've done so far.
I wonder if flushing nicotinic acid would work to increase blood vessel function in old age?
A study for tadalafil or sildenafil would probably show the same effects. Not because of common mechanism that prevents Alzheimer, but because such studies would probably plagued by the same methodological problems.
That would have been Janus. Gemini are twins, which represents all of your data being copied I guess.
Yes that complexity has put me off learning Rust. I’ve had a brush with Haskell already, thx! I get more out of glueing things together than deeply getting into the language itself. Took me a while to realize that! So now I am learning Go (feel like I have learned it in an hour lol!) with the hope of having a long term language I like for side projects. I never was satisfied with NodeJS or C# for this for various reasons relating to the complexities of setting up projects esp. when they don’t wanna work.
Or a single sub. Happened more than once suring NATO maneuvers,a single sub getting into a firing position completey undetected, armed with torpedoes able to sink the carrier.

No weapon is beyond reach in war, or indestructible. And still, they have their use cases.
Also the three founders of JetBrains, the developers of Kotlin, all graduated from St. Petersburg State University.
No-paywall version please.
There were a few pretty big migration waves. Kosovo/ex Yugoslavia in the 90s, Ukraine, 2015 (middle east) etc. Where each brought > 1 million new people. So Germans are on the decline, but we're adding a lot of migration via the asylum system in.

edit: data here https://en.wikipedia.org/wiki/Immigration_to_Germany
Climate Scientist Michael Mann Confronts Defamers in Court After 12-Year Delay
I think telling them to grow up is a bit harsh, but yes a thread filled with jokes would not belong on HN imo.
One Trillion Row Challenge (1 TRC)
This is interesting, I'm going through an internal debate about what type of lense to go with for cataract surgery. The latest progressive lenses or just correct for distance and wear reading glasses for close in work. I've come to the same conclusion, better to go with single lense, rather than the progressives.
That's No Moon; It's an Ocean World
I have a pop science understanding of neuroscience here. Im reading this as they’ve found a brain wide pattern of connectivity to determine if someone has a likelihood of adhd. Am I interpreting it correctly?
Also enjoy hotz due to ranting.

(Actually I'd consume more of that kind of content ie unpolished, quick videos. To me, the signal-to-noise is higher on videos like https://www.youtube.com/watch?v=ovNZU-gzr6A than videos like https://www.youtube.com/watch?v=81fAtiORLAg, which seem to take 99% of youtube)
Williams FW46 at the limit: Mystery surrounding new rear axle
For a hilarious short story about the Cobra Effect taken to extremes, check out Julian Gough's "The Great Hargeisa Goat Bubble": https://thefinanser.com/2009/05/the-great-hargeisa-goat-bubb...
weirdly, for my link that redirected to my countries' local coca-cola facebook brand page (denmark) which has its latest post 1 hour ago (8th feb 2023). I didnt know that kind of location-based redirect was a thing on facebook, interesting.
It will happen once bitcoin has proven itself as a store of value, new layers have been built on top of it and matured and have acquired a large user base with network effect.

Right now we already have proof of concept of a decentralised micro-payment network with Lightning. But it won't gain widespread adoption until more people have bitcoin, so much that they'd like to start spending it rather than buying/holding it (see Gresham's Law), its value has stabilised to a point that it can be used as a unit of account, and shops are therefore willing to price their goods/services in it.
For me as well.

I think making the controls into actual button elements would fix this. (Suspecting they are divs with onclick handlers now.)
Absolutely. There was a leaked memo iirc from Microsoft that prohibited "exceeds expectations".

And then there's the antipoaching https://en.wikipedia.org/wiki/Antipoaching
To just chime in, it also massively incentivizes liars, bullshitters and people who are straight up delusional.
Case Study: Aggregating a Billion Rows File in Under 6 Seconds
> I find it interesting that you think Apple products are more expensive because of the branding, I'm willing to pay more because they work much better than other competing systems and also if you subtract the much higher resale value they are actually the same value as other products.

You're assuming that resale value matters for most people, when it probably doesn't (many will use hardware until it's dead, or will pass it on to siblings, which renders the resale value moot).

And I fundamentally disagree that Apple products work better, and especially enough to merit the price difference. A fun case is RAM/disk upgrades. You really cannot say that Apple's premiums on 16GB and more RAM have anything to d with their hardware/software being better (and again, it really isn't).

If you're curious why I think Apple hardware/software isn't better, in no particular order:

* hardware is pretty good, but with limited options (I want a matte screen ffs, the reflections of glossy screens kill my eyes over a few hours) and brutal premiums for trivial things like not having only 8GB of RAM available.

* UX is actually pretty bad. As someone who grew up on Windows, has used various Linux distros with GNOME or KDE extensively, macOS is a nightmare for a few reasons:

* same as with hardware, very limited options. Want to not follow Apple's special way of doing things? You cannot without installing a bunch of extra software, which is sometimes paid (I mean things that any other OS has had for years, like key remapping, or window management). Do you want to have a different scroll direction between the touchpad and the mouse wheel? Well, there are two settings in the two different menus, one for mouse and one for touchpad, but they toggle each other... This is horrendous UX even Microsoft wouldn't do.

* there are massive amounts of hidden tricks, which are sometimes useful, sometimes not, but you cannot (usually) disable them. I do not care for Apple Music and have never used it, yet it will always pop up if macOS considers I don't have anything else to play when I tap the play button on my keyboard. I do not care for Apple Notes, but it will always pop up if I click at the bottom right on my screen by mistake. Discovery of those tricks is also hard

* The OSes absolutely sucks in providing any sort of feedback to the user. "Something went wrong", now go fuck yourself. I've had that with screen mirroring to iPad, installing apps on an iPad, a USB device misbehaving on macOS, Apple TV+ app on iPad failing to download stuff offline... there's no information whatsoever to help you understand what is happening and how you can fix it.

So no, I don't think Apple products really work that well, or are worth the massive premiums they ask for them. There is a decent ecosystem, but it locks you in it, so IMO most people are paying for the brand and due because that's all they know (hammer, nail, etc.)
Show HN: OkServer can now run as a systemD service thanks to a kind pull request
I was meaning to do this at some point, but it actually checks things off on my to-do list. A reminder of why git is god's greatest gift.
I think making the controls into actual button elements would fix this. (Suspecting they are divs with onclick handlers now.)
Another completely misleading article on gravity batteries. All the solid weight stuff is bunk, probably designed to suck out money from naive investors / corrupt state officials. Moving solid weights gives only a very small electric power, so building the proposed solid weight batteries gives units of MW at most, which is uneconomical. Unless it transports a large lake of water up and down a hill like in pumped-storage hydroelectric plants, and can provide tens or hundreds of MW. Such installations are very expensive to build today, because all the low-hanging fruit options seem to have been already built.
It helped me a lot too. Rest in peace, John.
Is this drug sponsored by Roger Goodell?
I think you should read Herovit's World. haha.
So apart from the protected class thing, there's no concept of wrongful dismissal in the US?

And what's different in Montana?
2023 was 1.48°C warmer than the 1850-1900 pre-industrial level
I'm (thankfully) not intimately familiar with the details but, yes, 48 hours is all you get for a quick and easy return to the vendor. In California, where I am, there is a so-called "lemon law" for appliances and it places the burden on the manufacturer. I don't think it mandates any particular length for the warranty though it does have provisions requiring buy backs under certain conditions.

When LG bought my fridge back the original warranty had expired a day prior and things were being handled under the terms of the extended warranty my landlady bought.
The text says something about how you shouldn't make the waveform blow up outside the canvas, but I am not sure whether its measured or shown.
Scheme: Gerald J. Sussman and Guy L. Steele were working on a followup to Conniver, which they called Schemer, but but the machine they were working with only allowed 6-character names.
Men on Viagra may reduce their Alzheimer's risk - study … in mice.
> Hiroshi Nakamura:

That's a name I haven't seen in a long time!

For those curious, Hiroshi Nakamura is a Japanese terrorist.
I can drive to work in twelve minutes. If I humor the premise of a bus that stops in front of my home and also my workplace, which is unlikely to ever exist no matter how much money is thrown at public transit, it would still take several times longer than driving myself because there are numerous other homes and businesses between which the bus would stop at.

Using a bus would mean I have to wake up earlier, and therefore fall asleep earlier, and also get back later. It would mean less time at home with my family. I suppose next you'll say that I should be living in walking distance of my job, like my life and indeed entire communities should be structured around employers like during the industrial revolution. God forbid you ever want to change your job, you'll have to hope the new one is next door or you'll be moving your family... more likely you're locked into your current job which is just the way employers would like it. The normalization of cars were a huge win for labor, but the anti-car crowd always ignores this. I guess being locked into my job and at the mercy of public transit is meant to be compensated by the benevolence of The Party who will surely have my back? No thanks.
He doesn't really stream anymore though
Given the number of people flying on private jets who demand legislation to take away my old pickup truck, I suggest we ban all civilian air travel until it meets 100% of the environmental and safety requirements my old pickup truck has had to meet in its lifetime.
It doesn't follow that if human males stole Neanderthal wives sometime in the past, that you would necessarily see Neanderthal mitochondrial DNA in present populations.

Consider a serial 'wife-stealing' human culture. One generation of human males leaps upon a small population of Neanderthals, killing the men and stealing the women. The next generation, a new group of half-neanderthal males leaves the colony in search of wives, finds a human group, kills the men, and steals the women. The children of this generation will be 1/4 Neanderthal with no Neanderthal mitochondrial DNA. Imagine that the first colony gets wiped out, as most ancient communities were. There you go.
Looks fine to me apart from the buttons. But if we're talking about "classless", some _has_ to mention Marx[1].

[1] https://mblode.github.io/marx
Doesn't stream
> despite having all the ability to make a competing ecosystem.

Eh, citation needed? Nvidia has a 30 years head start making GPUs and has been working on CUDA for 15. Meanwhile AMD, competing in the same space, is not even close to Nvidia's offering. And I don't see how Apple's experience in developing consumer products helps in developing HPC computing hardware/software (ok, the M1/M2 are a first step in the right direction).
It's one way to kill them.
Of course not. By I wouldn't say "DVD disc" because it's the same as "Digital Video Disc disc".
I remember the Minecraft guy streaming a decade or more ago - it was super popular. I feel he's totally gone from online for a decade too...
You're just some random commenter on Hacker News, why should I trust you?
And that makes it all okay? Still insanely cruel.

Would you volunteer to be anaesthetised and then have your head bashed in multiple times?

No? Why should animals.
Depends on where the fab is. I agree if we're talking about rural Arizona, but if the demand is there, I guarantee you that someone will open a franchise (or six) down the street and operate overnight to meet that demand. In and around larger cities though, it's not really a problem. There is usually _something_ open, even if it might not be a long list.
I had 15 years experience writing JS in the corporate world when I was laid off last year. Reflecting upon that here is what you need to have a stellar JS career.

* Be 10x at administration. Learn to communicate with precision and get your work done on time. This is what will get you promoted in comparison with your peers.

* Be average at writing software. Be as average as possible. If you are interested in solving real problems, innovating, or any kind of engineering you are in the wrong line of work and should immediately look for something unrelated. Your peers are only interested in the framework of the moment and the vanity of code style. If you over achieve beyond that you only lower your career mobility and desirability in the marketplace. You are hired to jiggle user events and put text on screen, so don’t over think what goes into the actual work with a bunch of delusions. Be average.

If you want to continue writing JS/TS for a living those two bullet points will dictate where you need to focus.
Because early JetBrains development was based mainly in Saint Petersburg.
I think they meant that cars are bad and public transit is good and solves the problem of wanting to do something else while in transit as opposed to driving.
Show HN: Audiocate – a Haskell library for combating audio deepfake misuse
Audiocate is a Haskell library for audio verification and source validation to attempt to combat AI generated audio deepfake misuse.
It's currently just a MSc dissertation project but hoping to make it actually usable in the near future
A 2008 interview with John Walker:

https://through-the-interface.typepad.com/through_the_interf...

He was ahead of the curve even on developments that were brand new in 2008 like social media:

“I'm interested in anti-social networking. I'm interested in protecting private data and one's own history in this environment of unprecedented disclosure.”
(Part 4 of the interview)
Were they incorrect? Seems like they were rather needlessly complex because of the earth-bound parameters.

IOW if you take the simpler heliocentric motion equations and want to make your life miserable by changing the reference frame to be geocentric you'd land up on epicyclic equations.

So even though the math is borne out of a misguided anthropocentric cosmology it does matches reality to a crude but reasonable approximation, unlike a edge-of-disc kraken.
But they wanted to use a native app, submitted it to the AppStore, Apple said no and Xbox had to go the PWA way. And now Apple reversed that decision for all regions, so Xbox are free to submit it again.

Doesn't make sense to be "forcing" them.
You're using a brand advertiser as an example when you should be using direct response advertiser as your example. Brand advertisers pay the least since their advertising is predicated on reaching a lot of people cheaply multiple times while direct advertisers pay the most since their advertising is predicated on getting people to convert immediately and judge their return accordingly.

The fact that you don't see Coca Cola ads means that Meta is able to find advertisers willing to pay more than them to reach you that you are more likely to convert immediately on.
How functional you are in later years certainly correlates to exercise and diet.
It's always funny to see the embedded "unconventional" theme come up again and again. Hot take: You don't need someone unconventional. You need someone good. Unconventional people are just the people you notice because they're outliers, and now rather than looking for what you need - which is someone good, you're looking for this other thing. This is particularly funny of course because this person spent 6 years working at Stripe, a company founded by a genius techie who went to MIT, dropped out, joined YC sold a company for a few million. Started a new business - Stripe, and got a load of funding from Peter Thiel. His path through life could not have been a more conventional story for a tech CEO.

So you tell me, should I be hiring you - the diamond in the rough unconventional middle manager at stripe. Or should I be hiring the absolutely conventional genius who built a billion dollar business.

Please, explain to me, what is it about being conventional that disqualifies someone?
Here is Gorbachev about the gentleman's agreement:
https://twitter.com/i/status/1749887239226617873
ROFL, thanks for that.
Security support for node 12 ended in 2022. For php5, in 2018. Those are very different.

Rhel 7 is still alive, supports node 8, maybe 12, but nothing higher officially.
TODO

* Ask ChatGPT for a random topic [1]

* Automate upload

[1] And this is what it said: A potential topic for a YouTube short could be "Quick Tips for Productivity." This topic is relevant and valuable to many viewers who are interested in maximizing their efficiency and getting more done in less time. You could share bite-sized productivity hacks, time management techniques, or organization tips that viewers can easily implement in their daily lives. Short, actionable content tends to perform well on YouTube shorts, making this topic a promising choice for engaging your audience in a concise format.
Being better than average is easy because the average is dragged down by people who drive drunk/tired/etc. An average safety robocar would be a downgrade for most responsible people.
Thermodynamic AI is getting hotter
It's fun when you know that SEPA transfers are:

- Guaranteed by the European central bank, that is advancing the money for free

- Done instantaneously, by the ECB

- Cost around 0.01 euro per transfer

So the entire delay between sending and receiving the money, that banks pretend is used to guarantee that the transfer is legitimate, and that the money exists etc, etc is actually purely artificial. The ECB is shouldering the risk, and advancing the money, free of cost.

All the rest (extra charges, delays, etc.) are banks handsomely lining their pockets.
Yes, it's infuriating. There are also various tuning like functions that had reduced the performance.
Here's one that works entirely clientside via Webassembly - https://sqliteviewer.app/

Upload your bloated firefox `places.sqlite` and select `moz_places` and it loads it without a hitch... if you trust the website not to steal your browsing history.

Unfortunately sqliteviewer.app is not open source. This one (https://inloop.github.io/sqlite-viewer/) is, though. But it uses a JS reimplementation of sqlite rather than true sqlite in WASM.
That's 34F in freedom units.
A recently formed ocean inside Saturn's moon Mimas
Ukraine had various facilities and personnel used for manufacturing and maintaining the missiles. Not having the launch codes means they can't launch them at a moments notice, it wouldn't prevent them from taking the missiles to a workshop and changing the launch codes.
Architecture of LLM Apps – Intro to Large Language Models – Data Labelling
I'm from a culture where mountains exist. Geography isn't a culture.

Having said that. In Sweden this routinely happens:

To clear the bike and car paths from snow, a mountain is of snow is made over the pedestrian path, then INEVITABLY bicyclists angry ring at pedestrians all the time… because pedestrians should walk in 1 meter high piled up snow of course?

The same also happens if there is a digging in progress and there is a 2 meter hole… cyclists still expect pedestrians to jump down in a hole and then climb up.

However where there is no bicycle path, they will go on the side walk (which is not allowed).

Of course a good % of them actually have an electric engine and zoom around very fast.
Private forum post at Scanalyst. I accidentally posted a ref on HN to it earlier not noticing it was not public.