I am currently integrating Pinecone in my app and that works like a charm, but of course you have to call their REST API which makes it slower than when it would be directly integrated in Mendix.
I see Postgres has pgVector, so maybe this could be enabled so that we can build similarity searches directly from Studio Pro. How awesome would that be.
Meta data filtering for instance: https://docs.pinecone.io/docs/metadata-filtering
That would be really cool!
Only bump on the road that I can see is access rights. How would you propose this would work?