frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

The DISTINCT in Your COUNT

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

Comments

muth02446•27m 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•10m ago
APPROX_COUNT_DISTINCT / APPROX_DISTINCT

https://www.sketchingbigdata.org/

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

Anthropic will design its own hardware to power Claude

https://arstechnica.com/ai/2026/08/anthropic-confirms-plans-to-build-an-in-house-silicon-team/
1•wertyk•55s ago•0 comments

Caveman Science Fiction

https://dresdencodak.com/2009/09/22/caveman-science-fiction/
1•erhuve•1m ago•0 comments

The original Quake gets a new DLC 30 years after its release

https://twitter.com/bethesda/status/2085427784210317743
1•aggrrrh•1m ago•0 comments

Some Moral and Technical Consequences of Automation (1960) [pdf]

https://www.cs.umd.edu/users/gasarch/BLOGPAPERS/moral.pdf
1•RGS1811•1m ago•0 comments

Google Gemini seems to expose private Google Docs data

https://www.reddit.com/r/IndieDev/comments/1vfwuf5/a_player_found_out_the_actual_name_of_my_games/
1•mostlysimilar•1m ago•1 comments

AI used to design new viruses

https://www.eurekalert.org/news-releases/1138470
1•DeepLogin•1m ago•0 comments

Should AI labs be treated like the owners of dangerous animals?

https://www.economist.com/science-and-technology/2026/08/06/should-ai-labs-be-treated-like-the-ow...
1•pseudolus•2m ago•1 comments

The End of Google Search—and the Internet—as We Know It

https://www.theringer.com/2026/08/04/tech/google-search-ai-internet
1•CharlesW•3m ago•0 comments

GitHub exposes pub keys at GitHub .com/${username}.keys

https://twitter.com/samhogan/status/2085380716163109265
1•gmays•5m ago•0 comments

ASK HN: Opus 5.0 is more autonomous

1•nunep•6m ago•1 comments

Agent Skills

https://github.com/addyosmani/agent-skills
1•tosh•6m ago•0 comments

Gemma Translator: DIY hardware for offline translation

https://github.com/google-gemma/gemma-translator
1•dmotz•6m ago•0 comments

Win Grep – A visual 3-pane log and text filtering tool for Windows

https://www.sharktime.com/en_WinGrep.html
1•piotrchlebek•7m ago•0 comments

AI Creates Bacteria-Killing Viruses: 'Extreme Caution' Warns Genome Pioneer

https://www.newsweek.com/ai-creates-bacteria-killing-viruses-extreme-caution-warns-genome-pioneer...
2•_____k•7m ago•0 comments

Anomaly

https://anomaly.cnetai.cyou
1•anoqwen•10m ago•0 comments

Show HN:Calibra: Train with Less Data

https://calibra-wulw.vercel.app/
1•omertt27•11m ago•0 comments

The Complexity We Choose

https://frazik.com/blog/2026/the-complexity-we-choose/
1•frazik•11m ago•0 comments

Kimi K3 is now available in GitHub Copilot

https://github.blog/changelog/2026-08-06-kimi-k3-is-now-available-in-github-copilot/
1•theanonymousone•13m ago•0 comments

Vibecoded a Busy Bar Control Centre

https://github.com/Shabablinchikow/Busy-Control-Centre
1•shabablinchikow•13m ago•0 comments

DeepSeek's price hike is about more than GPU costs

https://blog.chuanxilu.net/en/posts/2026/08/deepseek-price-increase-beyond-gpu/
2•theanonymousone•13m ago•0 comments

Modeling LLM Performance from First Principles

https://sidbabu.com/posts/llm-perf-modeling
1•matt_d•14m ago•0 comments

AI and Productivity: What Firms Are Saying on Earnings Calls

https://www.stlouisfed.org/on-the-economy/2026/jul/ai-productivity-what-firms-say-earnings-calls
2•b-man•14m ago•0 comments

Westminster Council suggests restrictions on standing at Soho and West End pubs

https://www.standard.co.uk/news/london/west-end-westminster-council-soho-pubs-standing-b1292557.html
1•jjgreen•15m ago•0 comments

AMD acquires startup Taalas to boost inference perf by etching models in silicon

https://www.theregister.com/systems/2026/08/06/amd-acquires-ai-chip-startup-taalas-to-boost-infer...
4•itvision•17m ago•1 comments

HP, Asus and Acer Begin Using CXMT Memory

https://www.tomshardware.com/tech-industry/three-major-pc-makers-now-using-chinese-memory-to-figh...
2•yogthos•17m ago•0 comments

The hardest working font in Manhattan (2025)

https://aresluna.org/the-hardest-working-font-in-manhattan/
1•dcminter•17m ago•0 comments

Ask HN: How do you choose your AI model?

1•ano-ther•17m ago•0 comments

Stochastic Parrot

https://en.wikipedia.org/wiki/Stochastic_parrot
1•simonebrunozzi•18m ago•0 comments

Quake – 30th Anniversary Update

https://slayersclub.bethesda.net/en-US/news/quake-30th-anniversary-update
25•dsubburam•19m ago•4 comments

OpenAI's New Device Will Be Hockey Puck-Sized and Cost over $300

https://www.bloomberg.com/news/articles/2026-08-06/what-is-openai-s-device-a-doughnut-shaped-spea...
2•htrp•20m ago•1 comments