news newest ask show jobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Better JIT for Postgres

https://github.com/vladich/pg_jitter

25•vladich•1h ago

Comments

eru•14m ago

> However, standard LLVM-based JIT is notoriously slow at compilation. When it takes tens to hundreds of milliseconds, it may be suitable only for very heavy, OLAP-style queries, in some cases.

I don't know anything here, but this seems like a good case for ahead of time compilation? Or at least caching your JIT results? I can image much of the time, you are getting more or less the same query again and again?

asah•13m ago

awesome! I wonder if it's possible to point AI at this problem and synthesize a bespoke compiler (per-architecture?) for postgresql expressions?

kvdveer•7m ago

Two things are holding back current LLM-style AI of being of value here:

* Latency. LLM responses are measured in order of 1000s of milliseconds, where this project targets 10s of milliseconds, that's off by almost two orders of magnitute.

* Determinism. LLMs are inherently non-deterministic. Even with temperature=0, slight variations of the input lead to major changes in output. You really don't want your DB to be non-deterministic, ever.

Show HN: First API for orbital compute scheduling with real physics

https://rotastellar.com/blog/shipping-first-orbital-compute-scheduler/

1•subhadipmitra•24s ago•0 comments

Show HN: Nova – AI terminal that writes, fixes, and ships your code

1•Bridgeye•42s ago•0 comments

Show HN: TerraViz – Real-time flights, earthquakes, ISS on one map

https://www.terraviz.live/

1•cvaambikapur•2m ago•0 comments

Show HN: I no longer monitor my coding agents, my desktop pet does

https://github.com/SwarmPack/SwarmWatch

1•prastik•4m ago•0 comments

DIY YouTuber powers an EV using 500 disposable vapes

https://www.notebookcheck.net/DIY-YouTuber-powers-an-EV-using-500-disposable-vapes.1239016.0.html

1•WM6v•13m ago•0 comments

Show HN: LEAX – CLI tool for analyzing C memory leaks with AI-assisted fixes

https://github.com/hooop/leax

1•emmmarti•14m ago•0 comments

Chimpanzees Are into Crystals

https://www.nytimes.com/2026/03/04/science/chimpanzees-crystals.html

1•jimnotgym•16m ago•0 comments

Max Sxhwarzer: I've decided to leave OpenAI

https://xcancel.com/max_a_schwarzer/status/2028939154944585989

1•doener•18m ago•0 comments

Can you defend your AI decisions?

https://codingsoul.org/2026/03/02/can-you-defend-your-ais-decisions/

1•hleichsenring•22m ago•1 comments

All top AI models in one place – GPT, Claude, Gemini, Grok

https://www.chatgoat.ai/en

1•HollisQi•25m ago•0 comments

Welcome to the Wasteland: A Thousand Gas Towns

https://steve-yegge.medium.com/welcome-to-the-wasteland-a-thousand-gas-towns-a5eb9bc8dc1f

3•weltview•27m ago•0 comments

Apple Studio Display XDR Supports Dicom Medical Imaging for Diagnostic Radiology

https://www.macrumors.com/2026/03/03/studio-display-xdr-dicom-medical-imaging/

1•tosh•28m ago•0 comments

When Reasoning Becomes a Trap: Gemini 3 Flash in FoodTruck Bench

https://foodtruckbench.com/blog/gemini-flash

1•Munksgaard•29m ago•0 comments

Au Revoir, Eleventy

https://hamatti.org/posts/au-revoir-eleventy/

2•Tomte•36m ago•0 comments

RFC 9849. TLS Encrypted Client Hello

https://www.rfc-editor.org/rfc/rfc9849.html

6•P_qRs•38m ago•0 comments

Altman's "sloppy" mistake works in Anthropic's favor [video]

https://www.youtube.com/shorts/ZklG_j10-IA

1•mdp2021•38m ago•1 comments

How Important Was the Battle of Hastings?

https://www.historytoday.com/archive/head-head/how-important-was-battle-hastings

3•benbreen•39m ago•1 comments

Fluid Cryptography Challenge

https://nests.zeabur.app/

1•realpaer•39m ago•1 comments

China uses AI doctor clones to help patients and improve healthcare

https://zoneofasia.com/china-uses-ai-doctor-clones-to-help-patients-and-improve-healthcare/

2•teleforce•42m ago•0 comments

Unmasking Redacted Names in Epstein Files Using Computer Vision (Open Source)

https://www.youtube.com/watch?v=mKK9VPito-E

2•birdculture•47m ago•1 comments

GPUI Mobile: Zed's GPUI Framework to iOS (Metal) and Android (Vulkan) in Rust

https://github.com/itsbalamurali/gpui-mobile

3•itsbalamurali•50m ago•1 comments

Tell HN: I got Claude Max for my open source project

4•asim•52m ago•2 comments

I built a local-first stock valuation tool based on Damodaran's methodology

https://github.com/stockvaluation-io/stockvaluation_io

3•softcane•53m ago•2 comments

Show HN: PulseWatch – AI-powered website change monitoring with visual selectors

https://pulsewatch.watch

2•KaracaTR•53m ago•0 comments

UN calls for investigation into deadly strike on school in Iran

https://www.reuters.com/world/middle-east/un-urges-investigation-into-horrific-attack-iran-school...

4•nerdyadventurer•56m ago•0 comments

The Influence of Anxiety: Harold Bloom and Literary Inheritance

https://thepointmag.com/examined-life/the-influence-of-anxiety/

3•apollinaire•1h ago•0 comments

Show HN: Mcpfs – Mount MCP servers as FUSE filesystems

https://github.com/airshelf/mcpfs

2•evoleinik•1h ago•0 comments

What Is Code Review For?

https://blog.glyph.im/2026/03/what-is-code-review-for.html

1•ingve•1h ago•0 comments

Israel Is Blowing Up Iran's Police State to Clear the Way for a Revolt

https://www.wsj.com/world/middle-east/israel-is-blowing-up-irans-police-state-to-clear-the-way-fo...

2•breppp•1h ago•0 comments

Show HN: Cloudwright – validate, cost, and export cloud architectures from text

https://github.com/xmpuspus/cloudwright

2•xmpuspus•1h ago•0 comments