news newest ask show jobs

Open Source @Github

fp.

Open in hackernews

Shredding JSON columns gave Logfire up to 1000x faster queries

https://pydantic.dev/articles/dynamic-shredding-2026-01-26

5•acossta•2h ago

Comments

sans_souse•2h ago

Let's just revert back 30 years and make the entire www plain text. What could possibly go wrong?

sgarland•38m ago

It is hilarious to me when companies act like they've made some huge discovery that's been well-known to anyone working in DBs for the past decade, if not more.

JSON is slow as hell, both for serdes, and especially querying it. Use it sparingly, if at all. Normalization is not that hard, and it's trivial now with LLMs. Tell Claude you want your schema in BCNF, or 5NF if you're feeling froggy. Denormalize if and only if you have performance issues.

guites•27m ago

The point they make is that user data is dynamic, meaning you can't just blindly normalize every json attribute into its own column. The challenge is determining which attributes deserve "shredding" and doing it automatically iiuc

Neywiny•10m ago

Not even companies. I've seen this with colleagues. They wanted JSON parsing in a moderately embedded device. No thank you. Parse it elsewhere, give me the binary result

Whatever became of holography? (2011)

https://www.americanscientist.org/article/whatever-became-of-holography

38•cainxinth•1h ago•8 comments

Governments are mishandling the affordability crisis

https://www.economist.com/finance-and-economics/2026/10/08/governments-are-mishandling-the-afford...

35•andsoitis•1h ago•24 comments

Total Annihilation, rebuilt for modern computers

https://nanolathe.gg

342•jttnr•6h ago•146 comments

Cartographers of North Korea (2019)

https://cartographers-nk.wonyoung.so/

171•edent•5h ago•29 comments

Fingerprints Are the New Cookies

https://royfish.dev/fingerprints-are-the-new-cookies

47•royfish•2h ago•18 comments

Recursive self-improvement through collective intelligence

https://pub.sakana.ai/mass/

47•hardmaru•2h ago•15 comments

Google Data Centers around the world

https://datacenters.google/locations/

45•andsoitis•2h ago•38 comments

The gap in shared understanding of LLM capability is widening

https://twitter.com/karpathy/status/2109361546505966046

218•albertzeyer•4h ago•352 comments

Illustration Beyond Proof

https://terrytao.wordpress.com/2026/10/11/illustration-beyond-proof/

15•smilelamp•1h ago•0 comments

So, You’d Like To Sell Your Print Issues Of The Onion?

https://theonion.com/archivehunt/

238•mooreds•5h ago•32 comments

Ask HN: Do you want a router that has DD-WRT pre-installed?

15•Ixander•22h ago•20 comments

Terence Tao: Math 2.0 [pdf]

https://teorth.github.io/tao-web/slides/math-2-0-caltech-2026.pdf

309•Anon84•11h ago•365 comments

Chapter 1 of Ways of Seeing by John Berger

https://www.ways-of-seeing.com/ch1

70•rafael859•6h ago•11 comments

IRCv3

https://ircv3.net/

346•basilikum•14h ago•294 comments

Google is illegaly cutting forest to build data centers

https://www.theguardian.com/technology/2026/oct/06/google-datacentres-finland-temporary-halt-envi...

80•heyimada•2h ago•8 comments

NYC's "Click to Cancel" rule is now in effect

https://www.nyc.gov/main/click-to-cancel

335•gregsadetsky•6h ago•165 comments

Passkeys are a trap. Do not use them

https://nonfunctional.substack.com/p/passkeys-are-a-trap-do-not-use-them

214•laurex•2h ago•117 comments

Local Indexing to reduce tool calling and token usage

https://tedhaley.ca/pensieve/

6•TedHaley•52m ago•0 comments

I guess I'm using WebP now?

https://anderegg.ca/2026/10/08/i-guess-im-using-webp-now

65•Brajeshwar•2d ago•66 comments

Safe SIMD in Rust, even on the inside

https://shnatsel.github.io/safe-simd-in-rust-even-on-the-inside/

26•ravenical•1d ago•1 comments

Programmable pigments: Photochromic nanoparticle inks for rewritable tattoos

https://www.cell.com/matter-light/fulltext/S3117-5848(26)00119-5

3•Bluestein•15h ago•0 comments

500B tokens later: Letting AI agents decompile a first-person shooter

https://momo5502.com/posts/2026-10-09-game-decompilation/

148•davikr•22h ago•107 comments

The tilde in your PATH may not be your HOME

https://disconnect3d.pl//2026/10/02/dont-put-tilde-in-your-path/

208•arusekk•12h ago•140 comments

Show HN: Plimsoll, a self-hosted sandbox for code your AI agent writes

https://github.com/plimsollmark/plimsoll

5•cagster•1h ago•1 comments

A Remote Employee Refused 160 Webcam Photos a Day. Her Employer Fired Her

https://www.inc.com/chloe-rosenberg/a-remote-employee-refused-160-webcam-photos-a-day-her-employe...

133•bhrlady•3h ago•98 comments

apsw: Another Python SQLite Wrapper

https://github.com/rogerbinns/apsw

60•tosh•7h ago•14 comments

FlowCE: Calculus on your TI-84 Plus CE

https://tommyb3ll.github.io/FlowCE/

22•jgx0•1d ago•7 comments

Show HN: BetterWispr – Free, open-source dictation for Mac

https://betterwispr.com/

146•kartik017•12h ago•92 comments

How I reverse engineered a commercial spatial audio effect

http://epestr.com/blog/reverse-engineering-a-commercial-spatial-audio-effect/

94•epestr•9h ago•31 comments

ClickHouse C – Talk to ClickHouse using its native binary protocol

https://github.com/ClickHouse/clickhouse-c

6•saisrirampur•1h ago•0 comments