Hacker News
@hackernewslive
28K
subscribers
231K
links
Download Telegram
Join
Hacker News
28K subscribers
Hacker News
The DISTINCT in Your COUNT
Article
,
Comments
boringSQL | Supercharge your SQL & PostgreSQL powers
The DISTINCT in your COUNT
COUNT(DISTINCT) has no combine function, so PostgreSQL can't merge per-worker results: the whole statement drops to one core and a disk-spilling sort. Push the distinctness into a GROUP BY instead and parallel query comes back.
🔥
7
👍
2
🌭
1
Hacker News
Dress made of living mycelium can renew and repair itself
Article
,
Comments
Dezeen
Dress made of living mycelium can renew and repair itself
Researchers in China have created a textile from living mycelium that is self-cleaning, near self-repairing and can fend off UV rays.
🥰
25
🤡
7
👀
6
🤮
4
🌭
1
Hacker News
Herdr is joining Y Combinator. The runtime stays open
Article
,
Comments
Herdr
Herdr is joining Y Combinator. The runtime stays open. — Herdr blog
Herdr is joining Y Combinator. The runtime is Apache-2.0 and stays open, and here is what the funding is actually for.
🤡
16
❤
2
👍
2
💩
1
🕊
1
🌭
1
🤣
1
Hacker News
Can you reverse engineer an ASIC?
Article
,
Comments
Jane Street Blog
Can you reverse engineer an ASIC?
👍
6
🤡
6
💩
2
👾
2
🌭
1
Hacker News
Unions Can Save Tech Workers and Tech Work
Article
,
Comments
Jacobin
Unions Can Save Tech Workers and Tech Work
Two University of California tech workers explain their unionization process — and how unions can help recapture the original promise of tech being used to better people’s lives rather than make the worst people in the world ever richer.
👏
50
🤡
18
🤣
8
🥰
5
💩
5
👎
4
❤
1
👍
1
🌭
1
Hacker News
The Era of (Good) Personal Software Has Arrived
Article
,
Comments
🤣
23
👍
6
🥱
3
👎
2
🌭
1
Hacker News
Quake – 30th Anniversary Update
Article
,
Comments
slayersclub.bethesda.net
Quake – 30th Anniversary Update
To celebrate the 30th Anniversary of Quake, we have collaborated with MachineGames to create a new episode, Dawn of the Machine, now available as a free update to Quake.
🏆
24
❤
2
🌭
1
Hacker News
Japanese Govt Asks US Govt to Stop Using Mario, Pokemono, Naruto Meme Postings
Article
,
Comments
毎日新聞
ポケモン、NARUTO…トランプ政権の無断使用に政府「懸念」伝達
トランプ米政権がイラン攻撃や不法移民対策などをアピールする交流サイト(SNS)の投稿で、さまざまな日本のアニメの映像を使用しているのを受け、日本政府が米側に懸念を複数回伝えていたことが外務省への取材で判明した。トランプ政権によるソフトコンテンツの無断使用は米国内のアーティストからも反発の声が上がっ
🤣
83
👾
11
❤
1
🤡
1
🌭
1
Hacker News
AMD Acquires Taalas
Article
,
Comments
Advanced Micro Devices, Inc.
AMD Acquires Taalas to Advance Compute Solutions for Rapidly Growing AI Inference Market
News Summary:
Taalas’ technology to further differentiate AMD’s AI roadmap by delivering breakthrough inference performance and…...
😐
17
🖕
4
👍
3
👨💻
2
🌭
1
Hacker News
AMD acquires startup Taalas to boost inference perf by etching models in silicon
Article
,
Comments
theregister
AMD acquires AI chip startup Taalas to boost inference performance by etching models into silicon
Early tech demos show model-specific integrated circuits churning out up to 17,000 tokens a second
😐
23
👍
4
🖕
4
🌭
1
Hacker News
Civilians under siege by Mexican cartel fight back with AK-47s, grenades
Article
,
Comments
PBS News
Civilians that were under siege by a Mexican cartel fight back with AK-47s and grenades
Experts say Guerrero now holds many competing armed groups and that vigilantes are often absorbed, and armed, by the cartels themselves.
😎
36
🔥
6
🫡
4
💩
3
❤
2
👍
1
😁
1
🌭
1
👻
1
Hacker News
A Visual Guide to Quantization – Demystifying the Compression of LLMs
Article
,
Comments
Maartengrootendorst
A Visual Guide to Quantization
Exploring memory-efficient techniques for LLMs
👍
18
🌭
1
Hacker News
Welcoming the Nepalese Government to Have I Been Pwned
Article
,
Comments
Troy Hunt
Welcoming the Nepalese Government to Have I Been Pwned
Today, we welcome the 47th government onboarded to Have I Been Pwned’s free gov service: Nepal. Their National Cyber Security Centre now has access to monitor Nepalese government domains against the data in HIBP. This gives the NCSC the ability to identify…
🔥
20
🌭
1
Hacker News
GitHub Actions suffers second-longest major outage in its history
Article
,
Comments
Githubstatus
GitHub Status - Uptime History
GitHub's Uptime History
🔥
18
❤
2
🤣
2
🥱
1
🌭
1
Hacker News
vLLM: Anatomy of a High-Throughput LLM Inference System
Article
,
Comments
Aleksagordic
Inside vLLM: Anatomy of a High-Throughput LLM Inference System - Aleksa Gordić
From paged attention, continuous batching, prefix caching, specdec, etc. to multi-GPU, multi-node dynamic serving at scale.
👍
13
🤔
1
🌭
1
Hacker News
Show HN: Pokémon Emerald Ported to Raspberry Pi Pico 2
Article
,
Comments
GitHub
GitHub - mattdeeds/pokeemerald-rp2350: Pokémon Emerald ported to the RP2350. No emulator, 60 fps HDMI output. Recompiled for Cortex…
Pokémon Emerald ported to the RP2350. No emulator, 60 fps HDMI output. Recompiled for Cortex-M33. - mattdeeds/pokeemerald-rp2350
🔥
22
❤
4
🌭
1
Hacker News
Bioengineered chewing gum may offer a way to fight HPV and other microbes
Article
,
Comments
ScienceDaily
Cancer-fighting chewing gum cuts HPV levels by up to 93%
A specially engineered chewing gum reduced HPV by up to 93% and nearly eliminated two bacteria linked to head and neck cancer. The treatment preserved beneficial mouth bacteria, raising hopes for a safer and more affordable therapy.
❤
40
🤮
19
💊
6
😱
4
🤡
2
🔥
1
🌭
1
Hacker News
Show HN: Whisper transcribes 70-year-olds more accurately than 20-year-olds
Article
,
Comments
GitHub
GitHub - Kayvan-Zahiri/asr-age-gap: Speech recognition does not degrade with speaker age. Voice-agent turn-taking does, by 2-5x.
Speech recognition does not degrade with speaker age. Voice-agent turn-taking does, by 2-5x. - Kayvan-Zahiri/asr-age-gap
🤣
23
🌭
1
Hacker News
New Orleans will use AI to answer 911 calls instead of a human
Article
,
Comments
Shreveport Times
New Orleans hoping limited AI use could speed response for emergencies
New Orleans is using AI to answer 911 calls instead of human dispatchers. What does this mean for crime and emergency response?
😨
75
🤮
49
🤡
20
😱
8
🌚
4
🤣
3
🥰
2
🤬
1
💩
1
🌭
1
🎃
1
Hacker News
Meta Ordered to Pay $942M to Address Harm to Kids from Social Media
Article
,
Comments
The Wall Street Journal
Meta Ordered to Pay $942 Million to Address Harm to Kids From Social Media
A New Mexico judge ordered the social-media giant to create a new $567 million fund in addition to paying $375 million in previously determined civil penalties.
❤
21
👏
17
🤡
7
🤮
3
🔥
2
🌭
1
Hacker News
What Happened to Talenti?
Article
,
Comments
Wirecutter: Reviews for the Real World
What Happened to Talenti?
Over the past 20 years, Talenti has changed from a small, independent brand to a piece of a corporate conglomerate. Has that affected its quality?
🤮
10
🌭
2