frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

PcapAnalyzer – self-hosted pcap analyzer with 27 problem detectors

https://github.com/sebaandrada-cell/PcapAnalyzer
1•sebaandrada•3m ago•0 comments

The Last Great Revolution

https://www.lesswrong.com/posts/ZxBaCDjxyxKaLHqGf/the-last-great-revolution
1•paulpauper•4m ago•0 comments

To code well, avoid blunders

https://www.seangoedecke.com/to-code-well-avoid-blunders/
1•gfysfm•4m ago•0 comments

Tesla Reality View Live Visualization Update

https://twitter.com/Tesla/status/2124222447855743019
2•hnburnsy•4m ago•0 comments

Things About the Insanity of Sand

https://kenorland.substack.com/p/the-insanity-of-sand
1•paulpauper•5m ago•0 comments

What Maintaining SwiftTerm Taught Me About AI Contributions

https://tirania.org/blog/archive/2026/Nov-20.html
1•worik•6m ago•0 comments

Meditation Anecdotes

https://robbiewmthompson.com/blog/anecdotes-on-meditation/
1•paulpauper•7m ago•0 comments

Deterministic IAM engine that proves AWS simulator is wrong

https://github.com/Pliauga/Bastion
1•edpliauga•7m ago•0 comments

Allo, your friendly neighborhood font

https://allo.joshpuckett.me/
1•hn-aarvin•8m ago•0 comments

Onionloom: Tor v3 .onion vanity addresses, CPU tuning, GPU acceleration

https://github.com/chrisch88dev/onionloom
1•petecooper•10m ago•0 comments

TODOs JJ Style

https://bwc9876.dev/blog/jj_todo/
1•birdculture•11m ago•0 comments

People who donate their poo: What it takes to be a super pooper

https://www.bbc.com/future/article/20261117-faecal-transplants-what-it-takes-to-be-a-super-pooper
1•jeffwass•13m ago•0 comments

Show HN: I built a playable 211M-param world model of the Backrooms

https://github.com/Yelar/noclip
1•yelarys•13m ago•0 comments

VSCode extension to add bib entries from your Zotero library

https://github.com/justachetan/zotero-live-cite
1•justachetan•14m ago•0 comments

Show HN: Quadrivia – Trivia for the Intellectually Curious

https://apps.apple.com/us/app/quadrivia/id6830515751
1•jchaykow•14m ago•0 comments

Show HN: Straum – Live Postgres aggregates without triggers or extensions

https://github.com/janbjorge/straum
1•jeeybee•15m ago•0 comments

Drugs, AI, and What Remains of Us

https://amirhkarimi.medium.com/drugs-ai-and-what-remains-of-us-2efa1494ecf5
1•nasimrahaman_tt•15m ago•1 comments

Finding Prime Locations

https://www.simonsfoundation.org/news/finding-prime-locations-the-continuing-challenge-to-prove-t...
1•jonbaer•17m ago•0 comments

Projecting humanity 1000 years into the future

https://arxiv.org/abs/2409.00067
1•xqcgrek2•17m ago•0 comments

FarmDash (zero-custody DeFi agent API): RFC 9727 catalog, typed webhooks

https://www.farmdash.one/.well-known/api-catalog
1•autoclawreviews•19m ago•0 comments

Test the Riemann Hypothesis with your spare CPU

https://riemann-at-home.github.io/riemann-at-home/
1•tito•22m ago•1 comments

Technological Progress and the Meaning of Work

https://aleximas.substack.com/p/technological-progress-and-the-meaning
1•anon7725•22m ago•0 comments

Riven (1997): Catherine Is Still in Her Cell (Undocumented Bug)

https://glthr.com/riven-prison-zip-remnant
1•glth•23m ago•0 comments

Man's use of synthetic testosterone for cows nearly destroyed his heart

https://arstechnica.com/health/2026/11/mans-secret-use-of-synthetic-testosterone-for-cows-nearly-...
4•hilux•24m ago•2 comments

Keurig home coffee machine tries to upload 100 GB of data per day

https://twitter.com/NomadsGalaxy/status/2107284088247689290
2•gumby•24m ago•1 comments

Transfinite Game Values in Infinite Chess (2014)

https://arxiv.org/abs/1302.4377
1•bookofjoe•25m ago•0 comments

How to make shell scripts invisible to kernel monitoring

https://hacktricks.wiki/en/generic-methodologies-and-resources/basic-forensic-methodology/anti-fo...
1•thunderbong•25m ago•0 comments

Show HN: Nistivo – custom AI models trained for you, one fixed quote

https://nistivo.com/
1•nistivo•26m ago•0 comments

A Guy Who Writes in His Underwear Has Hooked Millions of Men on Fiction

https://www.wsj.com/arts-culture/books/dungeon-crawler-carl-matt-dinniman-33886312
2•petethomas•26m ago•0 comments

Introduction to SELinux

https://github.blog/developer-skills/programming-languages-and-frameworks/introduction-to-selinux/
1•ronfriedhaber•26m ago•0 comments
Open in hackernews

Against SQL (2021)

https://www.scattered-thoughts.net/writing/against-sql/
4•yladiz•1y ago

Comments

rawgabbit•1y ago
Sorry. These criticisms don’t make much sense.

The author says SQL is the language for manipulating relational data. And then proceeds to complain SQL sucks at manipulating JSON.

Hmm. JSON is not relational. SQL expects data to be in third normal form.

If you are primarily working with JSON, please use something else.

The other two criticisms about SQL verboseness and reluctance to employ functions and other memory manipulations is the author’s confusion of the intended purpose of SQL. SQL treats data as the first class citizen. Think of data as the noun. SQL DML and SQL functions are modifiers. This is why SQL appears verbose. It is dragging all these data structures around. If you want to reduce SQL’s verbosity then you need to take an axe to the raw tables themselves and make them all cookie cutter. But then you have a completely different problem.