frontpage.
newsnewestaskshowjobs

Open Source @Github

fp.

Open in hackernews

I rewrote PostHog's SQL parser, 70x faster, while barely looking at the code

https://posthog.com/blog/sql-parser
38•robbie-c•1h ago

Comments

sam_lowry_•55m ago
Dunno about the parser, but you broke scrolling on your fancy website without noticing it also ;-)
mikkelam•42m ago
I cannot believe they're sticking to their guns on this website design. It's awful.
pixel_popping•11m ago
They have an excellent branding and have some balls to pull it off, it shows passion, I highly trust it even in company settings.
noja•2m ago
I love it. So different. Slightly BeOS.
kg•1m ago
Try clicking 'switch to website mode' on the left side
duendefm•20m ago
Well despite my current anti AI sentiment, I have to admit that after reading the article, It was a good use of AI, done by someone with good technical skills. Still I have the feeling that this only works because of the vast accumulated knowledge pre-AI, and if everybody keeps going in this path, it will end up making everyone not advancing their knowledge at the pace they did before. I feel that this AI immersion is really about selling our soul to the devil for short term gains.
Daishiman•5m ago
> till I have the feeling that this only works because of the vast accumulated knowledge pre-AI

I'm not about to say that there's nothing new under the sun, but parsers are a really well-understood problem where 99.9% of people don't need frontier knowledge and wouldn't be in a position to use it anyway.

And I don't think that people doing research on parsers would ever rely on LLMs for precisely that reason. But we're not parser researchers right?

Field Note #009: The Asymmetric Exposure

https://www.azimuth.so/p/field-note-009-the-asymmetric-exposure
1•bennieblanco•1m ago•0 comments

Anthropic Accuses Alibaba of 'Illicitly' Accessing AI Models

https://www.bloomberg.com/news/articles/2026-06-24/anthropic-accuses-alibaba-of-illicitly-accessi...
1•htrp•2m ago•0 comments

Discovery of pneumonia subtypes could lead to tailored treatments

https://www.cam.ac.uk/research/news/discovery-of-severe-pneumonia-subtypes-could-lead-to-tailored...
1•gmays•3m ago•0 comments

Stop Programming in Markdown

https://structural.chat/articles/programming-in-markdown/
1•pchiusano•4m ago•0 comments

FilenQ – a native macOS file manager for power users

https://filenq.app
1•webseidon•6m ago•0 comments

RBX Insider

https://rbxinsider.net
1•fefw•6m ago•0 comments

Arcade Supports EMA

https://www.arcade.dev/blog/arcade-supports-ema/
1•gnanagurusrgs•7m ago•0 comments

Why SELECT * is bad for SQL performance (2020)

https://tanelpoder.com/posts/reasons-why-select-star-is-bad-for-sql-performance/
1•downbad_•7m ago•0 comments

Lost Confidence

https://longform.asmartbear.com/confidence/
1•herbertl•9m ago•0 comments

Benefit Is Not Authority

https://instantial.substack.com/p/benefit-is-not-authority
1•groverbennett•9m ago•0 comments

GitHub shouldn't be a dependency for publishing Rust on crates.io

https://infosec.exchange/@mttaggart/116806641273303255
2•speckx•10m ago•0 comments

Stanford graduates rethink their futures as AI transforms tech

https://www.bbc.com/news/articles/c872j82j2qyo
3•jethronethro•10m ago•0 comments

You can see T-Mobile's acquisitions by where its logins are hosted

https://neobotnet.com/blog/cotw-t-mobile
1•caffeinedoom•10m ago•2 comments

50% of LG and Samsung smart TV apps embed residential proxies

https://cyberinsider.com/50-of-lg-and-samsung-smart-tv-apps-embed-residential-proxies/
4•Cider9986•12m ago•0 comments

Reliability Is an Enforcement Problem

https://instantial.substack.com/p/reliability-is-an-enforcement-problem
1•groverbennett•13m ago•0 comments

Slate Auto's simple electric truck starts at $24,950

https://techcrunch.com/2026/06/24/slate-autos-radically-simple-electric-truck-starts-at-24950/
1•tjwds•16m ago•1 comments

Claude Shannon: A Mathematical Theory of Cryptography

https://evervault.com/papers/shannon
1•ShaneCurran•18m ago•0 comments

Elon Musk denies Tesla's Autopilot caused crash that killed grandmother

https://arstechnica.com/tech-policy/2026/06/elon-musk-denies-teslas-autopilot-caused-crash-that-k...
2•worik•18m ago•1 comments

AI IQ Bio

https://www.aiiq.org/bio/
1•shea256•20m ago•0 comments

WebKit in Safari 27 Beta

https://webkit.org/blog/17967/news-from-wwdc26-webkit-in-safari-27-beta/
2•SllX•21m ago•0 comments

Find an open source alternative to anything

https://opensource.builders/
1•momentmaker•21m ago•0 comments

Meta pauses employee tracker for AI training amid privacy concerns

https://www.theguardian.com/technology/2026/jun/24/meta-pauses-employee-tracker-for-ai-training-a...
1•iamflimflam1•21m ago•1 comments

WikiHouse is a modular system for high performance, zero-carbon buildings

https://www.wikihouse.cc
1•momentmaker•23m ago•0 comments

A startup claims it broke through a bottleneck that's holding back LLMs

https://www.technologyreview.com/2026/06/19/1139313/a-startup-claims-it-broke-through-a-bottlenec...
2•theanonymousone•25m ago•0 comments

Show HN: Agents report broken docs, you get a GitHub issue

https://fixyourdocs.io/
1•mstopa•25m ago•0 comments

Show HN: Turn images into audio that can be decoded with a spectrogram

https://nsspot.herokuapp.com/imagetoaudio/
1•jupr•26m ago•0 comments

The quietest places in the loudest cities

https://earth.fm/the-quietest-places-in-the-worlds-loudest-cities/
2•momentmaker•27m ago•0 comments

Every AI Memory Benchmark Has an Asterisk

https://tenureai.dev/writing/every-ai-memory-benchmark-has-an-asterisk/
3•freewilly25•27m ago•0 comments

Are AI chatbots politically biased?

https://twitter.com/ianbremmer/status/2069744192230764723
6•MrBuddyCasino•28m ago•2 comments

An ECG biomarker for sudden cardiac death discovered with deep learning

https://www.nature.com/articles/s41586-026-10674-6
2•brandonb•28m ago•0 comments