Hacker News
Latest
US cybersecurity chief leaked sensitive government files to ChatGPT: Report
2026-01-29 @ 16:12:19Points: 89Comments: 36
Days numbered for 'risky' lithium-ion batteries
2026-01-29 @ 16:04:45Points: 16Comments: 5
OTelBench: AI struggles with simple SRE tasks (Opus 4.5 scores only 29%)
2026-01-29 @ 15:37:21Points: 38Comments: 29
Deep dive into Turso, the "SQLite rewrite in Rust"
2026-01-29 @ 14:51:56Points: 64Comments: 33
How to Choose Colors for Your CLI Applications (2023)
2026-01-29 @ 14:49:08Points: 70Comments: 39
Break Me If You Can: Exploiting PKO and Relay Attacks in 3DES/AES NFC
2026-01-29 @ 14:20:21Points: 25Comments: 7
Playing Board Games with Deep Convolutional Neural Network on 8bit Motorola 6809
2026-01-29 @ 14:03:12Points: 13Comments: 1
Claude Code Daily Benchmarks for Degradation Tracking
2026-01-29 @ 13:59:07Points: 232Comments: 118
A lot of population numbers are fake
2026-01-29 @ 13:36:54Points: 156Comments: 127
The Sovereign Tech Fund Invests in Scala
2026-01-29 @ 12:42:58Points: 36Comments: 25
Vitamin D and Omega-3 have a larger effect on depression than antidepressants
2026-01-29 @ 10:35:00Points: 666Comments: 455
AI on Australian travel company website sent tourists to nonexistent hot springs
2026-01-29 @ 10:15:42Points: 89Comments: 43
Europe’s next-generation weather satellite sends back first images
2026-01-29 @ 07:07:17Points: 511Comments: 75
We can’t send mail farther than 500 miles (2002)
2026-01-29 @ 03:58:33Points: 560Comments: 86
Questom (YC F25) is hiring an engineer
2026-01-29 @ 03:29:53Points: 1
Maine’s ‘Lobster Lady’ who fished for nearly a century dies aged 105
2026-01-29 @ 02:11:42Points: 203Comments: 53
Render Mermaid diagrams as SVGs or ASCII art
2026-01-29 @ 02:08:40Points: 360Comments: 52
Tesla ending Models S and X production
2026-01-28 @ 22:53:54Points: 482Comments: 996
Apple to soon take up to 30% cut from all Patreon creators in iOS app
2026-01-28 @ 20:59:30Points: 811Comments: 676
Airfoil (2024)
2026-01-28 @ 14:32:30Points: 506Comments: 59
Trinity large: An open 400B sparse MoE model
2026-01-28 @ 00:57:52Points: 226Comments: 73
How London became the rest of the world’s startup capital
2026-01-28 @ 00:16:57Points: 187Comments: 288
Show HN: ShapedQL – A SQL engine for multi-stage ranking and RAG
2026-01-27 @ 13:54:09Points: 52Comments: 20
I’m Tullie, founder of Shaped. Previously, I was a researcher at Meta AI, worked on ranking for Instagram Reels, and was a contributor to PyTorch Lightning.
We built ShapedQL because we noticed that while retrieval (finding 1,000 items) has been commoditized by vector DBs, ranking (finding the best 10 items) is still an infrastructure problem.
To build a decent for you feed or a RAG system with long-term memory, you usually have to put together a vector DB (Pinecone/Milvus), a feature store (Redis), an inference service, and thousands of lines of Python to handle business logic and reranking.
We built an engine that consolidates this into a single SQL dialect. It compiles declarative queries into high-performance, multi-stage ranking pipelines.
HOW IT WORKS:
Instead of just SELECT , ShapedQL operates in four stages native to recommendation systems:
RETRIEVE: Fetch candidates via Hybrid Search (Keywords + Vectors) or Collaborative Filtering. FILTER: Apply hard constraints (e.g., "inventory > 0"). SCORE: Rank results using real-time models (e.g., p(click) or p(relevance)). REORDER: Apply diversity logic so your Agent/User doesn’t see 10 nearly identical results.
THE SYNTAX: Here is what a RAG query looks like. This replaces about 500 lines of standard Python/LangChain code:
SELECT item_id, description, price
FROM
-- Retrieval: Hybrid search across multiple indexes
search_flights("$param.user_prompt", "$param.context"),
search_hotels("$param.user_prompt", "$param.context")
WHERE -- Filtering: Hard business constraints
price <= "$param.budget" AND is_available("$param.dates")
ORDER BY -- Scoring: Real-time reranking (Personalization + Relevance)
0.5 * preference_score(user, item) +
0.3 * relevance_score(item, "$param.user_prompt")
LIMIT 20 If you don’t like SQL, you can also use our Python and Typescript SDKs. I’d love to know what you think of the syntax and the abstraction layer!