frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

GAI, a Go-idiomatic, lightweight abstraction on top of LLMs

https://gai.maragu.dev/
1•markusw•1m ago•0 comments

'Remarkable' new enzymes built by algorithm with physics know-how

https://www.nature.com/articles/d41586-025-01897-0
1•Bluestein•1m ago•0 comments

A Breakthrough in Consciousness

https://cac.org/daily-meditations/a-breakthrough-in-consciousness/
1•squircle•2m ago•1 comments

The OpenHands CLI

https://www.all-hands.dev/blog/the-openhands-cli-ai-powered-development-in-your-terminal
1•Dowwie•2m ago•0 comments

Dilly Dilly the Battle of Beer Run

https://www.youtube.com/watch?v=xwl5ZhEkrPw
1•squircle•3m ago•0 comments

Memories of the good parts of using drugs can keep people hooked

https://theconversation.com/memories-of-the-good-parts-of-using-drugs-can-keep-people-hooked-altering-the-neurons-that-store-them-could-help-treat-addiction-245529
1•PaulHoule•4m ago•0 comments

Sitting–rising test scores predict natural and cardiovascular causes of deaths

https://watermark.silverchair.com/zwaf325.pdf?token=AQECAHi208BE49Ooan9kkhW_Ercy7Dm3ZL_9Cf3qfKAc485ysgAAA2swggNnBgkqhkiG9w0BBwagggNYMIIDVAIBADCCA00GCSqGSIb3DQEHATAeBglghkgBZQMEAS4wEQQMgWp2AFl-IfseiuYUAgEQgIIDHtuF5ZpFFsKKE3Mo4v9ZimgvnMLkqzd6IBYnl7X-NcTtwEZ3Z7n_Or4_NnDPyFMwrujyvMPIVh_ibWakMBQpSLnKmjbQ8HKfew_OwlR9ywgwrfE1qSXsS-U7p_0OlIXLoUt3s-iYgZyl7r0dByrIYzdnoTHsQYmePY9INKXrhqBTMimQ8hJbgOTsAU1YYMldsyH5RyKDDvHtyGRjWL2o0V0KftW0uLA-WyZftfGZl69AA5AFagfwreikz0jHgWJymJMMr45lVS8vyKvBJrbDWtU9PWtrCFvsa5IPmSZfhVsPQvq1haXt0Su0hv9VgbpHc-9PhprngMBc-BK1fzA8o3ECxyIC2O1Zs0vdUn4KD7f0gS7EWcdYB6CA0pYUpvP6qeIJ5zoPg2QhOQG5iLyr5AYbuD9377DT_x2Nik5ZuJYQUc-5Hu0Jj3EA86P8P4gZPE5j0ewfQnKPhNXMOwJLmacsZVgpSYYBzC8M8wyL9I21BsR8IYBHbx9l16CDDA1C1C3gdy7FYhgrk6kerkq_Mht2dBj-ndWfp4OH-SiMnHc4sKkewTC-QUEj5u-_dZznY5msOBFi6PxTNMmmX2oDTxEpNTOSAq6fJzfJx4AArOlpCNc51K1kbTzwSNoafvtFgRFxf-iywtxkKR8C4DCoC11wfKe-Cd3IuTv2Xq6gUXbKO_HXV_yqkIRtSycLX0AABQCKsYX-fDCgzMulxD3_aOqRul_g1wbTJcYBujt2JmCS2g2kkhsYmVtegj-5_oWfCL9GgGjFgNUQDcYbxv9SV2o1mNOdNbPSysDG5GiAx0XWsgy2bw-aqfgAOGIhcvwvnYIaJJCmdmaRv1ZSnPP5UCh_b-N3tuGHKMrcNXKusdWJExTVbINNwrZiCh4tbXpy9lU21LclLrct9x2NTWAmFvfb-QaPER3Iv1f0yO3r5EBLDjvqgjZy7A6kYljGoAfK6mxmHgIa6C_ZTHDD_pNwmm0QFaAFjNwqx03YWSsc1rg55YLhQssrHkQpqn86IAFrhB6PN36zuMOtgOCAwjZBmvOAa_PFgwtqgoh0aXclZA
1•domofutu•4m ago•0 comments

RFK Jr. is coming for your vaccines

https://www.theverge.com/health/688503/rfk-jr-vaccines
1•leotravis10•5m ago•0 comments

Analemmas the Equation of Time: Why the Path of the Sun Traces Out an 8 on Earth

https://www.iflscience.com/analemmas-and-the-equation-of-time-why-the-path-of-the-sun-traces-out-an-8-on-earth-79648
1•Bluestein•5m ago•0 comments

The OpenAI Podcast

https://openai.com/podcast/
1•OutOfHere•6m ago•0 comments

Giving GPT-3 a Turing Test (2020)

https://lacker.io/ai/2020/07/06/giving-gpt-3-a-turing-test.html
1•icapybara•9m ago•0 comments

Volkswagen Will Sell You an ID. Buzz Robotaxi

https://insideevs.com/news/763105/volkswagen-id-buzz-ad-autonomous-taxi-production-version/
1•PhilippGille•9m ago•0 comments

Politics and Bad Decisions Starved New York's Subways (2017)

