frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

Open in hackernews

Building agents using streaming SQL queries

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

Comments

simonw•4h 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•1h 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•4h 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•4h 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•3h 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•3h ago
How did it make an argument for immutability?
philipodonnell•3h 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.

Andrej Karpathy's YC AI SUS talk on the future of the industry

https://www.donnamagi.com/articles/karpathy-yc-talk
198•pudiklubi•4h ago•120 comments

The unreasonable effectiveness of fuzzing for porting programs

https://rjp.io/blog/2025-06-17-unreasonable-effectiveness-of-fuzzing
120•Bogdanp•5h ago•14 comments

Show HN: Workout.cool – Open-source fitness coaching platform

https://github.com/Snouzy/workout-cool
464•surgomat•9h ago•153 comments

My iPhone 8 Refuses to Die: Now It's a Solar-Powered Vision OCR Server

https://terminalbytes.com/iphone-8-solar-powered-vision-ocr-server/
121•hemant6488•5h ago•37 comments

Writing documentation for AI: best practices

https://docs.kapa.ai/improving/writing-best-practices
95•mooreds•5h ago•27 comments

Show HN: I built a tensor library from scratch in C++/CUDA

https://github.com/nirw4nna/dsc
73•nirw4nna•6h ago•8 comments

Poline – An enigmatic color palette generator using polar coordinates

https://meodai.github.io/poline/
157•zdw•3d ago•35 comments

Homomorphically Encrypting CRDTs

https://jakelazaroff.com/words/homomorphically-encrypted-crdts/
169•jakelazaroff•8h ago•53 comments

Introduction to the A* Algorithm (2014)

https://www.redblobgames.com/pathfinding/a-star/introduction.html
206•auraham•1d ago•80 comments

MiniMax-M1 open-weight, large-scale hybrid-attention reasoning model

https://github.com/MiniMax-AI/MiniMax-M1
303•danboarder•14h ago•68 comments

Terpstra Keyboard

http://terpstrakeyboard.com/web-app/keys.htm
188•xeonmc•11h ago•68 comments

Is there a half-life for the success rates of AI agents?

https://www.tobyord.com/writing/half-life
171•EvgeniyZh•10h ago•89 comments

Scrappy – Make little apps for you and your friends

https://pontus.granstrom.me/scrappy/
394•8organicbits•16h ago•127 comments

Revisiting Minsky's Society of Mind in 2025

https://suthakamal.substack.com/p/revisiting-minskys-society-of-mind
47•suthakamal•5h ago•17 comments

Attimet (YC F24) – Quant Trading Research Lab – Is Hiring Founding Engineer

https://www.ycombinator.com/companies/attimet/jobs/b1w9pjE-founding-engineer
1•kbanothu•4h ago

Framework Laptop 12 review

https://arstechnica.com/gadgets/2025/06/framework-laptop-12-review-im-excited-to-see-what-the-2nd-generation-looks-like/
167•moelf•6h ago•212 comments

Locally hosting an internet-connected server

https://mjg59.dreamwidth.org/72095.html
134•pabs3•16h ago•126 comments

I counted all of the yurts in Mongolia using machine learning

https://monroeclinton.com/counting-all-yurts-in-mongolia/
199•furkansahin•13h ago•76 comments

After millions of years, why are carnivorous plants still so small?

https://www.smithsonianmag.com/articles/carnivorous-plants-have-been-trapping-animals-for-millions-of-years-so-why-have-they-never-grown-larger-180986708/
184•gmays•5d ago•78 comments

Spatializing 6k years of global urbanization from 3700 BC to AD 2000

https://www.nature.com/articles/sdata201634
27•talonx•3d ago•1 comments

A different take on S-expressions

https://gist.github.com/tearflake/569db7fdc8b363b7d320ebfeef8ab503
38•tearflake•3d ago•29 comments

Should we design for iffy internet?

https://bytes.zone/posts/should-we-design-for-iffy-internet/
47•surprisetalk•2d ago•29 comments

Pwm flicker: Invisible light that's harming our health

https://caseorganic.medium.com/the-invisible-light-thats-harming-our-health-and-how-we-can-light-things-better-d3916de90521
36•SLHamlet•4h ago•42 comments

The Grug Brained Developer (2022)

https://grugbrain.dev/
991•smartmic•1d ago•485 comments

Building agents using streaming SQL queries

https://www.morling.dev/blog/this-ai-agent-should-have-been-sql-query/
80•rmoff•5h ago•7 comments

Show HN: Trieve CLI – Terminal-based LLM agent loop with search tool for PDFs

https://github.com/devflowinc/trieve/tree/main/clients/cli
19•skeptrune•7h ago•7 comments

Real-time action chunking with large models

https://www.pi.website/research/real_time_chunking
61•pr337h4m•1d ago•7 comments

Spherical CNNs (2018)

https://arxiv.org/abs/1801.10130
11•rkp8000•2d ago•1 comments

Reasoning by Superposition: A Perspective on Chain of Continuous Thought

https://arxiv.org/abs/2505.12514
43•danielmorozoff•8h ago•1 comments

Show HN: Free local security checks for AI coding in VSCode, Cursor and Windsurf

23•jaimefjorge•8h ago•12 comments