SQL for data scientists in 100 queries(gvwilson.github.io)
694 points by Anon84 | 130 comments
Greg Wilson's "SQL for the Weary" lesson notes with working examples for instructors teaching SQL to data scientists in about 100 queries.
Hacker News on
Stories posted this day, by points. Rank history starts with the October 2026 rebuild.
TSMC to build second Japan chip factory(finance.yahoo.com)
609 points by ytch | 444 comments
Reuters article on Yahoo Finance reporting TSMC will build a second chip factory in Japan, raising total investment to $20 billion.
The Ladybird browser project(ladybird.dev)
584 points by defied | 253 comments
Homepage of Ladybird, an independent web browser being built from scratch as part of the SerenityOS project, with build instructions and sponsor news.
Companies embracing SMS for account logins should be blamed for SIM-swap attacks(keydiscussions.com)
373 points by spenvo | 259 comments
Blog post arguing that companies like Apple, Dropbox, PayPal, Block, and Google that rely on SMS for logins and password resets are to blame for SIM-swap attacks.
The world is awful. The world is much better. The world can be much better(ourworldindata.org)
363 points by colonCapitalDee | 265 comments
Max Roser essay on Our World in Data arguing the world is simultaneously awful, much better than before, and capable of becoming much better.
Explore interesting places nearby listed on Wikipedia(en.nearbywiki.org)
348 points by udev4096 | 83 comments
NearbyWiki is an interactive map web app that shows Wikipedia-listed places near a chosen location.
![Screenshot of arxiv.org: Better Call GPT: Comparing large language models against lawyers [pdf]](https://hn.urlbox.com/shots/renders/2024/2/6/10c25137-34c1-43c9-a4e2-2642c4d17559.jpg)
Better Call GPT: Comparing large language models against lawyers [pdf](arxiv.org)
347 points by vinnyglennon | 236 comments
arXiv paper comparing large language models with junior lawyers and legal process outsourcers on contract review accuracy, speed, and cost.
Go 1.22(go.dev)
343 points by bestinterest | 127 comments
Official release notes for Go 1.22, covering language changes, tooling, runtime, compiler, standard library additions like math/rand/v2, and ports.
PostgreSQL is enough(gist.github.com)
314 points by cpursley | 219 comments
![Screenshot of ntsb.gov: Alaska Airlines flight 1282 NTSB preliminary report [pdf]](https://hn.urlbox.com/shots/renders/2024/2/7/7c47fc46-6d2b-4143-8c8e-62cb27b5117c.jpg)
OKRs Are Bullshit(blog.appliedcomputing.io)
210 points by hiyer | 147 comments
Making steel without emitting CO2(science.org)
205 points by ttfkam | 101 comments
Write a Letter to Your Future Self(futureme.org)
187 points by skanderbm | 93 comments
Billion file filesystem(blog.liw.fi)
150 points by pabs3 | 95 comments
The Sinusoidal Tetris(andreinc.net)
144 points by nomemory | 47 comments
The Apple Vision Pro(stratechery.com)
129 points by allenleein | 209 comments
![Screenshot of arxiv.org: Destruction of nuclear bombs using ultra-high energy neutrino beam (2003) [pdf]](https://hn.urlbox.com/shots/renders/2024/2/6/9321eca3-4c9f-4220-ab6d-c78ce6b4d054.jpg)
Show HN: Pika – Simple blogging software(pika.page)
101 points by bjhess | 36 comments
Vision 1993(tbray.org)
93 points by zdw | 57 comments
