5 ms·

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

• calebhwin 7mo 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 7mo ago
    Is it? pgvector is primarily about indexing, I think? This feels more similar =AI in Google Sheets.
    • calebhwin 7mo ago
      True though pgvector is not deterministic in a strict sense since HNSW is probabilistic.
• cpursley 7mo ago
  Yes, and I imagine pgclaw would pair well with pgmq and pg_cron for scheduled work. Postgres really is enough: https://postgresisenough.dev https://postgresisenough.dev
  • maxbond 7mo ago
    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 7mo ago
      You could probably use listen/subscribe trigger to accomplish that.