frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

The DISTINCT in Your COUNT

https://boringsql.com/posts/distinct-in-your-count/
18•gmcabrita•1h ago

Comments

muth02446•39m ago
If you are satisfied with an approximation of "DISTINCT", there is a facinating probabilistic algorithm by Flajolet and Martin

https://en.wikipedia.org/wiki/Flajolet%E2%80%93Martin_algori...

which fits on 10 lines and does not require sorting. Improved versions of it are LogLog and HyperLogLog.

esafak•22m ago
APPROX_COUNT_DISTINCT / APPROX_DISTINCT

https://www.sketchingbigdata.org/

thecaio•39m ago
Hard to make a case to engange with an AI written article even if not fully slop
natmaka•13m ago
In the same vein: https://www.snowflake.com/en/blog/engineering/postgres-count...

Qwen3.8 Max now ranked as the best overall model by agentic index

https://artificialanalysis.ai/?intelligence=agentic-index
263•apitman•2h ago•131 comments

Quake – 30th Anniversary Update

https://slayersclub.bethesda.net/en-US/news/quake-30th-anniversary-update
44•dsubburam•31m ago•20 comments

Mario Meets Pareto

https://www.mayerowitz.io/blog/mario-meets-pareto
770•theanonymousone•9h ago•138 comments

Herdr is joining Y Combinator. The runtime stays open

https://herdr.dev/blog/herdr-is-joining-y-combinator/
50•collinmanderson•1h ago•28 comments

Launch HN: ProvenMetal (YC S26) delivers circuit boards in days instead of weeks

https://provenmetal.com
142•willcarkner•4h ago•102 comments

Almost no skill required to cook a steak

https://blog.sydorets.com/en/posts/almost-no-skill-required-to-cook-a-steak/
199•yusyd•5h ago•231 comments

Can you reverse engineer an ASIC?

https://blog.janestreet.com/can-you-reverse-engineer-an-asic/
22•bschne•1h ago•2 comments

Improving GPT-5.6 Sol in ChatGPT—and expanding access for free users

https://openai.com/index/improving-gpt-5-6-sol-in-chatgpt/
68•tedsanders•3h ago•50 comments

Learn how chips are made with this Rollercoaster Tycoon-inspired animation

https://laurentiugabriel.github.io/ChipTycoon/
52•laurentiurad•6d ago•9 comments

Taste Is All That's Left

https://notashelf.dev/posts/taste-is-all-thats-left
69•tsak•3h ago•57 comments

Japanese Govt Asks US Govt to Stop Using Mario, Pokemono, Naruto Meme Postings

https://mainichi.jp/articles/20260803/k00/00m/010/133000c
49•m463•1h ago•16 comments

Crime Pays but Botany Doesn't

https://www.crimepaysbutbotanydoesnt.com/reading-list
605•DarkContinent•16h ago•187 comments

How to Make a Nintendo 64 Game in 2026

https://phoboslab.org/log/2026/08/xibalba64-making-of
422•atan2•2d ago•185 comments

The Simple Elegance of the Integrated Timing Belt Loopback Fastener

https://danielmangum.com/posts/integrated-timing-belt-loopback-fastener/
71•hasheddan•4d ago•16 comments

GitHub Actions and Pages are experiencing degraded availability

https://www.githubstatus.com/incidents/qcvjkzcs7j74
197•Footkerchief•5h ago•178 comments

Show HN: The Channels SDK – Bring Any Agent to Any Channel (Slack, MS Teams)

https://github.com/CopilotKit/channels-sdk
70•davidmckayv•4h ago•18 comments

Pareto Front

https://en.wikipedia.org/wiki/Pareto_front
204•binyu•1w ago•87 comments

Building progressively enhanced forms using Htmx

https://www.rafa.ee/articles/progressive-enhanced-forms-htmx/
32•mpweiher•6d ago•6 comments

Humans missed 1 in 3 threats approving AI agent commands across 40k game runs

https://scalex.dev/blog/ai-agent-permissions-stats/
213•Wirbelwind•8h ago•175 comments

Discovery Loop

https://www.discoveryloop.com/
895•xtreak29•1d ago•565 comments

The Triangle Game, from Zero

https://muchmirul.github.io/conjectures/multicolor-ramsey/
5•jdkee•4d ago•1 comments

Changes at Google DeepMind: Demis Hassabis from CEO to Chair, Jeff Dean departs

https://blog.google/company-news/inside-google/message-ceo/next-chapter-ai-momentum/
814•colesantiago•1d ago•863 comments

xAI, SpaceX, and the Race for AI Buildout

https://illegal.solutions/posts/xai_pollution
113•speckx•1h ago•68 comments

Zapscape (CVE-2026-64561)

https://github.com/V4bel/Zapscape
46•john_strinlai•4h ago•8 comments

Federal Communications Commission scraps limit on broadcast TV ownership

https://www.nbcnews.com/business/media/federal-communications-commission-scraps-limit-broadcast-t...
72•pseudolus•2h ago•61 comments

Unearthing my 1996 windowed OS in machine code for Am29000 homebrew computer

https://nanochess.org/the_am29000_computer.html
144•nanochess•5d ago•32 comments

Poles of Inaccessibility in the San Gabriel Mountains

https://notes.secretsauce.net/notes/2015/05/06_poles-of-inaccessibility-in-the-san-gabriel-mounta...
27•dima55•4d ago•20 comments

Dress made of living mycelium can renew and repair itself

https://www.dezeen.com/2026/08/05/dress-living-mycelium-renew-repair/
72•speckx•4h ago•46 comments

The title cards in Blade Runner are amazing

https://randsinrepose.com/archives/blade-runner-title-cards/
409•ExMachina73•23h ago•198 comments

Born Against, or why hobby programming communities are against LLM usage

https://blog.fogus.me/llm/born-against.html
397•lladnar•1d ago•461 comments