frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

A modern guide to SQL JOINs

https://kb.databasedesignbook.com/posts/sql-joins/
2•petalmind•2d ago

Comments

nchagnet•2d ago
This is really interesting, I'm always finding weird bugs in my joins once they grow a certain size and this has helped me understand why. Btw you still have a todo comment in section "Why you should only use ID equality"

Show HN: I built an open-sourced TypeScript SDK for Google NotebookLM

https://github.com/photon-hq/notebooklm-kit
1•vaandeetttt•2m ago•0 comments

We need to seize the means of robot production

https://boingboing.net/2026/01/05/we-need-to-seize-the-means-of-robot-production.html
1•ashishgupta2209•3m ago•0 comments

Innovation Cycles in an Age of AI

https://www.apifirst.tech/p/ai-innovation-cycles
1•AIandAPIs•3m ago•0 comments

Coral reef fish recovery could boost sustainable seafood servings by up to 50%

https://phys.org/news/2026-01-coral-reef-fish-recovery-boost.html
1•akg130522•4m ago•0 comments

Making a game engine based on dynamic signed distance fields [video]

https://www.youtube.com/watch?v=1I8LiVAyYVg
1•nice_byte•10m ago•2 comments

Show HN: Proof that any fixed-axis type system fails for some domain (Lean4)

https://zenodo.org/records/18123532
1•trissim•10m ago•0 comments

Why the Sudden Emergence of Sodium-Ion Batteries?

https://cleantechnica.com/2026/01/06/why-the-sudden-emergence-sodium-ion-batteries/
1•xbmcuser•11m ago•1 comments

"We have stratum zero at home"

https://ewpratten.com/blog/gps-timekeeping
1•ewpratten•12m ago•0 comments

A Child in the State of Nature

https://lareviewofbooks.org/article/a-child-in-the-state-of-nature/
2•Caiero•14m ago•0 comments

We Still Don't Know If Robotaxis Are Safer Than Human Drivers

https://www.bloomberg.com/news/features/2026-01-06/are-autonomous-vehicles-safer-than-human-drive...
2•jakelazaroff•14m ago•0 comments

What problems do you have at your job / startup / side project?

1•DinakarS•17m ago•1 comments

Prince of Persia Defeated Apple II's Memory Limitations

https://www.youtube.com/watch?v=sw0VfmXKq54
3•bane•17m ago•1 comments

On the slow death of scaling

https://papers.ssrn.com/sol3/papers.cfm?abstract_id=5877662
12•sethbannon•22m ago•1 comments

Chat platform Discord files confidentially for US IPO

https://www.reuters.com/business/chat-platform-discord-confidentially-file-us-ipo-bloomberg-news-...
3•mattas•22m ago•0 comments

Symbolic reasoning system with local inference and full auditability

https://signal-zero.ai/examples.html
1•klietus•22m ago•1 comments

Travel Is Not Education

https://fi-le.net/travel/
1•fi-le•26m ago•1 comments

Why write unit tests? (2024)

https://henko.net/blog/why-write-unit-tests/
4•todsacerdoti•27m ago•0 comments

Shex – Natural language CLI assistant that executes commands

https://github.com/YUHAI0/shex
1•Lmyuai•28m ago•1 comments

Show HN: Live UV Index Tracking of Your Location

https://uvindex.cc/
1•brianchanwh•32m ago•0 comments

In Memoriam: All the tech that died in 2025

https://mashable.com/article/in-memoriam-tech-deaths-2025-tivo-skype-microsoft-passwords
3•gnabgib•33m ago•0 comments

Show HN: Nthesis PostHog Survey Integration [video]

https://www.youtube.com/watch?v=AGG8QJHALPk
1•osigurdson•33m ago•1 comments

Anti-frameworkism: Choosing native web APIs over frameworks

https://blog.logrocket.com/anti-frameworkism-native-web-apis/
1•sarrietav•35m ago•0 comments

Jupiter's moon Europa lacks undersea activity needed for life, study suggests

https://phys.org/news/2026-01-jupiter-moon-europa-lacks-undersea.html
1•wglb•35m ago•1 comments

Designing a High-Performance OLTP Database from First Principles

https://shubhamrasal.com/writing/tigerbeetle-oltp-design
1•jorangreef•37m ago•0 comments

AI Is Coming for Your Job. Now What? [video]

https://www.youtube.com/watch?v=cJfKqKEyw1o
1•avonmach•40m ago•0 comments

Native NVMe Support in Windows Server 2025

https://techcommunity.microsoft.com/blog/windowsservernewsandbestpractices/announcing-native-nvme...
1•tanelpoder•41m ago•1 comments

I Built Payment Integration Instead of Using Better Auth's Payment Plugin

https://launchsaas.org/blog/why-custom-payment
1•victorymakes•48m ago•1 comments

The Guardian view on Trump's raid in Caracas: oil matters, but it's not the whol

https://www.theguardian.com/commentisfree/2026/jan/06/the-guardian-view-on-trumps-capture-in-cara...
2•hkhn•48m ago•0 comments

Donald Trump poses a threat to civilization

https://www.theguardian.com/commentisfree/2026/jan/06/donald-trump-threat-civilization
7•hkhn•50m ago•0 comments

Ask HN: How do you minimize dependence on US-based infrastructure?

3•__warlord__•54m ago•2 comments