i love postgres and pgvector... this is exactly to my tastes

calebhwin 6 hours ago | parent | next [-]

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 6 hours ago | parent [-]

Is it? pgvector is primarily about indexing, I think? This feels more similar =AI in Google Sheets.

	▲	calebhwin 5 hours ago \| parent [-]
		True though pgvector is not deterministic in a strict sense since HNSW is probabilistic.

▲

cpursley 4 hours ago | parent | prev [-]

Yes, and I imagine pgclaw would pair well with pgmq and pg_cron for scheduled work. Postgres really is enough: https://postgresisenough.dev

▲

maxbond 3 hours ago | parent [-]

Interesting to hear you say that, I was thinking (but hadn't said) that using WalEx to dispatch to some workers where the agent lived would be a better solution. The worker would then update the row (or more likely insert a new one in a different table with more constraints/different columns). I would be curious to hear what advantage you see in a `claw` type/`agent` column? I can't make heads or tails of it but I regard you as knowing a lot more about Postgres than me.

	▲	cpursley 6 minutes ago \| parent [-]
		You could probably use listen/subscribe trigger to accomplish that.