It would help if there was a node for:
Deleting items in Pinecone database. Not (only) by ID but ideally with a vector search or - even better - a filter based on metadata.
My use case:
Upserting to Pinecone is implemented OK, but you offer no (or very limited) support for maintaining or deleting them afterwards when using Pinecone serverless.
Examples of really ordinary use cases for this feature:
- It’s easy to “convert” a PDF into vectors and store them in Pinecone, but it’s hard to replace these vectors whenever the document is getting updated.
- It is easy to scrape a webpage regularly and store the content into Pinecone using n8n, but how do you identify and update the vectors whenever the web page content changes? You can’t.
We highly need the ability to easily clean up vectors to support use cases like this.
A related feature is support for record management. You don’t have to invent this yourself - feel free to copy how this works directly from Flowise (open source). Their implementation is highly valuable and extremely easy to use.
Any resources to support this?
Don’t know?
Are you willing to work on this?
I’m SO MUCH willing to test an MVP - or just provide input to a solution design - as I’m struggling with the lag of this feature in almost any of my workflows using RAG.