https://www.nytimes.com/2017/11/18/nyregion/new-york-subway-system-failure-delays.html
1•zelias•12m ago•0 comments

What details have been released in the Titan submersible implosion?

https://www.aol.com/news/details-released-titan-submersible-implosion-191217260.html
1•Bluestein•13m ago•0 comments

AI agents working with zero Human intervention to set up an ELK stack [video]

https://www.youtube.com/watch?v=mjx5RdF4-YQ
2•jcyriac•14m ago•1 comments

Show HN: Easy picture in picture final cut pro automation

1•andrewfromx•15m ago•0 comments

Dancing Boss

https://boss.laurasirvent.com/
1•wonger_•18m ago•0 comments

What resistance to the digital coup looks like

https://news.elenarossini.com/this-is-what-resistance-to-the-digital-coup-looks-like/
3•jethronethro•22m ago•0 comments

Obama's awkward call for a broad-scale Trump resistance

https://www.cnn.com/2025/06/18/politics/obama-trump-resistance-analysis
2•vinnyglennon•24m ago•1 comments

This AI Model Never Stops Learning

https://www.wired.com/story/this-ai-model-never-stops-learning/
1•kevinsync•24m ago•0 comments

Strongbox Joins Applause

https://strongboxsafe.com/strongbox-joins-applause/
1•1659447091•25m ago•0 comments

Major oil companies face first 'climate death' lawsuit

https://www.dw.com/en/major-oil-companies-face-first-climate-death-lawsuit/a-72899631
3•jmsflknr•25m ago•2 comments

We made top AI models compete at Diplomacy

https://every.to/diplomacy
1•kkwteh•25m ago•0 comments

Elon Musk calls Grok answer a 'major fail'

https://www.independent.co.uk/news/world/americas/us-politics/elon-musk-grok-right-wing-violence-b2772242.html
3•labrador•25m ago•3 comments

US FDA approves Gilead's twice-yearly injection for HIV prevention

https://www.reuters.com/business/healthcare-pharmaceuticals/us-fda-approves-gileads-twice-yearly-injection-hiv-prevention-2025-06-18/
3•JumpCrisscross•30m ago•0 comments

A shell command to create JSON: jo (2016)

https://jpmens.net/2016/03/05/a-shell-command-to-create-json-jo/
2•homebrewer•32m ago•0 comments

Using NotebookLM to Learn Things

https://www.augmentedswe.com/p/using-notebooklm-to-actually-learn
1•wordsaboutcode•32m ago•0 comments

Internet Relay Chat Protocol (1993)

https://datatracker.ietf.org/doc/html/rfc1459
4•coloneltcb•34m ago•0 comments

Basic Linear Algebra Subprograms

https://en.wikipedia.org/wiki/Basic_Linear_Algebra_Subprograms
3•diggan•37m ago•0 comments

Judge smacks down Pentagon plan to slash university research funding awards

https://www.theregister.com/2025/06/18/judge_pauses_dod_university_funding_cuts/
4•rntn•39m ago•0 comments
Open in hackernews

Building agents using streaming SQL queries

https://www.morling.dev/blog/this-ai-agent-should-have-been-sql-query/
74•rmoff•4h ago

Comments

simonw•3h ago
This combines a bunch of different things, but the key idea appears to be having a Flink (stream processing server) SQL query set up that effectively means that new documents added to the data store trigger a query that then uses an LLM (via a custom SQL function) to e.g. calculate a summary of a paper, then feeds that on to something that sends an alert to Slack or similar.

So this is about running LLM prompts as part of an existing streaming data processing setup.

I guess you could call a trigger-based SQL query an "agent", since that term is wide open to being defined however you want to use it!

gunnarmorling•16m ago
Author here, thanks for reading and commenting! Indeed my conclusion is that "agent" means different things to different people. The idea for this post was to explore what's there already and what may be missing for using SQL in this context. When following Anthropic's taxonomy, as of today, SQL let's you get quite far for building workflows. For agents in their terminology, some more work is needed to integrate things like MCP, but I don't see any fundamental reasons for why this couldn't be done.
nilirl•2h ago
This felt forced.

If you read through the whole thing, they don't manage to build an AI Agent, they make LLM API calls using Flink's SQL.

They admit making it agentic, with choice over tool selection and with agent-like memory, requires workarounds.

Annoying workarounds, imo.

The post mentions work is in progress to build agents that use Flink without using Flink SQL.

Thereby invalidating it's own title.

esafak•2h ago
Perhaps a charitable take is that this is a musing on how to use immutability for building agents? Maybe a functional approach would be less constrictive than SQL.
tra3•2h ago
Indeed. I'm very curious about the original source of inspiration for the post, "That microservice should have been a SQL query". It's not as catchy without AI though.
nilirl•2h ago
How did it make an argument for immutability?
philipodonnell•2h ago
I’ve built lots of pre-LLM data processing pipelines like this and the more I read people putting “agents” into this kind of context the less they resemble agents like the Anthropics of the world defines and the more they just resemble functions. I wonder if eventually there won’t be a distinction and it’ll just be a way to make processing and branching nodes in a pipeline less deterministic when you need more flexibility than pure code-rules can give you.