frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Show HN: Pgclaw – A "Clawdbot" in every row with 400 lines of Postgres SQL

https://github.com/calebwin/pgclaw
25•calebhwin•3h ago
Hi HN,

Been hacking on a simple way to run agents entirely inside of a Postgres database, "an agent per row".

Things you could build with this: * Your own agent orchestrator * A personal assistant with time travel * (more things I can't think of yet)

Not quite there yet but thought I'd share it in its current state.

Comments

tibbar•1h ago
This is mind-bending. I can't imagine that it performs well enough to be particularly fit for production just yet but..... wow.
swyx•1h ago
how exactly is adding a stored procedure as an agent mind bending
readme•1h ago
i love postgres and pgvector... this is exactly to my tastes
calebhwin•1h ago
Same, it's in a similar vein as pgvector - probably not as performant as turbopuffer or chroma but you get the benefits of being in a really nice ecosystem.
tibbar•1h ago
Is it? pgvector is primarily about indexing, I think? This feels more similar =AI in Google Sheets.
calebhwin•1h ago
True though pgvector is not deterministic in a strict sense since HNSW is probabilistic.
cpursley•6m ago
Yes, and I imagine pgclaw would pair well with pgmq and pg_cron for scheduled work. Postgres really is enough: https://postgresisenough.dev
wwweston•1h ago
This... does not seem like separation of concerns.

Not to mention that the data layer seems like the one where you want to keep things most deterministic.

noupdates•1h ago
To decouple this the person would have to broadcast nearly every event and rebuild the observer layers elsewhere.
danr4•1h ago
this is fucking awesome
xnx•1h ago
It feels like we're a week away from the Claw hype supplanting AI hype. Companies will start renaming things ClawX to get on the hype bandwagon.
calebhwin•1h ago
It's just an abstraction people are excited about at the moment. Langchain was an exciting abstraction at one point.

My bet is we converge on a super minimal model<>computer architecture.

maxbond•1h ago
I think "claw" isn't appealing enough to be genericized and that "agent" will continue to be the generic term, but we'll see.
maxbond•1h ago
What's the advantage in putting agents in the persistence layer rather than the application layer? This seems to me strictly less flexible, scalable, secure, easy to work with... I am having a hard time imagining why I would want to integrate with APIs or write an agentic harness in the database rather than in application code?

Maybe I'm behind the times but I don't understand.

4ndrewl•50m ago
It's similar to when we wrote all our business logic in eg pl/sql, stored procedures etc. Seems attractive at first, but it breaks separation of concerns, becomes difficult to test etc.
debugnik•22m ago
I don't understand why claw is a data type for columns in these examples, it doesn't seem to store any actual per-row state. Is it not possible to hook extensions onto "with" clauses or something similar?

Show HN: Generate Web Interfaces from Data

https://github.com/puffinsoft/syntux
6•Goose78•43m ago•0 comments

Show HN: Pgclaw – A "Clawdbot" in every row with 400 lines of Postgres SQL

https://github.com/calebwin/pgclaw
25•calebhwin•3h ago•17 comments

Show HN: Geo Racers – Race from London to Tokyo on a single bus pass

https://geo-racers.com/
59•pattle•10h ago•52 comments

Show HN: I generated a "stress test" of 200 rare defects from 7 real photos

2•jmalevez•23m ago•0 comments

Show HN: What is HN thinking? Real-time sentiment and concept analysis

https://ethos.devrupt.io/
5•ddtaylor•1h ago•0 comments

Show HN: 20+ Claude Code agents coordinating on real work (open source)

https://github.com/mutable-state-inc/lean-collab
31•austinbaggio•4h ago•29 comments

Show HN: The Rails developers' guide to mobile app frameworks

https://masilotti.com/rails-developers-guide-to-mobile-app-frameworks/
2•joemasilotti•1h ago•0 comments

Show HN: Inamate – Open-source 2D animation tool (alternative to Adobe Animate)

12•hactually•2d ago•11 comments

Show HN: ListofDisks – hard drive price index across 7 retailers not just Amazon

3•listofdisks•2h ago•0 comments

Show HN: CodeRLM – Tree-sitter-backed code indexing for LLM agents

https://github.com/JaredStewart/coderlm/blob/main/server/REPL_to_API.md
76•jared_stewart•1d ago•34 comments

Show HN: TinyFish Web Agent (82% on hard tasks vs. Operator's 43%)

https://www.tinyfish.ai/blog/mind2web
15•gargi_tinyfish•3h ago•10 comments

Show HN: AI agents play SimCity through a REST API

https://hallucinatingsplines.com
204•aed•3d ago•70 comments

Show HN: Agent Alcove – Claude, GPT, and Gemini debate across forums

https://agentalcove.ai
61•nickvec•1d ago•26 comments

Show HN: Insider Trading Alerts – Open-Market Buys&Sells from SEC Form 4 Filings

https://stockalert.pro/alerts/insider-transactions
4•Adanos•3h ago•0 comments

Show HN: TidesDB – A persistent key-value store optimized for modern hardware

https://github.com/tidesdb/tidesdb
8•alexpadula•4h ago•4 comments

Show HN: PardusDB – SQLite-like vector database in Rust

https://github.com/JasonHonKL/PardusDB
2•JasonHEIN•4h ago•0 comments

Show HN: Agent Tools – 136 deterministic data tools for AI agents (MCP/A2A/REST)

https://github.com/AtmaticAI/agent-tools
2•sathish-mg•4h ago•1 comments

Show HN: ClawDeploy – OpenClaw deployment for non-technical users

https://clawdeploy.com
2•gregzeng95•4h ago•0 comments

Show HN: BetterDB – Valkey/Redis monitoring that persists what servers forget

3•kaliades•5h ago•0 comments

Show HN: Got VACE working in real-time – 30fps on a 5090

https://daydream.live/real-time-video-generation-control
10•cmuir•5h ago•0 comments

Show HN: Triclock – A Triangular Clock

https://triclock.franzai.com/
55•franze•1d ago•14 comments

Show HN: A FIRE calculator that verifies or determines your retirement number

https://retirenumber.com/try
5•marcus-verus•6h ago•0 comments

Show HN: Rowboat – AI coworker that turns your work into a knowledge graph (OSS)

https://github.com/rowboatlabs/rowboat
198•segmenta•2d ago•56 comments

Show HN: It's 2026 and setting up a Mac for development is still mass googling

https://github.com/openbootdotdev/openboot
3•openbootdotenv•6h ago•1 comments

Show HN: I built a macOS tool for network engineers – it's called NetViews

https://www.netviews.app
239•n1sni•2d ago•60 comments

Show HN: HN stories cited most in comments

https://hacker-backlinks.browserbox.io
2•keepamovin•7h ago•0 comments

Show HN: Double blind entropy using Drand for verifiably fair randomness

https://blockrand.net/live.html
21•rishi_blockrand•18h ago•15 comments

Show HN: Distr 2.0 – A year of learning how to ship to customer environments

https://github.com/distr-sh/distr
96•louis_w_gk•2d ago•29 comments

Show HN: A segmentation model client-side via WASM – free background removal

https://qtoolkit.dev/tools/background-remover/
2•shivaodin•7h ago•0 comments

Show HN: JavaScript-first, open-source WYSIWYG DOCX editor

https://github.com/eigenpal/docx-js-editor
124•thisisjedr•3d ago•44 comments